Oracle sqlplus登陆异步io错误
先简单交代一下操作环境，主机版本为AIX 5307，数据库版本为10.2.0.4。为贪图方便，我从另一环境下（操作系统也为aix 5307），直接将Oracle软件tar至本地主机。然后进行relink all。至此，一切正常。但执行sqlplus时，出现以下问题：
引用
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 1 09:51:47 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
exec(): 0509-036 Cannot load program oracleorajf 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 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
Enter user-name: ^C
根据以上错误信息，一看就知道是aio配置问题。从AIX 5L开始，AIX开始支持2种aio：legacy AIO 和POSIX AIO。
配置legacy AIO（重启后生效）。可以用smitty aio或者用操作系统命令配置：chdev -P -l aio0 -a autoconfig=’available’
到11g为止，Oracle使用的是POSIX AIO（无需重启），配置POSIX AIO可以用如下命令
chdev -P -l posix_aio0 -a autoconfig=available。
当然也可以执行rootpre.sh来配置posix aio.
引用
# ./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_11-04-01.10:04:26
Saving the original files in /etc/ora_save_11-04-01.10:04:26....
Copying new kernel extension to /etc....
Loading the kernel extension from /etc
Oracle Kernel Extension Loader for AIX
Copyright (c) 1998,1999 Oracle Corporation
Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x3ef8900
Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x3ef8900
The kernel extension was successfuly loaded.
Configuring Asynchronous I/O....
Configuring POSIX Asynchronous I/O....
Checking if group services should be configured....
Nothing to configure.
打开rootpre.sh脚本可以看到如下语句，可以清楚的看到在AIX 5307上Oracle执行的就是红色标注部分：
引用
if [ $OSVER -lt 6 ]; then
log_con "nConfiguring Asynchronous I/O...."
AIO=`${LSDEV} -C -t aio|${AWK} '{print $2}'`
case ${AIO} in
*Available*) log_con "Asynchronous I/O is already defined"
is_autoconfig_available "aio0"
if [ $? -ne 1 ]; then
log_con "Setting autoconfig to available for aio0"
log_do "${CHDEV} -P -l aio0 -a autoconfig=available"
fi
;;
*Defined*) log_do "${MKDEV} -l aio0"
log_do "${CHDEV} -P -l aio0 -a autoconfig=available"
;;
*) log_con "Asynchronous I/O is not installed on this system."
log_con "You will need to install it, and either configure it yourself using"
log_con "'smit aio' or rerun the Oracle root installation procedure."
;;
esac
#--- configure POSIX AIO if AIX 5.2 or greater, we may want to use it
if [ ${OSVER}${OSREL} -ge 52 ]; then
log_con "nConfiguring POSIX Asynchronous I/O...."
POSIX_AIO=`${LSDEV} -C -t posix_aio|${AWK} '{print $2}'`
case ${POSIX_AIO} in
*Available*) log_con "Posix Asynchronous I/O is already defined"
is_autoconfig_available "posix_aio0"
if [ $? -ne 1 ]; then
log_con "Setting autoconfig to available for posix_aio0"
log_do "${CHDEV} -P -l posix_aio0 -a autoconfig=available"
fi
;;
*Defined*) log_do "${MKDEV} -l posix_aio0"
log_do "${CHDEV} -P -l posix_aio0 -a autoconfig=available"
;;
*) log_con "Posix Asynchronous I/O is not installed on this system."
log_con "You will need to install it, and either configure it yourself using"
log_con "'smit aio' or rerun the Oracle root installation procedure."
;;
esac
fi
fi
执行结束后sqlplus正常：
引用
# su - oracle
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 1 10:05:01 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> exit
Disconnected
引用
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 1 09:51:47 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
exec(): 0509-036 Cannot load program oracleorajf 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 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
Enter user-name: ^C
根据以上错误信息，一看就知道是aio配置问题。从AIX 5L开始，AIX开始支持2种aio：legacy AIO 和POSIX AIO。
配置legacy AIO（重启后生效）。可以用smitty aio或者用操作系统命令配置：chdev -P -l aio0 -a autoconfig=’available’
到11g为止，Oracle使用的是POSIX AIO（无需重启），配置POSIX AIO可以用如下命令
chdev -P -l posix_aio0 -a autoconfig=available。
当然也可以执行rootpre.sh来配置posix aio.
引用
# ./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_11-04-01.10:04:26
Saving the original files in /etc/ora_save_11-04-01.10:04:26....
Copying new kernel extension to /etc....
Loading the kernel extension from /etc
Oracle Kernel Extension Loader for AIX
Copyright (c) 1998,1999 Oracle Corporation
Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x3ef8900
Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x3ef8900
The kernel extension was successfuly loaded.
Configuring Asynchronous I/O....
Configuring POSIX Asynchronous I/O....
Checking if group services should be configured....
Nothing to configure.
打开rootpre.sh脚本可以看到如下语句，可以清楚的看到在AIX 5307上Oracle执行的就是红色标注部分：
引用
if [ $OSVER -lt 6 ]; then
log_con "nConfiguring Asynchronous I/O...."
AIO=`${LSDEV} -C -t aio|${AWK} '{print $2}'`
case ${AIO} in
*Available*) log_con "Asynchronous I/O is already defined"
is_autoconfig_available "aio0"
if [ $? -ne 1 ]; then
log_con "Setting autoconfig to available for aio0"
log_do "${CHDEV} -P -l aio0 -a autoconfig=available"
fi
;;
*Defined*) log_do "${MKDEV} -l aio0"
log_do "${CHDEV} -P -l aio0 -a autoconfig=available"
;;
*) log_con "Asynchronous I/O is not installed on this system."
log_con "You will need to install it, and either configure it yourself using"
log_con "'smit aio' or rerun the Oracle root installation procedure."
;;
esac
#--- configure POSIX AIO if AIX 5.2 or greater, we may want to use it
if [ ${OSVER}${OSREL} -ge 52 ]; then
log_con "nConfiguring POSIX Asynchronous I/O...."
POSIX_AIO=`${LSDEV} -C -t posix_aio|${AWK} '{print $2}'`
case ${POSIX_AIO} in
*Available*) log_con "Posix Asynchronous I/O is already defined"
is_autoconfig_available "posix_aio0"
if [ $? -ne 1 ]; then
log_con "Setting autoconfig to available for posix_aio0"
log_do "${CHDEV} -P -l posix_aio0 -a autoconfig=available"
fi
;;
*Defined*) log_do "${MKDEV} -l posix_aio0"
log_do "${CHDEV} -P -l posix_aio0 -a autoconfig=available"
;;
*) log_con "Posix Asynchronous I/O is not installed on this system."
log_con "You will need to install it, and either configure it yourself using"
log_con "'smit aio' or rerun the Oracle root installation procedure."
;;
esac
fi
fi
执行结束后sqlplus正常：
引用
# su - oracle
$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 1 10:05:01 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> exit
Disconnected