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.
3) adalnctl.sh {start | stop | status}
Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home)
listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(compared to 11i, only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2)
In simple terms, it is
Start Database listener process => addlnctl.sh start VIS
Start Database process => addbctl.sh start
Start Applications processes => adstrtal.sh apps/password
Stop Database listener process => addlnctl.sh stop VIS
Stop Database process => addbctl.sh stop
Stop Applications processes => adstpall.sh apps/password
4) adapcctl.sh {start|stop|status}
Script to start/stop Web Server or Oracle HTTP Server.
This script uses opmn (OPMN and Notification Server) with syntax similar to opmnctl start/stopproc ohs
like opmnctl stopproc ohs
(In 11i this script directly used to call apachectl executable but now calls opmnctl which in turn calls apachectl.
In 11i web server oracle home was 1.0.2.2.2 but in R12 its 10.1.3)
5) adcmctl.sh {start | stop | abort | status } [apps username/ apps password]
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )
6) adformsctl.sh {start | stop | status}
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like opmnctl stopproc type=oc4j instancename=forms
7) adformsrvctl.sh
This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet.
If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12
8) adoacorectl.sh {start | stop | status}
This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oacore
9) adoafmctl.sh {start | stop | status }
This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oafm
10) adopmnctl.sh {start | stop | status}
This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped abnormally opmn will/should start them automatically.
11) jtffmctl.sh {start | stop}
This script will be used to start/stop one to one fulfilment server.
12) mwactl.sh {start | stop }
To start / stop mwa telnet server where mwa is mobile application.
Log files for startup/shutdown scripts for application/mid tier in R12 are in $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log