Listener on TCPS, TNS-12557: TNS:protocol adapter not loadable
August 14, 2020 Leave a comment
Error
Listener configured on TCPS protocol cannot be started from 11g SE home:
[oracle@skybase ~]$ lsnrctl start LISTENER_TCPS ... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/skybase/listener_tcps/alert/log.xml Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=skybase.example.com)(PORT=1522))) TNS-12557: TNS:protocol adapter not loadable TNS-12560: TNS:protocol adapter error TNS-00527: Protocol Adapter not loadable
Reason
TCPS Support for Oracle SE not enabled.
Solution
Enable TCPS support using the following steps:
1. In $ORACLE_HOME/lib
, backup libntcps11.a
:
[oracle@skybase ~]$ cd $ORACLE_HOME/lib [oracle@skybase lib]$ cp libntcps11.a libntcps11.a.backup
2. Replace libntcps11.a
with libntcps11_ee.a.dbl
[oracle@skybase lib]$ cp libntcps11_ee.a.dbl libntcps11.a [oracle@skybase lib]$ ls -al libntcps* -rw-r--r-- 1 oracle oinstall 306314 Aug 14 16:31 libntcps11.a -rw-r--r-- 1 oracle oinstall 296986 Aug 14 16:30 libntcps11.a.backup -rw-r--r-- 1 oracle oinstall 306314 Jul 15 2013 libntcps11_ee.a.dbl
3. Stop all running processes from Oracle home:
$ srvctl stop database -d orcl
4. Relink
[oracle@skybase lib]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/lib [oracle@skybase lib]$ relink all writing relink log to: /u01/app/oracle/product/11.2.0/dbhome_1/install/relink.log
5. Start all previously stopped services and try to start listener again:
[oracle@skybase lib]$ srvctl start database -d orcl [oracle@skybase lib]$ lsnrctl start LISTENER_TCPS ... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/skybase/listener_tcps/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=skybase.example.com)(PORT=1522))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=skybase.example.com)(PORT=1522))) STATUS of the LISTENER ------------------------ Alias LISTENER_TCPS Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 14-AUG-2020 16:35:11 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/skybase/listener_tcps/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=skybase.example.com)(PORT=1522))) The listener supports no services The command completed successfully