Monday, January 14, 2008

Startup / Shutdown Apps

Startup / Shutdown Apps
This post covers startup & shutdown of Oracle Application DBAAs you are aware by now there is Database Tier ( Database & DB Listener ) and Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener, OnetoOne Fullfillment Server )

Order of StartUp of Services Should be

  1. DB Listener
  2. Database
  3. Application Tier Services
Order of ShutDown of Services Should be

  1. Application Tier Services
  2. Database
  3. DB ListenerDatabase Startup/Shutdown Scripts

Depending on your AD Version these will be in ORACLE_HOME/ appsutil/scripts /SID_hostnameaddbctl.sh database startup shutdown scriptaddlnctl.sh database listener Script Where AD is for Application DBADB is for databaseDLN is database listenerCTL is control -----Application Tier Startup/Shutdown ScriptsDepending on your AD Version these will be inOAD_TOP/admin/scripts/ SID_hostnameadalnctl.sh Apps Listener Control Scriptadapcctl.sh Apache/Web Server Control Script --downadcmctl.sh Concurrent Manager Control Scriptaddisctl.sh Discoverer Control Script --downadfrmctl.sh Forms server Control Scriptadrepctl.sh Report Server Control Scriptadstpall.sh Stop All Middle/Application Tieradstrtall.sh Start All Middle/Application TierWhere AD & CTL you already know now :) isn't itadl stand for Apps Listenerapc stand for Apachecm Concurrent Managerdis Discovererfrm formsrep report

Order Of Study (Apps-DBA)

Can any body suggest on sequence of study topics in order to prepare for APPS-DBA?

Thursday, June 14, 2007

Software download

I would appreciate if anyone could suggest where from to download the exact software setup to prepare for Oracle 11i APPS-DBA.