ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RAC ORA-12516,12519

RAC ORA-12516,12519

原创 Linux操作系统 作者:windtalker_cs 时间:2012-01-19 20:44:43 0 删除 编辑

[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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 技术人才的级差
请登录后发表评论 登录
全部评论

注册时间:2010-02-24

  • 博文量
    49
  • 访问量
    184859