vas startup/shutdown

VASPROD Instance Start Procedure:

Database Node : USMLRS540
Application Node : USMLRS541

1) Login to USMLRS540

[oracle@usmlrs540 ~]$

2) Run Environment file

[oracle@usmlrs540 ~]$ . ./vasprod_usmlrs540.env
[oracle@usmlrs540 ~]$

3) Start VASPROD database and listener.

[oracle@usmlrs540 ~]$ sqlplus / as sysdba

SQL>startup;

[oracle@usmlrs540 ~]$lsnrctl start vasprod

4) Now Login to Application tier USMLRS541

Last login: Thu Sep 2 02:58:58 2010 from 10.18.92.42

###############################
VASPROD AppTier Env Sourced
###############################

[applmgr@usmlrs541 ~]$

5) Go to scripts directory ( In R12 all start/stop scripts reside in INST_TOP)

[applmgr@usmlrs541 ~]$ cd $INST_TOP/admin/scripts

[applmgr@usmlrs541 scripts]$ ls
adalnctl.sh adautocfg.sh adexecsql.pl adformsctl.sh adoacorectl.sh adopmnctl.sh adstpall.sh gsmstart.sh java.sh msc mwactlwrpr.sh
adapcctl.sh adcmctl.sh adforms-c4wsctl.sh adformsrvctl.sh adoafmctl.sh adpreclone.pl adstrtal.sh ieo jtffmctl.sh mwactl.sh sqlnet.log
[applmgr@usmlrs541 scripts]$

6) Run start script as follows.

[applmgr@usmlrs541 scripts]$ sh adstrtal.sh apps/

7) Check Login URL: http://usmlrs541.arrow.com:8000


VASPROD Instance Stop Procedure:

1) Login to Application tier USMLRS541

Last login: Thu Sep 2 02:58:58 2010 from 10.18.92.42

###############################
VASPROD AppTier Env Sourced
###############################

[applmgr@usmlrs541 ~]$

2) Go to scripts directory

[applmgr@usmlrs541 ~]$ cd $INST_TOP/admin/scripts

[applmgr@usmlrs541 scripts]$ ls
adalnctl.sh adautocfg.sh adexecsql.pl adformsctl.sh adoacorectl.sh adopmnctl.sh adstpall.sh gsmstart.sh java.sh msc mwactlwrpr.sh
adapcctl.sh adcmctl.sh adforms-c4wsctl.sh adformsrvctl.sh adoafmctl.sh adpreclone.pl adstrtal.sh ieo jtffmctl.sh mwactl.sh sqlnet.log
[applmgr@usmlrs541 scripts]$

3) Run stop script as follows.

[applmgr@usmlrs541 scripts]$ sh adstpall.sh apps/

4) Login to USMLRS540

[oracle@usmlrs540 ~]$

5) Run Environment file

[oracle@usmlrs540 ~]$ . ./vasprod_usmlrs540.env
[oracle@usmlrs540 ~]$

6) Stop VASPROD database and listener

[oracle@usmlrs540 ~]$lsnrctl stop vasprod

[oracle@usmlrs540 ~]$sqlplus / as sysdba

SQL> shutdown immediate;