Failure to turn on asynchronous I/O on Red Hat Linux 9 , trying to improve Oracle9iR2 performance.
|
| Author | Content |
|---|---|
| dba477 Sep 06, 2004 10:47 PM EDT |
1. Installed kernel-2.4.20-35.9.i686.rpm
and reboot the Red Hat Linux 9 Server
2. Installed libaio-0.3.93-4.src.rpm
3. Patched 3 source files as advised in http://developer.osdl.org/daniel/libaio/patch.libaio-0.3-93.... 4.Rebuild and reinstalled libaio-0.3.93-4.rpm 5.Successfully compiled:- make -f ins_rdbms.mk async_on make -f ins_rdbms.mk ioracle Notice: Compilation failed before applying patch 6. Added to init.ora files:- disk_asynch_io=true filesystemio_options=asynch $lsnrctl start (OK) Attempt to start oracle instances:- [oracle@ServerDFW dbs]$ dbstart SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 6 21:44:12 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> oracledata01: relocation error: oracledata01: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference ERROR: ORA-12547: TNS:lost contact SQL> oracledata01: relocation error: oracledata01: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference oracledata01: relocation error: oracledata01: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference ORA-12547: TNS:lost contact SQL> SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 6 21:44:13 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> oraclesrvdata: relocation error: oraclesrvdata: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference ERROR: ORA-12547: TNS:lost contact SQL> oraclesrvdata: relocation error: oraclesrvdata: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference oraclesrvdata: relocation error: oraclesrvdata: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference ORA-12547: TNS:lost contact SQL> Same results under original kernel-2.4.20-8. This message was edited Sep 7, 2004 1:50 AM |
| dba477 Sep 08, 2004 2:57 AM EDT |
Finally I got it working. Step by step instruction is currently in pending queue on LXER |
| dba477 Sep 08, 2004 4:50 AM EDT |
Please,view http://lxer.com/module/newswire/view/21931/index.html |
You cannot post until you login.