How to Create Custom Schema in Oracle 11g /12c ?

Create  the following  details to create :   username : archive_purge password: archive123 tablespace name : archive_purge temporary tablespace name: temp To Create  tablespace : SQL>CREATE TABLESPACE archive_purge DATAFILE ‘/u01/MIC1213/db/apps_st/data/archive_purge01.dbf’ size 5G; To Create Create User : SQL> create user archive_purge identified by archive123 temporary tablespace temp default tablespace archive_purge; To Permission to User : SQL> grant connect …

How to Create Custom Schema in Oracle 11g /12c ? Read More »

Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB

      Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB  export  PERL5LIB=/u01/install/APPS/19.5.0/perl/lib/5.28.1:/u01/install/APPS/19.5.0/perl/lib/site_perl/5.28.1 export PATH=/u01/install/APPS/19.5.0/bin:$PATH export LD_LIBRARY_PATH=/u01/install/APPS/19.5.0/lib   CONTAINER DB NAME=EBSCDB1 pluggable  DB NAMe=EBSDB1   1. I got new server , so that I checked prerequest **************************************************   Red Hat Enterprise Linux Server release 7.7 (Maipo)     Use the “oracle-database-preinstall-19c” package to …

Cloning Oracle E-Business Suite R12.2.6 using 19c database Single PDB Read More »

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 »