Symptom
Oracle listener cannot be started. When you try to do it manually, it throws the error bellow:
<hostname>:<sid>adm $ lsnrctl start [LISTENER_NAME]
LSNRCTL for <OS>: Version 12.1.0.2.0 - Production on 30-AUG-2012 18:06:43
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /oracle/<SID>/121/bin/tnslsnr: please wait...
TNSLSNR for <OS>: Version 12.1.0.2.0 - Production
System parameter file is /oracle/<SID>/121/network/admin/listener.ora
Log messages written to /oracle/<SID>/121/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=<SID>.WORLD))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
<OS> Error: 1: Not owner
LSNRCTL for <OS>: Version 12.1.0.2.0 - Production on 30-AUG-2012 18:06:43
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Starting /oracle/<SID>/121/bin/tnslsnr: please wait...
TNSLSNR for <OS>: Version 12.1.0.2.0 - Production
System parameter file is /oracle/<SID>/121/network/admin/listener.ora
Log messages written to /oracle/<SID>/121/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=<SID>.WORLD))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
<OS> Error: 1: Not owner
Environment
- Any SAP System
- Oracle database as of 10.2
- Linux or Unix OS
Reproducing the Issue
The issue may be reproduced in several occasions, as bellow:
- Running SWPM
- Starting Oracle manually
- Starting Oracle on OS boot
Cause
This error is caused by lack of permissions in the socket files.
Resolution
Make sure that both <sid>adm and oracle/ora<sid> have full permissions in the following two directories:
- /tmp/.oracle
- /var/tmp/.oracle
- chown ora<sid>.dba /tmp/.oracle
- chmod 774 /tmp/.oracle
See Also
SAP Note 562403: FAQ: Oracle Net
Keywords
oracle lsnrctl tnslsnr swpm sapinst hpux hp-ux linux redhad red hat solaris aix suse installation upgrade
Header Data
Released On | 27.08.2015 23:49:43 | ||
Release Status | Released to Customer | ||
Component | BC-DB-ORA Oracle | ||
Other Components |
| ||
Priority | Normal | ||
Category | Problem |
No comments:
Post a Comment