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
About Mariami Kupatadze
DBA Knowledge Base 