Skip to main content
Oracle Database

Oracle Listener Failed to start on AIX

By February 8, 2023May 2nd, 2023No Comments3 min read

Tried to start the Listener on IBM AIX machine and it failed to start and reported the below errors

[oracle@oemhost:oemqa] /network/admin > lsnrctl start
exec(): 0509-036 Cannot load program lsnrctl because of the following errors:
        0509-130 Symbol resolution failed for lsnrctl because:
        0509-136   Symbol CreateIoCompletionPort (number 400) is not exported from
                   dependent module /unix.
        0509-136   Symbol GetMultipleCompletionStatus (number 401) is not exported from
                   dependent module /unix.
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.
[oracle@oemhost:oemqa] /network/admin >

Found the issue as published notes in Oracle Support notes

AIX:12c & above ,Installation/dbua/dbca/sqlplus/lsnrctl/netca Fails with “rtld: 0712-001 Symbol CreateIoCompletionPort was referenced “,’0509-130′,’0509-036′ (Doc ID 1949184.1)

To fix this issue, ask Linux administrator to fix this since it requires the root access. Instructions to Linux Administrator are below.

# smitty iocp
  Change / Show Characteristics of I/O Completion Ports
  Configure Defined I/O Completion Ports
                                                                           COMMAND STATUS

Command: OK            stdout: yes           stderr: no
Before command completion, additional instructions may appear below.

iocp0 changed
Changes will become effective at next system restart

Verify the IOCP status using below command

$ lsdev | grep iocp
iocp0 Available I/O Completion Ports

Reboot the server and then try to start the listener.

[oracle@oemhost:oemqa] /home/oracle > lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production on 05-OCT-2022 05:47:40

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Starting /opt/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production
System parameter file is /opt/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/oemhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oemhost)(PORT=1528)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oemhost.corpnmg.net)(PORT=1528)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production
Start Date                05-OCT-2022 05:47:41
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/oemhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oemhost)(PORT=1528)))
Services Summary...
Service "oemqa.corpnmg.net" has 1 instance(s).
  Instance "oemqa", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@oemhost:oemqa] /home/oracle >

After IOCP settings now the listener started successfully.

Leave a Reply