Hi There,
we are just doing an initial iteration for configuring dg broker on solaris (oracle 11R2).
after creating configuration when i add standby database , it gives me below error,
{code}
DGMGRL> create configuration 'PMARSDB' as primary database is PMARSDB connect identifier is PMARSDB;
Configuration "PMARSDB" created with primary database "pmarsdb"
DGMGRL> add database STD as connect identifier is STD maintained as physical;
Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
{code}
also to my disappointment, we are not able to connect to database through sqlplus when we give net service name (tns entry name) in the command
{code}oracle@mdcxuatdb05:~/app/oracle/product/11.2.0/dbhome_1/dbs$ sqlplus sys/*****@STD
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 16 18:22:40 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor{code}
below is the listener.ora and tnsnames.ora file entry
cat listener.ora
{code}
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PMARSDB_DGMGRL)
(ORACLE_HOME =/orainstall/home/oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME =PMARSDB))
(SID_DESC =
(GLOBAL_DBNAME = STD_DGMGRL)
(ORACLE_HOME =/orainstall/home/oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME =STD))
(SID_DESC =
(GLOBAL_DBNAME = STDNEW_DGMGRL)
(ORACLE_HOME =/orainstall/home/oracle/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME =STDNEW))
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.62.220.87)(PORT = 1521))
)
{code}
cat tnsnames.ora
{code}
# tnsnames.ora Network Configuration File: /orainstall/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PMARSDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.62.220.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PMARSDB)
)
)
STD=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.62.220.87)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=STD)
)
)
STDNEW=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.62.220.87)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=STDNEW)
)
)
can anyone figure out what is wrong here ?
also i am not sure why for the first time while configuring the DGBROKER it allowed me to connect through tns service name entry.