Modern Oracle DBA

Creating Oracle 11G Database manually in Linux Operating system Step 1: Create Directory structure #cd $ORACLE_BASE # cd admin # mkdir test #cd test #mkdir adump  bdump  pfile #cd fast_recovery_area # mkdir test Step 2: Create Parameter file in  $ORACLE_HOME/dbs location cd $ORACLE_HOME/dbs vi initTEST.ora TEST.__db_cache_size=8489271296 TEST.__java_pool_size=33554432 TEST.__large_pool_size=33554432 TEST.__oracle_base='/u03/app/oradba'#ORACLE_BASE set from environment TEST.__pga_aggregate_target=3388997632 TEST.__sga_target=10166992896 TEST.__shared_io_pool_size=0 TEST.__shared_pool_size=1509949440 TEST.__streams_pool_size=33554432 *.audit_file_dest='/u03/app/oradba/admin/TEST/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u03/app/oradba/oradata/TEST/control01.ctl','/u03/app/oradba/fast_recovery_area/TEST/control02.ctl' *.db_block_size=8192 *.db_domai...

🔧 AutoConfig Overview in Oracle E-Business Suite AutoConfig is a configuration tool that automates the setup of both Application Tier and Database Tier in Oracle E-Business Suite. The required configuration information is stored in an XML repository called the Applications Context File . There is one context file for each tier — Application and Database. 🧩 AutoConfig Components Context File Driver Files Template Files 📘 Context File It contains configuration values and environment details for each server. Format: SID_HOSTNAME.xml Location: Application Tier: echo $CONTEXT_FILE Database Tier: $ORACLE_HOME/appsutil/<contextfile.xml> 📝 Template Files Template files contain placeholder tags used to create configuration files. When AutoConfig runs, these tags are replaced with actual values from the context file. Locations: Application Tier: $PRODUCT_TOP/admin/template Database Tier: $ORACLE_HOME/appsutil/template 🚀 Dri...

ADOP patch (application DBA online patch) It is relisted to R12.2 It is utility to apply online patch There are five phases are available adop phase= Prepare adop phase= apply patches=<patch _number> adop phase= finalize adop phase= cutover adop phase= cleanup   ADOP Applying process:-   Step 1: Source the file system Step 2: Check the patch already applied are not?   (EX) Connect Sqlplus apps/apps select bug_number from ad_bugs where bug_number = 'Patch_number'; SQL> select bug_number from ad_bugs where bug_number = '24962217'; BUG_NUMBER ------------------------------   24962217 SQL> select bug_number from ad_bugs where bug_number='20518445'; no rows selected Download the patch and move the patch in $PATCH_TOP cd $PATCH_TOP   Or cd /apps/applmgr/fs_ne/EBSapps/patch Step 3: adop phase=prepare adop prepare phase will be create a new patching cycle Synchronizing filesystem of Run to Patch Step 4: ...