topic create automatic script and run by oracle user in Operating System - HP-UX

create automatic script and run by oracle user

Ricky_4 — Wed, 03 May 2006 23:58:45 GMT

Hi All,

I would like to create automatic startup script but that script should be run by oracle.
Please assist me how to this so it will start automatically once we reboot the server.

I attached the script so you will have an idea.

Thanks in advance.

Adriatico

Re: create automatic script and run by oracle user

m saravanan — Thu, 04 May 2006 00:45:56 GMT

Hi,

Put the following in the first line of your script,

su - oracle

save the script & move it to "/sbin/init.d" directory,
For Ex:
# mv /tmp/script /sbin/init.d/oracle

Link the script to "/sbin/rc3.d" , to start the script in run level 3. The naming convention should be Sxxx<script name>.
For Ex:
# cd /sbin/rc3.d
# ln -s /sbin/init.d/oracle S987oracle

If you any script to halt, put the same in "/sbin/rc2.d" and start the name with "K"

Regds,
Saravanan

Re: create automatic script and run by oracle user

Luk Vandenbussche — Thu, 04 May 2006 00:47:41 GMT

Hi,

Create a script in /sbin/init.d/oraclestart which contains

su - oracle -c "startscript"

Then execute the following

cd /sbin/rc2.d
ln -s /sbin/init.d/oraclestart S999oraclestart

You script will be executed when you reboot the server

Re: create automatic script and run by oracle user

Susik — Thu, 04 May 2006 00:47:59 GMT

file /etc/oratab
instance:/oracle_path:Y

Re: create automatic script and run by oracle user

Ricky_4 — Thu, 04 May 2006 19:29:26 GMT

All,

Please check procedure below if it will work also as automatic shutdown script by following "Luk Vandenbussche" reply as startup script.

procedure:
cd /sbin/rc2.d
ln -s /sbin/init.d/oraclestart K999oraclestart

Thanks.

Adriactico