RAC ORA-12516,12519

[oracle@racs1 ~]$ oerr ora 12516
12516, 00000, "TNS:listener could not find available handler with matching protocol stack"
// *Cause: None of the known and available service handlers for the given
// SERVICE_NAME support the client's protocol stack: transport, session,
// and presentation protocols.
// *Action: Check to make sure that the service handlers (e.g. dispatchers)
// for the given SERVICE_NAME are registered with the listener, are accepting
// connections, and that they are properly configured to support the desired
// protocols.

[oracle@racs1 ~]$ oerr ora 12519
12519, 00000, "TNS:no appropriate service handler found"
// *Cause: The listener could not find any available service handlers that
// are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener, and are accepting connections.

 

crs_start -all启动所有程序后

crs_stat -t全部都ONLINE

但是执行lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 19-JAN-2012 15:57:28

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
据网上说是静态注册的原因

lsnrctl status listener_name就正常了，

但是这样在远程连接就报12516和12519的错误

临时的解决办法：

srvctl stop listener -n racs1

srvctl stop listener -n racs2

racs1:

lsnrctl start

racs2:

lsnrctl start

执行完后，crs_stat -t，发现两个listener都是offline状态。

再执行

srvctl start listener -n racs1

srvctl start listener -n racs2

这样，问题就解决了，远程可以连接ORACLE了。

要想彻底解决可以如下做法：

vi /etc/hosts

127.0.0.1 localhost.localdomain localhost racs1

将后面的racs1 （计算机名）去掉就OK了。

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

转载于:http://blog.itpub.net/23065269/viewspace-715123/