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 is a configuration tool that automates the configuration of an Oracle E-Business Suite instance. The information required for configuring an Applications system is collected into an XML repository, called the Applications context. There is one Applications context for each application tier, and one for each database tier. When AutoConfig runs, it uses information from the Applications  context file to generate all configuration files, and update database profiles.  Autoconfig components: Context file Driver files Template files Context file: Configure the XML repository and related information XML file for each application and database server. XML file location Application: /apps/applmgr/fs1/inst/apps/san/appl/admin/san.xml Database: Cd $ORACLE_HOME/appsutil/<conextfile.xml> Template file: Template file contains only name tags All are replaced with the actual vales when during autoconfig run. D

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: