1 2 Previous Next 22 Replies Latest reply on Mar 8, 2012 7:56 AM by user4566776

    emca config error

    396953
      OS: Windows XP Prof
      DB: Oracle 11.1.0.6

      When i try to configure my database with database control like this:
      c:\>emca -config dbcontrol db -repos create
      I get the following errors in the event log.
      I searched the whole google, couldnt find a solution. If anybody encountered this error and resolved it, pls let me know how to correct it.
      Log file snippet:
      --------------------
      INFO: Uploading configuration data to EM repository (this may take a while) ...
      Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
      CONFIG: Error uploading configuration data to the repository
      oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

           at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
           at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:674)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:370)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
           at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
           at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
           at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
           at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
           at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
      Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Refer to the log file at C:\app\cfgtoollogs\emca\multiv\emca_repos_config_<date>.log for more details.
      Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig invoke
      SEVERE: Error uploading configuration data to the repository
      Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMConfig perform
      SEVERE: Error uploading configuration data to the repository
      Refer to the log file at C:\app\cfgtoollogs\emca\multiv\emca_2008_02_19_15_09_16.log for more details.
      Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMConfig perform
      CONFIG: Stack Trace:
      oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:382)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
           at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
           at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
           at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
           at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
           at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
      -------------------
      Siva
        • 1. Re: emca config error
          247514
          What's in this file ?

          C:\app\cfgtoollogs\emca\multiv\emca_2008_02_19_15_09_16.log

          Is C:\app your ORACLE_HOME ?

          What's ORACLE_SID set to?
          • 2. Re: emca config error
            396953
            I have even tried to drop the repository and deconfig and reconfig, but it dint work out.

            emca -deconfig dbcontrol db -repos drop
            - this is completely succesful
            emca -config dbcontrol db -repos create
            - this creates the repository, but fails in config with db control.

            Siva
            • 3. Re: emca config error
              396953
              ORACLE_SID is set to MULTIV
              ORACLE_HOME is set to C:\app\product\11.0\db_1

              C:\app\cfgtoollogs\emca\multiv\emca_2008_02_19_15_09_16.log event log file contents
              -----------------------------------------------------------------------------------------------------------------
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag '-migrate' set to false
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateFromDBControl' set to false
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateToCentralAgent' set to false
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateFromCentralAgent' set to false
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateToDBControl' set to false
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag '-config' set to true
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'UPDATE_EMAIL' set to true
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'dbcontrol' set to true
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'create' set to true
              Feb 19, 2008 3:09:16 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: ORACLE_HOME value: C:\app\product\11.1.0\db_1
              Feb 19, 2008 3:09:17 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Feb 19, 2008 3:09:17 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:17 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: EM_HOME value: C:\app\product\11.1.0\db_1
              Feb 19, 2008 3:09:36 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SID value: multiv
              Feb 19, 2008 3:09:36 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:36 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Feb 19, 2008 3:09:36 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
              Feb 19, 2008 3:09:36 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 19, 2008 3:09:36 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: multiv Host: 172.24.117.16 Node: null OH: C:\app\product\11.1.0\db_1 isDBC: false
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: multiv Host: 172.24.117.16 Node: null OH: C:\app\product\11.1.0\db_1 agentHome: null isCentral: false
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: multiv Host: 172.24.117.16 Node: null OH: C:\app\product\11.1.0\db_1 agentHome: null isCentral: false
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SYS_PWD.
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user:
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'asm_db' set to false
              Feb 19, 2008 3:09:37 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'asm_db' set to false
              Feb 19, 2008 3:09:39 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: PORT value: 1521
              Feb 19, 2008 3:09:41 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SYS_PWD.
              Feb 19, 2008 3:09:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: DBSNMP
              Feb 19, 2008 3:09:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:48 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: EMAIL_ADDRESS value:
              Feb 19, 2008 3:09:49 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: MAIL_SERVER_NAME value:
              Feb 19, 2008 3:09:49 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:49 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value:
              Feb 19, 2008 3:09:52 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value: yes
              Feb 19, 2008 3:09:52 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter LOG_FILE.
              Feb 19, 2008 3:09:52 PM oracle.sysman.emcp.EMConfig addEMCALogFile
              CONFIG: ORACLE_BASE :C:\app
              Feb 19, 2008 3:09:52 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Feb 19, 2008 3:09:52 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Feb 19, 2008 3:09:52 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: multiv
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.EMConfig perform
              INFO: This operation is being logged at C:\app\cfgtoollogs\emca\multiv\emca_2008_02_19_15_09_16.log.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'CHECK_CONFIG' set to true
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: DBSNMP
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'asm_db' set to false
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: multiv
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_DOMAIN value: multivision.cc
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: multiv
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: multiv.multivision.cc
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbid
              CONFIG: No dbid available. Will query db to extract it.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DBID value: 1901744937
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: multiv
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_DOMAIN value: multivision.cc
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: multiv
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: multiv.multivision.cc
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter EMAIL_ADDRESS.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.EMDBPreConfig invoke
              CONFIG: Passed repository configuration check
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
              CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
              Feb 19, 2008 3:09:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_DOMAIN value: multivision.cc
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: multiv.multivision.cc
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file C:\app\product\11.1.0\db_1\sysman\config\emd.properties to C:\app\product\11.1.0\db_1\sysman\config\emd.properties.emca.tmp
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil backupFile
              CONFIG: The original file C:\app\product\11.1.0\db_1\sysman\config\emd.properties has been copied to C:\app\product\11.1.0\db_1\sysman\config\emd.properties.emca.tmp
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file C:\app\product\11.1.0\db_1\sysman\config\emoms.properties to C:\app\product\11.1.0\db_1\sysman\config\emoms.properties.emca.tmp
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil backupFile
              CONFIG: The original file C:\app\product\11.1.0\db_1\sysman\config\emoms.properties has been copied to C:\app\product\11.1.0\db_1\sysman\config\emoms.properties.emca.tmp
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file C:\app\product\11.1.0\db_1\sysman\emd\targets.xml to C:\app\product\11.1.0\db_1\sysman\emd\targets.xml.emca.tmp
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil backupFile
              CONFIG: The original file C:\app\product\11.1.0\db_1\sysman\emd\targets.xml has been copied to C:\app\product\11.1.0\db_1\sysman\emd\targets.xml.emca.tmp
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: multiv Host: 172.24.117.16 Node: null OH: C:\app\product\11.1.0\db_1 agentHome: null isCentral: false
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: multiv Host: 172.24.117.16 Node: null OH: C:\app\product\11.1.0\db_1 isDBC: false
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: multiv Host: 172.24.117.16 Node: null OH: C:\app\product\11.1.0\db_1 isDBC: false
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter PORTS_FILE.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
              CONFIG: Setting oracle.installer.oui_loc to C:\app\product\11.1.0\db_1\oui
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
              CONFIG: Setting oracle.installer.oui_loc to C:\app\product\11.1.0\db_1\oui
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Homes to scan for used ports: [C:\app\product\11.1.0\db_1, C:\oracle]
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\app\product\11.1.0\db_1
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking JMS port: null from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking RMI port: null from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking HTTP port: null from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking JMS port: 5540 from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole_172.24.117.16_sikago
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking RMI port: 5520 from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole_172.24.117.16_sikago
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking HTTP port: 1158 from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole_172.24.117.16_sikago
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking JMS port: 5540 from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole_Laptop11_sikago
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking RMI port: 5520 from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole_Laptop11_sikago
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking HTTP port: 1158 from C:\app\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole_Laptop11_sikago
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking Agent port: 3938 from C:\app\product\11.1.0\db_1\172.24.117.16_sikago\sysman\config\emd.properties
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager getAgentPort
              CONFIG: Cannot parse EMD_URL correctly. No port identified
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking Agent port: null from C:\app\product\11.1.0\db_1\sysman\config\emd.properties
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Cannnot parse EMD_URL correctly. No port identified
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\oracle
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil getProperties
              CONFIG: Error reading file C:\oracle\sysman\config\emd.properties
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager getAgentPort
              CONFIG: Cannot parse EMD_URL correctly. No port identified
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking Agent port: null from C:\oracle\sysman\config\emd.properties
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Cannnot parse EMD_URL correctly. No port identified
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.FileUtil getProperties
              CONFIG: Error reading file C:\app\product\11.1.0\db_1\install\staticports.ini
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.util.PortManager getFreePorts
              CONFIG: C:\app\product\11.1.0\db_1:172.24.117.16:null:multiv:{}:null:{DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=1830}
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: AGENT_PORT_multiv value: 1830
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DBCONTROL_HTTP_PORT_multiv value: 5500
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: JMS_PORT_multiv value: 5541
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT_multiv.
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: RMI_PORT_multiv value: 5521
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
              CONFIG: Ports assigned for SID: multiv : {DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=1830}
              Feb 19, 2008 3:09:54 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:09:55 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 19, 2008 3:09:55 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
              CONFIG: File: C:\app\product\11.1.0\db_1\172.24.117.16_multiv\sysman\emd\agntstmp.txt:172.24.117.16 does not exists.
              Feb 19, 2008 3:09:55 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:09:55 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:09:55 PM oracle.sysman.emcp.EMReposConfig createRepository
              CONFIG: Spooling to C:\app\cfgtoollogs\emca\multiv\emca_repos_create_2008_02_19_15_09_55.log
              Feb 19, 2008 3:09:55 PM oracle.sysman.emcp.EMReposConfig createRepository
              INFO: Creating the EM repository (this may take a while) ...
              Feb 19, 2008 3:18:44 PM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Repository successfully created
              Feb 19, 2008 3:18:44 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter EMAIL_ADDRESS.
              Feb 19, 2008 3:18:44 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
              Feb 19, 2008 3:18:44 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_NAME.
              Feb 19, 2008 3:18:44 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_ADDR.
              Feb 19, 2008 3:18:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:18:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:18:45 PM oracle.sysman.emcp.EMReposConfig unlockAccounts
              CONFIG: Unlocking dbsnmp and sysman
              Feb 19, 2008 3:18:45 PM oracle.sysman.emcp.EMReposConfig invoke
              CONFIG: Successfully unlocked relevant accounts
              Feb 19, 2008 3:18:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYSMAN
              Feb 19, 2008 3:18:46 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:18:51 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
              CONFIG: Finished executing emreposoutofbox.sql
              Feb 19, 2008 3:18:51 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYSMAN
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
              CONFIG: Submitting dbms job: C:\app\product\11.1.0\db_1\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
              CONFIG: Successfully submitted dbms job
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
              CONFIG: Unlocking mgmt view user account
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
              CONFIG: view user sql: 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_status 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;
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Starting execution: CMD /C C:\app\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.bat "C:\app\product\11.1.0\db_1\sysman\admin\scripts;C:\app\product\11.1.0\db_1\bin;" C:/app/product/11.1.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe C:\app\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.pl C:\app\product\11.1.0\db_1 multiv SYS SYSDBA 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_status 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; 1 SYSMAN_PWD
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Exit value of 0
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Execution of CMD /C C:\app\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.bat "C:\app\product\11.1.0\db_1\sysman\admin\scripts;C:\app\product\11.1.0\db_1\bin;" C:/app/product/11.1.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe C:\app\product\11.1.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.pl C:\app\product\11.1.0\db_1 multiv SYS SYSDBA 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_status 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; 1 SYSMAN_PWD completed successfully
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Arguments passed C:\app\product\11.1.0\db_1 multiv SYS SYSDBA 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_status 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; 1 SYSMAN_PWD

              Connecting to database multiv in home C:\app\product\11.1.0\db_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_status 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.

              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
              CONFIG: Unlocked mgmt_view account
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.EMReposConfig invoke
              CONFIG: Successfully unlocked mgmt_view account
              Feb 19, 2008 3:18:52 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: multiv, oracleHome: C:\app\product\11.1.0\db_1, and user: SYS
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
              CONFIG: Passed listener validation check.Listener is up and running.
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
              INFO: Uploading configuration data to EM repository (this may take a while) ...
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
              CONFIG: Error uploading configuration data to the repository
              oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

                   at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
                   at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:674)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:370)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
                   at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
                   at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
                   at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
                   at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
                   at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Refer to the log file at C:\app\cfgtoollogs\emca\multiv\emca_repos_config_<date>.log for more details.
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMReposConfig invoke
              SEVERE: Error uploading configuration data to the repository
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMConfig perform
              SEVERE: Error uploading configuration data to the repository
              Refer to the log file at C:\app\cfgtoollogs\emca\multiv\emca_2008_02_19_15_09_16.log for more details.
              Feb 19, 2008 3:18:53 PM oracle.sysman.emcp.EMConfig perform
              CONFIG: Stack Trace:
              oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:382)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
                   at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
                   at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
                   at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
                   at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
                   at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
              -----------------------------------------------------------------------------------------------------------
              Siva
              • 4. Re: emca config error
                247514
                Check what's in your
                %WINDIR%\system32\drivers\etc\hosts

                Make sure get correct hostname in it. and try again.
                • 5. Re: emca config error
                  396953
                  Thanks for the suggestion "Yingkuan", i tried it but it failed too.
                  • 6. Re: emca config error
                    277993
                    Somehow your config is ot making contact with your database, so it cannot upload to the repository.

                    Two posibbilities:

                    1. The database is down and/or not accepting connections
                    2. The listener that should accept the connections to the database is down.

                    So check these two. If any is down, then start it.
                    • 7. Re: emca config error
                      oradba
                      There's one hint in the 11g README file, but you don't live in Turkey:
                      /*
                      Bug 6196406

                      Database Configuration Assistant (DBCA) may fail to configure Oracle Enterprise Manager Database Control if executed in Turkish operating system locale. The message Error uploading configuration data to the repository is reported.

                      Workaround
                      After the database creation, change the operating system session locale to English and configure Oracle Enterprise Manager Database Control manually using the EMCA tool. For example, in Linux csh shell, run:

                      $ setenv LC_ALL en_US
                      $ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate [-cluster]
                      */

                      Werner
                      • 8. Re: emca config error
                        396953
                        Thanks for suggestions. I did look at that README file and set my environment with locale settings to en_us(although i dont use Turkish in my laptop).
                        Even listener is listening to service multiv, db is also up.
                        In another log file, i get these messages:
                        -----------------------------------------------------------------------------------------------------
                        Feb 20, 2008 10:04:03 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection
                        INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Laptop11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=multiv.multivision.cc)))
                        Feb 20, 2008 10:04:04 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection
                        INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Laptop11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=multiv.multivision.cc)))
                        Feb 20, 2008 10:04:04 AM oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run
                        SEVERE: null
                        java.lang.reflect.InvocationTargetException
                             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:585)
                             at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:469)
                             at java.lang.Thread.run(Thread.java:595)
                        Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
                             at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
                             at java.lang.Runtime.loadLibrary0(Runtime.java:822)
                             at java.lang.System.loadLibrary(System.java:993)
                             at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3139)
                             at java.security.AccessController.doPrivileged(Native Method)
                             at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3135)
                             at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
                             at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:519)
                             at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
                             at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
                             at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)
                             at java.sql.DriverManager.getConnection(DriverManager.java:525)
                             at java.sql.DriverManager.getConnection(DriverManager.java:140)
                             at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:201)
                             at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:240)
                             at oracle.sysman.emdrep.config.IConfigurationContext.getConnection(IConfigurationContext.java:194)
                             at oracle.sysman.emdrep.config.IConfigurationContext.init(IConfigurationContext.java:96)
                             ... 6 more

                        Feb 20, 2008 10:04:04 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
                        WARNING: Exception Occured during Execution of oracle.sysman.emdrep.util.TransxWrapper
                        Feb 20, 2008 10:04:04 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
                        SEVERE: FATAL EXCEPTIONS:
                        FATAL Configuration Exceptions
                        -----------------------------------------------------------------------
                        C:\app\product\11.1.0\db_1\BIN>tnsping (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Laptop11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=multiv.multivision.cc)))

                        TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 20-FEB-2008 10:12:28

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

                        Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Laptop11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=multiv.multivision.cc)))
                        OK (10 msec)
                        *************************************
                        This is how java uses the jdbc connection with thin clinet, though this works fine, i dont understand where and how does it fail to connect somewhere.
                        • 9. Re: emca config error
                          ViragSharma
                          is there host entry in C:\WINDOWS\system32\drivers\etc\hosts ?
                          • 10. Re: emca config error
                            396953
                            C:\windows\system32\drivers\etc\hosts file contents
                            # Copyright (c) 1993-1999 Microsoft Corp.
                            #
                            # This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
                            #
                            # This file contains the mappings of IP addresses to host names. Each
                            # entry should be kept on an individual line. The IP address should
                            # be placed in the first column followed by the corresponding host name.
                            # The IP address and the host name should be separated by at least one
                            # space.
                            #
                            # Additionally, comments (such as these) may be inserted on individual
                            # lines or following the machine name denoted by a '#' symbol.
                            #
                            # For example:
                            #
                            # 102.54.94.97 rhino.acme.com # source server
                            # 38.25.63.10 x.acme.com # x client host

                            127.0.0.1 localhost
                            10.252.217.4          ora01
                            10.252.217.5          ora02
                            172.24.117.16          Laptop11
                            ------------------------------------------
                            It does have host names and IP address derived from DHCP.
                            While its able to connect and create & drop the repository, why does it fail to configure db control?
                            • 11. Re: emca config error
                              oradba
                              Maybe it's time to call Oracle support?

                              Werner
                              • 12. Re: emca config error
                                396953
                                After much research on the system, I see that it gets errorred out when trying to run this perl script:
                                C:\app\product\11.1.0\db_1\sysman\admin\emdrep\bin\TransX.pm
                                (this is where it starts "EMSchemaConfiguration")

                                But dont know how to resolve it, as i dont know much of perl.
                                • 13. Re: emca config error
                                  367362
                                  Hi,
                                  I just had the same problem on Linux.

                                  The solution was that I forgot to make a password file. The connection with sys as sysdba over the listener was not possible.

                                  Try to connect to the users sys as sysdba, system, dbsnmp and sysman with and without the listener.
                                  Maybe there's your error.

                                  Daniel
                                  • 14. Re: emca config error
                                    user10476344
                                    I have the same question in my system.
                                    What is the password file ?
                                    How to make it ?
                                    1 2 Previous Next