| unable to connect to database [message #353298] |
Mon, 13 October 2008 04:58  |
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 #537983 is a reply to message #353298] |
Tue, 03 January 2012 04:52  |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
