sqlplus: error while loading shared libraries: libaio.so.1:

機房登入出現問題

[oracle@tjdb01 db1]$ sqlplus / as sysdba

sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

檢視metalink,

Cause

The RPM package libaio-0.3.103-3.X86_64.RPM has not been installed.

$ rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio

libaio-0.3.105.2 (ia64)
libaio-0.3.105.2 (i386)

The output should show:

libaio-0.3.105.2 (x86_64)
libaio-0.3.105.2 (i386)

 

[oracle@tjdb01 lib]$ rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio

libaio-devel-0.3.105.2 (x86_64)

libaio-0.3.105.2 (i386)

libaio-devel-0.3.105.2 (i386)

 

發現libaio缺失，嘗試安裝

 

[root@tjdb01 ~]# yum install libaio*

Setting up Install Process

Setting up repositories

Reading repository metadata in from local files

Parsing package install arguments

Resolving Dependencies

--&gt Populating transaction set with selected packages. Please wait.

---&gt Downloading header for libaio to pack into transaction set.

libaio-0.3.105-2.x86_64.r 100% |=========================| 6.7 kB    00:00    

---&gt Package libaio.x86_64 0:0.3.105-2 set to be updated

--&gt Running transaction check

 

Dependencies Resolved

 

=============================================================================

 Package                 Arch       Version          Repository        Size

=============================================================================

Installing:

 libaio                  x86_64     0.3.105-2        el4_u8_base        18 k

 

Transaction Summary

=============================================================================

Install      1 Package(s)        

Update       0 Package(s)        

Remove       0 Package(s)        

Total download size: 18 k

Is this ok [y/N]: y

Downloading Packages:

(1/1): libaio-0.3.105-2.x 100% |=========================|  18 kB    00:01    

Running Transaction Test

Finished Transaction Test

Transaction Test Succeeded

Running Transaction

  Installing: libaio                       ######################### [1/1]

 

Installed: libaio.x86_64 0:0.3.105-2

Complete!

 

然後檢視，多出黑體字的包

[root@tjdb01 ~]# rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio

libaio-devel-0.3.105.2 (x86_64)

libaio-0.3.105.2 (x86_64)

libaio-0.3.105.2 (i386)

libaio-devel-0.3.105.2 (i386)

 

再次連線，ok

[oracle@tjdb01 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 22 11:44:47 2011

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> exit

Disconnected