1 2 Previous Next 26 Replies Latest reply: Jan 31, 2013 7:46 AM by Osama_Mustafa RSS

    EMCTL not working properly

    983161
      Hi,

      I am using oracle 11.2.0 database

      while i am executing "emctl" command the status will be

      EM Configuration issue. <DB_HOME>\app\product\11.2.0\dbhome/<hostname> not found.

      Thanks,
      praveen
        • 1. Re: EMCTL not working properly
          Fran
          duplicated thread:
          Re: Database Status
          • 2. Re: EMCTL not working properly
            Osama_Mustafa
            re configure the dbconsole using
            export ORACLE_HOME=
            export ORACLE_SID=
            emca -deconfig dbcontrol db -repos drop
            emca -config dbcontrol db -repos create 
            • 3. Re: EMCTL not working properly
              983161
              My Log file

              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
              CONFIG: Setting oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
              CONFIG: isHAInstalled: false
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag '-migrate' set to false
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateFromDBControl' set to false
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateToCentralAgent' set to false
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateFromCentralAgent' set to false
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'migrateToDBControl' set to false
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag '-deconfig' set to true
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'dbcontrol' set to true
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'drop' set to true
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: ORACLE_HOME value: E:\app\praveen\product\11.2.0\dbhome
              Jan 31, 2013 3:40:34 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Jan 31, 2013 3:40:35 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
              CONFIG: isHAInstalled: false
              Jan 31, 2013 3:40:35 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:35 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SID.
              Jan 31, 2013 3:40:38 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SID value: orcl
              Jan 31, 2013 3:40:41 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: PORT value: 1521
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SYS_PWD.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SERVICE_NAME.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ASM_OH.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter REP_DB_RUNNING_HOST.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database null : praveen-PC
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SYSMAN_PWD.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYS
              Jan 31, 2013 3:40:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:47 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value:
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value: yes
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter LOG_FILE.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig addEMCALogFile
              CONFIG: ORACLE_BASE :E:\app\praveen
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database null : praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SERVICE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYS
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig perform
              INFO: This operation is being logged at E:\app\praveen\cfgtoollogs\emca\orcl\emca_2013_01_31_15_40_34.log.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: EM_HOME value: E:\app\praveen\product\11.2.0\dbhome
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database orcl : praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SERVICE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYS
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database orcl : praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYS
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
              CONFIG: No Database unique name available. Will try to retrieve it from DB itself
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ASM_OH.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database orcl : praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYS
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
              CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database orcl : praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYS
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
              CONFIG: isHAInstalled: false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
              CONFIG: Sid: orcl Host: praveen-PC Node: null OH: E:\app\praveen\product\11.2.0\dbhome agentHome: null isCentral: false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
              CONFIG: Sid: orcl Host: praveen-PC Node: null OH: E:\app\praveen\product\11.2.0\dbhome isDBC: false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
              WARNING: EM is not configured for this database. No EM-specific actions can be performed.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
              CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=praveen-PC)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database orcl : praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\praveen\product\11.2.0\dbhome, and user: SYSMAN
              Jan 31, 2013 3:40:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Jan 31, 2013 3:40:52 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
              CONFIG: ORA-12541: TNS:no listener

              oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener

                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
                   at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
                   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)
              Jan 31, 2013 3:40:52 PM oracle.sysman.emcp.EMConfig perform
              SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
              Refer to the log file at E:\app\praveen\cfgtoollogs\emca\orcl\emca_2013_01_31_15_40_34.log for more details.
              Jan 31, 2013 3:40:52 PM oracle.sysman.emcp.EMConfig perform
              CONFIG: Stack Trace:
              oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
                   at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
                   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)
              Jan 31, 2013 3:40:52 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
              • 4. Re: EMCTL not working properly
                Paul R
                oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .

                tried that ?
                • 5. Re: EMCTL not working properly
                  983161
                  Hi,


                  Can u explain clearly


                  Thanks,
                  praveen
                  • 6. Re: EMCTL not working properly
                    Fran
                    He means:

                    ORA-12541: TNS no listener

                    Cause: Listener for the source repository has not been started.

                    Action: Start the Listener on the machine where the source repository resides.

                    set ORACLE_HOME, ORACLE_SID propertly.

                    $ lsnrctl start [listener_name]
                    • 7. Re: EMCTL not working properly
                      983161
                      Hi,

                      After setting Oracle_home and oracle_sid

                      Again I am executing "emctl" command the status will be

                      Same error

                      EM Configuration issue. <DB_HOME>\app\product\11.2.0\dbhome/<hostname> not found.

                      Thanks,
                      praveen
                      • 8. Re: EMCTL not working properly
                        983161
                        Hi,

                        Again i am executing "emctl" command the status will be

                        Same error

                        EM Configuration issue. <DB_HOME>\app\product\11.2.0\dbhome/<hostname> not found.

                        Thanks,
                        praveen
                        • 9. Re: EMCTL not working properly
                          Fran
                          obviously, you forgot one step.

                          $ lsnrctl start
                          • 10. Re: EMCTL not working properly
                            983161
                            No I was done that properly again i am getting same error
                            • 11. Re: EMCTL not working properly
                              Fran
                              post :

                              1.- lsnrctl status
                              2.- echo $ORACLE_HOME and echo $ORACLE_HOME and $ORACLE_UNQNAME
                              3.- after do steps 1 & 2, post again log
                              4.- Mark as answered your other post.
                              • 12. Re: EMCTL not working properly
                                983161
                                My lsnctrl status


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

                                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                                STATUS of the LISTENER
                                ------------------------
                                Alias LISTENER
                                Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
                                ction
                                Start Date 31-JAN-2013 14:28:32
                                Uptime 0 days 1 hr. 50 min. 25 sec
                                Trace Level off
                                Security ON: Local OS Authentication
                                SNMP OFF
                                Listener Parameter File E:\app\praveen\product\11.2.0\dbhome\network\admin\lis
                                tener.ora
                                Listener Log File e:\app\praveen\diag\tnslsnr\praveen-PC\listener\alert\
                                log.xml
                                Listening Endpoints Summary...
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                                Services Summary...
                                Service "CLRExtProc" has 1 instance(s).
                                Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                                Service "orcl" has 1 instance(s).
                                Instance "orcl", status READY, has 1 handler(s) for this service...
                                Service "orclXDB" has 1 instance(s).
                                Instance "orcl", status READY, has 1 handler(s) for this service...
                                The command completed successfully
                                • 13. Re: EMCTL not working properly
                                  Osama_Mustafa
                                  Before start creating your dbconsole did you export ORACLE_HOME, export ORACLE_UNIQUE , export ORACLE_SID
                                  • 14. Re: EMCTL not working properly
                                    983161
                                    Hi,

                                    by doing export Oracle_home

                                    'export' is not a recognised command as an internal command or external command


                                    operable program or batch file.
                                    1 2 Previous Next