With Database Control, you can monitor and administer a single Oracle Database instance.
- Ensure that you can connect to the Repository Database. Test it with SQL*Plus or TNSPING Utility. If you are unable to connect, review your listeners and tnsnames setup here: http://www.oracle-forums.com/creating-o ... x-t46.html
> [oracle@oracle10g ~]$ sqlplus '/as sysdba'
> [oracle@oracle10g ~]$ tnsping ORCL[oracle@oracle10g ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 26 21:10:09 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
> Take note of Database SID and Listener port number of your Repository Database.[oracle@oracle10g ~]$ tnsping ORCL
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 26-JAN-2012 21:10:39
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.localdomain)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL)))
OK (0 msec)
[oracle@oracle10g ~]$
- Start the Oracle EM dbconsole Build Script ($ORACLE_HOME/bin/emca for Linux).
> [oracle@oracle10g ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos create
- Access your Oracle Enterprise Manager via an Internet browser.[oracle@oracle10g ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos create
STARTED EMCA at Jan 26, 2012 9:14:18 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
Database hostname ................ oracle10g.localdomain
Listener port number ................ 1521
Database SID ................ ORCL
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jan 26, 2012 9:15:17 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/ORCL/emca_2012-01-26_09-14-17-PM.log.
Jan 26, 2012 9:15:19 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 26, 2012 9:17:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 26, 2012 9:17:22 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 26, 2012 9:18:59 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 26, 2012 9:18:59 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://oracle10g.localdomain:5500/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 26, 2012 9:18:59 PM
[oracle@oracle10g ~]$
> INFO: >>>>>>>>>>> The Database Control URL is http://oracle10g.localdomain:5500/em <<<<<<<<<<<
> From the above, the address cannot be resolved if you do not have DNS server installed in your local network. Change it with the correct IP Address of the server instead.
> Go to http://192.168.218.150:5500/em
- You should now be able to login to your Oracle Enterprise Manager.
To Start the Enterprise Manager Database Control:
[oracle@oracle10g ~]$ emctl start dbconsole
To Stop the Enterprise Manager Database Control:[ORCLA10 /home/oracle]$ emctl start dbconsole
TZ set to Asia/Manila
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://dgprim.localdomain:1158/em/conso ... pplication
Starting Oracle Enterprise Manager 10g Database Control .............................. started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/dgprim.localdomain_ORCLA10/sysman/log
[ORCLA10 /home/oracle]$
[oracle@oracle10g ~]$ emctl stop dbconsole
To Monitor the Enterprise Manager Database Control:[ORCLA10 /home/oracle]$ emctl stop dbconsole
TZ set to Asia/Manila
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://dgprim.localdomain:1158/em/conso ... pplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
[ORCLA10 /home/oracle]$
[oracle@oracle10g ~]$ emctl status dbconsole
[ORCLA10 /home/oracle]$ emctl status dbconsole
TZ set to Asia/Manila
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://dgprim.localdomain:1158/em/conso ... pplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/dgprim.localdomain_ORCLA10/sysman/log
[ORCLA10 /home/oracle]$