Oracle 12.1.0.2 - Container dbs
Data guard - standby CDB
I get:
ORA-12514: TNS:listener does not currently know of service requested in connect descripto
When trying to connect to the database (using CDB03_STBY).
Service entry is located in tnsnames.ora. Other databases with the same setup works fine.
lsnrctl status listener dont show the service, so for some reason the service is not registered.
Service "cdb03a" has 1 instance(s).
Instance "cdb03a", status UNKNOWN, has 1 handler(s) for this service...
Service "cdb03a_DGMGRL" has 1 instance(s).
Instance "cdb03a", status UNKNOWN, has 1 handler(s) for this service...
No other services are registered.
I have tried to register it using:
alter system register
That did not help.
I traced the registration and the service is listed as an active service.
Any ideas?
TheLonelyDBA
Listener.ora - A is standby
LISTENER_CDB03A =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraserver1)(PORT = 1525)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))
)
SID_LIST_LISTENER_CDB03A =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cdb03a)
(ORACLE_HOME = /appl/oracle/product/12.2.0/dbhome_1)
(SID_NAME = cdb03a)
)
(SID_DESC =
(GLOBAL_DBNAME = cdb03a_DGMGRL)
(ORACLE_HOME = /appl/oracle/product/12.2.0/dbhome_1)
(SID_NAME = cdb03a)
)
)
Tnsnames.ora
along other servvices:
CDB03_STBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraserver1)(PORT = 1525)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))
(ADDRESS = (PROTOCOL = TCP)(HOST = oraserver2)(PORT = 1525)(SEND_BUF_SIZE = 10485760)(RECV_BUF_SIZE = 10485760))
)
(SDU = 65535)
(CONNECT_DATA =
(SERVICE_NAME = CDB03_STBY)
)
)