Home » Infrastructure » Linux » unable to connect to database (Redhat 4.0 , Oracle 10g Enterprise)
unable to connect to database [message #353298] Mon, 13 October 2008 04:58 Go to next message
alan7193
Messages: 4
Registered: September 2008
Junior Member
After typing the following command:

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=oracle
$ORACLE_HOME/bin/lsnrctl start

The error is as follows:

Error listening on :(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS: PERMISSION denied
TNS-12560: TNS: protocol adapter error
TNS-00525: TNS: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...
Re: unable to connect to database [message #353308 is a reply to message #353298] Mon, 13 October 2008 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-00525: Insufficient privilege for operation
 *Cause:  Operating system failed to complete operation because user
 lacked sufficient privileges.
 *Action: Check your platform-specific privileges.

Regards
Michel
Re: unable to connect to database [message #353430 is a reply to message #353298] Mon, 13 October 2008 20:19 Go to previous messageGo to next message
alan7193
Messages: 4
Registered: September 2008
Junior Member
I'm a newbie in linux and oracle. Pls advise me what should i do?
Re: unable to connect to database [message #537983 is a reply to message #353298] Tue, 03 January 2012 04:52 Go to previous message
nitsmrinal
Messages: 1
Registered: January 2012
Location: kolkata
Junior Member
please check whether the current user has 777 permission for /var/tmp/.oracle..

Further details i found in a blog samadhandba.wordpress.com/2011/09/21/tns-12555-tns-12560-tns-00525-error-listening-on-descriptionaddressprotocolipckeyextproc1

Cause:

1) Ensure that /tmp/.oracle or /var/tmp/.oracle directory exists.

2) Confirm that the DBA user who is trying to start the listener has adequate read and write permissions on the directory specified above. The permissions should be 777.

3) If the /tmp directory has reached full capacity, this would cause the listener to fail to write the socket files.

Solution

To implement the solution, please use the following example:

1. cd /var/tmp

2. Check the whether the .oracle directory exists:

cd .oracle

3. If the directory does not exist, request the System Administrator create the directory and set the ownership as root:root with the permissions set to 01777

mkdir /var/tmp/.oracle
chmod 01777 /var/tmp/.oracle
chown root /var/tmp/.oracle
chgrp root /var/tmp/.oracle

4. Next try starting the TNS Listener using the 'lsnrctl start <listener_name>' command.
Previous Topic: can't start DBCA
Next Topic: I am not connected DATABASE
Goto Forum:
  


Current Time: Thu Mar 28 16:30:51 CDT 2024