Database Oracle11g Listener Can't Start Due to TNS Permission Denied

Feb 6, 2017 4:35 PM


There is a problem with Oracle database. The database is failed to start and the listner failed too. Bellow the step of diagnosis and troubleshooting I have already taken.
 
1 Symptom : 
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied



2 Testing :
-bash-3.2$ lsnrctl start
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 23-JAN-2017 15:34:56
Copyright (c) 1991, 2009, Oracle.  All rights reserved.


Starting /export/oracle/product_11/db_1/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
System parameter file is /export/oracle/product_11/db_1/network/admin/listener.ora
Log messages written to /export/oracle/diag/tnslsnr/standbyB/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Solaris Error: 13: Permission denied
Listener failed to start. See the error message(s) above...


Testing over SQL command line :
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=standbyB)(PORT=1521))'
 



3. Checking & fix it :
Check the permission of oracle log file at /var/tmp/.oracle directory. Then make sure that the permission is set for oracle user and group.

-bash-3.2$ ls -l /var/tmp/.oracle/*
srwxrwxrwx   1 wardi    wardi          0 Jan 21 11:35 /var/tmp/.oracle/s#3647.1
srwxrwxrwx   1 wardi    wardi          0 Jan 21 11:35 /var/tmp/.oracle/sEXTPROC1521


bash-3.2# chown -R oracle:oinstall /var/tmp/.oracle
-bash-3.2$ ls -l /var/tmp/.oracle/
total 0
srwxrwxrwx   1 oracle   oinstall       0 Jan 21 11:35 s#3647.1
srwxrwxrwx   1 oracle   oinstall       0 Jan 23 15:39 sEXTPROC1521
 


4. Test start the Listener :
-bash-3.2$ lsnrctl start

LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 23-JAN-2017 15:39:08

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

Starting /export/oracle/product_11/db_1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
System parameter file is /export/oracle/product_11/db_1/network/admin/listener.ora
Log messages written to /export/oracle/diag/tnslsnr/standbyB/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date                23-JAN-2017 15:39:10
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /export/oracle/product_11/db_1/network/admin/listener.ora
Listener Log File         /export/oracle/diag/tnslsnr/standbyB/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
 

5. Testing SQL :
-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 6 16:21:49 2017

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


/* EOF */

0 comments:

Popular Posts

Copyright @ 2010-2019 Suryaningrat Suwardi. Powered by Blogger.

Article list :