Wednesday, February 17, 2016

2211262 - Oracle Listener cannot be started

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


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
Among other. The common behavior is the error while starting it manually, as described in the Symptom.


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:
  1. /tmp/.oracle
  2. /var/tmp/.oracle
Correct by either changing the ownership or granting more privileges:
  1. chown ora<sid>.dba /tmp/.oracle
  2. 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
BC-INS-UNX Installation Unix
Priority Normal
Category Problem

No comments:

Post a Comment