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

Posted on 2007-10-10
Last Modified: 2013-12-19
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.
Question by:afcnoc
    LVL 29

    Accepted Solution


    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

    LVL 29

    Expert Comment


    PS: It will not affect any application schema.

    Author Comment

    I'll give it a try and let you know. May not get to it until tomorrow though.

    Author Comment

    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;

    Expert Comment

    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.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to recover a database from a user managed backup

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now