Saturday, April 19, 2008

Startup and Shutdown Procedures for Apps

Startup and Shutdown Procedures for Oracle Apps:
=================================

Order of StartUp of Services Should be as follows :

1. First DB Listener.
2. Database.
3. Application Tier Services.

Order of ShutDown of Services Should be as follows:
====================================

1. First Application Tier Services.
2. Database.
3. DB Listener.
Database Startup and Shutdown Scripts and its Locations :
Location of the script :
$ORACLE_HOME /appsutil/scripts /SID_hostname/

Start up script for Db Tier:
==================
addbctl.sh start - For database startup.
addlnctl.sh start (instance name) - for database listner startup.

Note : SID_hostname is called as a CONTEXT_NAME.

Stop script for Db Tier:
================

Location (same as given above and the script is also same) but :

addbctl.sh stop - For database shutdown.
addlnctl.sh stop (instance name) - for database listener shutdown.

Apps Tier Startup and Shutdown Scripts and its Locations :
=========================================
Location of the script :
===============

OAD_TOP/admin/scripts/ SID_hostname/

Note : COMN_TOP is called as OAD_TOP

Start up script for Db Tier :
=======================

adalnctl.sh start - Apps Listener Control Script
adapcctl.sh start apps/apps - Apache/Web Server Control Script
adcmctl.sh start apps/apps - Concurrent Manager Control Script
addisctl.sh start - Discoverer Control Script
adfrmctl.sh start - Forms server Control Script
adrepctl.sh start - Report Server Control Script

These are the the individual components to be started and the scripts for it. Instead of starting all this script individually there is a script which has a power to start all the above components in one stretch and to stop also. So instead of giving the above things individually we can use the following scripts to start and stop. This script is also in the same location and the script name as follows:

adstrtall.sh apps/apps - Start All Middle/Application Tier.
adstpall.sh apps/apps - All Middle/Application Tier.
Note:
(apps/apps) - This is application user and passwd.

Note : The main thing to look up in this topic is that the procedure should be followed correctly as mentioned above in the topic ORDER OF STARTUP and SHUTDOWN.

No comments: