Start and stop applications - R12

Database Tier Scripts in R12

For Database tier you need to start database and database listener. Scripts are located in

$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

Startup

1. Database Listener

$addlnctl.sh start

2. Database

$ addbctl.sh start

or alternatively you can use

lsnrctl start listener_name

$sqlplus “/as sysdba”

SQL> startup

Shutdown

1. Database Listener

$addlnctl.sh stop

2. Database

$ addbctl.sh stop immeidate|normal|abort

or alternatively you can use

lsnrctl stop listener_name

$sqlplus “/as sysdba”

SQL> shutdown immedidate|normal|abort

Application Tier Scripts in R12

Scripts for Application Tier services in R12 are located in

$ADMIN_SCRIPT_HOME

(Apps_base/inst/apps/$CONTEXT_NAME/admin/scripts)

where CONTEXT_NAME is of format SID_HOSTNAME

1) adstrtal.sh [appsusername/appspassword]

Script. to start all components/services of middle tier or application tier. This script. will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)

2) adstpall.sh [appsusername/appspassword]

Stop all components/services of middle tier or application tier.