TNS-12555: TNS:permission denied| TNS-12560: |TNS:protocol adapter error |TNS-00525: Insufficient privilege for operationLinux Error: 1: Operation not permitted

Whenever the oracle user permissions are modified or deleted from OS,the authentication of oracle user would be revoked

We can find some temporary debris socket files of the old oracle user listener permissions to access the oracle home

As a quick fix,delete all the temp files generated by listener in /var/tmp/.oracle directory which was used earlier

The key file placed on the directory which fails authentication

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19x)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

So these socket files should be deleted by root user because oracle already use these processes and dont have permissions to delete these files

Before deleting these files just take a backup copy of all the files in case of any issues

Cleanup the files

Listener is started successfully!

These socket files are used by listener process to exchange data to other oracle processes

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s