listener errors

1.LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-NOV-2011 06:50:23

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

   Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message      12545 not found; No message file for product=network, facility=TNS
   TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
   TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
   Linux Error: 2: No such file or directory

  

   solution:export ORACLE_SID ORACLE_HOME ORACLE_BASE.

 

2.TNSLSNR for Linux: Version 10.2.0.1.0 - Production
   NL-00280: error creating log stream /u01/oracle/network/log/listener.log
   NL-00278: cannot open log file
   SNL-00016: snlfohd: error opening file
   Linux Error: 13: Permission denied

   Listener failed to start. See the error message(s) above...

 

   solution:chmod 777 listener.log

 

3.TNSLSNR for Linux: Version 10.2.0.1.0 - Production
   System parameter file is /u01/oracle/network/admin/listener.ora
   Log messages written to /u01/oracle/network/log/listener.log
   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Toshiba)(PORT=1521)))
   Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
   TNS-12555: TNS:permission denied
   TNS-12560: TNS:protocol adapter error
   TNS-00525: Insufficient privilege for operation
   Linux Error: 1: Operation not permitted

 

   solution: chmod 777 /var/tmp/.oracle

                        the 1521 is used  by applications,change the 1522 or others

 4.TNS-12547: TNS:lost contact
    TNS-12560: TNS:protocol adapter error
    TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

 

    solution: clear listener.log


5.SQL> conn sys/oracle@oraclelsh as sysdba;
ERROR:
ORA-12523: TNS: 监听程序无法找到适用于客户机连接的例程

 

solution:tnsping oraclelsh

            set oracle_sid,oracle_home

            sqlnet.ora .(server=dedicated)

we login from the remote clients.

 

6.

 

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值