客户说执行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博客 ” ,链接:https://blog.itpub.net/25834554/viewspace-1051464/ ,如需转载,请注明出处,否则将追究法律责任。