一次tns故障处理

--故障
客户端可以tnsping通，但连接报错
h25k02dc:/crmboa>tnsping PXWSPMS1
TNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 21-NOV-2012 11:47:22
Copyright (c) 1997,  2007, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION_LIST= (FAILOVER=on) (LOAD_BALANCE=off) (DESCRIPTION= (ADDRESS_LIST= (FAILOVER=on) (LOAD_BALANCE=off) (ADDRESS= (PROTOCOL=TCP) (HOST=xxx.xxx.xxx.16) (PORT=1521))) (CONNECT_DATA= (FAILOVER_MODE= (TYPE=session) (METHOD=basic) (RETRIES=4) (DELAY=1)) (INSTANCE_NAME=wspms1) (SERVICE_NAME=wspms))) (DESCRIPTION= (ADDRESS_LIST= (FAILOVER=on) (LOAD_BALANCE=off) (ADDRESS= (PROTOCOL=TCP) (HOST=xxx.xxx.xxx.15) (PORT=1521))) (CONNECT_DATA= (FAILOVER_MODE= (TYPE=session) (METHOD=basic) (RETRIES=4) (DELAY=1)) (INSTANCE_NAME=wspms2) (SERVICE_NAME=wspms))))
OK (0 msec)

h25k02dc:/crmboa>sqlplus qwefgh/qwefgh@PXWSPMS1
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 21 11:47:15 2012
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name: ^C

--故障原因
oerr ora 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause:  The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener.  This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
//  - Wait a moment and try to connect a second time.
//  - Check which services are currently known by the listener by executing:
//    lsnrctl services
//  - Check that the SERVICE_NAME parameter in the connect descriptor of the
//    net service name used specifies a service known by the listener.
//  - If an easy connect naming connect identifier was used, check that
//    the service name specified is a service known by the listener.
//  - Check for an event in the listener.log file.
由于指定的INSTANCE_NAME和SERVICE_NAME并不是主机xxx.xxx.xxx.15/16的INSTANCE_NAME和SERVICE_NAME，故会报错

--故障处理
重新指定主机xxx.xxx.xxx.15/16的INSTANCE_NAME和SERVICE_NAME即可

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

转载于:http://blog.itpub.net/28278387/viewspace-749646/