Cause: This status shown when invalid configuration exist in data guard parameter or Primary Server are not able to connect Standby Server.
Solve : In my case primary server listeners are blocking new connection. After starting my
SQL> select name,open_mode,db_unique_name,switchover_status from v$database;
NAME OPEN_MODE DB_UNIQUE_NAME
--------- -------------------- ------------------------------
SWITCHOVER_STATUS
--------------------
SBLCBS READ WRITE drsbldb
FAILED DESTINATION
SQL> col DESTINATION format a35
col ERROR format a65
set lines 130
set pages 100
SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;
SQL> SQL> SQL> SQL>
DESTINATION ERROR
----------------------------------- -----------------------------------------------------------------
USE_DB_RECOVERY_FILE_DEST
sblcbs ORA-12528: TNS:listener: all appropriate instances are blocking
new connections
Solve : In my case primary server listeners are blocking new connection. After starting my
SQL> select name,open_mode,db_unique_name,switchover_status from v$database;
NAME OPEN_MODE DB_UNIQUE_NAME
--------- -------------------- ------------------------------
SWITCHOVER_STATUS
--------------------
SBLCBS READ WRITE drsbldb
FAILED DESTINATION
SQL> col DESTINATION format a35
col ERROR format a65
set lines 130
set pages 100
SELECT DESTINATION, ERROR FROM V$ARCHIVE_DEST;
SQL> SQL> SQL> SQL>
DESTINATION ERROR
----------------------------------- -----------------------------------------------------------------
USE_DB_RECOVERY_FILE_DEST
sblcbs ORA-12528: TNS:listener: all appropriate instances are blocking
new connections
This comment has been removed by the author.
ReplyDeletethis is one of the best blog related oracle thanks for explanation in a unique way .for more info about oracle oracle fusion financials training
ReplyDeleteThanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle APEX . Actually I was looking for the same information on internet for Oracle APEX and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle APEX . By attending Oracle APEX Training.
ReplyDelete
ReplyDeleteIam so thrilled because of finding your alluring website here.Actually i was searching for Oracle APEX.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle SOA.Thank you soo much..