Oracle APPS DBA Online Training Course Overview :
Infrastructure setup
 Installation of Virtual workstation

 Installation of OEL Operating system

 OEL Oracle Enterprise Linux

 Disk Druid configuration

 Manual partitions

 Assigning static ip to Ethernet

 Time zone selection

 Root user password configuration

 Packages selection

 Post installation configuration

 Login to the OS

 Installing Virtual tools

 Sharing of Folders from host OS to virtual OS

 Cloning of OS in virtual workstation

 Start and Shut of OS

Pre installation configuration

 EBS software stage

 Db tier

 Apps tier

 Edit the host file

 Group creation

 User creation

 Ownership permission

 Set password

 Rpms installation

EBS single node installation

 Execute the rapid wiz

 Install Oracle application

 New configuration port no

 Database node configuration

 Select necessary options

 Final installation

 Post installation steps

 Bash profile configuration

 DB tier bash profile

 Apps tier bash profile

 Login to url

 verify

EBS multi node installation

 Prepare the 2 node OS

 Perform pre installation

 Execute rapid wiz on first node

 Select db tier node

 Select Apps tier node

 Edit services

 OPMN

 Web entry point

 Web application services

 Batch process service

 Other service

 run the rapid wiz on 2nd node

 Save load configuration file

 Bash profile configuration

 Login to URL

 Verify

EBS File system: Oracle APPS DBA Online Training

 Database environment file

 Db context file

 control scripts

 C,R,D files

 Application environment file

 context file

 Db connectivity file

 control scripts Apps tier

 AD utilities

 Apache server configuration file

 Form sever configuration file

Manage EBS Service

 Db tier service

 Traditional method

 Control script service

 Listener service

 Apps tier service

 Apps Control scripts

 Individual service

 Apache server

 Forms server

 CMS server

 Application listener

 OPMN Service

 OC4J Service

 OC4J oacore – html based

 OC4J forms

 OC4J oafm – web service

 Oracle http service

Patch in Oracle APPS DBA Online Training

 Patch concepts

 one of patch

 single patch

 mini patch

 family patch

 maintenance patch pack

 Pre requisite patch

 Patch tool kit

 adpatch,adctrl,adadmin.adautocfg,admrgpch

 Maintenance mode

 Apply the patch

 Driver file

 Disable maintenance mode

 Verify patch

 Merging patch concept

System Admin

 User creation

 Password reset

 Account lock and unlock

 Profile

 Assign profile to users

 Monitor application users

 Terminate application user

 Create responsibility

 Assign responsibility to user

 Compile custom application

 Printer configuration

 Ad admin

 Auto config

 Custom manager

 Report

 Request set

Cloning

 Online and Offline cloning

 Multiple scenario

 Single node to single node

 single node to multi node

 multi node to single node

 multi node to multi node

 Verify

 Db tier adpreclone

 Apps tier clone

 Prepare the target system

 pre configuration

 Run adpreclone.pl

 Copy db tier and apps tier

 tar statement

 perform adcfgclone.pl

 Monitor statement

 Bash profile configuration

 Post cloning steps

 Verify

Up Gradation

 Ebs upgrade from 11i to R12

 Prepare 11i ebs system

 db 9i to 10g

 Apps 11i to R12

 Apply latest IOP

 Apply AD Patch

 Apply IOP patch

 Install 10g software

 configure env file

 apply patch set

 Run dbua to upgrade

 Enable autoconfig

 Listener config

 start application service

 Test application

 Apps tier upgrade

 Run rapdiwiz R12

 upgrade file system

 startup with R12

 Apply R12 AD Patch

 Apply maintenance patch pack

More about

Oracle Apps DBA Training