使用lsnrctl start启动TNS Listener失败的解决办法
| 分类: 性能测试之【DB篇】 |
http://s6/mw690/540701bfgd7a77961d7e5&690start启动TNS Listener失败的解决办法" TITLE="使用lsnrctl start启动TNS Listener失败的解决办法" />
原因:ORACLE_HOME变量设置错误
解决办法:重新设置ORACLE_HOME变量,如:export ORACLE_HOME=/home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1/
启动TNS Listener:
[uim722@coprflv0114 bin]$ ./lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-MAR-2013 07:57:06
Copyright (c) 1991, 2009, Oracle. All rights
reserved.
Starting /home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /home/uim722/Oracle/DB11g/diag/tnslsnr/coprflv0114/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=coprflv0114.us.oracle.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date
11-MAR-2013 07:57:06
Uptime
0 days 0 hr. 0 min. 0 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File
/home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File
/home/uim722/Oracle/DB11g/diag/tnslsnr/coprflv0114/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=coprflv0114.us.oracle.com)(PORT=1521)))
The listener supports no services
The command completed successfully
原因:ORACLE_HOME变量设置错误
解决办法:重新设置ORACLE_HOME变量,如:export ORACLE_HOME=/home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1/
启动TNS Listener:
[uim722@coprflv0114 bin]$ ./lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-MAR-2013 07:57:06
Copyright (c) 1991, 2009, Oracle.
Starting /home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /home/uim722/Oracle/DB11g/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /home/uim722/Oracle/DB11g/diag/tnslsnr/coprflv0114/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=coprflv0114.us.oracle.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias
Version
Start Date
Uptime
Trace Level
Security
SNMP
Listener Parameter File
Listener Log File
Listening Endpoints Summary...
The listener supports no services
The command completed successfully

加载中…