Re: Taking Binary backup while instance is running

  • From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Dec 2010 17:09:45 +0530

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
> ==============================
>

Other related posts: