Show Table of Contents
12.2. Relinking Oracle 10g to Enable Asynchronous I/O Support
Ensure that for 10g Release 1 and 2 the
libaio and libaio-devel RPMs are installed on the system:
# rpm -q libaio libaio-devel libaio-0.3.96-5 libaio-devel-0.3.96-5
If you relink Oracle for asynchronous I/O without installing the
libaio RPM, then you will get an error message similar to this one:
SQL> connect / as sysdba oracleorcl: error while loading shared libraries: libaio.so.1: cannot open \ shared object file: No such file or directory ERROR: ORA-12547: TNS:lost contact
The
libaio RPMs provide a native Linux asynchronous I/O API. In other words this is a kernel accelerated asynchronous I/O for the POSIX asynchronous I/O facility.
Note
10g Release 2 is shipped with asynchronous I/O support enabled. This means that 10g Release 2 does not need to be relinked. However, there is a bug in Oracle 10.1.0.2 that causes asynchronous I/O not to be installed correctly which can result in poor DB performance, see Bug:3438751 and Note:270213.1.
To relink Oracle 10g R1 for asynchronous I/O, execute the following commands:
# shutdown Oracle SQL> shutdown su - oracle $ cd $ORACLE_HOME/rdbms/lib $ make PL_ORALIBS=-laio -f ins_rdbms.mk async_on
If asynchronous I/O needs to be disabled, run the following commands:
# shutdown Oracle SQL> shutdown su - oracle $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk async_off

Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.