if you encounter this error while starting oracle

/etc/init.d/oraemctl start Starting Oracle EM DB Console:
Environment variable ORACLE_UNQNAME not defined. 
Please set ORACLE_UNQNAME to database unique name. OK
One possible solution is to edit the script
# vi /etc/init.d/oraemctl

and add the following code in blue

# oraemctl Starting and stopping Oracle Enterprise Manager Database Control.
# Script is valid for 10g and 11g versions.
# chkconfig: 35 80 30
# description: Enterprise Manager DB Control startup script

# Source function library.

. /etc/rc.d/init.d/functions


case "$1" in
  echo -n $"Starting Oracle EM DB Console:"
  su - $ORACLE_OWNER -c "ORACLE_SID=$ORACLE_SID $ORACLE_HOME/bin/emctl start dbconsole"
  echo "OK"
  echo -n $"Stopping Oracle EM DB Console:"
  su - $ORACLE_OWNER -c "ORACLE_SID=$ORACLE_SID $ORACLE_HOME/bin/emctl stop dbconsole"
  echo "OK"
 echo $"Usage: $0 {start|stop}"

Use of course the right SID, after that Oracle Enterprise manager will start correctly

# /etc/init.d/oraemctl start
Starting Oracle EM DB Console:Oracle Enterprise Manager 11g Database Control Release
Copyright (c) 1996, 2009 Oracle Corporation.&160; All rights reserved.
- An instance of Oracle Enterprise Manager 11g Database Control is already running.

comments powered by Disqus

You might like also


I'm Looking for a new JOB!

​Joomla extensions have moved!

Galaxiis (formely www.waltercedric.com) creates industry leading premium Joomla Extensions and is the longest running Joomla extensions provider since 2005.

Powerful Joomla extensions. - Excellent documentation. - Amazing support.

Visit now www.galaxiis.com