- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- baan+oracle shutdown script help
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 12:46 AM
тАО09-27-2004 12:46 AM
baan+oracle shutdown script help
i have Baan Erp package with oracle 9.2.0
on hp-ux 11i...Every Friday night i close
Baan erp application and then oracle db
below the steps;
1- cd baan/bse/etc
2- ./rc.stop
close Baan application
3-su - oracle
4-sqlplus /nolog
5-connect / as sysdba
6-shutdown immediate
7-exit
8-exit
9-lsnrctl
10-stop
11-exit
As you seen after 11 steps i go on for offline bck...Now i want to this from a script
and also want to write a start script after bck...but HOW?
Thank's so much for your kind concern&support
Best Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 01:08 AM
тАО09-27-2004 01:08 AM
Re: baan+oracle shutdown script help
su - oracle -c "$ORACLE_HOME/bin/dbshut"; echo $?
wait
su - oracle -c "$ORACLE_HOME/bin/agentctl stop"; echo $?
wait
su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop"; echo $?
wait
su - oracle -c "$ORACLE_HOME/bin/oemctl stop oms &"; echo $?
wait
If you are not running the oemctl process, you can skip that part.
mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 01:33 AM
тАО09-27-2004 01:33 AM
Re: baan+oracle shutdown script help
You could try a script like this, I'm not sure what the name of your baan startup script is but I just put in rc.start -
#!/sbin/sh
#
# change the value of ORACLE_HOME to be correct
# for your installation
#
ORACLE_HOME=/u01/app/oracle/product/9.2
PATH=${PATH}:$ORACLE_HOME/bin
#
# change the value of ORACLE to the login name of
# the oracle owner at your site
ORACLE_USER=oracle
export ORACLE_HOME PATH
#
LOG=$ORACLE_HOME/startup.log
touch $LOG
chmod a+r $LOG
#
case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start SQL*NET V2
echo "starting V2 listener"
su - $ORACLE_USER -c "/usr/local/bin/listener_start" >> $LOG 2>&1
# Start Agent
echo "starting agent"
/baan/bse/etc/rc.start >>$LOG 2>&1
# Start the database(s)
echo "starting Oracle databases"
su - $ORACLE_USER -c "/usr/local/bin/dbstart" >> $LOG 2>&1
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Agent
echo "stopping Baan"
/baan/bse/etc/rc.stop >> $LOG 2>&1
# Stop SQL*NET V2
echo "stopping V2 listener"
su - $ORACLE_USER -c "/usr/local/bin/listener_stop" >> $LOG 2>&1
# Stop the database(s)
echo "stopping Oracle databases"
su - $ORACLE_USER -c "/usr/local/bin/dbshut" >> $LOG 2>&1
;;
*)
echo "usage: $0 {start|stop}"
exit
esac
#
exit
HTH,
Peter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 01:38 AM
тАО09-27-2004 01:38 AM
Re: baan+oracle shutdown script help
Peter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 01:52 AM
тАО09-27-2004 01:52 AM
Re: baan+oracle shutdown script help
According to Mark's answer;
su - oracle -c "$ORACLE_HOME/bin/dbshut"; echo $?
does it make DB shutdown normal or immediate
because i want to use shutdown immediate...
Best Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 02:13 AM
тАО09-27-2004 02:13 AM
Re: baan+oracle shutdown script help
Peter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 10:53 PM
тАО09-27-2004 10:53 PM
Re: baan+oracle shutdown script help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2005 11:17 PM
тАО05-15-2005 11:17 PM