aix平臺執行sqlplus報:0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o]

liglewang發表於2011-06-22

客戶說執行sqlplus時報錯,詳細見下:

$ sqlplus 'sys/ligle as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 22 08:56:29 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

exec(): 0509-036 Cannot load program oraclebcrm because of the following errors:
0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
0509-136 Symbol kaio_rdwr64 (number 1) is not exported from
dependent module /unix.
0509-136 Symbol listio64 (number 2) is not exported from
dependent module /unix.
0509-136 Symbol acancel64 (number 3) is not exported from
dependent module /unix.
0509-136 Symbol iosuspend64 (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.
ERROR:
ORA-12547: TNS:lost contact

看資訊知道是可能跟aio有關係,查詢aio是否開啟?

root@hiuset_bas1:/>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 80 MAXIMUM number of servers per cpu True
minservers 1 MINIMUM number of servers True

開啟aio

root@hiuset_bas1:/>chdev -P -l aio0 -a autoconfig='available'
aio0 changed
root@hiuset_bas1:/>lsattr -El aio0
autoconfig available 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 80 MAXIMUM number of servers per cpu True
minservers 1 MINIMUM number of servers True

在執行sqlplus登陸db,沒有問題了~

--- END ---[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25834554/viewspace-1051464/,如需轉載,請註明出處,否則將追究法律責任。

相關文章