«

»

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/

1 comment

  1. Penta

    Dear apps dba,

    For security reasons,
    Can we start/stop the oracle apps services using non ‘apps’ user ?

    Because, if we write the password in the .sh file, we worry it’ll be read by others, so we want to create another user in the database.

    Please help, thanks for your info.

    Rgd,
    Penta

Leave a Reply

Your email address will not be published. Required fields are marked *