Saturday, July 20, 2019

Could not load program sqlplus error on AIX

First time when I finished installing Oracle Client 12.2.0.1 in AIX 7.1 and trying to run a simple ./sqlplus command, the following error was shown:

bash-4.3$ ./sqlplus
Could not load program ./sqlplus:
rtld: 0712-001 Symbol GetQueuedCompletionStatus was referenced
      from module /u01/app/oracle/client/lib/libons.so(), but a runtime definition
            of the symbol was not found.
rtld: 0712-001 Symbol ReadFile was referenced
      from module /u01/app/oracle/client/lib/libons.so(), but a runtime definition
            of the symbol was not found.
rtld: 0712-001 Symbol WriteFile was referenced
      from module /u01/app/oracle/client/lib/libons.so(), but a runtime definition
            of the symbol was not found.
bash-4.3$



It was odd, since the same installation worked with no errors in another machine, so after some research I figured out that IOCP module was not enabled on the server. It can be check by the following command:

bash-4.3$ lsdev | grep iocp

  iocp0       Defined  I/O Completion Ports


As you can see by the output above, iocp is set to Defined, which is the default configuration. In order to have the Oracle Client working properly, one must work with the system admin to have it enabled. The expected output for this command is:

bash-4.3$ lsdev | grep iocp

  iocp0    Available   I/O Completion Ports



No comments:

Post a Comment