After the installation of the database,you will get a link like below for OEM(Oracle Enterprise Manager) via which you can monitor the database from browser.
The link will be something like:
https://hostname:port/em
Ex: https://localhost:1521/em
Where hostname is the name of the machine on which database control is ruuning,and port is the TCP port on whihc it is listening for incoming connection requests.
To find the port details either you can check tnsnames.ora or listener.ora file ($ORACLE_HOME/network/admin) or best way is to go to $ORACLE_HOME/install/portlist.ini which lists all the ports configured by the OUI and DBCA.
Description About Database Control:
Database Control is a tool for managing one database(though this database can be clustered).
If there are several instances runing from the same ORACLE_HOME,each instance should have their own database control.
All communications with database control are over HTPPS.
To start the Database Control,use emctl utility located in the $ORACLE_HOME/bin directory.The 3 commands to start or stop Database Conctrol and to check it's status are
$ORACLE_HOME/bin> emctl start dbconsole
$ORACLE_HOME/bin> emctl stop dbconsole
$ORACLE_HOME/bin> emctl status dbconsole
P.N-> For above commands to work,3 environments variables must be set: PATH,ORACLE_HOME and ORACLE_SID.
PATH is needed to allow the OS to find emctl utility.
The ORACLE_HOME & ORACLE_SID are needed so that emctl can find the Database Control Configuration files.
These configuration files are in 3 places :
$ORACLE_HOME/sysman/config ---> this is general configuration directives that will apply to all Database Control instances running from the Oracle Home.(one per database).
The $ORACLE_HOME/hostname_sid/sysman/config and a similarly named directory beneath $ORACLE_HOME/oc4j/j2ee contain details for the database control that manages one particualr database.
Unless and until we will not start the database control the OEM link will never gonna work for us.
Sometimes you will get a request from your their OEM link is not working.As a DBA you have to ask whether the issue is same for all the users or only he/she alone facing the issue.If answer is for all,then please do the below workaround to resolve the issue.
servername@oracle> set the profile like . bash.profile or . /oracle.profile <<<as per yor db environment>>
or
servername@oracle> set ORACLE_SID=PROD
servername@oracle> emctl status dbconsole
if the status showing: ORACLE ENTERPRISER MANAGER 11g is not running.
servername@oracle>emctl start dbconsole
The status will show:
starting ORACLE ENTERPRISER MANAGER 11g database control......the ORACLEDBCONSOLEOCP11g service is starting...........
The Oracle DBCconsoleocp11g service was started successfully.
servername@oracle>emctl status dbconsole
The status will be: Oracle Enterpriser Manager 11g is running.
And you are done & problem solved :) :) :)
The link will be something like:
https://hostname:port/em
Ex: https://localhost:1521/em
Where hostname is the name of the machine on which database control is ruuning,and port is the TCP port on whihc it is listening for incoming connection requests.
To find the port details either you can check tnsnames.ora or listener.ora file ($ORACLE_HOME/network/admin) or best way is to go to $ORACLE_HOME/install/portlist.ini which lists all the ports configured by the OUI and DBCA.
Description About Database Control:
Database Control is a tool for managing one database(though this database can be clustered).
If there are several instances runing from the same ORACLE_HOME,each instance should have their own database control.
All communications with database control are over HTPPS.
To start the Database Control,use emctl utility located in the $ORACLE_HOME/bin directory.The 3 commands to start or stop Database Conctrol and to check it's status are
$ORACLE_HOME/bin> emctl start dbconsole
$ORACLE_HOME/bin> emctl stop dbconsole
$ORACLE_HOME/bin> emctl status dbconsole
P.N-> For above commands to work,3 environments variables must be set: PATH,ORACLE_HOME and ORACLE_SID.
PATH is needed to allow the OS to find emctl utility.
The ORACLE_HOME & ORACLE_SID are needed so that emctl can find the Database Control Configuration files.
These configuration files are in 3 places :
$ORACLE_HOME/sysman/config ---> this is general configuration directives that will apply to all Database Control instances running from the Oracle Home.(one per database).
The $ORACLE_HOME/hostname_sid/sysman/config and a similarly named directory beneath $ORACLE_HOME/oc4j/j2ee contain details for the database control that manages one particualr database.
Unless and until we will not start the database control the OEM link will never gonna work for us.
Sometimes you will get a request from your their OEM link is not working.As a DBA you have to ask whether the issue is same for all the users or only he/she alone facing the issue.If answer is for all,then please do the below workaround to resolve the issue.
servername@oracle> set the profile like . bash.profile or . /oracle.profile <<<as per yor db environment>>
or
servername@oracle> set ORACLE_SID=PROD
servername@oracle> emctl status dbconsole
if the status showing: ORACLE ENTERPRISER MANAGER 11g is not running.
servername@oracle>emctl start dbconsole
The status will show:
starting ORACLE ENTERPRISER MANAGER 11g database control......the ORACLEDBCONSOLEOCP11g service is starting...........
The Oracle DBCconsoleocp11g service was started successfully.
servername@oracle>emctl status dbconsole
The status will be: Oracle Enterpriser Manager 11g is running.
And you are done & problem solved :) :) :)
No comments:
Post a Comment