TNS-12555: TNS:permission denied

 

리스너를 가동 시켰는데 아래와 같은 현상이 발생

 

TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
   Linux Error: 1: Operation not permitted

 

ㅡ,.ㅡ;;;; 뭐지 이건...

찾다 찾다 해결책 찾음..

역시 나보다 먼저 삽질하신분은 항상 존재하는군요. ㅋㅋㅋ

 

chmod 777 /var/tmp/.oracle << 이 path 가 맞습니다.

 

젤 문제는 chown 이겁니다.

안되시는분은 아마 root 이거나 그룹이 엉뚱하거나 이럴겁니다.

해당 oracle과 그 해당하는 그룹으로 변경하세요.

저의 경우는 oracle:oinstall 입니다.

그래서

 

[root@redhat tmp]# chown oracle:oinstall .oracle [root@redhat tmp]# ls -al total 16 drwxrwxrwt.  4 root   root     4096 Apr  5 17:21 . drwxr-xr-x. 22 root   root     4096 Jan 13 15:54 .. drwxrwxrwt.  2 oracle oinstall 4096 Mar 20 17:15 .oracle drwx------.  5 ccuser ccuser   4096 Mar 19 15:26 kdecache-ccuser

 

 

[oracle@redhat ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-APR-2012 10:33:22 Copyright (c) 1991, 2009, Oracle.  All rights reserved. Starting /oracle/11gr2/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /oracle/11gr2/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /oracle/11gr2/diag/tnslsnr/redhat/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.233)(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                16-APR-2012 10:33:24 Uptime                    0 days 0 hr. 0 min. 0 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /oracle/11gr2/product/11.2.0/db_1/network/admin/listener.ora Listener Log File         /oracle/11gr2/diag/tnslsnr/redhat/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.233)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s).   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@redhat ~]$

 

참고 한 곳은 아래와 같습니다.

 

http://blog.naver.com/feelwoo?Redirect=Log&logNo=100068437656 : 쌩뚱보이