topic Re: emca - cannot drop dbconsole -repos db in Operating System - HP-UX

emca - cannot drop dbconsole -repos db

Ratzie — Wed, 25 Jun 2008 15:42:50 GMT

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

Vadim Loginov — Wed, 23 Jul 2008 07:58:16 GMT

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

Re: emca - cannot drop dbconsole -repos db

Ratzie — Wed, 23 Jul 2008 18:44:52 GMT

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