Oracle

Oracle APPS DBA Online Training

Oracle APPS DBA Online Training

Demo Video:

    

Course Content : 

1.  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

    2.  Pre installation configuration

  • EBS software stage
  • Db tier
  • Apps tier
  • Edit the host file
  • Group creation
  • User creation
  • Ownership permission
  • Set password
  • Rpms installation

    3.  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

    4.   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

   5.   EBS File system

  • 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

    6.  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

    7  Patch

  • 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

     8.  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

     9.  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

   10.  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