DG配置网络，报ORA-12514: TNS:listener does not...
<DIV><P>配置data guard网络监听的时候，连接测试报错如下：</P>
<P></P>
<P><FONT color=#ff0000>ERROR:<BR>ORA-12514: TNS:listener does not currently know of service requested in connect<BR>descriptor</FONT></P>
<P><FONT color=#ff0000></FONT></P>
<P><FONT color=#000000>出错原因是由于，在修改init$ORACLE_SID.ora文件时，在主库里面新添加了一项db_unique_name=10gpri；</FONT></P>
<P><FONT color=#000000>备库上新添加一项db_unique_name=10gstandby.</FONT></P>
<P><FONT color=#000000>在配置监听文件和客户端tnsnames.ora时，就要修改GLOBAL_DBNAME 成相应的10gpri或10standby.</FONT></P>
<P><FONT color=#ff0000></FONT></P>
<P>$ cat listener.ora <BR>LISTENER = <BR>(DESCRIPTION_LIST = <BR>(DESCRIPTION = <BR>(ADDRESS_LIST = <BR>(ADDRESS = (PROTOCOL = TCP)(HOST = <FONT style="BACKGROUND-COLOR: #ffff00">172.21.1.30</FONT>)(PORT = 1521)) <BR>) <BR>) <BR>) <BR>SID_LIST_LISTENER = <BR>(SID_LIST = <BR>(SID_DESC = <BR>(SID_NAME = PL***tProc) <BR>(ORACLE_HOME =<FONT style="BACKGROUND-COLOR: #ffff00"> /u01/oracle/product/10.2.0/db_1</FONT> ) <BR>(PROGRAM = extproc) <BR>) <BR>(SID_DESC = <BR>(GLOBAL_DBNAME = <FONT style="BACKGROUND-COLOR: #ffff00">10gpri</FONT>) <BR>(ORACLE_HOME = <FONT style="BACKGROUND-COLOR: #ffff00">/u01/oracle/product/10.2.0/db_1)</FONT> <BR>(SID_NAME = dg01) <BR>) <BR>)</P>
<P>$ cat tnsnames.ora </P>
<P>10gpri=<BR>(DESCRIPTION =<BR>(ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.30)(PORT = 1521))<BR>(CONNECT_DATA =<BR>(server=dedicated)<BR>(service_name = <FONT style="BACKGROUND-COLOR: #ffff00">10gpri</FONT>)<BR>)<BR>)</P>
<P>10gstandby=<BR>(DESCRIPTION =<BR>(ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.31)(PORT = 1521))<BR>(CONNECT_DATA =<BR>(server=dedicated)<BR>(service_name =<FONT style="BACKGROUND-COLOR: #ffff00"> 10gstandby</FONT>)<BR>)<BR>)</P>
<P></P>
<P>在两个节点上测试如下：</P>
<P>节点dg01：</P>
<P>$<FONT color=#0000ff> sqlplus scott/tiger@10gstandby</FONT></P>
<P>SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 24 03:29:28 2011</P>
<P>Copyright (c) 1982, 2005, Oracle. All rights reserved.</P>
<P><BR>Connected to:<BR>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<BR>With the Partitioning, OLAP and Data Mining options</P>
<P><BR>SCOTT_S:138_P:28085_10gstandby> show parameter name</P>
<P>NAME TYPE VALUE<BR>------------------------------------ ----------- ------------------------------<BR>db_file_name_convert string<BR>db_name string dg01<BR><FONT style="BACKGROUND-COLOR: #ffff00">db_unique_name string 10gstandby<BR></FONT>global_names boolean FALSE<BR>instance_name string dg01<BR>lock_name_space string<BR>log_file_name_convert string<BR><FONT style="BACKGROUND-COLOR: #ffff00">service_names string 10gstandby</FONT></P>
<P><FONT style="BACKGROUND-COLOR: #ffff00"></FONT></P>
<P><FONT style="BACKGROUND-COLOR: #ffffff">节点dg02</FONT>:</P>
<P>$<FONT color=#0000ff> sqlplus <a href="mailto:scott/tiger@10gpri" target="_blank"><FONT color=#669966>scott/tiger@10gpri</FONT></A></FONT></P>
<P>SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 24 03:29:28 2011</P>
<P>Copyright (c) 1982, 2005, Oracle. All rights reserved.</P>
<P><BR>Connected to:<BR>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<BR>With the Partitioning, OLAP and Data Mining options</P>
<P>SCOTT_S:145_P:22710_10gpri> show parameter name</P>
<P>NAME TYPE VALUE<BR>------------------------------------ ----------- ------------------------------<BR>db_file_name_convert string<BR>db_name string dg01<BR><FONT style="BACKGROUND-COLOR: #ffff00">db_unique_name string 10gpri</FONT><BR>global_names boolean FALSE<BR>instance_name string dg01<BR>lock_name_space string<BR>log_file_name_convert string<BR><FONT style="BACKGROUND-COLOR: #ffff00">service_names string 10gpri</FONT></P></DIV>
页:
[1]