I first encountered this error message when installing 18.104.22.168 on AIX, and have since hit this with other Oracle software, particularly Enterprise Manager agent.
HKE1DEV2@[/home/oracle]#sqlplus exec(): 0509-036 Cannot load program sqlplus because of the following errors: rtld: 0712-001 Symbol CreateIoCompletionPort was referenced from module /u01/app/oracle/product/22.214.171.124/client/lib/libttsh12.so(), but a runtime definition of the symbol was not found. rtld: 0712-001 Symbol GetMultipleCompletionStatus was referenced from module /u01/app/oracle/product/126.96.36.199/client/lib/libttsh12.so(), but a runtime definition of the symbol was not found.
The solution to this problem can be found in the Database Installation Guide
On IBM AIX on POWER Systems (64-Bit), enable I/O completion ports (IOCP) to ensure successful database and grid infrastructure installation.
You can check the current status with the following command:
/usr/sbin/lsdev -c iocp -F status
The result should be “Available”.
If it is not you should change it, either do this through smitty:
- Select Change/Show Characteristics of I/O Completion Ports.
- Change State to be configured at system restart from Defined to Available.
- Reboot the AIX server.
Or you can make the change directly with the following command:
mkdev -l iocp0