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) 

(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=

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.1.31)(PORT = 1521))

(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:

SCOTT_S:145_P:22710_10gpri> show parameter name

db_unique_name string 10gpri

service_names string 10gpri

    本文轉自vcdog 51CTO部落格，原文連結：http://blog.51cto.com/255361/837642，如需轉載請自行聯系原作者