This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Jan 31, 2013 5:46 AM by Osama_Mustafa RSS

EMCTL not working properly

983161 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    duplicated thread:
    Re: Database Status
  • 2. Re: EMCTL not working properly
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi,


    Can u explain clearly


    Thanks,
    praveen
  • 6. Re: EMCTL not working properly
    Fran Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    obviously, you forgot one step.

    $ lsnrctl start
  • 10. Re: EMCTL not working properly
    983161 Newbie
    Currently Being Moderated
    No I was done that properly again i am getting same error
  • 11. Re: EMCTL not working properly
    Fran Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Before start creating your dbconsole did you export ORACLE_HOME, export ORACLE_UNIQUE , export ORACLE_SID
  • 14. Re: EMCTL not working properly
    983161 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points