ORA-12514: 錯誤解決一例

環境 oracle rac + dataguard 。

在進行連線測試時出現如下錯誤。
備庫連線主庫正常 。
主庫連線備庫：
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Dec 28 10:13:58 2011

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

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

tnsping standby 一切正常 。

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 28-DEC-2011 10:13:23

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.4.14)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =xc)))
OK (10 msec)

於是檢視備庫service_names 引數，發現這個引數沒有配置 。
在備庫設定service_names引數，問題解決 。

配置方法 ：service_names='oracle_sid' (例項名稱)