Tag Archives: Steps

How to create and drop the EMCA dbcontrol Oracle Enterprise Manager Service

Leave a reply

Create and Drop the EMCA DBcontrol Enterprise Manager Server

Drop the EMCA dbcontrol or OEM

1. First unlock the account sysman by login in the database

alter user sysman account unlock;

2. Set the oracle home and path environment variable.

SET ORACLE_HOME=C:\oracle\product\10.2.0\db_1
SET PATH=%ORACLE_HOME%\bin;%PATH%

3. Set the oracle sid environment variable.

SET ORACLE_SID=ORCL

4. Drop the existing OEM  or EMCA DBCONTROL Service

emca -deconfig  dbcontrol db -repos drop

OR

emca -deconfig dbcontrol db -repos drop -SYS_PWD xxx -SYSMAN_PWD xxx

STARTED EMCA at Jul 13, 2008 8:26:42 AM
EM Configuration Assistant, Version 11.1.0.5.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 SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y

Create the EMCA dbcontrol or OEM environment:

1. Set the Oracle Home variable

SET ORACLE_SID=ORCL
SET ORACLE_HOME=c:\oracle\product\10.2.0\db_1
SET PATH=%ORACLE_HOME%\bin;%PATH%

2. Start the command EMCA for creating the repository:

emca -config dbcontrol db -repos create

STARTED EMCA at Jul 13, 2008 8:28:48 AM
EM Configuration Assistant, Version 10.2.0.4.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:
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 ................ C:\oracler\product\10.2.0\db_1
LOCAL hostname ................ databaseserver
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