13 Replies Latest reply: Nov 19, 2013 3:44 AM by Aamir0731 RSS

    EM Configuration problem, emom.properties

    Aamir0731

      Hi,

       

      I am trying to configure Enterprise manager using Oracle 11g on win 7

      I have created the repository successfully.

      On using

      emca -config dbcontrol db


      I getting error in logs I am pasting the last parts here...

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

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.EMReposConfig invoke

      INFO: Uploaded configuration data successfully

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.ParamsManager getParam

      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.EMDBCConfig updateEmomsProps

      CONFIG: Updating file D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties ...

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.ParamsManager getParam

      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.util.FileUtil _deleteFile

      CONFIG: Deleting file D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.util.FileUtil copyFile

      CONFIG: exception caught in copyFile:

      oracle.sysman.emcp.exception.FileUtilException: Copying file D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca to D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties

        at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)

        at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)

        at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)

        at oracle.sysman.emcp.EMDBCConfig.updateEmomsProps(EMDBCConfig.java:926)

        at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:408)

        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:590)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

      Caused by: java.io.FileNotFoundException: D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties (Access is denied)

        at java.io.FileOutputStream.open(Native Method)

        at java.io.FileOutputStream.<init>(FileOutputStream.java:179)

        at java.io.FileOutputStream.<init>(FileOutputStream.java:131)

        at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)

        ... 11 more

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.EMDBCConfig updateEmomsProps

      CONFIG: Copying file D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca to D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.EMConfig perform

      SEVERE: Error updating D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties

      Refer to the log file at D:\app\IST-85\cfgtoollogs\emca\orcl\emca_2013_11_11_20_58_39.log for more details.

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.EMConfig perform

      CONFIG: Stack Trace:

      oracle.sysman.emcp.exception.EMConfigException: Error updating D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties

        at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:413)

        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:590)

        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

      Nov 11, 2013 9:07:16 PM oracle.sysman.emcp.EMConfig restoreOuiLoc

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\IST-85\product\11.2.0\dbhome_1\oui

       

      Please have a look on it and let me know where I did mistake.

      Thanks,

      Aamir.

        • 1. Re: EM Configuration problem, emom.properties
          Anar Godjaev

          Hi,

          Please check below link:

          DBA-Village

          Thank you

          • 2. Re: EM Configuration problem, emom.properties
            mkathirv

            Error, Caused by: java.io.FileNotFoundException: D:\app\IST-85\product\11.2.0\dbhome_1\sysman\config\emoms.properties (Access is denied)

            Looks like windows administrator is either newly added or doesn't have privileges to execute emctl -config dbcontrol db command.
            Windows machine has to be rebooted if OS accounts were changed. Once done, the try executing the same command.

            • 3. Re: EM Configuration problem, emom.properties
              Aamir0731

              Thank you sir for the reply,

              I have tried the same, but getting same error again. And yes I have got a new system and I am already logged as a administrator. If still I need some privileges to execute emctl, please let me know how to perform it.

              Thank you.

              • 4. Re: EM Configuration problem, emom.properties
                Rahul-Em-Oracle

                Hi Aamir,

                 

                Do the following

                1. Click on Windows start menu => All programs => Accessories => Right click on "Command Prompt" => Run as administrator

                2. Click Yes when prompt

                3. set ORACLE_HOME=D:\app\IST-85\product\11.2.0\dbhome_1

                4. set ORACLE_SID=<DB_SID>

                5. %ORACLE_HOME%/bin/emca -config dbcontrol db

                 

                Regards,
                Rahul

                • 5. Re: EM Configuration problem, emom.properties
                  Aamir0731

                  Thank you Rahul sir,

                   

                  I have done the same and it worked for that emoms.properties problem...

                  but now i am getting a new exception from the log-

                  Nov 16, 2013 1:59:48 PM oracle.sysman.emcp.util.FileUtil setAttributeInXML

                  SEVERE: Error parsing XML file D:\app\IST-85\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml

                  Nov 16, 2013 1:59:48 PM oracle.sysman.emcp.util.FileUtil setAttributeInXML

                  CONFIG: Stack Trace:

                  java.io.FileNotFoundException: D:\app\IST-85\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml (The system cannot find the file specified)

                    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:992)

                    at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:423)

                    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:590)

                    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

                    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

                    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

                  Nov 16, 2013 1:59:48 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles

                  CONFIG: Failed to set value in server.xml for application-server tag

                  Nov 16, 2013 1:59:48 PM oracle.sysman.emcp.EMConfig perform

                  SEVERE: Error instantiating OC4J configuration files

                  Refer to the log file at D:\app\IST-85\cfgtoollogs\emca\orcl\emca_2013_11_16_13_56_45.log for more details.

                  Nov 16, 2013 1:59:48 PM 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:427)

                    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:590)

                    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

                    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

                    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

                  Nov 16, 2013 1:59:48 PM oracle.sysman.emcp.EMConfig restoreOuiLoc

                  CONFIG: Restoring oracle.installer.oui_loc to D:\app\IST-85\product\11.2.0\dbhome_1\oui

                   

                  I checked that location there was no server.xml file...

                  Please let me know how i can get that?

                  or what i am missing..

                  Thank you

                  • 6. Re: EM Configuration problem, emom.properties
                    mkathirv

                    Make sure the the OS user has administrator privileges and can control the windows services.

                     

                    1. Open the CMD prompt as administrator (locate the cmd in start menu, right click => run as administrator)

                    2. Then run emca commands

                    %ORACLE_HOME%/bin/emca -deconfig dbcontrol db -repos drop
                    %ORACLE_HOME%/bin/emca -config dbcontrol db -repos create

                    • 7. Re: EM Configuration problem, emom.properties
                      Rahul-Em-Oracle

                      Hi Aamir,

                       

                      This problem is occurring because the file <OH>/oc4j/j2ee/OC4J_DBConsole/config/server.xml is missing

                      Do you have the filesystem backup for the this file , if yes then you can try restoring this file and try re-running the emca command

                      If you don;t have a file system backup then

                      Install the EM components from the database software CD

                      A. Launch the 11G installer.

                      B. Set the destination to your 11g database Oracle home.

                      C. Choose 'custom' installation and check the option "Oracle Enterprise Manager 11g Database Control 11.x.x"

                      D. After the DB Control component is installed, re-run the emca tool.

                      i.e

                      1. Click on Windows start menu => All programs => Accessories => Right click on "Command Prompt" => Run as administrator

                      2. Click Yes when prompt

                      3. set ORACLE_HOME=D:\app\IST-85\product\11.2.0\dbhome_1

                      4. set ORACLE_SID=<DB_SID>

                      5. %ORACLE_HOME%/bin/emca -config dbcontrol db

                       

                      Ref

                      Creating DBConsole via EMCA Fails With Error "SEVERE: Error parsing XML file" for server.xml (Doc ID 394081.1)

                       

                      Regards,

                      Rahul

                      • 8. Re: EM Configuration problem, emom.properties
                        Aamir0731

                        Hii Rahul Sir,

                         

                        I tried to configure 11g using DBCA.... and i got the error -

                        EM configuration failed due to following reason -

                        refer to log cfgtoollogs\dbca\emconfig.log for more details.

                         

                        And the LOG says -

                        CONFIG: No value was set for the parameter ORACLE_HOSTNAME.

                        Nov 18, 2013 12:45:30 PM oracle.sysman.emcp.util.FileUtil setAttributeInXML

                        SEVERE: Error parsing XML file D:\app\IST-85\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml

                        Nov 18, 2013 12:45:30 PM oracle.sysman.emcp.util.FileUtil setAttributeInXML

                        CONFIG: Stack Trace:

                        java.io.FileNotFoundException: D:\app\IST-85\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml (The system cannot find the file specified)

                          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:992)

                          at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:423)

                          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.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)

                          at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)

                          at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

                          at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)

                          at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)

                          at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

                          at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)

                          at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)

                          at java.lang.Thread.run(Thread.java:595)

                        Nov 18, 2013 12:45:30 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles

                        CONFIG: Failed to set value in server.xml for application-server tag

                        Nov 18, 2013 12:45:30 PM oracle.sysman.emcp.EMConfig perform

                        SEVERE: Error instantiating OC4J configuration files

                        Refer to the log file at D:\app\IST-85\cfgtoollogs\dbca\orcl\emConfig.log for more details.

                        Nov 18, 2013 12:45:30 PM 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:427)

                          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.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)

                          at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)

                          at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

                          at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)

                          at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)

                          at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

                          at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)

                          at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)

                          at java.lang.Thread.run(Thread.java:595)

                         

                        Now I remember when I installed 11g in my system, I got the same message at that time... but I ignored that because all I wanted to install 11g at that time......

                         

                        What should I do now?

                        And Thank you very much for your time sir.

                        • 9. Re: EM Configuration problem, emom.properties
                          mkathirv

                          Did you try my steps provided above?

                          • 10. Re: EM Configuration problem, emom.properties
                            EricvdS

                            Before installing the database (software) you did check (see  Oracle Database Preinstallation Requirements ) the Host Name Resolution?

                            Is your c:\system32\drivers\etc\hosts file like it should?

                             

                            Eric

                            • 11. Re: EM Configuration problem, emom.properties
                              Aamir0731

                              Yes mkathirv sir,

                               

                              I have followed your steps too... I tried as administrator and that problem of emoms.properties was solved but now getting this above problem....

                              I think I did some mistakes during installation....

                              • 12. Re: EM Configuration problem, emom.properties
                                Aamir0731

                                Hi Eric,

                                 

                                yes i had created loopback adapter before installation, what else i left?

                                • 13. Re: EM Configuration problem, emom.properties
                                  Aamir0731

                                  Thank you all...

                                  After all this process.... I have found out that all this problem was coming because of wrong installation.

                                  Now I have installed Oracle with new setup.

                                  But I want to thank you all to find the root problem, and I also learned some new things.

                                  Now  I am marking this thread as answered.

                                  Will post more stuff soon

                                  bye