Forum Stats

  • 3,839,188 Users
  • 2,262,461 Discussions
  • 7,900,888 Comments

Discussions

How to re-install Enterprise Manager for Oracle database 11gR2

Bhavin Dave-Oracle
Bhavin Dave-Oracle Member Posts: 11 Employee
edited Dec 8, 2012 4:12PM in Enterprise Manager
Hi,

I installed Oracle database 11gR2 on Windows 7 with 4 GB of physical memory and over 200 GB of free disk space. Just before the finish screen a warning indicated that Enterprise Manager could not be setup and asked me to execute a few commands through command-line to configure it.

Just as I executed the first command the antivirus installed on my laptop deleted a lot of files relating to Enterprise Manager as it detected threats from them. Currently the database works fine but I'm unable to figure out how to get the Enterprise Manager up.

Is there a way to re-install Enterprise Manager for the database already installed?

Answers

  • are you refering to Database control when you say Enterprise manager in your above post?
  • Bhavin Dave-Oracle
    Bhavin Dave-Oracle Member Posts: 11 Employee
  • LaserSoft
    LaserSoft Member Posts: 260 Silver Badge
    Hi Friend,


    To drop and recreate DBConsole configuration files and repository using a single command, run below EMCA command.
    This command will recreate the DBConsole configuration files and DBConsole repository for the Database.

    <ORACLE_HOME>/bin/emca -config dbcontrol db -repos recreate

    Enter the following information:
    Database SID: <sid>
    ----------------------------------------------------------------------
    WARNING : While repository is dropped the database will be put in quiesce mode.
    ----------------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: Y
    Listener port number: <Port>
    Password for SYS user:
    Password for DBSNMP user:
    Password for SYSMAN user:
    Email address for notifications (optional):
    Outgoing Mail (SMTP) server for notifications (optional):
    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]:Y


    Log Files will store in the below location :
    --------------------------------------------
    /home/oracle/app/oracle/cfgtoollogs/emca/orcl/emca_with_date.log

    Thanks
    LaserSoft
  • Bhavin Dave-Oracle
    Bhavin Dave-Oracle Member Posts: 11 Employee
    Hi LaserSoft,

    The antivirus has deleted many important files like the emca, emagent.exe etc.
    Hence the command-line is unable to recognize the emca command and proceed.

    Thanks.
    Bhavin Dave
  • Rajesh Lathwal
    Rajesh Lathwal Member Posts: 2,423
    It means ORACLE_HOME files are missing , please restore the files if you have a backup .

    Or reinstall oracle in new home and move your existing database to new home and then retry.

    Regards
    Rajesh
  • Bhavin Dave-Oracle
    Bhavin Dave-Oracle Member Posts: 11 Employee
    Hi Rajesh,

    I did a fresh installation after deinstalling the previously created database. The Database Configuration Assistant was unable to setup Enterprise Manager once again.

    On following the steps mentioned above by LaserSoft I got the following output :

    e:\app\Bhavin\product\11.2.0\dbhome_1\BIN>emca -config dbcontrol db -repos recreate

    STARTED EMCA at Dec 9, 2012 2:17:51 AM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: ocp11g
    Listener port number: 1521
    Listener ORACLE_HOME [ E:\app\Bhavin\product\11.2.0\dbhome_1 ]: y
    Password for SYS user:
    Password for DBSNMP user:
    Password for SYSMAN user:
    Password for SYSMAN user: Email address for notifications (optional):
    Outgoing Mail (SMTP) server for notifications (optional):
    -----------------------------------------------------------------

    You have specified the following settings

    Database ORACLE_HOME ................ E:\app\Bhavin\product\11.2.0\dbhome_1

    Local hostname ................ Bhavin-PC
    Listener ORACLE_HOME ................ y
    Listener port number ................ 1521
    Database SID ................ ocp11g
    Email address for notifications ...............
    Outgoing Mail (SMTP) server for notifications ...............

    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: y
    Dec 9, 2012 2:18:16 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at E:\app\Bhavin\cfgtoollogs\emca\ocp11g\em
    ca_2012_12_09_02_17_51.log.
    Dec 9, 2012 2:18:28 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Listener is not up or database service is not registered with it. Start
    the Listener and register database service and run EM Configuration Assistant ag
    ain .
    Refer to the log file at E:\app\Bhavin\cfgtoollogs\emca\ocp11g\emca_2012_12_09_0
    2_17_51.log for more details.
    Could not complete the configuration. Refer to the log file at E:\app\Bhavin\cfg
    toollogs\emca\ocp11g\emca_2012_12_09_02_17_51.log for more details.

    --------------------------------------------------
    LISTENER.ORA
    --------------------------------------------------
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = E:\app\Bhavin\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Bhavin\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    ADR_BASE_LISTENER = E:\app\Bhavin

    ------------------------------------------------------
    TNSNAMES.ORA
    ------------------------------------------------------
    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )

    OCP11G =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = ocp11g)
    )
    )

    LISTENER_OCP11G =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Also I'm able to tnsping and lsnrctl.exe states the listener LISTENER as started.

    e:\app\Bhavin\product\11.2.0\dbhome_1\BIN>tnsping ocp11g

    TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 09-DEC-2
    012 02:34:46

    Copyright (c) 1997, 2010, Oracle. All rights reserved.

    Used parameter files:
    E:\app\Bhavin\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
    t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ocp11g)))
    OK (0 msec)

    e:\app\Bhavin\product\11.2.0\dbhome_1\BIN>lsnrctl start listener

    LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 09-DEC-2012 02:35
    :46

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    TNS-01106: Listener using listener name LISTENER has already been started
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Thanks.
    Bhavin Dave
This discussion has been closed.