DGM-17016: failed to retrieve status for database
Hello,
Appreciate your support in this..Urgently Please help me to solve this issue as its a production issue!
its Oracle Data guard 11g r2 windows environment ..
it was working fine but after restarting i found this error the standby database oracle not available and the primary database redo transport error.
Kindly find the screenshots below for more details..
Note: the connection name lbsdb is what i used to connect at but after restarting is gives tns:listener does not currently know of service requested in connect descriptor when logging,
So i created a new listener (Listener1) with the port 1522 and it used the connection name in tnsnames LBSDB_test just to login.
And here is my TNS names:
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LBSDB_PR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)
)
)
LBSDB_SB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)
)
)
DGB_PR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDB_PR_UN_DGMGRL.CORP.SA.ZAIN.COM)
)
)
DGB_SB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDB_SB_UN_DGMGRL.CORP.SA.ZAIN.COM)
)
)
LBSDB_PR_AP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDB_PR_UN.CORP.SA.ZAIN.COM)
)
)
LBSDB_SB_AP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDB_SB_UN.CORP.SA.ZAIN.COM)
)
)
LBSDB =
(DESCRIPTION =
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)
(SERVER = DEDICATED)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = BASIC)
(RETRIES = 15)
(DELAY = 10)))))
LBSDB_QUERY =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1525)) )
(CONNECT_DATA =
(SERVICE_NAME = LBSDB_SB.CORP.SA.ZAIN.COM)
)
)
GISSTAGING =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.123.105.179)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GISSTAGING)
)
)
LBSDB_test =
(DESCRIPTION =
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.5)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.164.6)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = LBSDB.CORP.SA.ZAIN.COM)
(SERVER = DEDICATED)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = BASIC)
(RETRIES = 15)
(DELAY = 10)))))
