Oracle Apps DBA preparation II
I hope you have gone through Oracle apps 11i Architecture , installation & File system. If you are reading this post without reading Part I which is at http://becomeappsdba.blogspot.com/2006/08/apps-11i-dba-preparation.html then please first go through it first then only you can appreciate this post.
By Now You know Apps Architecture , Installation 11i Apps & you had a glance Filesystem of Oracle Apps Vision Instance (If you don’t understand all directories in file system don’t worry, It took 2 years for me to understand various directories in Apps 11i)
Next you should try is Start Stop Oracle application 11i Services .
Order of Startup is
First Database Services & then Application Tier Services (Middle Tier)
Order of Shutdown is
First Application Tier Services & then Database.
In order to check How to Start Stop Oracle apps 11i Middle Tier services & where are shutdown / startup script exist check http://becomeappsdba.blogspot.com/2006/08/startup-shutdown-apps-services.html
Database & DB Listener startup / shutdown scripts are under $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME or $ORACLE_HOME/appsutil/scripts/$SID ( depending on your Apps 11i & AD version )
addbctl.sh is used to control database . Start/Stop database
addlnctl.sh is used to control database listener ( Note that database listener is different from Apps listener)
Try starting stopping services or better open startup / shutdown scripts to check what all they are doing (These are shell files & you can open them by any editor like vi in Unix & notepad on windows)
If you are looking for any formal training , you can check for training from Oracle by visiting site http://education.oracle.com or I have listed some Oracle Apps 11i Training Institute in Bangalore, Chennai (Madras), Hyderabad & Pune at http://teachmeoracle.com/training02.html . If you know any other apps 11i training institute in India or any other country mail me at atul_iiit@yahoo.com
Atul Kumar
Oracle Apps 11i DBA