Month: July 2020

Application Cold Backup of ORACLE R12.2 step by steps

Leave a Comment / Application Cold Backup in r12.2 / By

      1. Crontab Check If you want to take cold backup, first check-in Application Crontab Job scheduled or not     Check the status of the crontab [applprod@r12prdappl ~]$ crontab -l #Report_archive 00 17 * * * . /home/applprod/scripts/report_archive.sh #Application_Binaries_backup 00 01 * * 1-5 sh /home/applprod/scripts/Prod_binaries.sh > /tmp/Prod_binaries_daily_bkp.log Disable the crontab [applprod@r12prdappl ~]$ …

Application Cold Backup of ORACLE R12.2 step by steps Read More »

DB Cold Backup of ORACLE R12.2 step by step

Leave a Comment / DB Cold Backup in ORACLE r12.2 / By

  1. Crontab Check If you want to take cold backup, first check-in database   Crontab Job scheduled or not     Check the status of the crontab   [root@r12prddb ~]# crontab -l   00 01 * * 1-5 su oraprod -c “. /home/oraprod/rman_script/Prod_rman_fullbkp.sh” 40 01 * * 1-5 su oraascp -c “. /home/oraascp/rman_scripts/rman_full_backup.sh”   40 02 * …

DB Cold Backup of ORACLE R12.2 step by step Read More »

ERROR “Use of uninitialized value $result in split “at /u01/TESTASCP/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.

Leave a Comment / ERROR "Use of uninitialized "- ADOPValdidationUtils.pmline / By

      I started adop patch, the first phase  I got this type of Error The file txkADOPValidations.error for adop session shows the following:      Use of uninitialized value $result in split at      /u01/TESTASCP/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.       Root Cause is Patch context file is missing in the FND_OAM_CONTEXT_FILES table   …

ERROR “Use of uninitialized value $result in split “at /u01/TESTASCP/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294. Read More »

ADOP (Online Patch ) 12.2 Steps

2 Comments / adop, adop -staus, ADOP (Online Patch ) 12.2 Steps, Adop online patch, adop patch, Online Patch, R12.2 adop / By

There are below 5 Phases of ADOP(online patching):  PREPARE  APPLY  FINALIZE  CUTOVER  CLEANUP Steps:- 1. Download the patch and unzip on patch_top. 2. Must go through Readme.html or readme.txt. 3. Prepare the system for patching source the run file system   $ adop phase=prepare   4. Check the adop status $ adop -status 5. Goto …

ADOP (Online Patch ) 12.2 Steps Read More »

ORA-00257:archiver error, connect internal only until freed

Leave a Comment / Archive Error, connect internal only until freed, ORA-00257:archiver error / By

log shows below error and users are unable to connect to the database   First check  in alert log Following is error is  Errors in file u01oracleproduct11.2.0diagrdbmsTESTPRODtestprodtracetest_arc1_1010.trc ORA-16038: log 3 sequence# 1459 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 3 thread 1: ‘u01oracleoradataTESTPRODredo03.LOG’ Cause of this message is because archive …

ORA-00257:archiver error, connect internal only until freed Read More »