3 Replies Latest reply: Jan 21, 2013 11:26 PM by 986085 RSS

    Unable to start EM (Enterprise Manager)

    986085
      Hi,

      Need your assistance in checking this error.
      I am using oracle version 11 Release 2 Patch 3.
      Below is the error encountered after trying to create the database console.
      Due the this, I was not able to startup the EM.

      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
      Jan 21, 2013 1:29:54 PM oracle.sysman.emcp.util.FileUtil setAttributeInXML
      SEVERE: Error parsing XML file /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml
      Jan 21, 2013 1:29:54 PM oracle.sysman.emcp.util.FileUtil setAttributeInXML
      CONFIG: Stack Trace:
      java.io.FileNotFoundException: /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml (No such file or directory)

      I already deconfig and recreate the database console but to no avail.
      ORACLE_HOME, ORACLE_SID, ORACLE_HOSTNAME are defined properly.

      [ora11g2@sharedservice-admin-crms centraldb]$ echo $ORACLE_HOSTNAME
      sharedservice-admin-crms
      [ora11g2@sharedservice-admin-crms centraldb]$

      Hostname is already declared in /etc/hosts.
      ORACLE_SID is also declared in tnsnames.ora.

      [ora11g2@sharedservice-admin-crms centraldb]$ tnsping centraldb

      TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 21-JAN-2013 14:28:54

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

      Used parameter files:


      Used TNSNAMES adapter to resolve the alias
      )SERVICE_NAME=centraldb.shi.com.ph)
      OK (10 msec)

      Appreciate immediate response.
      Thank you!
        • 1. Re: Unable to start EM (Enterprise Manager)
          Rajesh Lathwal
          Please share the error details received while configuring dbconsole ?

          Also please check EMCA troubleshooting tips:

          http://docs.oracle.com/cd/E11882_01/server.112/e17120/dbcontrol006.htm#CHDIACJG

          Thanks
          Rajesh
          • 2. Re: Unable to start EM (Enterprise Manager)
            986085
            Hi,

            Thanks for your immediate response.
            I tried it again following the directions in http://docs.oracle.com/cd/E11882_01/server.112/e17120/dbcontrol006.htm#CHDIACJG.
            See results below:

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

            [ora11g2@sharedservice-admin-crms ~]$ hostname
            sharedservice-admin-crms
            [ora11g2@sharedservice-admin-crms ~]$ echo $ORACLE_HOSTNAME
            sharedservice-admin-crms
            [ora11g2@sharedservice-admin-crms ~]$ echo $ORACLE_SID
            centraldb
            [ora11g2@sharedservice-admin-crms ~]$ echo $ORACLE_HOME
            /u01/app/ora11g2/product/11.2.0/dbhome_1
            [ora11g2@sharedservice-admin-crms ~]$

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

            [ora11g2@sharedservice-admin-crms ~]$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db

            STARTED EMCA at Jan 22, 2013 9:16:01 AM
            EM Configuration Assistant, Version 11.2.0.3.0 Production
            Copyright (c) 2003, 2011, Oracle. All rights reserved.

            Enter the following information:
            Database SID: centraldb

            Do you wish to continue? [yes(Y)/no(N)]: Y
            Jan 22, 2013 9:16:15 AM oracle.sysman.emcp.EMConfig perform
            INFO: This operation is being logged at /u02/DATAFILE/cfgtoollogs/emca/centraldb/emca_2013_01_22_09_16_00.log.
            Jan 22, 2013 9:16:15 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
            WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
            1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
            2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
            Enterprise Manager configuration completed successfully
            FINISHED EMCA at Jan 22, 2013 9:16:15 AM

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

            [ora11g2@sharedservice-admin-crms ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

            STARTED EMCA at Jan 22, 2013 9:18:20 AM
            EM Configuration Assistant, Version 11.2.0.3.0 Production
            Copyright (c) 2003, 2011, Oracle. All rights reserved.

            Enter the following information:
            Database SID: centraldb
            Listener port number: 1521
            Listener ORACLE_HOME [ /u01/app/ora11g2/product/11.2.0/dbhome_1 ]:
            Password for SYS user:
            Password for DBSNMP 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 ................ /u01/app/ora11g2/product/11.2.0/dbhome_1

            Local hostname ................ sharedservice-admin-crms
            Listener ORACLE_HOME ................ /u01/app/ora11g2/product/11.2.0/dbhome_1
            Listener port number ................ 1521
            Database SID ................ centraldb
            Email address for notifications ...............
            Outgoing Mail (SMTP) server for notifications ...............

            -----------------------------------------------------------------
            ----------------------------------------------------------------------
            WARNING : While repository is dropped the database will be put in quiesce mode.
            ----------------------------------------------------------------------
            Do you wish to continue? [yes(Y)/no(N)]: Y
            Jan 22, 2013 9:19:19 AM oracle.sysman.emcp.EMConfig perform
            INFO: This operation is being logged at /u02/DATAFILE/cfgtoollogs/emca/centraldb/emca_2013_01_22_09_18_19.log.
            Jan 22, 2013 9:19:22 AM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Dropping the EM repository (this may take a while) ...
            Jan 22, 2013 9:21:21 AM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Repository successfully dropped
            Jan 22, 2013 9:21:23 AM oracle.sysman.emcp.EMReposConfig createRepository
            INFO: Creating the EM repository (this may take a while) ...
            Jan 22, 2013 9:29:30 AM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Repository successfully created
            Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
            INFO: Uploading configuration data to EM repository (this may take a while) ...
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Uploaded configuration data successfully
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil setAttributeInXML
            SEVERE: Error parsing XML file /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig perform
            SEVERE: Error instantiating OC4J configuration files
            Refer to the log file at /u02/DATAFILE/cfgtoollogs/emca/centraldb/emca_2013_01_22_09_18_19.log for more details.
            Could not complete the configuration. Refer to the log file at /u02/DATAFILE/cfgtoollogs/emca/centraldb/emca_2013_01_22_09_18_19.log for more details.


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

            Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sharedservice-admin-crms)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ce
            ntraldb.shi.com.ph))) in home /u01/app/ora11g2/product/11.2.0/dbhome_1 with user "SYS" role "SYSDBA".
            connected to database.
            sql to execute declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_
            view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_sta
            tus like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.
            set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified
            by ' || view_user_pwd || ''; END IF; end;
            noOfParams to bind: 1.
            sql execute successfully.

            Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
            CONFIG: Unlocked mgmt_view account
            Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig invoke
            CONFIG: Successfully unlocked mgmt_view account
            Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
            INFO: Uploading configuration data to EM repository (this may take a while) ...
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Uploaded configuration data successfully
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMDBCConfig updateEmomsProps
            CONFIG: Updating file /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.properties ...
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.ParamsManager getParam
            CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil _copyFile
            CONFIG: Copying file /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.properties.emca to /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.proper
            ties

            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil _copyFile
            CONFIG: Copying file /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.properties.emca.util.tmp to /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emo
            ms.properties
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.ParamsManager getParam
            CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil setAttributeInXML
            SEVERE: Error parsing XML file /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil setAttributeInXML
            CONFIG: Stack Trace:
            java.io.FileNotFoundException: /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml (No such file or directory)
            at java.io.FileInputStream.open(Native Method)
            at java.io.FileInputStream.<init>(FileInputStream.java:106)
            at java.io.FileInputStream.<init>(FileInputStream.java:66)
            at java.io.FileReader.<init>(FileReader.java:41)
            at oracle.sysman.emcp.util.FileUtil.setAttributeInXML(FileUtil.java:1065)
            at oracle.sysman.emcp.EMDBCConfig.instantiateOC4JConfigFiles(EMDBCConfig.java:1000)
            at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:431)
            at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:174)
            at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:144)
            at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:255)
            at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
            CONFIG: Failed to set value in server.xml for application-server tag
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig perform
            SEVERE: Error instantiating OC4J configuration files
            Refer to the log file at /u02/DATAFILE/cfgtoollogs/emca/centraldb/emca_2013_01_22_09_18_19.log for more details.
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig perform
            CONFIG: Stack Trace:
            oracle.sysman.emcp.exception.EMConfigException: Error instantiating OC4J configuration files
            at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:435)
            at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:174)
            at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:144)
            at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:255)
            at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
            Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
            CONFIG: Restoring oracle.installer.oui_loc to /u01/app/ora11g2/product/11.2.0/dbhome_1/oui

            Edited by: user9930023 on Jan 21, 2013 9:27 PM
            • 3. Re: Unable to start EM (Enterprise Manager)
              986085
              Here's the complete error details:

              Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sharedservice-admin-crms)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ce
              ntraldb.shi.com.ph))) in home /u01/app/ora11g2/product/11.2.0/dbhome_1 with user "SYS" role "SYSDBA".
              connected to database.
              sql to execute declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_
              view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_sta
              tus like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.
              set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified
              by ' || view_user_pwd || ''; END IF; end;
              noOfParams to bind: 1.
              sql execute successfully.

              Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
              CONFIG: Unlocked mgmt_view account
              Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig invoke
              CONFIG: Successfully unlocked mgmt_view account
              Jan 22, 2013 9:29:38 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
              INFO: Uploading configuration data to EM repository (this may take a while) ...
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Uploaded configuration data successfully
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMDBCConfig updateEmomsProps
              CONFIG: Updating file /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.properties ...
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.properties.emca to /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.proper
              ties

              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emoms.properties.emca.util.tmp to /u01/app/ora11g2/product/11.2.0/dbhome_1/sysman/config/emo
              ms.properties
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil setAttributeInXML
              SEVERE: Error parsing XML file /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.util.FileUtil setAttributeInXML
              CONFIG: Stack Trace:
              java.io.FileNotFoundException: /u01/app/ora11g2/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole/config/server.xml (No such file or directory)
              at java.io.FileInputStream.open(Native Method)
              at java.io.FileInputStream.<init>(FileInputStream.java:106)
              at java.io.FileInputStream.<init>(FileInputStream.java:66)
              at java.io.FileReader.<init>(FileReader.java:41)
              at oracle.sysman.emcp.util.FileUtil.setAttributeInXML(FileUtil.java:1065)
              at oracle.sysman.emcp.EMDBCConfig.instantiateOC4JConfigFiles(EMDBCConfig.java:1000)
              at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:431)
              at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:174)
              at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:144)
              at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:255)
              at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
              at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
              at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
              at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
              CONFIG: Failed to set value in server.xml for application-server tag
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig perform
              SEVERE: Error instantiating OC4J configuration files
              Refer to the log file at /u02/DATAFILE/cfgtoollogs/emca/centraldb/emca_2013_01_22_09_18_19.log for more details.
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig perform
              CONFIG: Stack Trace:
              oracle.sysman.emcp.exception.EMConfigException: Error instantiating OC4J configuration files
              at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:435)
              at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:174)
              at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:144)
              at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:255)
              at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
              at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
              at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
              at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
              Jan 22, 2013 9:31:58 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to /u01/app/ora11g2/product/11.2.0/dbhome_1/oui