1827894 Members
1718 Online
109969 Solutions
New Discussion

startup script

 
Fabien GUTIERREZ
Frequent Advisor

Re: startup script

init scripts on hp-ux must follow some rules
let s see behind what to use

#!/sbin/sh
PATH=/usr/sbin:/usr/bin:/sbin
export PATH

case $1 in
'start_msg')
echo "a string"
;;

'stop_msg')
echo "a string"
;;

'start')
/sbin/init.d/yourscript start
;;
'stop')
/sbin/init.d/yourscript stop
;;
'status')
/sbin/init.d/yourscript status
;;
*)
echo "Utilisation $0 start|stop|status"
exit 1
;;
esac
exit 0
sh5490
Frequent Advisor

Re: startup script

hi yogreej,

pls find new dbor script contents

# directory for you installation
ORACLE_HOME=/u01/app/oracle/OraHome_1;export ORACLE_HOME
rval=0
set_return() {
x=$?
if [ $x -ne 0 ]; then
echo "EXIT CODE: $x"
rval=1
fi
}
exit$rval

#;export ORACLE_HOME
ORACLE_SID=ciehoi;export ORACLE_SID
# oracle owner at your site.
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
LOG=$ORACLE_HOME/stop1.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"
su - $ORACLE -c "lsnrctl start" >> $LOG2>&1 &
fi
echo "Starting Oracle databases"
su - $ORACLE -c "dbstart" >> $LOG2>&1 &
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net Listener">> $LOG2>&1&
su - $ORACLE -c "lsnrctl stop" >> $LOG2>&1 &
fi
echo "stopping Oracle databases">>$LOG2>&1&
su - $ORACLE -c "dbshut" >> $LOG2>&1 &
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit

thanks

shabir

Peter Nikitka
Honored Contributor

Re: startup script

Hi,

when you had read Fabian's carefully, you would have identified the problematic lines:
>>>
...
# oracle owner at your site.
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
...
<<<
Nothing of the variable PATH is set but you use it. Put at least this at the beginning of your startup script:
PATH=${PATH:-/usr/bin}

The logfile should contain much lesser 'not found's (if any).

The statement
exit$rval
is wrong - there needs to be a space between command and argument:
exit $rval

mfg Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
Yogeeraj_1
Honored Contributor

Re: startup script

hi Shabir,

based on the recommendations made by Fabian and Peter above. I have modified your dbora script and uploading it again.

can you please try this again?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: startup script

your modified dbora script
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: startup script

hi Yogreej,
thanks all for providing me inputs,

This script still not works, i have run the modified dbora script provided by you.
Also it didn't work while executing under root user.


Output from "/sbin/rc2.d/S99dbora start":
----------------------------
/sbin/rc2.d/S99dbora[7]: hostname: not found.
/sbin/rc2.d/S99dbora[10]: touch: not found.

usage: /sbin/rc2.d/S99dbora.org {start|stop}
Output from "/sbin/rc2.d/S99dbora.org start":
----------------------------
/sbin/rc2.d/S99dbora.org[7]: hostname: not found.
/sbin/rc2.d/S99dbora.org[12]: touch: not found.
starting Oracle Net Listener
Starting Oracle databases
/sbin/rc2.d/S99dbora.org[26]: su: not found.
/sbin/rc2.d/S99dbora.org[23]: su: not found.

thanks

shabir
TTr
Honored Contributor

Re: startup script

All the errors still have "sbin/rc2.d/S99dbora" in them. (NOTE the rc2.d/S99dbora)

Where did you put this dbora script? It is probably not getting executed.

You must delete any/all dbora scripts in the rc2.d, rc3.d directories and replace them with a symbolic link that points to /sbin/init.d/dbora script

This was pointed out repeatedly earlier by more than one person.
Yogeeraj_1
Honored Contributor

Re: startup script

hi Shabir,

Let us redo the configuration.

Below the main steps:

1. Find and delete all the files relating to dbora:
SRV2:sbin>cd /sbin
SRV2:sbin>ll */*dbora*
-rwxr-xr-x 1 bin bin 3874 Aug 31 2007 init.d/dbora
lrwxrwxrwx 1 root sys 19 Jul 24 2003 rc1.d/K100dbora -> /sbin/init.d/dbora
lrwxrwxrwx 1 root sys 19 Jul 24 2003 rc2.d/S900dbora -> /sbin/init.d/dbora
SRV2:sbin> rm rc*/*dbora

(Please ensure that dbora has the attributes 755 and ownership bin:bin)


2. Create new symbolic links
SRV2:sbin> ln -s /sbin/init.d/dbora /sbin/rc1.d/K100dbora
SRV2:sbin> ln -s /sbin/init.d/dbora /sbin/rc2.d/S900dbora



3. Ensure that the /etc/rc.config.d/dbora is properly configured
SRV2:sbin>cat /etc/rc.config.d/dbora
# ORACLE DATABASE configuration
#
# ORACLE_START_STOP : Set to 1 to start ORACLE DATABASE
#
ORACLE_START_STOP=1

SRV2:sbin>

4. Restart the server to see if the Oracle database is properly starting now.

(please post your /etc/rc.log)

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: startup script

hi yogreej,

As per your inputs,and after rebooting server,database not starts.

Pls find the rc.log for you info.

thanks

Peter Nikitka
Honored Contributor

Re: startup script

Hi,

- do you use Yogeeraj's script ?

- add a
export PATH
after the setting of the PATH variable

- send us the output of
type hostname
type touch
uname -a

of your HP server.

mfG Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
sh5490
Frequent Advisor

Re: startup script

hi,
yes , we have executed script provided by yogreej,
pls find below the required info.
# hostname
posserve.ciegroup.net
# uname -a
HP-UX posserve B.11.23 U ia64 4192405881 unlimited-user license
thanks

shabir


Peter Nikitka
Honored Contributor

Re: startup script

Hi,

do you have results for a version with the export PATH
statement?
As a test, include a call
/usr/bin/hostname
in the script to check for accessability.

mfG Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
sh5490
Frequent Advisor

Re: startup script

hi peter,

thanks for u imputs
pls see the contents of dbora scrip which is running perfect under root user,
but after modification this didn't work

#;export ORACLE_HOME
ORACLE_SID=ciehoi;export ORACLE_SID
# oracle owner at your site.
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
LOG=$ORACLE_HOME/stop1.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"
su - $ORACLE -c "lsnrctl start" >> $LOG2>&1 &
fi
echo "Starting Oracle databases"
su - $ORACLE -c "dbstart" >> $LOG2>&1 &
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net Listener">> $LOG2>&1&
su - $ORACLE -c "lsnrctl stop" >> $LOG2>&1 &
fi
echo "stopping Oracle databases">>$LOG2>&1&
su - $ORACLE -c "dbshut" >> $LOG2>&1 &
;;
*)
echo "usage: $0 {start|stop}"
exit
;;

thanks

shabir
Peter Nikitka
Honored Contributor

Re: startup script

Hi,

you did NOT make some of the modifications, we noted in our answers - esp. you did NOT protect for an empty PATH variable!
I would not start the oracle processes in background (drop the &), but that's perhaps only my opinion: Only such you can be shure, that a connect to the DB will succeed after having your console prompt - else the startup may be still incomplete.

#;export ORACLE_HOME
ORACLE_SID=ciehoi;export ORACLE_SID
# oracle owner at your site.
ORACLE=oracle
# CHANGED: PATH=${PATH}:$ORACLE_HOME/bin
PATH=${PATH:-/usr/bin}:$ORACLE_HOME/bin
export PATH

HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
LOG=$ORACLE_HOME/stop1.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"
su - $ORACLE -c "lsnrctl start" >> $LOG2>&1 &
fi
echo "Starting Oracle databases"
su - $ORACLE -c "dbstart" >> $LOG2>&1 &
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net Listener">> $LOG2>&1&
su - $ORACLE -c "lsnrctl stop" >> $LOG2>&1 &
fi
echo "stopping Oracle databases">>$LOG2>&1&
su - $ORACLE -c "dbshut" >> $LOG2>&1 &
;;
# YOU NEED THIS AS WELL, as rc will supply this parameters:
start_msg) echo "starting oracle " ;;
stop_msg) echo "stopping oracle " ;;
*)
echo "usage: $0 {start[_msg]|stop[_msg}"
# SUPPLY AN EXIT CODE FOR exit
retcode=1
;;

# MISSING ESAC
esac

# USUALLY you work with a variable retcode (e.g.) in rc scripts
exit ${retcode:-0}

mfG Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
sh5490
Frequent Advisor

Re: startup script

hi, yogreej,

pls provide me further inputs to resolve the issue

thanks

shabir
Peter Nikitka
Honored Contributor

Re: startup script

Hi Shabir,

just use the script in my posting!

mfG Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
Yogeeraj_1
Honored Contributor

Re: startup script

hi Shabir,

Did you try peter's script above?

revert!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: startup script

hhi,

yes we have tried the script provided by peter .

same problem

thanks

shabir
Peter Nikitka
Honored Contributor

Re: startup script

Hi,

please add this debug-output creating statements at the beginning of your script and send us this output:

set -x
#;export ORACLE_HOME
ORACLE_SID=ciehoi;export ORACLE_SID
# oracle owner at your site.
ORACLE=oracle
# CHANGED: PATH=${PATH}:$ORACLE_HOME/bin
PATH=${PATH:-/usr/bin}:$ORACLE_HOME/bin
export PATH
type hostname
HOST=`hostname`
... (rest like before) ...

mfG Peter
The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
sh5490
Frequent Advisor

Re: startup script

hi peter,
pls find find the output


$ ./dbora stop
+ oRACLE_SID=cieho
+ export ORACLE_SID
+ ORACLE=oracle
+ ORACLE_HOME=/u01/app/oracle/OraHome_1
+ export ORACLE_HOME
+ PATH=/usr/bin:/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:/usr/bin/X11:/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:/u01/app/oracle/OraHome/bin:/usr/local/bin:.:/u01/app/oracle/OraHome_1/bin
+ export PATH
+ + hostname
HOST=posserve.ciegroup.net
+ + uname
PLATFORM=HP-UX
+ LOG=/u01/app/oracle/OraHome_1/stop1.log
+ touch /u01/app/oracle/OraHome_1/stop1.log
touch: /u01/app/oracle/OraHome_1/stop1.log cannot create
+ chmod a+r /u01/app/oracle/OraHome_1/stop1.log
chmod: can't access /u01/app/oracle/OraHome_1/stop1.log
+ echo ./dbora: shutting down
+ ./dbora[34]: /u01/app/oracle/OraHome_1/stop1.log: Cannot create the specified file.
+ date
+ ./dbora[35]: /u01/app/oracle/OraHome_1/stop1.log: Cannot create the specified file.
+ [ -f /u01/app/oracle/OraHome_1/bin/tnslsnr ]
+ echo stopping Oracle databases
+ 1>& 1
stopping Oracle databases
+ su - oracle -c dbshut
+ 1>& 1
Password:
su: Sorry
+ exit 0


thanks

shabir



Yogeeraj_1
Honored Contributor

Re: startup script

hi Shabir,

>$ ./dbora stop

you must run this as "root" NOT the oracle user.

also,
>+ oRACLE_SID=cieho

Somewhere in your script it is written "oRACLE_SID-cieho" instead of "ORACLE_SID", please correct this line.


Please rerun the test and post the requested output again.

revert!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: startup script

hi Yogreej,
pls see the out of dbora start & dbora stop
script,both we executed under root user

./dbora start

/opt/perl_64/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/thunderbi
rd:/opt/gwlm/bin:/usr/contrib/bin/X11:/opt/langtools/bin:/opt/caliper/bin:/opt/s
entinel/bin:/usr/local/bin:/u01/app/oracle/OraHome_1/bin
+ export PATH
+ + hostname
HOST=posserve.ciegroup.net
+ + uname
PLATFORM=HP-UX
+ LOG=/u01/app/oracle/OraHome_1/stop1.log
+ touch /u01/app/oracle/OraHome_1/stop1.log
+ chmod a+r /u01/app/oracle/OraHome_1/stop1.log
+ echo ./dbora: starting up
+ 1>> /u01/app/oracle/OraHome_1/stop1.log
+ date
+ 1>> /u01/app/oracle/OraHome_1/stop1.log
+ [ -f /u01/app/oracle/OraHome_1/bin/tnslsnr ]
+ echo starting Oracle Net Listener
starting Oracle Net Listener
+ su - oracle -c lsnrctl start
+ 1>& 1
(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).
You have mail.

LSNRCTL for HPUX: Version 10.2.0.3.0 - Production on 28-MAY-2008 12:18:41

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Starting /u01/app/oracle/OraHome_1/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.3.0 - Production
System parameter file is /u01/app/oracle/OraHome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/OraHome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=posserve.ciegroup.net)(P
ORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.3.0 - Production
Start Date 28-MAY-2008 12:18:41
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/OraHome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/OraHome_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=posserve.ciegroup.net)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
+ echo Starting Oracle databases
Starting Oracle databases
+ su - oracle -c dbstart
+ 1>& 1
(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).
You have mail.
/u01/app/oracle/OraHome_1/bin/dbstart[89]: test: Specify a parameter with this c
ommand.
Failed to auto-start Oracle Net Listener using /bin/tnslsnr
Processing Database instance "cieho": log file /u01/app/oracle/OraHome_1/startup
.log
+ exit 0
#

dbora stop script output
# id
uid=0(root) gid=3(sys) groups=0(root),1(other),2(bin),4(adm),5(daemon),6(mail),7(lp),20(users)
# ./dbora stop
+ ORACLE_SID=cieho
+ export ORACLE_SID
+ ORACLE=oracle
+ ORACLE_HOME=/u01/app/oracle/OraHome_1
+ export ORACLE_HOME
+ 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:/u01/app/oracle/OraHome_1/bin
+ export PATH
+ + hostname
HOST=posserve.ciegroup.net
+ + uname
PLATFORM=HP-UX
+ LOG=/u01/app/oracle/OraHome_1/stop1.log
+ touch /u01/app/oracle/OraHome_1/stop1.log
+ chmod a+r /u01/app/oracle/OraHome_1/stop1.log
+ echo ./dbora: shutting down
+ 1>> /u01/app/oracle/OraHome_1/stop1.log
+ date
+ 1>> /u01/app/oracle/OraHome_1/stop1.log
+ [ -f /u01/app/oracle/OraHome_1/bin/tnslsnr ]
+ echo stopping Oracle Net Listener
+ 1>& 1
stopping Oracle Net Listener
+ su - oracle -c lsnrctl stop
+ 1>& 1
(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).
You have mail.

LSNRCTL for HPUX: Version 10.2.0.3.0 - Production on 28-MAY-2008 12:22:26

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
+ echo stopping Oracle databases
+ 1>& 1
stopping Oracle databases
+ su - oracle -c dbshut
+ 1>& 1
(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).
You have mail.
/u01/app/oracle/OraHome_1/bin/dbshut[78]: test: Specify a parameter with this command.
Failed to auto-stop Oracle Net Listener using /bin/tnslsnr
Processing Database instance "cieho": log file /u01/app/oracle/OraHome_1/shutdown.log

+ exit 0
# #

thanks

shabir
Peter Nikitka
Honored Contributor

Re: startup script

Hi,

your problem now ist no longer related to a system startup/shutdown script.
It's a not uncommon glitch in the oracle scripts, and the output tells you all you need:
Look at the mentioned lines in the script(s)
/u01/app/oracle/OraHome_1/bin/dbstart[89]
/u01/app/oracle/OraHome_1/bin/dbshut[78]

There will be a construct like (example!)
[ $var = value ]
and the variable var is empty. Change to
[ "$var" = value ]
and better read some lines previous to that lines under what condition that variable was left empty.

mfG Peter

The Universe is a pretty big place, it's bigger than anything anyone has ever dreamed of before. So if it's just us, seems like an awful waste of space, right? Jodie Foster in "Contact"
Yogeeraj_1
Honored Contributor

Re: startup script

hi again,

Thank you for the last output.

It now seems that the problem has narrowed down to the dbshut and dbstart scripts.

We now need to investigate further in this direction.

can you confirm that no changes have been made to these two scripts?

revert!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
sh5490
Frequent Advisor

Re: startup script

hi yogreej/peter,

thanks for reply

There was no changes done in these scripts

thanks
shabir