Month: July 2020

Application Cold Backup of ORACLE R12.2 step by steps

      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

  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.

      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

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

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 »