1 2 3 4 Previous Next 59 Replies Latest reply: Apr 14, 2010 2:32 AM by 725039 Go to original post RSS
      • 15. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
        725039
        Can you please how us first few lines of /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log?

        Regards,
        Phiri
        • 16. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
          guruparan
          <pre>
          [oracle@oel ~]$ wc /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log
          573 4050 39934 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log
          </pre>

          So, the first 30 lines.

          <pre>
          [oracle@oel ~]$ head -30 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log
          Apr 14, 2010 1:12:56 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
          CONFIG: Setting oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
          CONFIG: isHAInstalled: false
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag '-migrate' set to false
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'migrateFromDBControl' set to false
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'migrateToCentralAgent' set to false
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'migrateFromCentralAgent' set to false
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'migrateToDBControl' set to false
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag '-config' set to true
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'UPDATE_EMAIL' set to true
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'dbcontrol' set to true
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'db' set to true
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'create' set to true
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setFlag
          CONFIG: Flag 'drop' set to true
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.ParamsManager setParam
          CONFIG: Setting param: ORACLE_HOME value: /u01/app/oracle/product/11.2.0/db_1
          Apr 14, 2010 1:12:57 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
          CONFIG: isCRSInstalled: false
          </pre>

          Last 20 lines here

          <pre>
          [oracle@oel ~]$ tail /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log
          at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:203)
          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
          at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
          at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
          at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
          at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
          at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
          Apr 14, 2010 1:13:51 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
          CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
          [oracle@oel ~]$ tail -20 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log
          at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
          at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
          at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
          at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
          Apr 14, 2010 1:13:51 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 again .
          Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_12_56.log for more details.
          Apr 14, 2010 1:13:51 AM oracle.sysman.emcp.EMConfig perform
          CONFIG: Stack Trace:
          oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
          at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:203)
          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
          at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
          at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
          at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
          at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
          at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
          Apr 14, 2010 1:13:51 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
          CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
          </pre>
          • 17. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
            725039
            >
            oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .

            Apr 14, 2010 1:13:51 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 again .

            >

            Please check if Listener has been started on guest OS (VMware).
            lsnrctl status
            If not started, please start Listener.
            lsnrctl start
            Then recreate DB Control.
            emca -config dbcontrol db -repos recreate
            Regards,
            Phiri
            • 18. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
              guruparan
              <pre>
              [oracle@oel ~]$ lsnrctl start

              LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-APR-2010 01:37:30

              Copyright (c) 1991, 2009, Oracle. All rights reserved.

              Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

              TNSLSNR for Linux: Version 11.2.0.1.0 - Production
              System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
              Log messages written to /u01/app/oracle/diag/tnslsnr/oel/listener/alert/log.xml
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
              Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11gr2.localdomain)(PORT=1521)))
              TNS-12545: Connect failed because target host or object does not exist
              TNS-12560: TNS:protocol adapter error
              TNS-00515: Connect failed because target host or object does not exist
              Linux Error: 111: Connection refused

              Listener failed to start. See the error message(s) above...
              </pre>

              The hostname is wrong. See below.

              <pre>
              [oracle@oel ~]$ hostname
              oel.localdomain
              </pre>

              I corrected it to oel.localdomain.

              <pre>
              [oracle@oel ~]$ vi /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
              [oracle@oel ~]$ lsnrctl start

              LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-APR-2010 01:38:41

              Copyright (c) 1991, 2009, Oracle. All rights reserved.

              Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

              TNSLSNR for Linux: Version 11.2.0.1.0 - Production
              System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
              Log messages written to /u01/app/oracle/diag/tnslsnr/oel/listener/alert/log.xml
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel.localdomain)(PORT=1521)))

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
              Start Date 14-APR-2010 01:38:41
              Uptime 0 days 0 hr. 0 min. 1 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
              Listener Log File /u01/app/oracle/diag/tnslsnr/oel/listener/alert/log.xml
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel.localdomain)(PORT=1521)))
              The listener supports no services
              The command completed successfully
              </pre>

              Now, going to try recreate DB. :)
              • 19. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                725039
                Very well then. It should work just fine now.... any luck with Oracle SQL Developer now? It should work now.

                Regards,
                Phiri
                • 20. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                  guruparan
                  Almost the same error, I guess.

                  <pre>
                  [oracle@oel ~]$ emca -config dbcontrol db -repos recreate

                  STARTED EMCA at Apr 14, 2010 1:42:00 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: DB11G
                  log4j:ERROR No appenders could be found for category (emSDK.config).
                  log4j:ERROR Please initialize the log4j system properly.
                  Listener port number: 1521
                  Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_1 ]:
                  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 ................ /u01/app/oracle/product/11.2.0/db_1

                  Local hostname ................ oel5-11gr2.localdomain
                  Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
                  Listener port number ................ 1521
                  Database SID ................ DB11G
                  Email address for notifications ...............
                  Outgoing Mail (SMTP) server for notifications ...............

                  -----------------------------------------------------------------
                  Do you wish to continue? [yes(Y)/no(N)]: y
                  Apr 14, 2010 1:42:36 AM oracle.sysman.emcp.EMConfig perform
                  INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_41_59.log.
                  Apr 14, 2010 1:42:37 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
                  WARNING: Error initializing SQL connection. SQL operations cannot be performed
                  Apr 14, 2010 1:42:37 AM oracle.sysman.emcp.EMReposConfig invoke
                  INFO: Dropping the EM repository (this may take a while) ...
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                  WARNING: Error executing /u01/app/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11gr2.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.localdomain))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_drop_2010_04_14_01_42_37.log
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMReposConfig invoke
                  SEVERE: Error dropping the repository
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMReposConfig invoke
                  INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_drop_<date>.log for more details.
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMConfig perform
                  SEVERE: Error dropping the repository
                  Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_41_59.log for more details.
                  Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_41_59.log for more details.

                  </pre>

                  The messages from log.

                  <pre>
                  [oracle@oel ~]$ head -30 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_41_59.log
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
                  CONFIG: Setting oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
                  CONFIG: isHAInstalled: false
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag '-migrate' set to false
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'migrateFromDBControl' set to false
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'migrateToCentralAgent' set to false
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'migrateFromCentralAgent' set to false
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'migrateToDBControl' set to false
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag '-config' set to true
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'UPDATE_EMAIL' set to true
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'dbcontrol' set to true
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'db' set to true
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'create' set to true
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setFlag
                  CONFIG: Flag 'drop' set to true
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.ParamsManager setParam
                  CONFIG: Setting param: ORACLE_HOME value: /u01/app/oracle/product/11.2.0/db_1
                  Apr 14, 2010 1:42:00 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                  CONFIG: isCRSInstalled: false
                  </pre>

                  Last 20 lines

                  <pre>
                  [oracle@oel ~]$ tail -20 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_41_59.log
                  WARNING: Error executing /u01/app/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11gr2.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.localdomain))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_drop_2010_04_14_01_42_37.log
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMReposConfig invoke
                  SEVERE: Error dropping the repository
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMReposConfig invoke
                  INFO: Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_drop_<date>.log for more details.
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMConfig perform
                  SEVERE: Error dropping the repository
                  Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_01_41_59.log for more details.
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMConfig perform
                  CONFIG: Stack Trace:
                  oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
                  at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
                  at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
                  at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                  at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
                  at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                  at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                  at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                  Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
                  CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
                  </pre>

                  Any idea :(
                  • 21. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                    guruparan
                    Yes. You are right!

                    Now, since listener is up, I can connect via Oracle SQL Developer. Great. Two issues are resolved. Got to get this Enterprise Manager right. :)
                    • 22. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                      725039
                      >
                      INFO: Dropping the EM repository (this may take a while) ...

                      Apr 14, 2010 1:42:38 AM oracle.sysman.emcp.util.PlatformInterface executeCommand

                      WARNING: Error executing /u01/app/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11gr2.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.localdomain))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/cfgtoollogs/emca/orcl/emca_repos_drop_2010_04_14_01_42_37.log
                      >

                      Almost there; notice the *(HOST=oel5-11gr2.localdomain)*

                      Show us the entries in emoms.properties file
                      cat $ORACLE_HOME/sysman/config/emoms.properties
                      Regards,
                      Phiri
                      • 23. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                        guruparan
                        <pre>
                        [oracle@oel ~]$ cat $ORACLE_HOME/sysman/config/emoms.properties
                        # OMS login information
                        oracle.sysman.eml.mntr.emdRepSID=%EM_REPOS_SID%
                        oracle.sysman.eml.mntr.emdRepPwdEncrypted=false
                        oracle.sysman.eml.mntr.emdRepPwdSeed=doesntmatter
                        oracle.sysman.eml.mntr.emdRepPort=%EM_REPOS_PORT%
                        oracle.sysman.eml.mntr.emdRepUser=%EM_REPOS_USER%
                        oracle.sysman.eml.mntr.emdRepPwd=%EM_REPOS_PWD%
                        oracle.sysman.eml.mntr.emdRepServer=%EM_REPOS_HOST%
                        oracle.sysman.eml.mntr.emdRepConnectDescriptor=%EM_REPOS_CONNECTDESCRIPTOR%

                        # From the old web.xml file
                        oracle.sysman.emSDK.svlt.ConsoleServerHost=%HOSTNAME%
                        oracle.sysman.emSDK.svlt.ConsoleServerPort=%EM_UPLOAD_PORT%
                        # The https port dedicated to the receiver servlet using an EM Certificate
                        oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=%EM_UPLOAD_HTTPS_PORT%
                        oracle.sysman.emSDK.svlt.ConsoleServerName=%HOSTNAME%:%EM_UPLOAD_PORT%_Management_Service

                        %SET_CONSOLE_MODE%oracle.sysman.emSDK.svlt.ConsoleMode=%CONSOLE_MODE%
                        %USE_DB_CONSOLE%oracle.sysman.emSDK.sec.ReuseLogonPassword=true
                        %USE_DB_CONSOLE%oracle.sysman.eml.mntr.emdRepDBName=%EM_TARGET_DBNAME%
                        %USE_DB_CONSOLE%oracle.sysman.eml.mntr.emdRepRAC=false

                        %USE_DB_CONSOLE%oracle.sysman.eml.mntr.emdRepDBID=%EM_TARGET_DBID%

                        # iSQL*Plus integration
                        oracle.sysman.db.isqlplusUrl=%ISQLPLUS_PROTOCOL%://%ISQLPLUS_HOST%:%ISQLPLUS_PORT%/isqlplus/dynamic
                        oracle.sysman.db.isqlplusWebDBAUrl=%ISQLPLUS_PROTOCOL%://%ISQLPLUS_HOST%:%ISQLPLUS_PORT%/isqlplus/dba/dynamic

                        # port specific ping command
                        emdrep.ping.pingCommand=%EM_PING_COMMAND%

                        # HTTP Proxy server to Oracle MetaLink
                        %USE_HTTP_PROXY%proxyHost=%EM_PROXYHOST%
                        %USE_HTTP_PROXY%proxyPort=%EM_PROXYPORT%
                        %USE_HTTP_PROXY%dontProxyFor=%EM_DONTPROXYFOR%
                        #%USE_HTTP_PROXY%proxyUser=
                        #%USE_HTTP_PROXY%proxyPwd=
                        #%USE_HTTP_PROXY%proxyRealm=
                        #%USE_HTTP_PROXY%proxyPropsEncrypted=false

                        # For controlling the sharing of realtime metric collection
                        #oracle.sysman.emSDK.emd.rt.useMonitoringCred=true

                        # The number of JDBC statements that's cached per repository
                        # connection. Setting it to 0 would turn off caching
                        oracle.sysman.emRep.dbConn.statementCacheSize=50

                        # The number of JDBC statements that's cached per direct-target admin
                        # connection. Setting it to 0 would turn off caching
                        #oracle.sysman.db.adm.conn.statementCacheSize=0

                        # The number of JDBC statements that's cached per real-time database
                        # connection used for performance monitorng
                        #oracle.sysman.db.perf.conn.statementCacheSize=0
                        #
                        # The email address for out-of-band notifications
                        #
                        em_email_address=%EM_EMAIL_ADDRESS%
                        em_email_gateway=%EM_EMAIL_GATEWAY%

                        # The number of results to be returned in the tables
                        # on activity-related pages
                        #oracle.sysman.db.ashPurgeSize=10

                        # This boolean property controls whether the loader should use metadata cache
                        # The loader skips over rowsets for which it detects that the metadata is
                        # already present.
                        #
                        # The default value is TRUE
                        # em.loader.enableMetadataCache=FALSE

                        #
                        # The return email address for out-of-band notifications
                        #
                        em_from_email_address=%EM_FROM_EMAIL_ADDRESS%
                        # Set the following to true to receive email for the oms startup, shutdown or crash
                        em_oob_startup=false
                        em_oob_shutdown=false
                        em_oob_crash=false
                        em.ip.ui.enable=true

                        #
                        # Whether or not the PublicServlet is enabled to allow WEB-INF/publicPages.lst
                        # to specify pages that don't require login to EM
                        #
                        oracle.sysman.emSDK.svlt.PublicServletEnabled=true

                        # Comma seperated list of modules for which dump command should executed.
                        em.oms.dumpModules=omsThread,repos
                        an environment with large number of targets, alerts, errors, policy
                        # violations, ORACLE_HOMEs, etc, the rendering time of Console Home Page
                        # may be too long. Setting this attribute to true will hide some element
                        # in the Console Home Page and thus reducing the rendering time.
                        #
                        # Default : false
                        #
                        LargeRepository=false

                        </pre>

                        Yup, the hostname is wrong. Where should I correct it?
                        • 24. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                          725039
                          Perhaps we ought to just do what Oracle recommends. Run the commands below and let us know what happens.
                          emca -deconfig dbcontrol db
                          
                          emca -config dbcontrol db -repos recreate
                          Regards,
                          Phiri
                          • 25. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                            guruparan
                            <pre>
                            [oracle@oel ~]$ emca -deconfig dbcontrol db

                            STARTED EMCA at Apr 14, 2010 2:07:57 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: DB11G

                            Do you wish to continue? [yes(Y)/no(N)]: y
                            log4j:ERROR No appenders could be found for category (emSDK.config).
                            log4j:ERROR Please initialize the log4j system properly.
                            Apr 14, 2010 2:08:11 AM oracle.sysman.emcp.EMConfig perform
                            INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_07_56.log.
                            Apr 14, 2010 2:08:11 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
                            WARNING: EM is not configured for this database. No EM-specific actions can be performed.
                            Enterprise Manager configuration completed successfully
                            FINISHED EMCA at Apr 14, 2010 2:08:12 AM
                            </pre>

                            <pre>
                            [oracle@oel ~]$ emca -config dbcontrol db -repos recreate

                            STARTED EMCA at Apr 14, 2010 2:08:53 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: DB11G
                            log4j:ERROR No appenders could be found for category (emSDK.config).
                            log4j:ERROR Please initialize the log4j system properly.
                            Listener port number: 1521
                            Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_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/oracle/product/11.2.0/db_1

                            Local hostname ................ oel5-11gr2.localdomain
                            Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
                            Listener port number ................ 1521
                            Database SID ................ DB11G
                            Email address for notifications ...............
                            Outgoing Mail (SMTP) server for notifications ...............

                            -----------------------------------------------------------------
                            Do you wish to continue? [yes(Y)/no(N)]: y
                            Apr 14, 2010 2:09:25 AM oracle.sysman.emcp.EMConfig perform
                            INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_08_52.log.
                            Apr 14, 2010 2:09:26 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 again .
                            Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_08_52.log for more details.
                            Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_08_52.log for more details.
                            </pre>

                            From the log

                            <pre>
                            [oracle@oel ~]$ head -30 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_08_52.log
                            Apr 14, 2010 2:08:52 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
                            CONFIG: Setting oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
                            CONFIG: isHAInstalled: false
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag '-migrate' set to false
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateFromDBControl' set to false
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateToCentralAgent' set to false
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateFromCentralAgent' set to false
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateToDBControl' set to false
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag '-config' set to true
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'UPDATE_EMAIL' set to true
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'dbcontrol' set to true
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'db' set to true
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'create' set to true
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'drop' set to true
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: ORACLE_HOME value: /u01/app/oracle/product/11.2.0/db_1
                            Apr 14, 2010 2:08:53 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                            CONFIG: isCRSInstalled: false
                            </pre>

                            Last few lines
                            <pre>
                            [oracle@oel ~]$ tail -20 /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_08_52.log
                            at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
                            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                            Apr 14, 2010 2:09:26 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 again .
                            Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_08_52.log for more details.
                            Apr 14, 2010 2:09:26 AM oracle.sysman.emcp.EMConfig perform
                            CONFIG: Stack Trace:
                            oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
                            at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
                            at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:203)
                            at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
                            at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                            at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
                            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                            Apr 14, 2010 2:09:26 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
                            CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
                            </pre>

                            Checked the listener

                            <pre>
                            [oracle@oel ~]$ lsnrctl status

                            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-APR-2010 02:12:05

                            Copyright (c) 1991, 2009, Oracle. All rights reserved.

                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                            STATUS of the LISTENER
                            ------------------------
                            Alias LISTENER
                            Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                            Start Date 14-APR-2010 01:38:41
                            Uptime 0 days 0 hr. 33 min. 24 sec
                            Trace Level off
                            Security ON: Local OS Authentication
                            SNMP OFF
                            Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
                            Listener Log File /u01/app/oracle/diag/tnslsnr/oel/listener/alert/log.xml
                            Listening Endpoints Summary...
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
                            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel.localdomain)(PORT=1521)))
                            Services Summary...
                            Service "DB11GXDB.localdomain" has 1 instance(s).
                            Instance "DB11G", status READY, has 1 handler(s) for this service...
                            Service "orcl.localdomain" has 1 instance(s).
                            Instance "DB11G", status READY, has 1 handler(s) for this service...
                            The command completed successfully
                            </pre>

                            I guess it is running properly.
                            • 26. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                              guruparan
                              I guess this is wrong
                              Local hostname ................ oel5-11gr2.localdomain 
                              Where to correct this? This is stored in pfile?
                              • 27. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                                725039
                                >
                                You have specified the following settings
                                Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
                                Local hostname ................ oel5-11gr2.localdomain
                                Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
                                >

                                Strange indeed... still picking oel5-11gr2.localdomain

                                Please try the following and let us know what happens.
                                emca -deconfig dbcontrol db -repos drop
                                
                                emca -config dbcontrol db -repos create
                                Regards,
                                Phiri
                                • 28. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                                  guruparan
                                  In the log, I could find this
                                  CONFIG: Couldn't get listener port. File /u01/app/oracle/product/11.2.0/db_1/oel5-11gr2.localdomain_null/sysman/config/emoms.properties does not exists
                                  If I can correct the hostname, other things should work pretty much as magic.
                                  • 29. Re: Oracle DB 11gR2 in OracleEnterpriseLinux 5.4(Guest OS on Windows XP VMWare)
                                    guruparan
                                    It picks up the wrong host name and still complains that listener is not up.

                                    This error:
                                    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 again .
                                    from
                                    <pre>
                                    [oracle@oel ~]$ emca -deconfig dbcontrol db -repos drop

                                    STARTED EMCA at Apr 14, 2010 2:20:04 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: DB11G
                                    Listener port number: 1521
                                    Password for SYS user:
                                    log4j:ERROR No appenders could be found for category (emSDK.config).
                                    log4j:ERROR Please initialize the log4j system properly.
                                    Invalid username/password.
                                    Password for SYS user:
                                    Password for SYSMAN user:

                                    Do you wish to continue? [yes(Y)/no(N)]: y
                                    Apr 14, 2010 2:20:28 AM oracle.sysman.emcp.EMConfig perform
                                    INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_20_03.log.
                                    Apr 14, 2010 2:20:28 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
                                    WARNING: EM is not configured for this database. No EM-specific actions can be performed.
                                    Apr 14, 2010 2:20: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 again .
                                    Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_20_03.log for more details.
                                    Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2010_04_14_02_20_03.log for more details.
                                    [oracle@oel ~]$
                                    </pre>