This discussion is archived
3 Replies Latest reply: Jan 21, 2013 9:26 PM by 986085 RSS

Unable to start EM (Enterprise Manager)

986085 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points