Oracle AppsDBAs World: Script to start/stop R12 services

Script to start R12 services
-------------------------------------
Open a file in vi editor and save it as a script(.sh) format.

#vi start.sh

echo "Starting Database Listener"
/usr/bin/su - oravis -c '/u02/oracle/db/tech_st/10.2.0/appsutil/scripts/VIS_lab/addlnctl.sh start VIS'
echo "Database Listener started"
sleep 5
echo "Starting Oracle Database"
/usr/bin/su - oravis -c '/u02/oracle/db/tech_st/10.2.0/appsutil/scripts/VIS_lab/addbctl.sh start'
echo "Oracle Database started"
sleep 15
echo "Starting Oracle Applications"
/usr/bin/su - applvis -c '/u01/apps/VIS_lab/admin/scripts/adstrtal.sh apps/apps'
echo "Oracle Applications Started"

:wq!(save & quit)

Script to stop R12 services
-----------------------------------
Open a file in vi editor and save it as a script(.sh) format.

#vi stop.sh

echo "Stopping Oracle Applications"
/usr/bin/su - applvis -c '/u01/apps/VIS_lab/admin/scripts/adstpall.sh apps/apps'
echo "Oracle Applications stopped"
sleep 5
kill -9 `ps -ef | grep applvis | awk '{print $2}'`
echo "Stopping Database Listener"
/usr/bin/su - oravis -c '/u02/oracle/db/tech_st/10.2.0/appsutil/scripts/VIS_lab/addlnctl.sh stop VIS'
echo "Database Listener stopped"
echo "Stopping Oracle Database"
/usr/bin/su - oravis -c '/u02/oracle/db/tech_st/10.2.0/appsutil/scripts/VIS_lab/addbctl.sh stop immediate'
sleep 5
echo "Oracle Database stopped"

:wq(save & quit)

Use these shell scripts to start/stop r12 services instead of doing manually.

posted by Senthil Kumaran @ 3:55 AM

0 Comments: