20121203 监听启不来

---重启数据库后监听启动不起来

根据日志发现是listener.ora中配置的$ORACLE_HOME有问题,修改后重启成功

oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Dec 2 23:01:52 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2154176 bytes
Variable Size            1023410496 bytes
Database Buffers          570425344 bytes
Redo Buffers                7421952 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 02-DEC-2012 23:02:42

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

Starting /oracle/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
System parameter file is /oracle/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/diag/tnslsnr/mds/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.65.2.9)(PORT=1521)))
TNS-01201: Listener cannot find executable /opt/oracle/app/oracle/product/11.1.0/db_1/bin/oracle for SID mds

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

oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> more listener.ora
# listener.ora Network Configuration File: /oracle/app/product/11g/db/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.65.2.9)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ora11g)
      (ORACLE_HOME = /opt/oracle/app/oracle/product/11.1.0/db_1)
      (SID_NAME = mds)
    )
  )
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin>
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin>
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> ls
20121203listener.ora        listener.ora_bak_1121       samples                     tnsnames.ora
listener.ora                listener10111912AM0926.bak  shrept.lst                  tnsnames10111912AM0926.bak
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> more listener.ora
# listener.ora Network Configuration File: /oracle/app/product/11g/db/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.65.2.9)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ora11g)
      (ORACLE_HOME = /opt/oracle/app/oracle/product/11.1.0/db_1)
      (SID_NAME = mds)
    )
  )
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> tail -f /oracle/app/diag/tnslsnr/mds/listener/alert/log.xml
 host_addr='UNKNOWN'>
 <txt>TNS-01201: Listener cannot find executable /opt/oracle/app/oracle/product/11.1.0/db_1/bin/oracle for SID mds
 </txt>
</msg>
<msg time='2012-12-02T23:02:42.619-05:45' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='mds'
 host_addr='UNKNOWN'>
 <txt>No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.65.2.9)(PORT=1521)))
 </txt>
</msg>

^Coracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> cd /opt/oracle/app/oracle/product/11.1.0/db_1/bin/oracle
ksh: /opt/oracle/app/oracle/product/11.1.0/db_1/bin/oracle:  not found.
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> cd $ORACLE_HOME
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1> PWD
ksh: PWD:  not found.
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1> pwd
/oracle/app/oracle/product/11.1.0/db_1
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1> cd /opt/oracle/app/oracle/product/11.1.0/db_1
ksh: /opt/oracle/app/oracle/product/11.1.0/db_1:  not found.
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1> cd /oracle/app/oracle/product/11.1.0/db_1/network/admin
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> ls
20121203listener.ora        listener.ora_bak_1121       samples                     tnsnames.ora
listener.ora                listener10111912AM0926.bak  shrept.lst                  tnsnames10111912AM0926.bak
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> vi listener.ora
"listener.ora" 17 lines, 449 characters
# listener.ora Network Configuration File: /oracle/app/product/11g/db/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.65.2.9)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ora11g)
      (ORACLE_HOME = /oracle/app/oracle/product/11.1.0/db_1)
      (SID_NAME = mds)
    )
  )
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"listener.ora" 17 lines, 445 characters
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> ls
20121203listener.ora        listener.ora_bak_1121       samples                     tnsnames.ora
listener.ora                listener10111912AM0926.bak  shrept.lst                  tnsnames10111912AM0926.bak
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 02-DEC-2012 23:09:40

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

Starting /oracle/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
System parameter file is /oracle/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/diag/tnslsnr/mds/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.65.2.9)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.65.2.9)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
Start Date                02-DEC-2012 23:09:41
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/app/diag/tnslsnr/mds/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.65.2.9)(PORT=1521)))
Services Summary...
Service "ora11g" has 1 instance(s).
  Instance "mds", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle:mds:/oracle/app/oracle/product/11.1.0/db_1/network/admin>