Oracle命令--oracle错误TNS-01201

启动监听失败~
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 查看该路径。

 

转载于:https://www.cnblogs.com/freshbreeze/archive/2013/06/09/3134454.html