Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

emca - cannot drop dbconsole -repos db

Ratzie
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.

2 REPLIES

Re: emca - cannot drop dbconsole -repos db

Hi,

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

Regards,
Vadim
Ratzie
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

Replace
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