DG configure network reports ORA-12514: TNS: listenerdoesnot...

DG configure network reports ORA-12514: TNS: listenerdoesnot...

DG configuration Network reports ORA-12514: TNS: listener does not...

When configuring the data guard network listener, the connection test reports the following error:

ERROR:
ORA-12514: TNS: listener does not currently know of service requested in connect
Descriptor

The error is caused by a new db_unique_name = 10 upli added to the master database when modifying the init $ Oracle_SID.ora file;

Add db_unique_name = 10gstandby to the slave database.

When configuring the listener file and the client tnsnames. ora, You need to modify GLOBAL_DBNAME to the corresponding 10upli or 10standby.

[Oracle @ dg01 admin] $ cat listener. ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.21.1.30) (PORT = 1521 ))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PL *** tProc)
(ORACLE_HOME =/u01/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = 10 upli)
(ORACLE_HOME =/u01/oracle/product/10.2.0/db_1)
(SID_NAME = dg01)
)
)

[Oracle @ dg01 admin] $ cat tnsnames. ora

10 upli =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.21.1.30) (PORT = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(Service_name = 10 upli)
)
)

10 gstandby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.21.1.31) (PORT = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(Service_name = 10 gstandby)
)
)

Test on two nodes as follows:

Node dg01:

[Oracle @ dg01 dbs] $ sqlplus scott/tiger @ 10 gstandby

SQL * Plus: Release 10.2.0.1.0-Production on Wed Aug 24 03:29:28 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

SCOTT_S: 138_P: 28085_10gstandby> show parameter name

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_file_name_convert string
Db_name string dg01
Db_unique_name string 10 gstandby
Global_names boolean FALSE
Instance_name string dg01
Lock_name_space string
Log_file_name_convert string
Service_names string 10 gstandby

Node dg02:

[Oracle @ dg02 dbs] $ sqlplus scott/tiger @ 10 upli

SQL * Plus: Release 10.2.0.1.0-Production on Wed Aug 24 03:29:28 2011

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

SCOTT_S: 145_P: 22710_10upli> show parameter name

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_file_name_convert string
Db_name string dg01
Db_unique_name string 10 upli
Global_names boolean FALSE
Instance_name string dg01
Lock_name_space string
Log_file_name_convert string
Service_names string 10 upli