This post covers step by step instructions of How to Start/Stop services in Oracle Applications R12. These steps are from Online Oracle Apps DBA (11i /R12) training here (This is interactive online course over weekend with hands on exercises on installation, patching, cloning during weekdays)

Assumptions

Application Tier O.S. User : avisr12 (usually applmgr)
Database Tier O.S. User : ovisr12 (usually oracle)
R12 install base : /oracle/apps/r12/visr12
Database SID : visr12
Database Version : 11.1.0
Hostname : focusthreadr12
Operating System : Unix/Linux
Apps Schema Password : apps (apps is default password)

.

Start-Up/Shutdown order

If you are starting services then first start Database Tier services and then Application Tier Services.
If you are shutting down services then first stop Application Tier services and then Database Tier Services.
  

1. Startup

1.1 Start Database Tier
1.1.1
Login as database tier user (ovisr12)
1.1.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/db/tech_st/11.1.0
—- cd /oracle/apps/r12/visr12/db/tech_st/11.1.0
—- . visr12_focusthreadr12.com (note: dot in front)
1.1.3 Start database
—- sqlplus “/as sysdba”
—- SQL> startup
1.1.4
Start Database Listener (lsnrctl start $SID)
—- lsnrctl start visr12
.

.

1.2 Start Application Tier
1.2.1
Login as application tier user (avisr12)
1.2.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/apps/apps_st/appl
—- cd /oracle/apps/r12/visr12/apps/apps_st/appl
—- . visr12_focusthreadr12.com (note: dot in front)
1.2.3 Start Application Tier (adstrtal.sh apps/$apps_password)
—- cd $ADMIN_SCRIPTS_HOME
—- ./adstrtal.sh apps/apps 

.

.

2. Shutdown Services

2.1 Shutdown Application Tier
2.1.1
Login as application tier user (avisr12)
2.1.2 Set environment variable by running $SID_hostname.env from $INSTALL_BASE/apps/apps_st/appl
—- cd /oracle/apps/r12/visr12/apps/apps_st/appl
—- . visr12_focusthreadr12.com (note: dot in front)
2.1.3 Stop Application Tier (adstpall.sh apps/$apps_password)
—- cd $ADMIN_SCRIPTS_HOME
—- ./adstpall.sh apps/apps 

.

2.2 Shutdown Database Tier
2.2.1
Login as database tier user (ovisr12)
2.2.2 Set environment variable by running $SID_hostname.env from $INSTALL_BASE/db/tech_st/11.1.0
—- cd /oracle/apps/r12/visr12/db/tech_st/11.1.0
—- . visr12_focusthreadr12.com (note: dot in front)
2.2.3 Stop database
—- sqlplus “/as sysdba”
—- SQL> shutdown immediate
2.2.4
Stop Database Listener (lsnrctl start $SID)
—- lsnrctl stop visr12

.

  • For startup/shutdown in Oracle Applications 11i check here  and here
  • For start/stop services in Oracle Application Server (10g) click here
  • For start/stop services in WebLogic (Fusion Middleware 11g) click here

.

To register for Oracle Apps DBA training (11i & R12) click here [next batch starting 17th April]