Oracle listener process on init

kashnaraga · #1 (**permalink**) 01-24-06, 04:53

Hi all,
I want to set the 'tnslsnr' process to run at init.
(So I won't have to restart it everytime the system is rebooting)

If I add the running command line to my /etc/inittab file (btw I use Solaris)
it will run with the user root.

Is it possible?
how can it run with the oracle db user it usually runs under?

Thanks ahead,
Oren

anacedent · #2 (**permalink**) 01-24-06, 10:39

>how can it run with the oracle db user it usually runs under?
$ man su

LKBrwn_DBA · #3 (**permalink**) 01-24-06, 13:15

Here is one way to do it:

Code:

#!/bin/ksh
if [ $# -eq 0 ] 
then
        echo "%-Error, Missing Parameter: $0 {start | stop}"
        exit
fi
###################################################
# 1st time thru, su to oracle (used for boot and shutdown procedures)
###################################################
if [ ! "$2" = "ORADBA" ]
then
        su - oracle -c "/etc/init.d/db_oracle.ksh $1 ORADBA" 
        exit
fi
 
case $1 in
        'start')
                /oracle/local/utl/db_startup.ksh all &
                /oracle/dbsrvr/8.1.7/bin/lsnrctl start
                ;;
        'stop')
                /oracle/dbsrvr/8.1.7/bin/lsnrctl stop
                /oracle/local/utl/db_shutdown.ksh all
                ;;
        *)
                echo "%-Error, Invalid Parameter: $0 {start | stop}"
                exit
                ;;
esac
exit

kashnaraga · #4 (**permalink**) 01-25-06, 09:10

If I will call a shell script from the inittab (which will call the command which will start the lsnr process) on this way :

/etc/inittab:
su::once:/usr/sbin/<su.sh> ---> calling <su.sh> from /etc/inittab

<su.sh> , will contain this line :
su - <user> -c <'cmd'> ----> where cmd is the actuall command to start lsnr

It is a good solution BUT ,
It will work only if the user which runs the command would be root
(Because that user can 'su' without password).

Does the commands\scripts that we call through the /etc/inittab file always run under 'root' user ?
If yes then it kinda solve my problem ...
Does anybody know :) ?

Thanks in advance,
Oren :)

LKBrwn_DBA · #5 (**permalink**) 01-25-06, 12:41

You add the script I posted into /etc/init.d and all the /etc/rc?.d directories.

Also you will have to code the "db_startup.ksh" and "db_shutdown.ksh" scripts.

Good luck!

Internet Services

Web Development

Digital Marketing

Consumer Tech