Hey there...
Try this...Oracle 10g needs dbstart/dbshut to be called with $ORACLE_HOME as
an argument. The echo $? dont seem to work but the script starts and stops
Oracle OK. Every DB listed in /etc/oratab with last field as Y will be
stopped and started with this script.
Here's my script:
#!/bin/sh
# chkconfig: 35 99 10
# description: Oracle auto start-stop script.
#
# Set ORACLE_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORACLE_OWNER to the user id of the owner of the
# Oracle database in ORACLE_HOME.
ORACLE_HOME=/oracle/product/10g
ORACLE_OWNER=oracle
export ORACLE_HOME ORACLE_OWNER
if [ ! -f ${ORACLE_HOME}/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - ${ORACLE_OWNER} -c
'ORACLE_HOME_LISTNER=$ORACLE_HOME;${ORACLE_HOME}/bin/dbstart
${ORACLE_HOME}';ret=$?
if ((ret==0))
then
echo "OK"
else
echo "FAILED"
fi
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - ${ORACLE_OWNER} -c
'ORACLE_HOME_LISTNER=$ORACLE_HOME;${ORACLE_HOME}/bin/dbshut
${ORACLE_HOME}';ret=$?
if ((ret==0))
then
echo "OK"
else
echo "FAILED"
fi
;;
esac
#End of script
Cheers,
Phil
On Tue, Dec 9, 2008 at 8:59 PM, SIG - Pédagogie <sigpedag@xxxxxxxxxxxxxx>wrote:
> Hello,
>
> I'm using an up-to-date Red Hat Enterprise Linux 4.7 (64 bits) system and
> I'd like to setup a startup/shutdown script to manage an Oracle AS 10g R2
> installation.
>
> The script works fine (start/stop/restart) when called from a bash
> prompt and it's launched at system startup with no problem.
>
> The issue is that it's no called at all when the system shuts down, I
> checked runlevels, permissions for the script, I even put some "wall" and
> "echo" in it...
>
> I try different priorities, different script names, different shells, it's
> always the same. The only particularity of the script is that the commands I
> launch need to run under a user with no privileges, I use "su" for that.
>
> (Once again, everything works when it's called from a shell, so doesn't
> seem to be "su"-related and the "wall" and "echo" command that should be
> exectued in root aren't executed)
>
> I have absolutely no idea why this happens...
>
> =========================================================================
>
> # ls -l /etc/init.d/ora-as1
> -rwxr-xr-x 1 root root 617 Dec 9 14:45 /etc/init.d/ora-as1
>
> =========================================================================
>
> # cat /etc/init.d/ora-as1
> #!/bin/sh
> #
> # Startup script for Oracle AS 10g R2
> # chkconfig: 345 86 14
> #
> # description: Bla bla bla
>
> start() {
> su -c "opmnctl startall" - ora-as1
> su -c "emctl start iasconsole" - ora-as1
> }
>
> stop() {
> wall "Stopping ora-as1"
> echo "`date` - Stopping ora-as1" >> /var/log/oracleas10gr2.log
> su -c "emctl stop iasconsole" - ora-as1
> su -c "opmnctl stopall" - ora-as1
> }
>
> # See how we were called
> case "$1" in
> start)
> start
> ;;
> stop)
> stop
> ;;
> restart)
> stop
> start
> ;;
> *)
> echo "Usage: $0 {start|stop|restart}"
> esac
>
> exit 0
>
> =========================================================================
>
> # find /etc/rc* -type l -name "*ora-as1*"
> /etc/rc.d/rc1.d/K14ora-as1
> /etc/rc.d/rc2.d/K14ora-as1
> /etc/rc.d/rc3.d/S86ora-as1
> /etc/rc.d/rc4.d/S86ora-as1
> /etc/rc.d/rc0.d/K14ora-as1
> /etc/rc.d/rc5.d/S86ora-as1
> /etc/rc.d/rc6.d/K14ora-as1
>
> =========================================================================
>
> # chkconfig --list ora-as1
> ora-as1 0:off 1:off 2:off 3:on 4:on 5:on 6:off
>
> =========================================================================
>
> Any idea?
> --
> Nicolas
>
>
> --
> Ce message a ete verifie par MailScanner
> pour des virus ou des polluriels et rien de
> suspect n'a ete trouve.
>
> --
> redhat-list mailing list
> unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
> https://www.redhat.com/mailman/listinfo/redhat-list
>
--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subjecthttps://www.redhat.com/mailman/listinfo/redhat-list
