standby ORA-12514

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
*** 2008-03-12 23:57:11.107 62692 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'wtstandby'. Error is 12514.

[@more@]

*** 2008-03-12 23:57:11.107 62692 kcrr.c
Error 12514 received logging on to the standby
Error 12514 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'wtstandby'
Error 12514 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'wtstandby'
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
*** 2008-03-12 23:57:11.107 62692 kcrr.c
PING[ARC0]: Heartbeat failed to connect to standby 'wtstandby'. Error is 12514.
*** 2008-03-12 23:57:11.107 60970 kcrr.c
kcrrfail: dest:2 err:12514 force:0 blast:1
*** 2008-03-12 23:58:11.110
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12514 and errmsg is 'ORA-12514: TNS:listener does not currently know of service r
equested in connect descriptor

可能原因:

Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
结果都不是这些原因,把tnsnames的wtstandby的SERVICENAME改为SID就可以了.

wtstandby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = shtest)
)
)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/668365/viewspace-1007492/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/668365/viewspace-1007492/