7 Replies Latest reply on Dec 7, 2012 7:19 AM by 655734

    pls help to create repository

    927187
      SQL> drop user sysman cascade;

      User dropped.

      SQL> commit
      2 ;

      Commit complete.

      SQL> quit

      C:\Documents and Settings\SKS>emca -config dbcontrol db -repos create

      STARTED EMCA at May 10, 2012 11:16:57 AM
      EM Configuration Assistant, Version 11.1.0.7.0 Production
      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Enter the following information:
      Database SID: VESS
      Listener port number: 1521
      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 ................ C:\app\SKS\product\11.1.0\db_1

      Local hostname ................ computer
      Listener port number ................ 1521
      Database SID ................ VESS
      Email address for notifications ...............
      Outgoing Mail (SMTP) server for notifications ...............

      -----------------------------------------------------------------
      Do you wish to continue? [yes(Y)/no(N)]: y
      May 10, 2012 11:17:35 AM oracle.sysman.emcp.EMConfig perform
      INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_11_16_57.log.
      May 10, 2012 11:17:37 AM oracle.sysman.emcp.EMReposConfig createRepository
      INFO: Creating the EM repository (this may take a while) ...
      May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMReposConfig invoke
      SEVERE: Error creating the repository
      May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_repos_create_<date>.log for more details.
      May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMConfig perform
      SEVERE: Error creating the repository
      Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_11_16_57.log for more details.
      Could not complete the configuration. Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_
      11_16_57.log for more details.
        • 1. Re: pls help to create repository
          Kamran Agayev A.
          Please post the output of the following log file:
          C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_11_16_57.log
          • 2. Re: pls help to create repository
            839439
            check the below link. this will sort out your problem

            http://neeraj-dba.blogspot.in/2012/01/how-to-reconfigure-oem-in-oracle-10g-on.html


            Good luck


            --neeraj                                                                                                                                                                                                                                                                                                                                                   
            • 3. Re: pls help to create repository
              927187
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag '-migrate' set to false
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateFromDBControl' set to false
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateToCentralAgent' set to false
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateFromCentralAgent' set to false
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateToDBControl' set to false
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag '-config' set to true
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'UPDATE_EMAIL' set to true
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'dbcontrol' set to true
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'create' set to true
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: ORACLE_HOME value: C:\app\SKS\product\11.1.0\db_1
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              May 10, 2012 11:16:57 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:16:58 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: EM_HOME value: C:\app\SKS\product\11.1.0\db_1
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SID value: VESS
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: VESS Host: computer Node: null OH: C:\app\SKS\product\11.1.0\db_1 isDBC: false
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: VESS Host: computer Node: null OH: C:\app\SKS\product\11.1.0\db_1 agentHome: null isCentral: false
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: VESS Host: computer Node: null OH: C:\app\SKS\product\11.1.0\db_1 agentHome: null isCentral: false
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SYS_PWD.
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user:
              May 10, 2012 11:17:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:06 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'asm_db' set to false
              May 10, 2012 11:17:06 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'asm_db' set to false
              May 10, 2012 11:17:10 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: PORT value: 1521
              May 10, 2012 11:17:15 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SYS_PWD.
              May 10, 2012 11:17:15 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:15 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: DBSNMP
              May 10, 2012 11:17:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:30 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: EMAIL_ADDRESS value:
              May 10, 2012 11:17:32 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: MAIL_SERVER_NAME value:
              May 10, 2012 11:17:32 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:32 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value:
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value: yes
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter LOG_FILE.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.EMConfig addEMCALogFile
              CONFIG: ORACLE_BASE :C:\app\SKS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.EMConfig perform
              INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_11_16_57.log.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'CHECK_CONFIG' set to true
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: DBSNMP
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'asm_db' set to false
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBID.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbid
              CONFIG: No dbid available. Will query db to extract it.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DBID value: 2915575207
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: vess
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter EMAIL_ADDRESS.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
              May 10, 2012 11:17:35 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.EMDBPreConfig invoke
              CONFIG: Passed repository configuration check
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
              CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: vess
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file C:\app\SKS\product\11.1.0\db_1\sysman\config\emd.properties to C:\app\SKS\product\11.1.0\db_1\sysman\config\emd.properties.emca.tmp
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.FileUtil backupFile
              CONFIG: The original file C:\app\SKS\product\11.1.0\db_1\sysman\config\emd.properties has been copied to C:\app\SKS\product\11.1.0\db_1\sysman\config\emd.properties.emca.tmp
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file C:\app\SKS\product\11.1.0\db_1\sysman\config\emoms.properties to C:\app\SKS\product\11.1.0\db_1\sysman\config\emoms.properties.emca.tmp
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.FileUtil backupFile
              CONFIG: The original file C:\app\SKS\product\11.1.0\db_1\sysman\config\emoms.properties has been copied to C:\app\SKS\product\11.1.0\db_1\sysman\config\emoms.properties.emca.tmp
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file C:\app\SKS\product\11.1.0\db_1\sysman\emd\targets.xml to C:\app\SKS\product\11.1.0\db_1\sysman\emd\targets.xml.emca.tmp
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.FileUtil backupFile
              CONFIG: The original file C:\app\SKS\product\11.1.0\db_1\sysman\emd\targets.xml has been copied to C:\app\SKS\product\11.1.0\db_1\sysman\emd\targets.xml.emca.tmp
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: VESS Host: computer Node: null OH: C:\app\SKS\product\11.1.0\db_1 agentHome: null isCentral: false
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: VESS Host: computer Node: null OH: C:\app\SKS\product\11.1.0\db_1 isDBC: false
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: VESS Host: computer Node: null OH: C:\app\SKS\product\11.1.0\db_1 isDBC: false
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter PORTS_FILE.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT_VESS.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT_VESS.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_VESS.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT_VESS.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT.
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
              CONFIG: Setting oracle.installer.oui_loc to C:\app\SKS\product\11.1.0\db_1\oui
              May 10, 2012 11:17:36 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
              CONFIG: Setting oracle.installer.oui_loc to C:\app\SKS\product\11.1.0\db_1\oui
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Homes to scan for used ports: [C:\app\SKS\product\11.1.0\db_1]
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\app\SKS\product\11.1.0\db_1
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking JMS port: null from C:\app\SKS\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking RMI port: null from C:\app\SKS\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking HTTP port: null from C:\app\SKS\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager getAgentPort
              CONFIG: Cannot parse EMD_URL correctly. No port identified
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Marking Agent port: null from C:\app\SKS\product\11.1.0\db_1\sysman\config\emd.properties
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
              CONFIG: Cannnot parse EMD_URL correctly. No port identified
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.FileUtil getProperties
              CONFIG: Error reading file C:\app\SKS\product\11.1.0\db_1\install\staticports.ini
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.PortManager getFreePorts
              CONFIG: C:\app\SKS\product\11.1.0\db_1:computer:null:VESS:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter AGENT_PORT_VESS.
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: AGENT_PORT_VESS value: 3938
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_VESS.
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DBCONTROL_HTTP_PORT_VESS value: 1158
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter JMS_PORT_VESS.
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: JMS_PORT_VESS value: 5540
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter RMI_PORT_VESS.
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: RMI_PORT_VESS value: 5520
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.EMDBPreConfig getFreePorts
              CONFIG: Ports assigned for SID: VESS : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
              CONFIG: File: C:\app\SKS\product\11.1.0\db_1\computer_VESS\sysman\emd\agntstmp.txt:computer does not exists.
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine connecting with SID: VESS, oracleHome: C:\app\SKS\product\11.1.0\db_1, and user: SYS
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: SQLEngine created successfully and connected
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.EMReposConfig createRepository
              CONFIG: Spooling to C:\app\SKS\cfgtoollogs\emca\vess\emca_repos_create_2012_05_10_11_17_37.log
              May 10, 2012 11:17:37 AM oracle.sysman.emcp.EMReposConfig createRepository
              INFO: Creating the EM repository (this may take a while) ...
              May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMReposConfig createRepository
              CONFIG: ORA-01921: role name 'MGMT_USER' conflicts with another user or role name

              oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01921: role name 'MGMT_USER' conflicts with another user or role name

                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
                   at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:270)
                   at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:311)
                   at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
                   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)
              May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMReposConfig invoke
              SEVERE: Error creating the repository
              May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_repos_create_<date>.log for more details.
              May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMConfig perform
              SEVERE: Error creating the repository
              Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_11_16_57.log for more details.
              May 10, 2012 11:17:39 AM oracle.sysman.emcp.EMConfig perform
              CONFIG: Stack Trace:
              oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:230)
                   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)
              • 4. Re: pls help to create repository
                839439
                Hi

                As you have only drop the sysman schemas not the dependent role and objects .The above logfile shows the below error
                ORA-01921: role name 'MGMT_USER' conflicts with another user or role name
                Drop the above user "MGMT_USER" and drop the repository too. Check the above link to recreate the repository


                --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                • 5. Re: pls help to create repository
                  839439
                  duplicate post

                  Edited by: Vishen on May 10, 2012 11:39 AM
                  • 6. Re: pls help to create repository
                    927187
                    dropped role : mgmt_user. getting following error... but i dropped sysman user and gave cmmit...


                    CONFIG: ORA-20001: SYSMAN already exists..
                    ORA-06512: at line 17

                    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
                    ORA-06512: at line 17

                         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
                         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
                         at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:270)
                         at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:311)
                         at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
                         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
                         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)
                    May 10, 2012 11:45:27 AM oracle.sysman.emcp.EMReposConfig invoke
                    SEVERE: Error creating the repository
                    May 10, 2012 11:45:27 AM oracle.sysman.emcp.EMReposConfig invoke
                    INFO: Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_repos_create_<date>.log for more details.
                    May 10, 2012 11:45:27 AM oracle.sysman.emcp.EMConfig perform
                    SEVERE: Error creating the repository
                    Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_11_44_44.log for more details.
                    May 10, 2012 11:45:27 AM oracle.sysman.emcp.EMConfig perform
                    CONFIG: Stack Trace:
                    oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
                         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:230)
                         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)
                    • 7. Re: pls help to create repository
                      655734
                      @924184: try this emca -config dbcontrol db -repos recreate