DBSTART SCRIPT DOES NOT WORK WITH KSH SHELL on HP-UX

DBSTART script does not work with KSH shell and it gives the following error:

/base/oracle/product/V10.2.0.3/bin/dbstart[89]: test: argument expected
Failed to auto-start Oracle Net Listener using /bin/tnslsnr
Processing Database instance “DGED00”: log file
/base/oracle/product/V10.2.0.3/startup.log
logout

This happens when running dbstart as a part of the startup procedures. It can be reproduced using the command line as follows:
su – oracle -c “${ORACLE_HOME}/bin/dbstart”

1/ The result of this command is :
/base/oracle/product/V10.2.0.3/bin/dbstart[89]: test: argument expected
Failed to auto-start Oracle Net Listener using /bin/tnslsnr
Processing Database instance “DGED00”: log file
/base/oracle/product/V10.2.0.3/startup.log
logout

2/ The content of startup.log is :
startinst[79]: /base/oracle/product/V10.2.0.3/dbs/spfileDGED00.ora: unknown
test operator
logger: illegal option — s
Usage: logger [ -t tag ] [ -p pri ] [ -i ] [ -f file ] [message …]
logger: illegal option — s
Usage: logger [ -t tag ] [ -p pri ] [ -i ] [ -f file ] [message …]
logger: illegal option — s
Usage: logger [ -t tag ] [ -p pri ] [ -i ] [ -f file ] [message …]

WORKAROUND:

In the dbstart script, there is a test on existence of some files :

if [ -e $SPFILE -o -e $SPFILE1 -o -e $PFILE ] ; then
When changing it to be (as in version 10.2.0.2), it works fine:
if [ -f $SPFILE -o -f $SPFILE1 -o -f $PFILE ] ; then

ksh on HPIA does not support test -e argument and so fails.
Passing over to DDR as generic as maybe the generic code
could use a more widely supported option such as -r
(as -e will show that a file exists even if it cannot be read
but -r will only short the file exists if it can be read
and -r should honor symbolic links).

Advertisements

2 Responses

  1. Hi Miranda, its’s work for me!! Thanks for post this note! Bye

  2. Worked for me.

    Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: