Showing results for 
Search instead for 
Did you mean: 

emca - cannot drop dbconsole -repos db

Super Advisor

emca - cannot drop dbconsole -repos db

I ran emca and successfully installed the OEM.
It pulled the wrong hostname that the listener is running on.
So, I can start it:
emca start dbconsole

But can not connect to the database.
So, I thought blow it away...

I cannot do:
emca -deconfig dbcontrol db -repos drop

SEVERE: Error dropping the repository
ORA-12541: TNS:no listener

The thing is the listener is right. OEM is wrong.
So how do I blow it away?
Of what is the syntax to change the Database hostname?

We put the data traffic and listener on a separate vlan.


Re: emca - cannot drop dbconsole -repos db


Maybe the command below will help you to resolve your issue:

emca -config dbcontrol db -repos recreate

It recreates configuration files and repository for DB console

Super Advisor

Re: emca - cannot drop dbconsole -repos db

I had to submit a service request with oracle:

To drop your misconfigured repository

1. Log in to the DB host

2. Set ORACLE_SID to your database SID and ORACLE_HOME to your database home

3. cd $ORACLE_HOME/sysman/admin/emdrep/bin

4. Run the following command:

./RepManager HHHH NNNN SSSS -sys_password PPPP -action drop

HHHH with the hostname where your listener is running
NNNN with the listener port number
SSSS with your database SID
PPPP with the password for the SYS user
When prompted 'Enter repository user name:', enter SYSMAN
When prompted 'Enter repository user password:', enter the password for the SYSMAN user