Re: Taking Binary backup while instance is running

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_at_gmail.com> 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_at_gmail.com> 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_at_gmail.com> 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 _at_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
==============================

--
http://www.freelists.org/webpage/oracle-l