Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listener error: ora-12528

581652Jul 19 2007 — edited Jul 20 2007
I am running Oracle 10g DB on windows 2003 server, DB running in archive log mode.

1) At the DB console i see that the DB is in mount state, all the services are running.

following error at the DB console.

Agent Connection to Instance

Status Failed

Details ORA-12528: TNS:listener: all appropriate instances are blocking new connections (DBD ERROR: OCIServerAttach)

2) C:\Documents and Settings\nkhaja>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 19 15:11:46 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: sys
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

RMAN> connect target niku

target database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12560: TNS:protocol adapter error

RMAN> exit


Recovery Manager complete.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=EBSONYC02.EBSO.COM)(PORT
=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 19-JUL-2007 14:05:16
Uptime 0 days 1 hr. 12 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Apps\oracle\product\10.2.0\db_1\network\admin\liste
ner.ora
Listener Log File C:\Apps\oracle\product\10.2.0\db_1\network\log\listene
r.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EBSONYC02.EBSO.COM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "niku" has 1 instance(s).
Instance "niku", status BLOCKED, has 1 handler(s) for this service...
Service "niku_XPT" has 1 instance(s).
Instance "niku", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

Can you tell me what the problem is and how can i resolve this.
I think the archive destination is full, now that the DB is in open state, how can i disable archiving. am not able to connect as well.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2007
Added on Jul 19 2007
18 comments
2,706 views