Re: Automating Database Startup and Shutdown on Tru64 os V5.1A

fabrizio wrote:
> Dear users,
> I'm trying to configure the automatic oracle startup and shutdwn for tru64
> OS V5.1A.
> I followed the post-instalation in the reference manual so:
>
> 1) in the /etc/oratab file I added DB_NAME:ORACLE_HOME:Y
> 2) in the /sbin/init.d/oracle directory I added the script below.
> the /sbin/init.d/oracle is owned by root:system and its permissions are
> 750
>

<snip>

>
> It should be correct but during the stratup of the system I see nothing
> about the
> oracle starting up I see only a strange PERMISSON DEINED.
>
> If I try to launch as root the command:
>
> rsh MY.HOST.NAME -l oracle /sbin/init.d/oracle
>
> as in the script the I see the same PERMISSION DEINED.
> So I think that the script is launched correctly but something appens when
> the script try to execute te rsh command
>
> Could someone tell me where I'm wrong?
>
>

I donnot use thru64 but from what I'm seeing you are trying to execute the script as the user "oracle" while you assigned permission 750 and the ownership is root:system.

The permission denied is due to oracle not having the execution privilage on your script.

I would even check this line:

     if [ ! "$2" = "ORA_DB" ] ; then
         rsh $HOST -l $ORACLE /sbin/init.d/oracle $1 ORA_DB
         exit
     fi

(not too elegant in my opinion and it should be the reason for permission denied during boot)

and:

             echo "starting Oracle Net listener"
             $ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &

If you launch the script as root you can have some bad surprises.

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe