1 2 Previous Next 18 Replies Latest reply on Sep 19, 2012 3:18 PM by 951027

    EM configuration issue

    951027
      Helllo all,

      I am unabe to open OEM.
      while checking the status getting the following message.
      I am using win7.



      C:\Users\user>EMCTL STATUS
      EM Configuration issue. C:\app\user\product\11.2.0\dbhome_1/user-TOSH_prod3 no
      t found.

      Please advice
        • 1. Re: EM configuration issue
          Osama_Mustafa
          recreate enterprise you configuration file is missing use
          emca -deconfig dbcontrol db -repos drop
          emca -config dbcontrol db -repos create
          1 person found this helpful
          • 2. Re: EM configuration issue
            951027
            C:\Users\User>emca -deconfig dbcontrol db -repos drop

            STARTED EMCA at Sep 19, 2012 10:23:54 AM
            EM Configuration Assistant, Version 11.2.0.0.2 Production
            Copyright (c) 2003, 2005, Oracle. All rights reserved.

            Enter the following information:
            Database SID: prod3
            Listener port number: 1521
            Password for SYS user:
            Password for SYSMAN user:
            Password for SYSMAN user:
            Do you wish to continue? [yes(Y)/no(N)]: Y
            Sep 19, 2012 10:24:17 AM oracle.sysman.emcp.EMConfig perform
            INFO: This operation is being logged at C:\app\User\cfgtoollogs\emca\emca_2012_
            09_19_10_23_54.log.
            Sep 19, 2012 10:24:17 AM oracle.sysman.emcp.EMConfig perform
            SEVERE: Database instance unavailable.
            Refer to the log file at C:\app\User\cfgtoollogs\emca\emca_2012_09_19_10_23_54.
            log for more details.
            Could not complete the configuration. Refer to the log file at C:\app\User\cfgt
            oollogs\emca\emca_2012_09_19_10_23_54.log for more details.

            C:\Users\User>emca -config dbcontrol db -repos create

            STARTED EMCA at Sep 19, 2012 10:25:37 AM
            EM Configuration Assistant, Version 11.2.0.0.2 Production
            Copyright (c) 2003, 2005, Oracle. All rights reserved.

            Enter the following information:
            Database SID: prod3
            Database Control is already configured for the database prod3
            You have chosen to configure Database Control for managing the database prod3
            This will remove the existing configuration and the default settings and perform
            a fresh configuration
            Do you wish to continue? [yes(Y)/no(N)]: Y
            Listener port number: 1521
            Listener ORACLE_HOME [ C:\app\User\product\11.2.0\dbhome_1 ]: C:\app\User\prod
            uct\11.2.0\dbhome_1
            Password for SYS user:
            Password for DBSNMP user:
            Password for SYSMAN user:
            Password for SYSMAN user: Email address for notifications (optional):
            Outgoing Mail (SMTP) server for notifications (optional):
            -----------------------------------------------------------------

            You have specified the following settings

            Database ORACLE_HOME ................ C:\app\User\product\11.2.0\dbhome_1

            Local hostname ................ User-TOSH
            Listener ORACLE_HOME ................ C:\app\User\product\11.2.0\dbhome_1
            Listener port number ................ 1521
            Database SID ................ prod3
            Email address for notifications ...............
            Outgoing Mail (SMTP) server for notifications ...............

            -----------------------------------------------------------------
            Do you wish to continue? [yes(Y)/no(N)]: Y
            Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.EMConfig perform
            INFO: This operation is being logged at C:\app\User\cfgtoollogs\emca\prod3\emca
            _2012_09_19_10_25_36.log.
            Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.util.FileUtil backupFile
            WARNING: Could not backup file C:\app\User\product\11.2.0\dbhome_1\sysman\confi
            g\emd.properties
            Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.util.FileUtil backupFile
            WARNING: Could not backup file C:\app\User\product\11.2.0\dbhome_1\sysman\confi
            g\emoms.properties
            Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.util.FileUtil backupFile
            WARNING: Could not backup file C:\app\User\product\11.2.0\dbhome_1\sysman\emd\t
            argets.xml
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
            WARNING: Specified port 5540 is already in use.
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
            WARNING: Specified port 5520 is already in use.
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
            WARNING: Specified port 1158 is already in use.
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
            WARNING: Specified port 3938 is already in use.
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
            INFO: Stopping Database Control (this may take a while) ...
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig createRepository
            INFO: Creating the EM repository (this may take a while) ...
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig invoke
            SEVERE: Error creating the repository
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Refer to the log file at C:\app\User\cfgtoollogs\emca\prod3\emca_repos_cr
            eate_<date>.log for more details.
            Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMConfig perform
            SEVERE: Error creating the repository
            Refer to the log file at C:\app\User\cfgtoollogs\emca\prod3\emca_2012_09_19_10_
            25_36.log for more details.
            Could not complete the configuration. Refer to the log file at C:\app\User\cfgt
            oollogs\emca\prod3\emca_2012_09_19_10_25_36.log for more details.













            C:\Users\User>emctl start dbconsole
            Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
            Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
            https://User-TOSH:1158/em/console/aboutApplication
            Starting Oracle Enterprise Manager 11g Database Control ...The service name is i
            nvalid.

            More help is available by typing NET HELPMSG 2185.
            • 3. Re: EM configuration issue
              Osama_Mustafa
              Sep 19, 2012 10:24:17 AM oracle.sysman.emcp.EMConfig perform
              SEVERE: Database instance unavailable.

              are you sure your database is up ? or you provide the right SID ?

              How You use emctl status dbconsole
              and the all the command line finished with invalid status

              SEVERE: Error creating the repository
              Refer to the log file at C:\app\User\cfgtoollogs\emca\prod3\emca_2012_09_19_10_
              *25_36.log for more details.*
              Could not complete the configuration. Refer to the log file at C:\app\User\cfgt
              oollogs\emca\prod3\emca_2012_09_19_10_25_36.log for more details.

              Post the these Log please
              • 4. Re: EM configuration issue
                951027
                yes the database is up and running the sid is prod3,

                this is the first log whic u requested @ mostafa



                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
                CONFIG: Setting oracle.installer.oui_loc to C:\app\User\product\11.2.0\dbhome_1\oui
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
                CONFIG: isHAInstalled: false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag '-migrate' set to false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'migrateFromDBControl' set to false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'migrateToCentralAgent' set to false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'migrateFromCentralAgent' set to false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'migrateToDBControl' set to false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag '-config' set to true
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'UPDATE_EMAIL' set to true
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'dbcontrol' set to true
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'db' set to true
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'create' set to true
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: ORACLE_HOME value: C:\app\User\product\11.2.0\dbhome_1
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                CONFIG: isCRSInstalled: false
                Sep 19, 2012 10:25:37 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
                CONFIG: isHAInstalled: false
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: SID value: prod3
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName
                CONFIG: No service name available. Will try to set db_unique_name.db_domain
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter REP_DB_RUNNING_HOST.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getHost
                CONFIG: Host having instnces running for database null : User-TOSH
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: REP_DB_RUNNING_HOST value: User-TOSH
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter SYSMAN_PWD.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter PORT.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                CONFIG: isCRSInstalled: false
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getRepDbPort
                CONFIG: Couldn't get listener port. File C:\app\User\product\11.2.0\dbhome_1\User-TOSH_null\sysman\config\emoms.properties does not exists
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter SERVICE_NAME.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                CONFIG: isLocalConnectionRequired: true
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                Sep 19, 2012 10:25:40 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine connecting with SID: prod3, oracleHome: C:\app\User\product\11.2.0\dbhome_1, and user:
                Sep 19, 2012 10:25:41 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine created successfully and connected
                Sep 19, 2012 10:25:41 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                Sep 19, 2012 10:25:41 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DB_UNIQUE_NAME.istant.java:522)
                Sep 19, 2012 10:25:41 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'asm_db' set to false
                Sep 19, 2012 10:25:51 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: CONFIRMATION ANSWER value: yes
                Sep 19, 2012 10:25:54 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: PORT value: 1521
                Sep 19, 2012 10:26:38 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: LISTENER_OH value: C:\app\User\product\11.2.0\dbhome_1
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter SYS_PWD.
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ASM_OH.
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.ParamsManager getHost
                CONFIG: Host having instnces running for database prod3 : User-TOSH
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: REP_DB_RUNNING_HOST value: User-TOSH
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter SYSMAN_PWD.
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.ParamsManager getRepDbPort
                CONFIG: Listener Port: 1521
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                CONFIG: isLocalConnectionRequired: true
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                Sep 19, 2012 10:26:40 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine connecting with SID: prod3, oracleHome: C:\app\User\product\11.2.0\dbhome_1, and user: SYS
                Sep 19, 2012 10:26:41 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine created successfully and connected
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ASM_OH.
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.ParamsManager getHost
                CONFIG: Host having instnces running for database prod3 : User-TOSH
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: REP_DB_RUNNING_HOST value: User-TOSH
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter SYSMAN_PWD.
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.ParamsManager getRepDbPort
                CONFIG: Listener Port: 1521
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                CONFIG: isLocalConnectionRequired: true
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine connecting with SID: prod3, oracleHome: C:\app\User\product\11.2.0\dbhome_1, and user: DBSNMP
                Sep 19, 2012 10:26:43 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine created successfully and connected
                Sep 19, 2012 10:26:47 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: EMAIL_ADDRESS value:
                Sep 19, 2012 10:26:48 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: MAIL_SERVER_NAME value:
                Sep 19, 2012 10:26:48 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:26:48 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: CONFIRMATION ANSWER value:
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager setParam
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager getHost
                CONFIG: Host having instnces running for database prod3 : User-TOSH
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: REP_DB_RUNNING_HOST value: User-TOSH
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager getRepDbPort
                CONFIG: Listener Port: 1521
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.util.GeneralUtil isLoc
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
                CONFIG: isHAInstalled: false
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
                Sep 19, 2012 10:27:04 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
                CONFIG: Sid: prod3 Host: User-TOSH Node: null OH: C:\app\User\product\11.2.0\dbhome_1 agentHome: null isCentral: false
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
                CONFIG: Sid: prod3 Host: User-TOSH Node: null OH: C:\app\User\product\11.2.0\dbhome_1 isDBC: true
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setFlag
                CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to true
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter AGENT_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter RMI_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter JMS_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
                CONFIG: Sid: prod3 Host: User-TOSH Node: null OH: C:\app\User\product\11.2.0\dbhome_1 isDBC: true
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter PORTS_FILE.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter JMS_PORT_null.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter JMS_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter RMI_PORT_null.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter RMI_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_null.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter AGENT_PORT_null.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter AGENT_PORT.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.FileUtil getProperties
                CONFIG: Error reading file C:\app\User\product\11.2.0\dbhome_1\install\staticports.ini
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager getConfiguredPorts
                CONFIG: C:\app\User\product\11.2.0\dbhome_1:User-TOSH:null:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter AGENT_PORT_User-TOSH.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: AGENT_PORT_User-TOSH value: 3938
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_User-TOSH.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: DBCONTROL_HTTP_PORT_User-TOSH value: 1158
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter JMS_PORT_User-TOSH.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: JMS_PORT_User-TOSH value: 5540
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter RMI_PORT_User-TOSH.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: RMI_PORT_User-TOSH value: 5520
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMDBPreConfig getConfiguredPorts
                CONFIG: Configured ports for SID: prod3 : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getParam
                CONFIG: No value was set for the parameter PORTS_FILE.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
                CONFIG: Setting oracle.installer.oui_loc to C:\app\User\product\11.2.0\dbhome_1\oui
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Homes to scan for used ports: [C:\app\User\product\11.2.0\client_1, C:\app\User\product\11.2.0\client_4, C:\app\User\product\11.2.0\dbhome_1]
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\app\User\product\11.2.0\client_1
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.FileUtil getProperties
                CONFIG: Error reading file C:\app\User\product\11.2.0\client_1\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager getAgentPort
                CONFIG: Cannot parse EMD_URL correctly. No port identified
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking Agent port: null from C:\app\User\product\11.2.0\client_1\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Cannnot parse EMD_URL correctly. No port identified
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\app\User\product\11.2.0\client_4
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.FileUtil getProperties
                CONFIG: Error reading file C:\app\User\product\11.2.0\client_4\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager getAgentPort
                CONFIG: Cannot parse EMD_URL correctly. No port identified
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking Agent port: null from C:\app\User\product\11.2.0\client_4\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Cannnot parse EMD_URL correctly. No port identified
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\app\User\product\11.2.0\dbhome_1
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking JMS port: null from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking RMI port: null from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking HTTP port: null from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking JMS port: 5540 from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_User-TOSH_prod1
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking RMI port: 5520 from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_User-TOSH_prod1
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking HTTP port: 1158 from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_User-TOSH_prod1
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking JMS port: 5540 from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_User-TOSH_prod3
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking RMI port: 5520 from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_User-TOSH_prod3
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking HTTP port: 1158 from C:\app\User\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_User-TOSH_prod3
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking Agent port: 3938 from C:\app\User\product\11.2.0\dbhome_1\User-TOSH_prod1\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking Agent port: 3938 from C:\app\User\product\11.2.0\dbhome_1\User-TOSH_prod3\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager getAgentPort
                CONFIG: Cannot parse EMD_URL correctly. No port identified
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Marking Agent port: null from C:\app\User\product\11.2.0\dbhome_1\sysman\config\emd.properties
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                CONFIG: Cannnot parse EMD_URL correctly. No port identified
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
                WARNING: Specified port 5540 is already in use.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
                WARNING: Specified port 5520 is already in use.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
                WARNING: Specified port 1158 is already in use.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager isPortInUse
                WARNING: Specified port 3938 is already in use.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PortManager getFreePorts
                CONFIG: C:\app\User\product\11.2.0\dbhome_1:User-TOSH:null:prod3:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMDBPreConfig getFreePorts
                CONFIG: Ports assigned for Node: User-TOSH : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
                INFO: Stopping Database Control (this may take a while) ...
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
                CONFIG: cmdType: 1
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PlatformInterface isPre112Home
                CONFIG: oracleHome: C:\app\User\product\11.2.0\dbhome_1 isPre112Home: false
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
                CONFIG: Service does not exist
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                CONFIG: isLocalNodeDone: true localNode: null
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
                CONFIG: New Env List: [ALLUSERSPROFILE=C:\ProgramData, AMDAPPSDKROOT=C:\Program Files (x86)\AMD APP\, APPDATA=C:\Users\User\AppData\Roaming, C:\WINDOWS\SYSTEM32\=C:\windows\system32\, CLASSPATH=C:\app\User\product\11.2.0\dbhome_1\jlib\emca.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\srvm.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\srvmasm.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\cvu.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\emConfigInstall.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\ldapjclnt11.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\ldap.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\share.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\srvmhas.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\netcfg.jar;C:\app\User\product\11.2.0\dbhome_1\jlib\http_client.jar;C:\app\User\product\11.2.0\dbhome_1\lib\http_client.jar;C:\app\User\product\11.2.0\dbhome_1\lib\xmlparserv2.jar;C:\app\User\product\11.2.0\dbhome_1\assistants\jlib\assistantsCommon.jar;C:\app\User\product\11.2.0\dbhome_1\sysman\jlib\emCORE.jar;C:\app\User\product\11.2.0\dbhome_1\sysman\jlib\emagentSDK.jar;C:\app\User\product\11.2.0\dbhome_1\oui\jlib\OraInstaller.jar;C:\app\User\product\11.2.0\dbhome_1\oui\jlib\OraPrereq.jar;C:\app\User\product\11.2.0\dbhome_1\inventory\prereqs\oui\OraPrereqChecks.jar;C:\app\User\product\11.2.0\dbhome_1\oui\jlib\OraPrereqChecks.jar;, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=USER-TOSH, COMSPEC=C:\windows\system32\cmd.exe, EMCA_JAR=C:\app\User\product\11.2.0\dbhome_1\jlib\emca.jar, EMDROOT=C:\app\User\product\11.2.0\dbhome_1, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Users\User, JRE_JAVA=C:\app\User\product\11.2.0\dbhome_1\jdk\jre\bin\java, LD_LIBRARY_PATH=C:\app\User\product\11.2.0\dbhome_1\lib32;C:\app\User\product\11.2.0\dbhome_1\lib;C:\app\User\product\11.2.0\dbhome_1\perl\lib;null, LIB_DIR=C:\app\User\product\11.2.0\dbhome_1\jlib, LOCALAPPDATA=C:\Users\User\AppData\Local, LOGONSERVER=\\USER-TOSH, NUMBER_OF_PROCESSORS=4, OH=C:\app\User\product\11.2.0\dbhome_1, ORACLE_HOME=C:\app\User\product\11.2.0\dbhome_1, ORACLE_SID=PROD3, ORACLE_UNQNAME=PROD3, OS=Windows_NT, PATH=C:\app\User\product\11.2.0\dbhome_1\bin;C:\app\User\product\11.2.0\dbhome_1\jdk\jre\bin\server;C:\app\User\product\11.2.0\dbhome_1\bin;C:\app\User\product\11.2.0\dbhome_1\bin;C:\orant\bin;C:\app\User\product\11.2.0\client_3\;C:\app\User\product\11.2.0\client_2\bin;C:\app\User\product\11.2.0\client_1\bin;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\orant\jdk\bin, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PERL5LIB=C:\app\User\product\11.2.0\dbhome_1\sysman\admin\scripts;C:\app\User\product\11.2.0\dbhome_1\bin;, PROCESSOR_ARCHITECTURE=AMD64, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 42 Stepping 7, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2a07, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROGRAMFILES(X86)=C:\Program Files (x86), PROGRAMW6432=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, SESSIONNAME=Console, SYSTEMDRIVE=C:, SYSTEMROOT=C:\windows, TEMP=C:\Users\User\AppData\Local\Temp, TMP=C:\Users\User\AppData\Local\Temp, USERDOMAIN=User-TOSH, USERNAME=User, USERPROFILE=C:\Users\User, WINDIR=C:\windows, WINDOWS_TRACING_FLAGS=3, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log, WV_GATEWAY_CFG=C:\orant\listener\cfg\wdbsvr.app]
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getHost
                CONFIG: Host having instnces running for database prod3 : User-TOSH
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager setParam
                CONFIG: Setting param: REP_DB_RUNNING_HOST value: User-TOSH
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.ParamsManager getRepDbPort
                CONFIG: Listener Port: 1521
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                CONFIG: isLocalConnectionRequired: true
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine connecting with SID: prod3, oracleHome: C:\app\User\product\11.2.0\dbhome_1, and user: SYS
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                CONFIG: SQLEngine created successfully and connected
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig createRepository
                CONFIG: Spooling to C:\app\User\cfgtoollogs\emca\prod3\emca_repos_create_2012_09_19_10_27_05.log
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig createRepository
                INFO: Creating the EM repository (this may take a while) ...
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig createRepository
                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:1655)
                     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1005)
                     at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
                     at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)
                     at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:511)
                     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:229)
                     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
                     at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                     at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
                     at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
                     at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
                     at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig invoke
                SEVERE: Error creating the repository
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMReposConfig invoke
                INFO: Refer to the log file at C:\app\User\cfgtoollogs\emca\prod3\emca_repos_create_<date>.log for more details.
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMConfig perform
                SEVERE: Error creating the repository
                Refer to the log file at C:\app\User\cfgtoollogs\emca\prod3\emca_2012_09_19_10_25_36.log for more details.
                Sep 19, 2012 10:27:05 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:241)
                     at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
                     at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                     at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
                     at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
                     at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
                     at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
                Sep 19, 2012 10:27:05 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
                CONFIG: Restoring oracle.installer.oui_loc to C:\app\User\product\11.2.0\dbhome_1\oui
                • 5. Re: EM configuration issue
                  Osama_Mustafa
                  try to do the following please

                  Are you passing the port parameter ????

                  also do the following step please to make sure all thing is right :

                  *1-In your local users and groups add User to ORA_DBA group.*
                  *2-Set ORACLE_HOME and ORACLE_SID, and re-try the install.*
                  *3-Sqlplus / as sysdba*
                  @$ORACLE_HOME/rdbms/admin/dbmspool.sql
                  SQL> @$ORACLE_HOME/rdbms/admin/prvtpool.plb
                  *4. Grant execution privilege on the package:*
                  SQL> grant execute on dbms_shared_pool to sysman;
                  SQL> grant execute on dbms_shared_pool to dba;
                  *5- you need to repeat above steps*

                  Thank you
                  Osama Mustafa
                  1 person found this helpful
                  • 6. Re: EM configuration issue
                    Fran
                    maybe this is a bit late to share this link but please take a look of this:
                    http://docs.oracle.com/cd/E17559_01/install.111/e16847/appdx_repmgr.htm
                    1 person found this helpful
                    • 7. Re: EM configuration issue
                      yoonas
                      Hi,

                      The drop of repo was not successfull it seems. why don't you try to drop properly then continue with recreation.

                      regards
                      • 8. Re: EM configuration issue
                        951027
                        @mustafa, I am using windows 7 home premium, and the local groups and users feature is unavailable
                        will this make a difference?


                        Thanks
                        • 9. Re: EM configuration issue
                          Osama_Mustafa
                          the most important thing , the user who will install database have insufficient privilege
                          1 person found this helpful
                          • 10. Re: EM configuration issue
                            yoonas
                            Hi,

                            if you want to check the user group check it with net user <username>

                            Regards
                            • 11. Re: EM configuration issue
                              951027
                              hi thanks, this time i opened my cmd using run as administrator and tried dropping and it worked.

                              Then created and im able to log in to OEM yipee :) thanks a ton


                              C:\windows\system32>emca -deconfig dbcontrol db -repos drop

                              STARTED EMCA at Sep 19, 2012 1:47:41 PM
                              EM Configuration Assistant, Version 11.2.0.0.2 Production
                              Copyright (c) 2003, 2005, Oracle. All rights reserved.

                              Enter the following information:
                              Database SID: prod3
                              Listener port number: 1521
                              Password for SYS user:
                              Password for SYSMAN user:
                              Password for SYSMAN user:
                              Do you wish to continue? [yes(Y)/no(N)]: Y
                              Sep 19, 2012 1:47:57 PM oracle.sysman.emcp.EMConfig perform
                              INFO: This operation is being logged at C:\app\User\cfgtoollogs\emca\prod3\emca
                              _2012_09_19_13_47_41.log.
                              Sep 19, 2012 1:47:57 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
                              INFO: Stopping Database Control (this may take a while) ...
                              Sep 19, 2012 1:47:58 PM oracle.sysman.emcp.EMReposConfig invoke
                              INFO: Dropping the EM repository (this may take a while) ...
                              Sep 19, 2012 1:51:35 PM oracle.sysman.emcp.EMReposConfig invoke
                              INFO: Repository successfully dropped
                              Enterprise Manager configuration completed successfully
                              FINISHED EMCA at Sep 19, 2012 1:51:38 PM



                              C:\windows\system32>emca -config dbcontrol db -repos create

                              STARTED EMCA at Sep 19, 2012 2:06:48 PM
                              EM Configuration Assistant, Version 11.2.0.0.2 Production
                              Copyright (c) 2003, 2005, Oracle. All rights reserved.

                              Enter the following information:
                              Database SID: prod3
                              Listener port number: 1521
                              Listener ORACLE_HOME [ C:\app\User\product\11.2.0\dbhome_1 ]:
                              Password for SYS user:
                              Password for DBSNMP user:
                              Password for SYSMAN user:
                              Password for SYSMAN user: Email address for notifications (optional):
                              Outgoing Mail (SMTP) server for notifications (optional):
                              -----------------------------------------------------------------

                              You have specified the following settings

                              Database ORACLE_HOME ................ C:\app\User\product\11.2.0\dbhome_1

                              Local hostname ................ User-TOSH
                              Listener ORACLE_HOME ................ C:\app\User\product\11.2.0\dbhome_1
                              Listener port number ................ 1521
                              Database SID ................ prod3
                              Email address for notifications ...............
                              Outgoing Mail (SMTP) server for notifications ...............

                              -----------------------------------------------------------------
                              Do you wish to continue? [yes(Y)/no(N)]: Y
                              Sep 19, 2012 2:07:19 PM oracle.sysman.emcp.EMConfig perform
                              INFO: This operation is being logged at C:\app\User\cfgtoollogs\emca\prod3\emca
                              _2012_09_19_14_06_48.log.
                              Sep 19, 2012 2:07:20 PM oracle.sysman.emcp.EMReposConfig createRepository
                              INFO: Creating the EM repository (this may take a while) ...
                              Sep 19, 2012 2:13:00 PM oracle.sysman.emcp.EMReposConfig invoke
                              INFO: Repository successfully created
                              Sep 19, 2012 2:13:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepos
                              itory
                              INFO: Uploading configuration data to EM repository (this may take a while) ...
                              Sep 19, 2012 2:13:35 PM oracle.sysman.emcp.EMReposConfig invoke
                              INFO: Uploaded configuration data successfully
                              Sep 19, 2012 2:13:39 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareL
                              ib
                              INFO: Software library configured successfully.
                              Sep 19, 2012 2:13:39 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibra
                              ry
                              INFO: Deploying Provisioning archives ...
                              Sep 19, 2012 2:14:01 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibra
                              ry
                              INFO: Provisioning archives deployed successfully.
                              Sep 19, 2012 2:14:01 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
                              INFO: Securing Database Control (this may take a while) ...
                              Sep 19, 2012 2:14:10 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
                              INFO: Database Control secured successfully.
                              Sep 19, 2012 2:14:10 PM oracle.sysman.emcp.util.DBControlUtil startOMS
                              INFO: Starting Database Control (this may take a while) ...
                              Sep 19, 2012 2:15:06 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
                              INFO: Database Control started successfully
                              Sep 19, 2012 2:15:06 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
                              INFO: >>>>>>>>>>> The Database Control URL is https://User-TOSH:5500/em <<<<<<<
                              <<<<
                              Sep 19, 2012 2:15:08 PM oracle.sysman.emcp.EMDBPostConfig invoke
                              WARNING:
                              ************************ WARNING ************************

                              Management Repository has been placed in secure mode wherein Enterprise Manager
                              data will be encrypted. The encryption key has been placed in the file: C:/app/
                              User/product/11.2.0/dbhome_1/User-TOSH_prod3/sysman/config/emkey.ora. Please
                              ensure this file is backed up as the encrypted data will become unusable if thi
                              s file is lost.

                              ***********************************************************
                              Enterprise Manager configuration completed successfully
                              FINISHED EMCA at Sep 19, 2012 2:15:08 PM

                              C:\windows\system32>emctl status
                              Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                              Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
                              Oracle Enterprise Manager 10g Database Control commands:
                              emctl start | stop dbconsole
                              emctl status | secure | setpasswd dbconsole
                              emctl config dbconsole -heap_size <size_value> -max_perm_size <size_valu
                              e>
                              emctl status agent
                              emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-
                              port>/em/*>]
                              emctl getversion
                              emctl reload | upload | clearstate | getversion agent
                              emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
                              emctl config agent <options>
                              emctl config agent updateTZ
                              emctl config agent getTZ
                              emctl resetTZ agent
                              emctl config agent credentials [<Target_name>[:<Target_Type>]]
                              emctl gensudoprops
                              emctl clearsudoprops
                              Blackout Usage :
                              emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_
                              Type>]].... [-d <Duration>]
                              emctl stop blackout <Blackoutname>
                              emctl status blackout [<Target_name>[:<Target_Type>]]....

                              The following are valid options for blackouts
                              <Target_name:Target_type> defaults to local node target if not specified.
                              If -nodeLevel is specified after <Blackoutname>,the blackout will be applied to
                              all targets and any target list that follows will be ignored.
                              Duration is specified in [days] hh:mm

                              emctl getemhome
                              emctl ilint
                              Em Key Commands Usage :
                              emctl config emkey -emkeyfile <emkey.ora path> [-force] [-sysman_pwd <sysman pas
                              sword>]
                              emctl config emkey -emkey [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <s
                              ysman password>]
                              emctl config emkey -repos [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <s
                              ysman password>]
                              emctl config emkey -remove_from_repos [-sysman_pwd <sysman password>]
                              emctl config emkey -copy_to_repos [-sysman_pwd <sysman password>]
                              emctl status emkey [-sysman_pwd <sysman password>]

                              Secure DBConsole Usage :
                              emctl secure dbconsole -sysman_pwd <sysman password> [-passwd_file <abs file loc
                              ]
                              [-host <slb hostname>] [-sid <service name>] [-reset] [-secure_port <sec
                              ure_port>]
                              [-root_dc <root_dc>] [-root_country <root_country>] [-root_state <root_s
                              tate>] [-root_loc <root_loc>]
                              [-root_org <root_org>] [-root_unit <root_unit>] [-root_email <root_email
                              ]
                              [-wallet <wallet loc>] [-wallet_pwd <wallet pwd>] [-trust_certs_loc <cer
                              ts loc>]
                              emctl secure status dbconsole
                              Register Targettype Usage :
                              emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <
                              rep passwd> <rep host> <rep port> <rep sid> OR
                              emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <
                              rep passwd> <rep connect descriptor>


                              C:\windows\system32>emctl status dbconsole
                              Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                              Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
                              https://User-TOSH:5500/em/console/aboutApplication
                              Oracle Enterprise Manager 11g is running.
                              ------------------------------------------------------------------
                              Logs are generated in directory C:\app\User\product\11.2.0\dbhome_1/User-TOSH_
                              prod3/sysman/log
                              • 12. Re: EM configuration issue
                                951027
                                C:\Users\User>net user User
                                User name User
                                Full Name Toshiba
                                Comment
                                User's comment
                                Country code 000 (System Default)
                                Account active Yes
                                Account expires Never

                                Password last set 14-Jul-12 1:45:26 AM
                                Password expires Never
                                Password changeable 14-Jul-12 1:45:26 AM
                                Password required No
                                User may change password Yes

                                Workstations allowed All
                                Logon script
                                User profile
                                Home directory
                                Last logon 19-Sep-12 1:28:47 PM

                                Logon hours allowed All

                                Local Group Memberships Administrators       ora_dba
                                Global Group memberships *None
                                The command completed successfully.
                                • 13. Re: EM configuration issue
                                  951027
                                  how to add the privileges then?
                                  • 14. Re: EM configuration issue
                                    yoonas
                                    NET LOCALGROUP [group name1 [name2 ...] {ADD | /DELETE}
                                    1 2 Previous Next