Create and Drop the EMCA dbcontrol Oracle Enterprise Manager Service

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.