天天看點

oracle exec報錯,AIX 未開啟AIO引起SQLPLUS登陸報錯exec(): 0509-036

AIX Version 5.3

Oracle8i Enterprise Edition Release 8.1.7.4.0

新接手一個環境,主機是從其它小機恢複來的,遇到一些問題,記錄一下。

[email protected]:/u01>relink all

*******

[email protected]:/u01>sqlplus '/ as sysdba'

exec(): 0509-036 Cannot load program sqlplus because of the following errors:

0509-130 Symbol resolution failed for /usr/lib/libc.a(aio.o) because:

0509-136   Symbol kaio_rdwr (number 1) is not exported from

dependent module /unix.

0509-136   Symbol listio (number 2) is not exported from

dependent module /unix.

0509-136   Symbol acancel (number 3) is not exported from

dependent module /unix.

0509-136   Symbol iosuspend (number 4) is not exported from

dependent module /unix.

0509-136   Symbol aio_nwait (number 5) is not exported from

dependent module /unix.

0509-136   Symbol aio_nwait64 (number 6) is not exported from

dependent module /unix.

0509-136   Symbol aio_nwait_timeout (number 7) is not exported from

dependent module /unix.

0509-136   Symbol aio_nwait_timeout64 (number 8) is not exported from

dependent module /unix.

0509-026 System error: Error 0

0509-192 Examine .loader section symbols with the

'dump -Tv' command.

檢視異步IO設定:

AAAAA:/# lslpp -l bos.rte.aio

Fileset                      Level  State      Description

----------------------------------------------------------------------------

Path: /usr/lib/objrepos

bos.rte.aio                5.3.7.3  APPLIED    Asynchronous I/O Extension

Path: /etc/objrepos

bos.rte.aio                5.3.7.0  COMMITTED  Asynchronous I/O Extension

AAAAA:/# lsattr -El aio0

autoconfig defined STATE to be configured at system restart True

fastpath   enable  State of fast path                       True

kprocprio  39      Server PRIORITY                          True

maxreqs    4096    Maximum number of REQUESTS               True

maxservers 10      MAXIMUM number of servers per cpu        True

minservers 1       MINIMUM number of servers                True

------------------

改變AIO設定: AAAAA:/# chdev -P -l aio0 -a autoconfig='available' 重新開機主機: AAAAAt:/# shutdown -Fr 重新開機後正常: [email protected]:/oracle>sqlplus '/ as sysdba' SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 30 16:08:23 2015 (c) Copyright 2000 Oracle Corporation.  All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL>