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

463181Jan 29 2007 — edited Jan 31 2007

system: ORACLE RAC 9i on Solaris 9. have 2 databases (4 instances).
problem: can connect 3 instances but unable to connect 4th. following error.

ORA-12521: TNS:listener could not resolve INSTANCE_NAME given in connect descriptor.

when I check listener status its shows following.

Service "BODB.world" has 2 instance(s).
Instance "BODB1", status READY, has 2 handler(s) for this service...
Instance "BODB2", status READY, has 1 handler(s) for this service...
Service "DB.world" has 2 instance(s).
Instance "DB1", status READY, has 2 handler(s) for this service...
Instance "DB2", status BLOCKED, has 1 handler(s) for this service...

how can I change instance status BLOCKED to READY?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2007

Added on Jan 29 2007

#general-database-discussions

8 comments

1,366 views