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

還不算暈發表於2015-07-30
AIX Version 5.3
Oracle8i Enterprise Edition Release 8.1.7.4.0

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


oracle@AAAAA:/u01>relink all
*******

oracle@AAAAA:/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

重啟後正常:
oracle@AAAAA.prod:/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>

相關文章