DG配置网络报ORA-12514: TNS:listener does not...
配置data guard网络监听的时候，连接测试报错如下：ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor出错原因是由于，在修改init$Oracle_SID.ora文件时，在主库里面新添加了一项db_unique_name=10gpri；
备库上新添加一项db_unique_name=10gstandby.
在配置监听文件和客户端tnsnames.ora时，，就要修改GLOBAL_DBNAME 成相应的10gpri或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 = 10gpri) (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1) (SID_NAME = dg01)))[oracle@dg01 admin]$ cat tnsnames.ora 10gpri=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.30)(PORT = 1521)) (CONNECT_DATA =(server=dedicated) (service_name = 10gpri))) 10gstandby=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.31)(PORT = 1521)) (CONNECT_DATA =(server=dedicated) (service_name = 10gstandby)))
在两个节点上测试如下：
节点dg01：
[oracle@dg01 dbs]$ sqlplus scott/tiger@10gstandby SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 24 03:29:28 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: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 10gstandby global_names boolean FALSE instance_name string dg01 lock_name_space string log_file_name_convert string service_names string 10gstandby节点dg02:[oracle@dg02 dbs]$ sqlplus scott/tiger@10gpri SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 24 03:29:28 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: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_10gpri> show parameter name NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_file_name_convert string db_name string dg01 db_unique_name string 10gpri global_names boolean FALSE instance_name string dg01 lock_name_space string log_file_name_convert string service_names string 10gpri