This discussion is archived
8 Replies Latest reply: Jan 31, 2013 4:19 AM by Osama_Mustafa RSS

Database Status

983161 Newbie
Currently Being Moderated
Hi Gurus,

I am using oracle 11g database and


My database status should be "AGENT UNREACHABLE"

help me how can i resolve it

Thanks,
praveen
  • 1. Re: Database Status
    Fran Guru
    Currently Being Moderated
    980158     
          
          
    Handle:      980158  
    Status Level:      Newbie
    Registered:      Jan 6, 2013
    Total Posts:      17
    Total Questions:      9 (9 unresolved)
    close your answered threads marking them as resolved. Keep the forum clean


    with a little search of this forum i saw:
    Agent unreachable (Unrecognized Windows Sockets error: 0: JVM_Bind)
    Agent is Unreachable (REASON = Connection refused) but the host is UP
    OEM - Agent Unreachable
    Agent unreachable
  • 2. Re: Database Status
    983161 Newbie
    Currently Being Moderated
    Hi,

    Thanks for the reply

    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
  • 3. Re: Database Status
    Fran Guru
    Currently Being Moderated
    $ORACLE_HOME, $ORACLE_SID set properly? lsnrctl status?
    what em logs said?

    A trick would be:
    ./runInstaller -ORACLE_HOSTNAME=yourhostname.yourdomain
  • 4. Re: Database Status
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
  • 5. Re: Database Status
    Aman.... Oracle ACE
    Currently Being Moderated
    You didn't bother to tell your o/s informaiton but it seems that you are on Windows and I believe you are using a DHCP based machine too. So if yes, the IP address of the machine is changed and the em repository is not found . If this is correct, set up a static IP and recreate the EM repository.

    Aman....
  • 6. Re: Database Status
    983161 Newbie
    Currently Being Moderated
    Hi,

    Thanks for all replies...........


    My log file error

    Jan 31, 2013 3:45:06 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
    CONFIG: No db domain available. Will query db for db_domain parameter
    Jan 31, 2013 3:45:06 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
    Jan 31, 2013 3:45:06 PM oracle.sysman.emcp.util.FileUtil copyFile
    CONFIG: exception caught in copyFile:
    oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties to E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties.emca.tmp
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
         at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
         at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1247)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Caused by: java.io.FileNotFoundException: E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties.emca.tmp (Access is denied)
         at java.io.FileOutputStream.open(Native Method)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
         ... 11 more
    Jan 31, 2013 3:45:06 PM oracle.sysman.emcp.util.FileUtil backupFile
    WARNING: Could not backup file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties
    Jan 31, 2013 3:45:06 PM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: Stack trace:
    oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties to E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties.emca.tmp
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:625)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
         at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
         at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1247)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Caused by: oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties to E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties.emca.tmp
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
         ... 10 more
    Caused by: java.io.FileNotFoundException: E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties.emca.tmp (Access is denied)
         at java.io.FileOutputStream.open(Native Method)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
         ... 11 more
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil copyFile
    CONFIG: exception caught in copyFile:
    oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties.emca to E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
         at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
         at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1262)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Caused by: java.io.FileNotFoundException: E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties (Access is denied)
         at java.io.FileOutputStream.open(Native Method)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
         ... 11 more
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil backupFile
    WARNING: Could not backup file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties.emca
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: Stack trace:
    oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties.emca to E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:625)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
         at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
         at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1262)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Caused by: oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties.emca to E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
         ... 10 more
    Caused by: java.io.FileNotFoundException: E:\app\praveen\product\11.2.0\dbhome\sysman\config\emoms.properties (Access is denied)
         at java.io.FileOutputStream.open(Native Method)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
         ... 11 more
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil copyFile
    CONFIG: exception caught in copyFile:
    oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml to E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml.emca.tmp
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
         at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
         at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1274)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Caused by: java.io.FileNotFoundException: E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml.emca.tmp (Access is denied)
         at java.io.FileOutputStream.open(Native Method)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
         ... 11 more
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil backupFile
    WARNING: Could not backup file E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: Stack trace:
    oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml to E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml.emca.tmp
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:625)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
         at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
         at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1274)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Caused by: oracle.sysman.emcp.exception.FileUtilException: Copying file E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml to E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml.emca.tmp
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
         at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
         ... 10 more
    Caused by: java.io.FileNotFoundException: E:\app\praveen\product\11.2.0\dbhome\sysman\emd\targets.xml.emca.tmp (Access is denied)
         at java.io.FileOutputStream.open(Native Method)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
         at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
         at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
         ... 11 more
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
    CONFIG: isHAInstalled: false
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 3:45:07 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:45:07 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:45:07 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 3:45:07 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:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter PORTS_FILE.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT.
    Jan 31, 2013 3:45:07 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:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Homes to scan for used ports: [E:\app\praveen\product\11.2.0\dbhome, E:\obisup\oracle_common, E:\obisup\Oracle_BI1]
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME E:\app\praveen\product\11.2.0\dbhome
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: null from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: null from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: null from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: 5540 from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole_localhost_orcl
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: 5520 from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole_localhost_orcl
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: 1158 from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole_localhost_orcl
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: 5540 from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole_praveen-PC_orcl
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: 5520 from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole_praveen-PC_orcl
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: 1158 from E:\app\praveen\product\11.2.0\dbhome\oc4j\j2ee\OC4J_DBConsole_praveen-PC_orcl
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager getAgentPort
    CONFIG: Cannot parse EMD_URL correctly. No port identified
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: null from E:\app\praveen\product\11.2.0\dbhome\sysman\config\emd.properties
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Cannnot parse EMD_URL correctly. No port identified
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME E:\obisup\oracle_common
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil getProperties
    CONFIG: Error reading file E:\obisup\oracle_common\sysman\config\emd.properties
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager getAgentPort
    CONFIG: Cannot parse EMD_URL correctly. No port identified
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: null from E:\obisup\oracle_common\sysman\config\emd.properties
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Cannnot parse EMD_URL correctly. No port identified
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME E:\obisup\Oracle_BI1
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager getAgentPort
    CONFIG: Cannot parse EMD_URL correctly. No port identified
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: null from E:\obisup\Oracle_BI1\sysman\config\emd.properties
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Cannnot parse EMD_URL correctly. No port identified
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.FileUtil getProperties
    CONFIG: Error reading file E:\app\praveen\product\11.2.0\dbhome\install\staticports.ini
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.PortManager getFreePorts
    CONFIG: E:\app\praveen\product\11.2.0\dbhome:praveen-PC:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=3938}
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: AGENT_PORT_praveen-PC value: 3938
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DBCONTROL_HTTP_PORT_praveen-PC value: 5500
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: JMS_PORT_praveen-PC value: 5541
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT_praveen-PC.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: RMI_PORT_praveen-PC value: 5521
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
    CONFIG: Ports assigned for Node: praveen-PC : {DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=3938}
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
    CONFIG: File: E:\app\praveen\product\11.2.0\dbhome\praveen-PC_orcl\sysman\emd\agntstmp.txt:praveen-PC does not exists.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database orcl : praveen-PC
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: praveen-PC
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 3:45:07 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:45:07 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine created successfully and connected
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMReposConfig createRepository
    CONFIG: Spooling to E:\app\praveen\cfgtoollogs\emca\orcl\emca_repos_create_2013_01_31_15_45_07.log
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Jan 31, 2013 3:45:07 PM 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)
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at E:\app\praveen\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at E:\app\praveen\cfgtoollogs\emca\orcl\emca_2013_01_31_15_44_15.log for more details.
    Jan 31, 2013 3:45:07 PM 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)
    Jan 31, 2013 3:45:07 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
    CONFIG: Restoring oracle.installer.oui_loc to E:\app\praveen\product\11.2.0\dbhome\oui
  • 7. Re: Database Status
    Fran Guru
    Currently Being Moderated
    or you close one of the two open thread with the same problem or i will refuse to answer you.

    write answers here, questioned in the other thread don't help to understand your problem
  • 8. Re: Database Status
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Caused by: java.io.FileNotFoundException ..... (Access is denied)
    did you install database successfully ?

Legend

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