AIX 未开启AIO引起SQLPLUS登陆报错exec(): 0509-036

来源:互联网 发布:soc软件品牌 编辑:程序博客网 时间:2024/06/05 10:25
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>

0 0
原创粉丝点击