- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g automated startup/shutdown HP-UX 11.23
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
тАО03-17-2008 08:00 AM
тАО03-17-2008 08:00 AM
Oracle 10g automated startup/shutdown HP-UX 11.23
I'm trying to make an automated procedure to startup/shutdown oracle at reboot time in a HP-UX 11.23 server. I've followed the steps explained in Oracle's Metalink "How to Start Database And Listener at System Reboot on Unix Systems" but its written for Oracle 9i server. And I have Oracle 10g. :p . I've done all the steps described there but as I hoped, it doesn't work.
Does anybody have a script to make this work?
10 Points will be given for the correct scripts =)
Thanks in advance,
Miguel Rentes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:06 AM
тАО03-17-2008 08:06 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
put them in your startup template file.
1)cp /sbin/init.d/template /sbin/init.d/oracle
2) edit /sbin/init.d/oracle startup and shutdown sections with su - oracle -c "$ORACLE_HOME/bin/dbstart or dbshut.
3) modify CONTROL_VARIABLE to ORACLE.
4)create /etc/rc.config.d/oracle and edit ORACLE=1
5) in /sbin/rc3.d. ln -s /sbin/init.d/oracle S900oracle
6) in /sbin/rc2.d. ln -s /sbin/init.d/oracle K900oracle
Test it out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:25 AM
тАО03-17-2008 08:25 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
You can also follow the instructions in the document found in the URL below:
http://docs.hp.com/en/934/startup.pdf
though generic, you can configure your oracle database to start using the same principles.
if you need any further assistance, please let us know.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 11:45 PM
тАО03-17-2008 11:45 PM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
(just uncomment and set your lines in the dbstart for listener starting and stopping)
#!/bin/sh
PATH=/usr/sbin:/usr/bin:/sbin
export PATH
export oraowner=YOUR_ORA_OWNER
export ORACLE_HOME=YOUR_ORACLE_HOME
#
set -x
rval=0
case "$1" in
'start_msg')
echo "Starting Oracle Databases"
;;
'stop_msg')
echo "Stopping Oracle Databases"
;;
'start')
su - $oraowner -c "$ORACLE_HOME/bin/dbstart"
rval=0
;;
'stop')
su - $oraowner -c "$ORACLE_HOME/bin/dbshut"
rval=0
;;
*)
echo "Usage \: dbora \
rval=1
;;
esac;
exit $rval
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 01:08 AM
тАО03-18-2008 01:08 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
Please check the attached script. Its working on 10g.
Thanks & Regards
Aashique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-19-2008 07:36 AM
тАО03-19-2008 07:36 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
I just went through this problem and here is what I ended up with (attached). It works very well and avoids the "issues" when trying to use "su" to the oracle account...
The only pre-requisite for this version of the script is that root must be able to "ssh" to the oracle account without a password. I'm not sure if you know how to generate the keys to achieve this - if not, let me know. (The original script from Oracle used "remsh" instead of "ssh".)
Hope it helps - I went through a lot to get this working, but it was worth it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2008 12:31 PM
тАО10-14-2008 12:31 PM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
@Graham
"The only pre-requisite for this version of the script is that root must be able to "ssh" to the oracle account without a password. I'm not sure if you know how to generate the keys to achieve this - if not, let me know. (The original script from Oracle used "remsh" instead of "ssh".)"
Can you please provide the steps how to create these keys?
Thanks,
Rade
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-25-2010 02:56 AM
тАО05-25-2010 02:56 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
Here's what I did to make this work.
1) Log onto the system as root. Edit the file /etc/oratab. Add a line for any Oracle SID you want to start after a system reboot:
2) Create a script named oracle under /sbin/init.d and add the following contents:
#!/bin/sh
#installation
ORACLE_HOME=/oracle/oraHome1
PATH=${PATH}:$ORACLE_HOME/bin:/usr/bin
HOST=`hostname`
#change the value of ORACLE to the login name of the oracle owner
ORACLE=oracle
export ORACLE_HOME PATH
LOG=$ORACLE_HOME/startup.log
rm -f $LOG
touch $LOG
chmod 666 $LOG
chown oracle:users $LOG
# When HP-UX starts/stops
case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
echo "starting Oracle Net listener" >> $LOG
echo "starting Oracle databases" >> $LOG
su - oracle -c ├в $ORACLE_HOME/bin/dbstart >> $LOG├в
su - oracle -c "$ORACLE_HOME/bin/lsnrctl start >> $LOG"
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
echo "stopping Oracle Net listener" >> $LOG
echo ├в stopping Oracle databases├в >> $LOG
su ├в oracle ├в c ├в $ORACLE_HOME/bin/dbshut >> $LOG├в
su - oracle -c ├в $ORACLE_HOME/bin/lsnrctl stop >> $LOG├в
;;
*)
echo " Starting Automated Oracle startup"
exit
;;
esac
#
exit
3) Change this script's permissions and owner:
chmod 750 /sbin/init.d/oracle
chown bin:bin /sbin/init.d/oracle
4) Create the following links:
ln -s /sbin/init.d/oracle /sbin/rc3.d/S99oracle
ln -s /sbin/init.d/oracle /sbin/rc0.d/K01oracle
5) Logout as root. At the next system reboot you will have the instance specified above automatically started.
Hope this procedure helps =)
Best regards,
Miguel Rentes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-25-2010 03:21 AM
тАО05-25-2010 03:21 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2010 03:22 AM
тАО05-26-2010 03:22 AM
Re: Oracle 10g automated startup/shutdown HP-UX 11.23
Listen, if you noticed script which you type has some strange symbols, i mean i dont know which letters are there. Would you attach script in text file?
Best regards,
rustam
P.S. I'm gonna do it tomorrow morning when i will be at work.