Saturday, 15 May 2010

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)

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.