you may try with relink check the link http://www.puschitz.com/TuningLinuxForOracle.shtml in the link go to following section and check whether its applicable in your case *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 async I/O without installing the libaio RPM, then you will get an error message similar to this one: SQL> connect / as sysdbaoracleorcl: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory ERROR: ORA-12547: TNS:lost contact Thanks! Subodh n 13 December 2010 17:09, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: Hi Subodh, > > I moved the patched oracle home to the old name and didnt require any > change in tnsnames and listener.ora files. Does it require a relink of > binary if I go with this method? please advice. ETL jobs are fired on the > same host but with a different username. Invalid jobs are also compiled, ETL > jobs doesnot use db_links. > Please help. > > Thanks, > anant > > On Mon, Dec 13, 2010 at 4:03 PM, Subodh Deshpande < > deshpande.subodh@xxxxxxxxx> wrote: > >> does the environment variable points to proper oracle home.. >> it sounds like you also had changed oracle home, if so then is the new >> tnsnames ora points to correct databases with new home(check new >> listener.ora) and did you checked the connectivity from any client with a >> query not just with tnsping >> >> from where these ETL jobs are fired are they dba jobs.. >> after patching did you comipled all the objects and further are there any >> database links being used, are these links valid >> >> thanks..subodh >> On 13 December 2010 13:20, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: >> >>> Hi All, >>> >>> I recently had a task on CPU Patching July 10 on my production >>> instance (runs with HP-UX 64 bit PA-RISC). We had less time to apply the >>> patch on production as it took more time on Dev and Stage. We took an online >>> backup of binary and renamed it as 9208_BAK and exported all the required >>> parameters like LD_LIBRARY_PATH, ORACLE_HOME, PATH, usr/bin/cc etc to point >>> to the backed-up oracle home on the same server. The opatch applied >>> successfully on new oracle home and kept it ready for catcpu.sql to run >>> during the downtime window. Post moving the oracle home back to 9208, >>> applied @catcpu.sql successfully. Observations found nothing on alert log >>> and patch logs. Now some of the application ETL jobs facing TNS -host lost >>> contact post CPU patch(No changes done at apps side). Please help in >>> understanding where exactly issue lies when am able to tnsping from external >>> host and connect to DB without any issue. what might have created issues in >>> terms of libraries, oracle binary files? >>> >>> Thanks, >>> Anant >>> >> >> >> >> -- >> ============================== >> DO NOT FORGET TO SMILE TODAY >> ============================== >> > > -- ============================== DO NOT FORGET TO SMILE TODAY ==============================