EMCA

How to create Oracle Enterprise manager repository in 10g R1

Oracle@linuxDomain:~> emca -repos create

STARTED EMCA at Jul 10, 2007 5:00:50 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: lamp
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 10, 2007 5:01:05 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.1.0/Db_1/cfgtoollogs/emca/lamp/emca_2007-07-10_05-00-50-PM.log.
Jul 10, 2007 5:01:05 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 10, 2007 5:03:49 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 10, 2007 5:03:50 PM


oracle@linuxDomain:~> emca -config dbcontrol db

STARTED EMCA at Jul 10, 2007 5:06:16 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: lamp
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.1.0/Db_1

Database hostname ................ linuxDomain.site
Listener port number ................ 1521
Database SID ................ lamp
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 10, 2007 5:06:36 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.1.0/Db_1/cfgtoollogs/emca/lamp/emca_2007-07-10_05-06-16-PM.log.
Jul 10, 2007 5:06:36 PM oracle.sysman.emcp.DatabaseChecks performReposChecks
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Jul 10, 2007 5:06:43 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 10, 2007 5:08:25 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 10, 2007 5:08:25 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://linuxDomain.site:5501/em <<<<<<<<<<<

How to create Oracle Enterprise manager repository in 10g R2

C:\>set oracle_sid=us

C:\>emctl status dbconsole

Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://standbyserver.samiindia.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
Logs are generated in directory D:\oracle\product\10.2.0\db_1/standbyserver.sami
india.com_us/sysman/log

C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://standbyserver.samiindia.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The requested service
has already been started.
More help is available by typing NET HELPMSG 2182.

C:\>emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Nov 21, 2007 5:55:10 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: us
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 21, 2007 5:55:27 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\US\emca_2007-11-21_05-55-10-PM.log.
Nov 21, 2007 5:55:28 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 21, 2007 5:55:49 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Nov 21, 2007 5:58:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 21, 2007 5:58:12 PM

C:\>emca -config dbcontrol db -repos create

STARTED EMCA at Nov 21, 2007 6:03:01 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: us
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 ................ D:\oracle\product\10.2.0\db_1
Database hostname ................ standbyserver.samiindia.com
Listener port number ................ 1521
Database SID ................ us
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 21, 2007 6:03:15 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\US\emca_2007-11-21_06-03-01-PM.log.
Nov 21, 2007 6:03:18 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 21, 2007 6:08:18 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 21, 2007 6:08:32 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 21, 2007 6:09:33 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 21, 2007 6:09:33 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://standbyserver.samiindia.com
:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 21, 2007 6:09:33 PM

Automatically start and stop the DB-Console

$ emctl start dbconsole
$ emctl stop dbconsole
$ emctl status dbconsole

oracle@linuxDomain:~> emctl status dbconsole
TZ set to Asia/Calcutta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://linuxDomain.site:5501/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.1.0/Db_1/linuxDomain.site_lamp/sysman/log


Try to connect to the database Control

http://urip:urportnumber/em