Wednesday, 5 September 2012

Start / Stop Services in Oracle Applications R12 ( Database & Application Tier)

Step by step instructions of How to Start/Stop services in Oracle Applications R12 are shown Below.

Specifications :

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

1.Start-Up Order :
1.1.Start the database tier
1.2.Start the Application tier.

2.Shut-down Order :
2.1.Stop the Application tier
2.2.Stop the  database  tier.

1.Start-Up Order:
1.1.Start Database Tier
    (i) Login as database tier user (oracle)
    (ii) Set environment variable 
           - cd /oracle/apps/r12/Testr12/db/tech_st/11.1.0 ( $Home/db/tech_st/11.1.0 )
           - . Test_hostr12.com ( $SID_hostname.env  )
    (iii) Start database
          - sqlplus “/as sysdba”
          - SQL> startup
    (iv) 
Start Database Listener (lsnrctl start $SID)
           - lsnrctl start Test

1.2.Start Application Tier
    (i) Login as application tier user (oracle)
    (ii) Set environment variable 
           - cd /oracle/apps/r12/Testr12/apps/apps_st/appl
           - . Test_hostr12.com ( $SID_hostname.env  )
    (iii) Start Application Tier 
           - cd $ADMIN_SCRIPTS_HOME
           - . /adstrtal.sh apps/apps  (adstrtall.sh apps/appspassword)

2.Shut-down Order : 
2.1.Stop the Application tier
    (i) Login as application tier user (oracle)
    (ii) Set environment variable 
           - cd /oracle/apps/r12/Testr12/apps/apps_st/appl
           - . Test_hostr12.com ( $SID_hostname.env  )
    (iii) Stop Application Tier 
          - cd $ADMIN_SCRIPTS_HOME
          - . /adstpall.sh apps/apps  (adstpall.sh apps/appspassword)

2.2.Stop the  database  tier
    (i) Login as database tier user (oracle)
    (ii) Set environment variable 
           - cd /oracle/apps/r12/Testr12/db/tech_st/11.1.0 ( $Home/db/tech_st/11.1.0 )
           - . Test_hostr12.com ( $SID_hostname.env  )
    (iii) Stop database
          - sqlplus “/as sysdba”
          - SQL> Shutdown immediate
    (iv) 
Stop Database Listener 
           - lsnrctl stop Test


Delete Apache log files :
Stop the Apache.
delete all the log files from
$IAS_ORACLE_HOME/Apache/Apache/logs
$IAS_ORACLE_HOME/Apache/Jserv/logs/jvm
$IAS_ORACLE_HOME/Apache/Jserv/logs
Start the Apache

No comments:

Post a Comment