Search This Blog

Total Pageviews

Monday 19 September 2011

sqlplus / as sysdba ORA-12162: TNS:net service name is incorrectly specified

I was getting this error ...


TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
sqlplus / as sysdba ORA-12162: TNS:net service name is incorrectly specified



LSNRCTL> start
Starting /opt/oracle/product/10.2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /opt/oracle/product/10.2/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

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


oracle@tst-01:/opt/oracle/product/10.2/bin> ./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 19 09:37:47 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified


oracle@tst-01:/var/tmp # ls -ltr
total 9
drwxrwxrwt 2 root root 48 2007-05-03 14:43 vi.recover
drwx------ 4 root root 128 2011-02-24 11:49 zypp.qP07gR
drwxrwxrwt 2 root oinstall 560 2011-05-19 17:38 .oracle <<<<<<<<<<<<<<<<------ permission was not correct
drwx------ 4 root root 128 2011-08-03 15:46 zypp.ORXIAp
-rw-r--r-- 1 root root 1 2011-09-19 08:48 jk.shm.4268.lock
-rw-r--r-- 1 root root 384 2011-09-19 08:53 jk.shm.4268


ls -ltr /var/tmp/.oracle <<<<< check the permission of following dir
total 0
srwxrwxrwx 1 dmadmin oinstall 0 2010-09-09 10:43 s#9043.2
srwxrwxrwx 1 dmadmin oinstall 0 2010-09-09 10:43 s#9043.1
srwxrwxrwx 1 dmadmin oinstall 0 2010-09-16 12:37 s#19542.2
srwxrwxrwx 1 dmadmin oinstall 0 2010-09-16 12:37 s#19542.1
srwxrwxrwx 1 dmadmin oinstall 0 2010-09-23 10:34 s#13477.2
srwxrwxrwx 1 dmadmin oinstall 0 2010-09-23 10:34 s#13477.1
srwxrwxrwx 1 dmadmin oinstall 0 2010-10-11 16:41 s#26392.2
srwxrwxrwx 1 dmadmin oinstall 0 2010-10-11 16:41 s#26392.1
srwxrwxrwx 1 dmadmin oinstall 0 2010-10-14 16:54 s#16462.2
srwxrwxrwx 1 dmadmin oinstall 0 2010-10-14 16:54 s#16462.1
srwxrwxrwx 1 dmadmin dba 0 2011-05-03 12:10 s#21515.2
srwxrwxrwx 1 dmadmin dba 0 2011-05-03 12:10 s#21515.1
srwxrwxrwx 1 dmadmin dba 0 2011-05-05 11:33 s#24844.2
srwxrwxrwx 1 dmadmin dba 0 2011-05-05 11:33 s#24844.1
srwxrwxrwx 1 dmadmin dba 0 2011-05-19 17:38 sEXTPROC1
srwxrwxrwx 1 dmadmin dba 0 2011-05-19 17:38 s#9985.2
srwxrwxrwx 1 dmadmin dba 0 2011-05-19 17:38 s#9985.1



oracle@tst-01:/var/tmp # chown -R oracle:oinstall .oracle




oracle@apt-tst-01:/opt/oracle/product/10.2/bin> ./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 19 09:44:37 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

No comments:

Oracle DBA

anuj blog Archive