Create and Drop Oracle Enterprise Manager Console on Windows Server

Configure Oracle Enterprise Manager Console on Windows Server

1. Check the sysman user is present in the database.

select username from dba_users where username ='SYSMAN';

1.jpg

2. If exists command to drop existing setting otherwise go to step 4

emca -deconfig dbcontrol db -repos drop

2.jpg

3. After step 2 check the user sysman is dropped from database.

select username from dba_users where username ='SYSMAN';

3

4. Start configuring Enterprise manager repository

emca -repos create

4

5. Configure db control service

emca -config dbcontrol db

 
4

It’s failed due to user name is locked, So need to reset and unlock username for DBSNMP and SYSMAN.

5

6. Again start the db control command:

emca -config dbcontrol db

1.png

6
Installation is completed.

Step 7: check status of Enterprise manage tool as

emctl status dbconsole

Step 8: Start the enterprise manager tool

emctl start dbconsole

step 9: Stop the enterprise manager tool

emctl stop dbconsole

If you received following errors:
The OracleDBConsolePEGA service could not be started.
A service specific error occurred: 2.
More help is available by typing NET HELPMSG 3547.
 
Solution:
Then set the following parameters:

set oracle_home=
Set PATH=
set oracle_sid=
set oracle_hostname=localhost
set oracle_unqname=pega


Try to start the em console. Go to following link:
https://smarttechways.com/2014/09/25/environment-variable-oracle_unqname-not-defined-in-em-status/

emctl start dbconsole

Note: If it’s not started then set upper parameter and start from step 1 from reconfigure again.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s