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

业务新装的数据库，在启动监听的时候报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博客 ” ，链接：http://blog.itpub.net/11590946/viewspace-1062061/，如需转载，请注明出处，否则将追究法律责任。