topic Re: Run The Database Automatically in Operating System - HP-UX

Run The Database Automatically

Mousa55 — Tue, 20 Jan 2009 11:12:20 GMT

Hi All,

how i can up the database automatic after reboot or restart the server
i mean after restart the server i don't want refer to DBA to run the database, only i need a script or something to make a server to run the database automatically
only i need the DBA when i want to shutdown the database.
how i can do it that?

thanks and best regards

Re: Run The Database Automatically

Yogeeraj_1 — Tue, 20 Jan 2009 11:21:45 GMT

hi,

that should not be too difficult.

See post at the following thread:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1218941

if you need any further assistance, please do let us know.

kind regards
yogeeraj

Re: Run The Database Automatically

Mousa55 — Tue, 20 Jan 2009 11:35:45 GMT

Hi All,

but this script it is working or no?
and my OS 11.11 and 9i database

# installation
ORACLE_HOME=/u01/app/oracle/OraHome_1
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST='hostname'
#
# change the value of ORACLE to the login name of the
# oracle owner at your site
#
export ORACLE_HOME PATH
su - $ORACLE -c "$0 $1 ORA_DB"
##
if [ ! "$2" = "ORA_DB" ] ; then
ssh -l $HOST $ORACLE /sbin/init.d/oradba $1 ORA_DB
exit
fi
#
LOG=$ORACLE_HOME/startup1.log
touch $LOG
chmod a+r $LOG
#
case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "starting Oracle Net listener"
$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &
fi
echo "starting Oracle databases"
$ORACLE_HOME/bin/dbstart >> $LOG 2>&1
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net listener"
$ORACLE_HOME/bin/lsnrctl stop >> $LOG 2>&1
fi
echo "stopping Oracle databases"
$ORACLE_HOME/bin/dbshut >> $LOG 2>&1
;;
*)
echo "usage: $0 {start|stop}".

exit
;;
esac
#
exit
RACLE_HOME=/u01/app/oracle/OraHome_1
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST='hostname'
#
# change the value of ORACLE to the login name of the
# oracle owner at your site
#
export ORACLE_HOME PATH
su - $ORACLE -c "$0 $1 ORA_DB"
##
if [ ! "$2" = "ORA_DB" ] ; then
rsh $HOST -l $ORACLE /sbin/init.d/oradba $1 ORA_DB
exit
fi
#
LOG=$ORACLE_HOME/startup1.log
touch $LOG
chmod a+r $LOG
#
case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "starting Oracle Net listener"
$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &
fi
echo "starting Oracle databases"
$ORACLE_HOME/bin/dbstart >> $LOG 2>&1
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net listener"
$ORACLE_HOME/bin/lsnrctl stop >> $LOG 2>&1

script directory
=/sbin/init.d
script output
bash-3.2# ./dbora start
+ ORACLE_HOME=/u01/app/oracle/OraHome_1
+ ORACLE=oracle
+ PATH=/usr/sbin:/bin:/usr/bin:/usr/dt/bin:/usr/bin/X11:/sbin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/sas/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/resmon/bin:/usr/contrib/kwdb/bin:/opt/graphics/common/bin:/opt/sfm/bin:/opt/hpsmh/bin:/opt/upgrade/bin:/opt/sec_mgmt/bastille/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/ignite/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/thunderbird:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/langtools/bin:/opt/caliper/bin:/opt/sentinel/bin:/usr/local/bin:/bin
+ + hostname
HOST=posserve.ciegroup.net
+ + uname
PLATFORM=HP-UX
+ export ORACLE_HOME PATH
+ i#
./dbora[17]: i#: not found.
+ [ ! = ORA_DB ]
+ echo

+ [ HP-UX = HP-UX ]
+ su - oracle -c ./dbora start ORA_DB
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.

RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.

Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
+ exit

pls provide me the input to resolve the problem

thanks

Re: Run The Database Automatically

Dennis Handly — Tue, 20 Jan 2009 11:38:21 GMT

>but this script it is working or no?
./dbora[17]: i#: not found.
+ [ ! = ORA_DB ]

This isn't working. Where is this "i#"?

Re: Run The Database Automatically

Mousa55 — Tue, 20 Jan 2009 11:44:53 GMT

Hi All,

How to make my server to start/shutdown the database automatically.

thanks

Re: Run The Database Automatically

Michael Mike Reaser — Tue, 20 Jan 2009 17:00:31 GMT

Refer to the documentation for the database package(s) you're using. If the database(s) can be started at system boot time, then their manuals should state the way to set up the /sbin/init.d/[whatever] script and where to link it under the /sbin/rc[0-4].d hierarchy.

Re: Run The Database Automatically

Yogeeraj_1 — Wed, 21 Jan 2009 04:37:02 GMT

> How to make my server to start/shutdown the database automatically.

You may wish to follow guidelines found at this url:
http://docs.hp.com/en/934/startup.pdf

hope this help!

kind regards
yogeeraj

Re: Run The Database Automatically

Mousa55 — Wed, 21 Jan 2009 04:50:06 GMT

Hi All,

thanks for all, but Is there any script ready?
and then change it to match my system.

thanks again

Re: Run The Database Automatically

Dennis Handly — Wed, 21 Jan 2009 06:04:36 GMT

>but is there any script ready?

There is a rc(1m) template in /sbin/init.d/template.

Re: Run The Database Automatically

OldSchool — Wed, 21 Jan 2009 21:02:10 GMT

*somebody* starts it and stops it today. You, the dba or ???

find out what they have to run to start it. Find out what they have to run to stop it.

then use a "rc template" file to do the actual work...