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 */
Database Oracle11g Listener Can't Start Due to TNS Permission Denied
Feb 6, 2017 4:35 PM
Filed Under: explor, oracle |0 comments
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment