Redhat6.2安装Oracle11g客户端及遇到的问题分析 - 数据库编程

96 Jul 8 09:49 light drwxr-xr-x. 3 oracle oinstall 4096 Jul 8 09:49 odbc -rw-r--r--. 1 oracle oinstall 1996228 Jul 31 2009 ojdbc5.jar -rw-r--r--. 1 oracle oinstall 2111220 Jul 31 2009 ojdbc6.jar -rw-r--r--. 1 oracle oinstall 1656280 Aug 2 2009 orai18n.jar -rw-r--r--. 1 oracle oinstall 82983 Aug 2 2009 orai18n-mapping.jar -rw-r-----. 1 oracle oinstall 55 Jul 8 09:48 oraInst.loc -rwxr-xr-x. 1 oracle oinstall 6909 Aug 1 2009 sqlplus -rwxr-xr-x. 1 oracle oinstall 377507 Aug 13 2009 wrc -rw-r--r--. 1 oracle oinstall 37807 Aug 13 2009 xstreams.jar
此处如果提示找不到libsqlplus.so文件，并不是因为缺少包，而是因为没有指定LD_LIBRARY_PATH环境变量，或是指定错了位置（指定到了$ORALCE_HOME/lib下）
[oracle@Ptyjkweb client_1]$ ldd sqlplus linux-gate.so.1 => (0x00322000) libsqlplus.so => not found libclntsh.so.11.1 => not found libnnz11.so => not found libdl.so.2 => /lib/libdl.so.2 (0x00bd3000) libm.so.6 => /lib/libm.so.6 (0x00147000) libpthread.so.0 => /lib/libpthread.so.0 (0x0021f000) libnsl.so.1 => /lib/libnsl.so.1 (0x00110000) libc.so.6 => /lib/libc.so.6 (0x00745000) /lib/ld-linux.so.2 (0x00476000) libaio.so.1 => not found
此时会发现有4个库文件为“not found”状态，而一旦LD_LIBRARY_PATH环境变量配置正确，上面3个库文件就会链接正常，如下：
[oracle@Ptyjkweb client_1]$ sqlplus / as sysdba sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
[oracle@Ptyjkweb logs]$ which sqlplus /oracle/client_1/sqlplus [oracle@Ptyjkweb logs]$ cd /oracle/client_1/ [oracle@Ptyjkweb client_1]$ ldd sqlplus linux-gate.so.1 => (0x00322000) libsqlplus.so => /oracle/client_1/libsqlplus.so (0x003ac000) libclntsh.so.11.1 => /oracle/client_1/libclntsh.so.11.1 (0xf5a23000) libnnz11.so => /oracle/client_1/libnnz11.so (0x004f8000) libdl.so.2 => /lib/libdl.so.2 (0x00bd3000) libm.so.6 => /lib/libm.so.6 (0x00147000) libpthread.so.0 => /lib/libpthread.so.0 (0x0021f000) libnsl.so.1 => /lib/libnsl.so.1 (0x00110000) libc.so.6 => /lib/libc.so.6 (0x00745000) /lib/ld-linux.so.2 (0x00476000) libaio.so.1 => not found

现在只剩下libio.so.1这个库文件无法正常链接，其实也是因为缺少安装包，目前也仅安装了64位的包
[oracle@Ptyjkweb client_1]$ rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio libaio-0.3.107-10.el6.x86_64 libaio-devel-0.3.107-10.el6.x86_64
曾尝试直接从别的11g库(64 bit)中将libaio.so.1文件拷贝到/oracle/client_1目录下，执行sqlplus时会报以下错误： sqlplus: error while loading shared libraries: libaio.so.1: wrong ELF class: ELFCLASS64

[root@Ptyjkweb Packages]# pwd /mnt/Server/Packages [root@Ptyjkweb Packages]# ls -l |grep libaio -r--r--r--. 201 root root 21664 Aug 17 2010 libaio-0.3.107-10.el6.i686.rpm -r--r--r--. 149 root root 21752 Aug 17 2010 libaio-0.3.107-10.el6.x86_64.rpm -r--r--r--. 173 root root 13580 Aug 17 2010 libaio-devel-0.3.107-10.el6.i686.rpm -r--r--r--. 128 root root 13516 Aug 17 2010 libaio-devel-0.3.107-10.el6.x86_64.rpm [root@Ptyjkweb Packages]# rpm -ivh libaio-0.3.107-10.el6.i686.rpm Preparing... ########################################### [100%] 1:libaio ########################################### [100%] [root@Ptyjkweb Packages]# rpm -ivh libaio-devel-0.3.107-10.el6.i686.rpm Preparing... ########################################### [100%] 1:libaio-devel ########################################### [100%] [root@Ptyjkweb Packages]# rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio libaio-0.3.107.10.el6 (x86_64) libaio-devel-0.3.

Redhat6.2安装Oracle11g客户端及遇到的问题分析(四)