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

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

1 comments
Anonymous says August 23, 2006

Hi Atul,

Gr8 man…..keep it up…..Can u please share some info…about the backup procedure for Oracle Apps 11i for both application and database

Reply
Add Your Reply