Oracle User setting for EBS in oracle user .bash_profile
DB_HOME=/u01/oracle/VIS/db/tech_st/11.1.0; export DB_HOME
APPL_TOP=/u01/oracle/VIS/apps/apps_st/appl; export APPL_TOP
COMMON_TOP=/u01/oracle/VIS/inst/apps/VIS_ebs; export COMMON_TOP
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
NPX_PLUGIN_PATH=/u01/oracle/VIS/apps/tech_st/10.1.2/jdk.142_06
# Now set environment
. $APPL_TOP/APPSVIS_ebs.env
--------------------------------------------------------------
Create a script start_VIS.sh in oracle user home directory with following content
# commands to start EBS
cd $DB_HOME
. ./VIS_ebs.env
cd $DB_HOME/appsutil/scripts/VIS_ebs
# start the listener
./addlnctl.sh start VIS
# start the database tier
./addbctl.sh start
cd $INST_TOP/admin/scripts
# start EBS services (apps tier)
./adstrtal.sh apps/apps
# start the internal conc manager
./adcmctl.sh start apps/apps
-----------------------------------------------------------
Create a script stop_VIS.sh in oracle user home directory with following content
# commands to shutdown instance
cd $INST_TOP/admin/scripts
# stop all EBS services (apps tier)
./adstpall.sh apps/apps
cd $DB_HOME
. ./VIS_localhost.env
cd $DB_HOME/appsutil/scripts/VIS_ebs
# stop the listener
./addlnctl.sh stop VIS
# stop the database
./addbctl.sh stop immediate
No comments:
Post a Comment