create automatic script and run by oracle user

[Ricky_4]

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

[m saravanan]

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

[Luk Vandenbussche · Accepted solution]

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

[Susik]

file /etc/oratab
instance:/oracle_path:Y

[Ricky_4]

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