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

    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
              • 4. Re: Database Status
                Osama_Mustafa
                • 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 ?