02.Oracle/DataBase2008. 7. 18. 14:13
반응형

오라클 엔진을 다른 디렉토리로 옮긴후에 아래와 같은 에러 발생
/usr/oracle -> /oracle


$ lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 25-SEP-2002 19:13:30

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Starting /oracle/app/oracle/product/8.1.7/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production
System parameter file is /oracle/app/oracle/product/8.1.7/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=su405.chonbuk.ac.kr)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
TNS-01201: Listener cannot find executable /usr/oracle/app/oracle/product/8.1.7/bin/extproc for SID
PLSExtProc


@ 해결책

$ cd $ORACLE_HOME/network/admin
$ vi listener.ora

(ORACLE_HOME = /usr/oracle/app/oracle/product/8.1.7)
->
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)

[출처] [Oracle] 오라클 리스너 실행이 안될때 해결책|작성자 poporena

Posted by 1010