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!

Instance status "BLOCKED" and ora-12528

463181May 23 2007 — edited Mar 6 2008

Oralce 10.2.0.1 -- SUN SPARC 10 64bit

instance is in nomount state, can connect using "sys/passwd@string as sysdba" on node 1 but unable to connect from 2nd node. following error received.

Node:2
connect sys/passwd@string as sysdba;
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Listener state on node 1 is following:

Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "string" has 1 instance(s).
Instance "string", status BLOCKED, has 1 handler(s) for this service...
Service "string" has 1 instance(s).
Instance "string", status UNKNOWN, has 1 handler(s) for this service...
Service "string_XPT" has 1 instance(s).
Instance "string", status BLOCKED, has 1 handler(s) for this service...

Message was edited by:
jees

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2008

Added on May 23 2007

#general-database-discussions

9 comments

37,763 views