6 Replies Latest reply: Dec 8, 2012 3:12 PM by BhavinDave RSS

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

    BhavinDave
      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?
        • 1. Re: How to re-install Enterprise Manager for Oracle database 11gR2
          Akanksha Sheoran Kaler
          are you refering to Database control when you say Enterprise manager in your above post?
          • 3. Re: How to re-install Enterprise Manager for Oracle database 11gR2
            LaserSoft
            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
            • 4. Re: How to re-install Enterprise Manager for Oracle database 11gR2
              BhavinDave
              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
              • 5. Re: How to re-install Enterprise Manager for Oracle database 11gR2
                Rajesh Lathwal
                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
                • 6. Re: How to re-install Enterprise Manager for Oracle database 11gR2
                  BhavinDave
                  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