0509-130 Symbol resolution failed for /oracle/app/oracle/12.2.0/db_1/lib/libons.so问题处理

在AIX 7.2上安装Oracle 12.2后sqlplus启动不了，出现0509-130 Symbol resolution failed for /oracle/app/oracle/12.2.0/db_1/lib/libons.so because错误

操作系统版本

$ oslevel -s
7200-04-05-2148

启动sqlplus出现报错

$ sqlplus / as sysdba
exec(): 0509-036 Cannot load program sqlplus because of the following errors:
        0509-130 Symbol resolution failed for /oracle/app/oracle/12.2.0/db_1/lib/libons.so because:
        0509-136   Symbol CreateIoCompletionPort (number 93) is not exported from
                   dependent module /unix.
        0509-136   Symbol GetQueuedCompletionStatus (number 94) is not exported from
                   dependent module /unix.
        0509-136   Symbol ReadFile (number 95) is not exported from
                   dependent module /unix.
        0509-136   Symbol WriteFile (number 96) is not exported from
                   dependent module /unix.
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.

该问题是由于iocp参数果然没有改，检查iocp参数

# lsdev |grep iocp
iocp0      Defined               I/O Completion Ports

查询得知iocp参数为Defined，要将其改成 available

# chdev -l iocp0 -P -a autoconfig='available';
iocp0 changed

该参数要重启生效

# shutdown -Fr

SHUTDOWN PROGRAM
Thu Jun  9 10:58:13 CST 2022

重启后检查iocp参数

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

尝试启动sqlplus

# su - oracle
$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jun 9 11:08:51 2022

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

Connected to an idle instance.

至此，问题解决