1 Reply Latest reply on Aug 28, 2015 2:25 AM by Dude!

    problems configuring Enterprise Manager

    MichaelJordan

      I have a new 11g installation on RHEL 6, and ran the following command:

       

      emca -config dbcontrol db -repos create

       

      I received the following output:  ======================================================

      Aug 27, 2015 1:28:19 PM oracle.sysman.emcp.EMConfig perform

      INFO: This operation is being logged at /home/oracle/app/oracle/cfgtoollogs/emca/orcl/emca_2015_08_27_13_27_54.log.

      Aug 27, 2015 1:28:19 PM oracle.sysman.emcp.EMReposConfig createRepository

      INFO: Creating the EM repository (this may take a while) ...

      Aug 27, 2015 1:32:16 PM oracle.sysman.emcp.EMReposConfig invoke

      INFO: Repository successfully created

      Aug 27, 2015 1:32:18 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

      INFO: Uploading configuration data to EM repository (this may take a while) ...

      Aug 27, 2015 1:33:14 PM oracle.sysman.emcp.EMReposConfig invoke

      INFO: Uploaded configuration data successfully

      Aug 27, 2015 1:33:16 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

      INFO: Securing Database Control (this may take a while) ...

      Aug 27, 2015 1:33:17 PM oracle.sysman.emcp.util.PlatformInterface executeCommand

      WARNING: Error executing /home/oracle/app/oracle/product/11.2.0/bin/emctl config emkey -repos

      Aug 27, 2015 1:33:17 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

      WARNING: Configuring EM-Key failed.

      Aug 27, 2015 1:33:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

      WARNING: Error securing Database control.

      Aug 27, 2015 1:33:17 PM oracle.sysman.emcp.EMDBPostConfig setWarnMsg

      INFO: Error securing Database Control. Database Control has been brought-up in non-secure mode. To secure the Database Control execute the following command(s):

       

      1) Set the environment variable ORACLE_UNQNAME to Database unique name

      2) /home/oracle/app/oracle/product/11.2.0/bin/emctl stop dbconsole

      3) /home/oracle/app/oracle/product/11.2.0/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > 

      4) /home/oracle/app/oracle/product/11.2.0/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > 

      5) /home/oracle/app/oracle/product/11.2.0/bin/emctl start dbconsole

       

      To secure Em Key, run /home/oracle/app/oracle/product/11.2.0/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >

      Aug 27, 2015 1:33:17 PM oracle.sysman.emcp.util.DBControlUtil startOMS

      INFO: Starting Database Control (this may take a while) ...

      Aug 27, 2015 1:33:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

      INFO: Database Control started successfully

      Aug 27, 2015 1:33:27 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

      INFO: >>>>>>>>>>> The Database Control URL is http://x4170:1158/em <<<<<<<<<<<

       

      Error securing Database Control. Database Control has been brought-up in non-secure mode. To secure the Database Control execute the following command(s):

       

      1) Set the environment variable ORACLE_UNQNAME to Database unique name

      2) /home/oracle/app/oracle/product/11.2.0/bin/emctl stop dbconsole

      3) /home/oracle/app/oracle/product/11.2.0/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > 

      4) /home/oracle/app/oracle/product/11.2.0/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > 

      5) /home/oracle/app/oracle/product/11.2.0/bin/emctl start dbconsole

       

      To secure Em Key, run /home/oracle/app/oracle/product/11.2.0/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >

      =====================================================================

      I checked what unqname was set to and it looks correct:

      [oracle@oraclex4170 11.2.0]$ env | grep ORA

      ORACLE_UNQNAME=orcl

      ORACLE_SID=orcl

      ORACLE_BASE=/home/oracle/app/oracle

      ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0

       

      SQL> select name, db_unique_name from v$database;

       

      NAME      DB_UNIQUE_NAME

      --------- ------------------------------

      ORCL      orcl

      ==========================================================================

      I then tried the next 2 steps

      [oracle@oraclex4170 11.2.0]$ /home/oracle/app/oracle/product/11.2.0/bin/emctl stop dbconsole

      Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

      Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

      http://x4170:1158/em/console/aboutApplication

      Stopping Oracle Enterprise Manager 11g Database Control ...

      ...  Stopped.

       

      [oracle@oraclex4170 11.2.0]$ /home/oracle/app/oracle/product/11.2.0/bin/emctl config emkey -repos

      Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0

      Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

      Please enter repository password:

       

      Error occurred. Check the logs.

      =======================================================================

       

      can someone tell me where i can find this log?

       

      I checked the most recent emca_repos_config_*.log but found no errors.


      thanks,

      Michael

       

       

       

       

      :

        • 1. Re: problems configuring Enterprise Manager
          Dude!

          What was the actual problem you were initially trying to solve? Did you change the computer's hostname after installing Oracle database and ran into a problem similar like:

           

          OC4J Configuration issue. /u01/app/oracle/product/112/db/oc4j/j2ee/OC4J_DBConsole_host.domain_orcl not found.

           

          Instead of dropping and recreating the sysman repository, which you will usually find on the web, there was a much easier fix by simply creating a symbolic link. If your new hostname was localhost and your new hostname is for example vm01.example.com:

           

          $ ln -s localhost_orcl vm01.example.com_orcl
          $ ln -s OC4J_DBConsole_localhost_orcl OC4J_DBConsole_vm01.example.com_orcl
          
          

           

          This way the dbconsole port stays at TCP 1158, otherwise, when you drop and re-create the repository it will be 5500+

           

          To avoid the problem altogether, export the ORACLE_UNQNAME variable prior to running the database installer.

           

          Regarding your problem, have you tried to reset the sysman account:

           

          $ connect / as sysdba
          SQL> alter user sysman identified by 'oracle_4U' account unlock'
          
          

           

          Then enter the sysman password when prompted to enter the repository password.

           

          Btw, there is no more dbconsole in 12c anymore. The dbconsole is actually not Enterprise manager, but Database Control.