Apache Server (Oracle)

[Michael Velez]

> -----Original Message-----
> From: redhat-list-bounces at redhat.com 
> [mailto:redhat-list-bounces at redhat.com] On Behalf Of Larry D Sorensen
> Sent: Thursday, December 21, 2006 5:56 PM
> To: redhat-list at redhat.com
> Subject: Re: Apache Server (Oracle)
> 
> My default runlevel is 5. As for the httpd configuration, it 
> was set to off for all. I changed it to on for runlevel 5, 
> then I rebooted. http appears to have started, but I still 
> cannot open a browser to my Oracle Enterprise Manager. Thanks 
> for your help.
> 
> Are there any Oracle people out there that I can help me with 
> the next step? Do I need to move some http conf settings to a 
> more global location from my oracle environment, or something else?
> 
> Larry
>  
> On Thu, 21 Dec 2006 17:42:53 -0500 "Gaddis, Jeremy L."
> <jeremy at linuxwiz.net> writes:
> > On 12/21/06, Larry D Sorensen <larry.sorensen at juno.com> wrote:
> > > As part of an Oracle installation, I set up some web pages;
> > however, upon
> > > reboot, the apache server does not seem to be starting. I cannot
> > access
> > > the Enterprise Manager web page on my server. Can someone explain
> > to me
> > > what I need to do to get to set up things to automatically start
> > after a
> > > reboot?
> > 
> > 1. What's your default runlevel (grep ^id /etc/inittab | awk -F : 
> > '{
> > print $2 }')?
> > 
> > 2. Is Apache configured to automatically start up in that runlevel 
> > (chkconfig --list httpd)?
> > 
> > --
> > Jeremy L. Gaddis, MCP, GCWN
> > http://www.linuxwiz.net/
> > 
> > --
> > redhat-list mailing list
> > unsubscribe
> > mailto:redhat-list-request at redhat.com?subject=unsubscribe
> > https://www.redhat.com/mailman/listinfo/redhat-list
> > 
> > 

To start the Oracle Enterprise Manager, you need to execute the following
command as the oracle user:

$ORACLE_HOME/bin/emctl start dbconsole

I usually start the listener, the databases, and the enterprise manager in
an oracle script in init.d.  To start the Oracle Enterprise Manager for more
than one database instance, you need to call the emctl command for each
instance setting the ORACLE_SID variable to the appropriate instance before
each call to emctl.


Hope this helps,
Michael

I have included the script I use below for your reference (be careful, I've
seen my microsoft outlook mess with the formatting and delete characters):

------- START OF SCRIPT ----------

#!/bin/bash
#
# chkconfig: 345 99 01
#
# Description: This file starts and stops all Oracle databases, as well as
the Oracle Listener
# 

ORACLE_HOME=/usr/oracle/orahome
ORACLE=oracle

LOG=${ORACLE_HOME}/startup.log
touch $LOG
chmod a+r $LOG
chown oracle:dba $LOG

PATH=${PATH}:${ORACLE_HOME}/bin

if [ -f /etc/rc.d/init.d/functions ]; then
        . /etc/rc.d/init.d/functions
fi

case $1 in
'start')
	echo "Starting Oracle Services" > $LOG
	date >> $LOG

	echo -n "Starting Oracle Net Listener"
	runuser - $ORACLE -c "$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1"
	sleep 2
        PID=`pidof -s -x -o $$ -o $PPID -o %PPID tnslsnr`
        if [ $PID ]
	then
		echo_success
	else
		echo_failure
	fi
	echo

	echo -n "Starting Oracle Database"
	runuser - $ORACLE -c "$ORACLE_HOME/bin/dbstart >> $LOG 2>&1 &"
	if [[ $? = 0 ]]
	then
		echo_success
	else
		echo_failure
	fi
	echo

	echo -n "Starting Oracle Enterprise Manager For Database Trade"
	ORACLE_SID=oradb
	runuser - $ORACLE -c "$ORACLE_HOME/bin/emctl start dbconsole >> $LOG
2>&1 &"
	if [[ $? = 0 ]]
	then
		echo_success
	else
		echo_failure
	fi
	echo

	touch /var/lock/subsys/oracle
	;;
'stop')

	echo -n "Stopping Oracle Net Listener"
	runuser - $ORACLE -c "$ORACLE_HOME/bin/lsnrctl stop >> $LOG 2>&1"
	if [[ $? = 0 ]]
	then
		echo_success
	else
		echo_failure
	fi

	echo -n "Stopping Oracle Database"
	runuser - $ORACLE -c "$ORACLE_HOME/bin/dbshut >> $LOG 2>&1"
	if [[ $? = 0 ]]
	then
		echo_success
	else
		echo_failure
	fi

	ORACLE_SID=oradb
	echo -n "Stopping Oracle Enterprise Manager For Database Trade"
	runuser - $ORACLE -c "$ORACLE_HOME/bin/emctl stop dbconsole >> $LOG
2>&1 &"
	if [[ $? = 0 ]]
	then
		echo_success
	else
		echo_failure
	fi
	echo

	rm -f /var/lock/subsys/oracle

	;;
*)
	echo "usage: $0 {start|stop}"
	exit -1
	;;
esac
exit 0