No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


wrong permission of files lead to failed to start up listener of oracle database

Publication Date:  2014-06-30 Views:  466 Downloads:  0
Issue Description
The listener of oracle database failed to start up, when we run command "lsnrctl start", we got below error message:
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

Alarm Information
Handling Process
run below command to correct the permission:
chmod 777 /var/tmp/.oracle

and then try to startup the lisnter, it worked fine. problem  solved.
Root Cause
from the error : TNS-00525: Insufficient privilege for operation. check this error on the internet , we found it maybe caused by wrong permission of "/var/tmp/.oracle"

execute command: ll -a /var/tmp

db2:/var/tmp # ll -a /var/tmp
total 36
drwxr--r--  2 root   root     4096 Mar 27  2013 .oracle

from the result we know oracle user don't have permission to run this command. that should be the problem.
the error code is very useful to solve the problem of oracle database