Hello,
I have spent many hours but don't understand what little thing I am missing or confusing me.. Please help to fix the issue.
Physical Standb db created successfully, but now facing following issue: Though it should be and must be fixed but really making me mad
DGMGRL> SHOW CONFIGURATION;
Configuration - DATA GUARD
Protection Mode: MaxPerformance
Databases:
dg - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> ADD DATABASE DG_DB2
> AS CONNECT IDENTIFIER IS DG_DB2
> MAINTAINED AS PHYSICAL;
Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Failed.
PRIM:
db_name: DG
db_unique_name: dg
service_names: dg
STBY:
db_name: DG
db_unique_name: dg_db2
service_names: dg_db2
# TNSNAMES same entries on both Primary and Standby: HOSTNAMES are different.
DG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01.domain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg)
)
)
DG_DB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db02.domain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg_db2)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db01.domain)(PORT = 1521)) db02.domain for Standby on standby machine.
)
)
# Listener.ora on PRIMARY:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db01.domain)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dg_DGMGRL.domain)
(ORACLE_HOME = /oracle/app/11g/db)
(SID_NAME = dg)
(SERVICE_NAME = dg.domain)
)
)
# Listener.ora on Standby:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dg_db2_DGMGRL.domain)
(ORACLE_HOME = /oracle/app/11g/db)
(SID_NAME = dg_db2)
(SERVICE_NAME = dg_db2.domain)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db02.domain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
I created Stby DB with the minimum parameters required, so that I configure BROKER and see it magic, but badly stuck in this situation here. I have read many docs related to this..but can not fix it unfortunately.
Please guide me from your own experience as note ids, blogs are not helping me here...
Bundle of thanks.
Best Regards