TNS-12557: TNS:protocol adapter not loadable TNS-12560: TNS:protocol adapter error

Description:

Oracle 10.2 on hpux 11.23 PA. When i try to start listener i go the next errors:

Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pav2qa2)(PORT=1521)))
TNS-12557: TNS:protocol adapter not loadable
 TNS-12560: TNS:protocol adapter error
  TNS-00527: Protocol Adapter not loadable

Solution:

1. Check if you have correct ORACLE_HOME, ORACLE_SID and PATH environments.

2. Check if /tmp/.oracle and /var/tmp/.oracle directories exists.

3. Check permissions for those directories for current user who is trying to start listener.

mkdir /var/tmp/.oracle

mkdir /tmp/.oracle

chown -R oracle:oinstall /var/tmp/.oracle /tmp/.oracle

chmod -R 01777 /var/tmp/.oracle /tmp/.oracle

 

4. Run the listener, problem solved:

lsnrctl start

 

5. If you still cant start listener grant 777 permissions to oracle on /tmp directory.

chmod -R 777 /tmp /var/tmp