• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10491
  • Last Modified:

EM-dbconsole service will not start after hostname and ip change.

I have an Oracle 10g server. The hostname and IP address of the server were changed and now the dbconsole service will not start. I know this problem is related to the name/ip change but not sure how to fix it.
I have seen articles that say to run emca -x to drop and recreate the "repository" but I am not sure if this will effect the running database/schema. This is an online production server and can't be brought down at this time.
0
afcnoc
Asked:
afcnoc
  • 2
  • 2
1 Solution
 
MikeOM_DBACommented:

Try re-configuring the repository:

emca -config dbcontrol db -repos recreate

If that does not work, then drop/create new:

emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create

0
 
MikeOM_DBACommented:

PS: It will not affect any application schema.
0
 
afcnocAuthor Commented:
I'll give it a try and let you know. May not get to it until tomorrow though.
0
 
afcnocAuthor Commented:
Sorry it took so long to get back to this...I got pulled for another project.
The drop/create worked perfectly!!
To anyone else using this solution here are a couple of pointers.
Make sure you enter the SID correctly, it has to match the SID on the server including the case of the letters ( MySid is not the same as mysid).
Make sure you have the passwords for the following user accounts before starting;
SYS
SYSMAN
DBSNMP
0
 
SailajamkCommented:
Currently after the IP change - I updated the TNSNames.ora and Listener.ora. The console doesnot work. When I try the follwoing
1) conn sys@VRD as SYSDBA
I get connected to idle instance

2) Now when I run startup - the instance is getinng terminated forcefully.

Any solutions to this problem.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now