8 Replies Latest reply on Jan 31, 2013 12:19 PM by Osama_Mustafa

    Database Status

    983161
      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
          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
            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
              $ORACLE_HOME, $ORACLE_SID set properly? lsnrctl status?
              what em logs said?

              A trick would be:
              ./runInstaller -ORACLE_HOSTNAME=yourhostname.yourdomain
              • 5. Re: Database Status
                Aman....
                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
                  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
                    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
                      Caused by: java.io.FileNotFoundException ..... (Access is denied)
                      did you install database successfully ?