Header Ads Widget

TNS-12557: TNS:protocol adapter not loadable

We had below issue while starting listener after database manual clone.

See error.

LSNRCTL> start PMVTEST
Starting /u02/oradba/product/11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u02/oradba/product/11.2.0/network/admin/PMVTEST_pmvtest/listener.ora
Log messages written to /u02/oradba/product/11.2.0/admin/PMVTEST_pmvtest/diag/tnslsnr/pmvtest/pmvtest/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pmvtest)(PORT=1522)))
TNS-12557: TNS:protocol adapter not loadable
 TNS-12560: TNS:protocol adapter error
  TNS-00527: Protocol Adapter not loadable

Listener failed to start. See the error message(s) above...



Solutions:

1. please check /tmp/.oracle and /var/tmp/.oracle directory exists or not.

2. if directories does not exist, then create it as root user.

mkdir /tmp/.oracle
mkdir /var/tmp/.oracle

3. change owner and group to root.

chown root:root /tmp/.oracle
chown root:root /var/tmp/.oracle

4. change permission to 777

chmod 777 /tmp/.oracle
chmod 777 /var/tmp/.oracle


this resolved my issue.