This content has been marked as final. Show 9 replies
Looks like the database is open in some exclusive mode...
A BLOCKED status means that the instance cannot accept connections.
Can you post your listener.ora file?
Also compare tnsnames.ora files on the two servers.
Check error messages
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.
Action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.
This might be due to startup nomount .
tnsnames.ora file is same on both nodes and tnsping is working fine.
Following is listener.ora on node1........
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.20)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-dg)(PORT = 1521)(IP = FIRST))
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/asm)
(PROGRAM = extproc)
(SID_NAME = string)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db)
need to start db in nomount state because I will restore from backup. (backup taken from naother node to restore as Standby db)
oh, I over looked the "nomount" part.
That explains it. In nomount stage, user are not allowed to connect using net service.
You need to connect to database locally using OS authetication. So in your case, you have to connect to database on node1 not on node2
In your listner.ora file edit by adding you instance name, then restart the listner and your instance.try it, it will work. cheers --- Kayode Taiwo(Nigeria)
Looks like very old thread...
I av you tried my suggestion???
Did it work for you??