«

»

Aug 02

Print this Post

How to Start/Stop Services in Oracle Applications

This post explains topic on how to start/stop application tier and database tier services in Oracle Applications.

Starting/Stopping Services in Oracle Applications:

1.Starting Database Tier Services:

Step1: Login to the Database Tier

Step2: Source the database environment file

Step3: Start the database services

  • Go to $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME> directory
  • Start Net Services listener using the following script
addlnctl.sh start listener_name
  • Start the Database service
addbctl.sh start

2.Starting Oracle Application Tier Services:

Step1: Login to the Application Tier

Step2: Source the application environment file

Step3: Start the application services

  • Go To $INST_TOP/admin/scripts/<CONTEXT_NAME> directory
  • Run the following script for starting all application services.
sh adstrtall.sh APPS username</<APPS password>

3.Stopping Oracle Application Tier Services:

Step1: Login to the Application Tier

Step2: Source the environment file

Step3: Start the application services

  • Go To $INST_TOP/admin/scripts/<CONTEXT_NAME> directory
  • Run the following script for starting all application services
sh adstpall.sh APPS username</<APPS password>

4.Stopping Database Tier Services:

Step1: Login to the Database Tier

Step2: Source the database environment file

Step3: Start the database services

  • Go to $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME> directory
  • Start Net Services listener using the following script
addlnctl.sh stop listener_name
  • Stop the Database service
addbctl.sh stop

                 On Windows Operating system, the services can be started/stopped in two ways

1.Using command line prompt:

  • Open command prompt
  • Start the required services For eg: adstrtall.cmd start

2. Using Services control panel:

  •  Go to Start > Administrative Tools and click Services.
  •  Select the relevant service in the Services window.
  •  Click Start or Stop, as required

Individual Scripts and their usage:

  • adapcctl.sh: HTTP (Web) Server: Processes URL requests to execute Forms-based Applications and HTML-based Applications.
  • adcmctl.sh: This script is related to the Concurrent Managers to read requests for programs and start the appropriate concurrent programs. These scripts require the APPS username and password.
  • adformsctl.sh:This script is realted to forms (OC4J) component and these scripts are used to start, stop and check the status of the Forms OC4J instance.
  • adformsrvctl.sh: This script is realed to forms (Socket), which is used to start, stop and check the status of the Forms services in Socket Mode.
  • adoacorectl.sh: This is related to oacore for start, stop and check the status of the oacore OC4J instance.
  • adopmnctl.sh: This is related to Oracle Process Manager (opmn) and which are used to start, stop and check the status of opmn.
  • adstrtal.sh: This script is used to start all application tier server processes. These scripts require the APPS username and password.
  • adstpall.sh: This script is used to start all application tier server processes. These scripts require the APPS username and password.
  • adlnctl.sh: This script is used to start/stop the Net Services listeners
  • addbcctl.sh: This script is used to start/stop the database services

 

Permanent link to this article: http://myappsdba.com/how-to-startstop-services-in-oracle-applications/