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.