Taking Binary backup while instance is running

From: Shastry(DBA) <"Shastry>
Date: Mon, 13 Dec 2010 13:20:13 +0530
Message-ID: <AANLkTi=_8sBdmGUSU0tVcO6mPxdrwPz3Tw26qvxU1yRj_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 13 2010 - 01:50:13 CST

Original text of this message