ITPub博客

首页 > 数据库 > Oracle > 监听无法启动报TNS-01150 TNS-01153错误

监听无法启动报TNS-01150 TNS-01153错误

原创 Oracle 作者:super_sky 时间:2013-12-03 16:59:52 0 删除 编辑

业务新装的数据库,在启动监听的时候报TNS-01150 TNS-01153错误,下面是错误信息

ecctest:orar6d 42> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-DEC-2013 15:35:29
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Starting /oracle/R6D/112_64/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /oracle/R6D/112_64/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/ecctest/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=R6D.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=R6D)))
TNS-01150: The address of the specified listener name is incorrect
 TNS-01153: Failed to process string: (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=ecctest)(PORT=1521))
Listener failed to start. See the error message(s) above...
ecctest:orar6d 43>

导致这一问题的是ASO没有安装或者ASO没有完成安装。
通过adapters命令,可以看到如下信息

Installed Oracle Net transport protocols are:
IPC
BEQ
Error!!! TCP/IP is not completely installed!
Present in libntcp10, but
missing from ntcontab.o...
Error!!! SSL is not completely installed!
Present in libntcps10, but missing from ntcontab.o...
RAW
Error!!!
SDP/IB is not completely installed!
Present in libntcp10, but missing from ntcontab.o...

这说明ntcontab.o没有正确安装,这个问题可能发生在安装或者打patch过程中。解决这个问题只需要重新安装ntcontab.o即可。

1)确认环境变量参数,ORACLE_HOME和LD_LIBRARY_PATH
ORACLE_HOME=
LD_LIBRARY_PATH=$ORACLE_HOME/lib
2)关闭数据库
3)执行下面的步骤
$ script /tmp/relink_adapt.out
$ cd $ORACLE_HOME/bin
$ ./gennttab
$ cd $ORACLE_HOME/network/lib
$ make -f ins_net_client.mk ntcontab.o
$ cd $ORACLE_HOME/bin
$ genclntsh
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk install
$ cd $ORACLE_HOME/sqlplus/lib
$ make -f ins_sqlplus.mk install
$ cd $ORACLE_HOME/network/lib
$ make -f ins_net_client.mk install
$ cd $ORACLE_HOME/network/lib
$ make -f ins_net_server.mk install
$ exit
4)在此检查
$ cd $ORACLE_HOME/bin
$ adapters oracle

5)启动监听,问题解决。

参考文档:
Listener Fails To Start On Tcps Protocol With TNS-01153 And TNS-01150 (文档 ID 837910.1)
ORA-12157 On Bequeath Connections After Installation (文档 ID 435795.1)

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

请登录后发表评论 登录
全部评论

注册时间:2011-01-11

  • 博文量
    77
  • 访问量
    807921