OEM not connecting to NEW repository - SOMEONE PLEASE HELP!

From: Edwinah63 <edwinah_at_customercare.com.au>
Date: 15 Aug 2005 13:27:23 -0700
Message-ID: <1124137643.102371.247800@g14g2000cwa.googlegroups.com>

i have used EMCA to drop my original repository "OEMREP" (after not being able to successfully rename it) - selecting to remove it in its entirety (not just repository only).

to my surprise, i found all the files, services etc associated with OEMREP still in existance. i had thought that all of these files would have been removed so i:

• removed all the physical files that i could find (dbf, spfile, pfile etc)
• removed all references to it in listner.ora, tnsnames.ora
• cleared out the win2k registry of as many references as i could find.
• created a new repository called OERW2K

when i started the gui OEM, i found i could log in standalone, but not log into the OMS.

looked at oms.nohup found that the OMS appears to be trying to connect to the old OEMREP:

 [main][2005-8-15:10:37:54:765] ORA-01017: invalid username/password; logon denied
:
..../...._at_jdbc:oracle:oci8:@(D­ESCRIPTION=(ADDRESS=(PROTOCOL=­TCP)(Host=ORACW2K)(Port=1521))­(CONNECT_DATA=(SID=OEMREP)))

 [main][2005-8-15:10:37:54:765] VdbSession.processError: invalid connect string
 [main][2005-8-15:10:38:4:796] VdbSession.processError: errorCode

>1017<

 [main][2005-8-15:10:38:4:796] VdbSession.processError: errorMsg

>ORA-01017: invalid username/password; logon denied

looked in omsconfig.properties:

#OMS Configuration Properties
#Mon Aug 15 11:14:01 GMT+10:00 2005

OEM.REPOSITORY.PASSWORD=e6f152­1c48f888ab
oem.BootHost=localhost
OEM.EMCA_SHOW_WELCOME_PAGE=tru­e
OEM.REPOSITORY.LAST_CREATED_SI­D=OEREPW2K
OEM.REPOSITORY.DATABASE=(DESCR­IPTION=(ADDRESS=(PROTOCOL=TCP)­(Host=ORACW2K)(Port=1521))(CON­NECT_DATA=(SID=OEREPW2K)))

oem.BootPort=7771

OEM.REPOSITORY.USER=OEMSYS
OEM.REPOSITORY.DATABASE_ORIG=O­RACW2K:1521:OEREPW2K what i have:

• oracle 9i patch set 5
• win2k
• the entire installation is a test only so i can trash the whole lot if i need to but would prefer not to since my gut feel is that i only have to change 1 or 2 small things to get it to work.
• references in listner and tnsnames to the new repository

what i need:

• what file or win registry key is the OMS using to read where it should connect?
• is there a utility i could use to repoint the repository?
• what can i do to change the OMS from pointing to OEMREP and point it to the new repository OERW2K?
• once pointing to the right repository, how i can set the sysman password if it is not already there?

someone please answer or at least refer me to someplace where i can find the answer myself. i've already googled around and can't find anything similar to my problem. all help gratefully received :)

Edwinah63 Received on Mon Aug 15 2005 - 15:27:23 CDT