启动监听失败~
oracle@linux119:~> lsnrctl start
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 06-NOV-2012 09:59:23
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Starting /opt/oracle/product/11g/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /opt/oracle/product/11g/db/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/linux119/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux119)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
TNS-01201: Listener cannot find executable /home/oracle/app/product/11/db/bin/oracle for SID ora11g
---------------------解决---------------------------
oracle@linux119:~/product/11g/db/network/admin> pwd
/opt/oracle/product/11g/db/network/admin
oracle@linux119:~/product/11g/db/network/admin> vi listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/11g/db/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.212.119)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ora11g)
(ORACLE_HOME =/opt/oracle/product/11g/db)---------oracle_home 被改变,使用 echo $ORACLE_HOME 查看该路径。