Hi,
I have a problem trying to connect to enterprise manager, the message shows that the Oracle Enterprise Manager is active, when trying to connect from any browser (Internet Explorer), the page is not available. As I can solve this problem ..?
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://server20:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
Link to download the file to contain the trace:
https://rapidshare.com/files/3681783364/error.txt
Part of the Log:
2011-09-25 17:59:15,764 Thread-337 ERROR upload: 3 Failures in a row or XML error for B0000026.xml, retcode = -2, we give up
2011-09-25 17:59:19,768 Thread-338 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 17:59:19,768 Thread-338 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 17:59:19,776 Thread-338 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 17:59:19,776 Thread-338 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 17:59:23,999 Thread-3 WARN http: nmehl_httpListener: signaled to exit from emctl
2011-09-25 17:59:25,000 Thread-3 WARN : Signalled to Exit Normally. Signaled to exit from emctl
2011-09-25 18:00:25,937 Thread-1 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 18:00:25,937 Thread-1 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 18:00:25,941 Thread-1 WARN command: Job Subsystem Timeout set at 600 seconds
2011-09-25 18:00:25,967 Thread-1 WARN upload: Upload manager has no Failure script: disabled
2011-09-25 18:00:26,071 Thread-1 WARN metadata: Metric VirtualHosts does not have any data columns
2011-09-25 18:00:29,225 Thread-1 WARN metadata: Metric hung_system_traces does not have any data columns
2011-09-25 18:00:30,209 Thread-11 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,209 Thread-10 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,209 Thread-13 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,209 Thread-12 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,335 Thread-13 WARN TargetManager: Query returned 0 rows (only one expected) for the dynamic property from_cluster
2011-09-25 18:00:30,335 Thread-13 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,353 Thread-13 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,355 Thread-13 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:30,754 Thread-13 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 18:00:40,115 Thread-12 WARN vpxoci: OCI Error -- ErrorCode(604): ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","SQLA","tmp")
SQL = " OCISessionGet"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server20)(PORT=1522))(CONNECT_DATA=(SID=trans)))
2011-09-25 18:00:40,115 Thread-12 ERROR vpxoci: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","SQLA","tmp")
2011-09-25 18:00:40,116 Thread-12 WARN vpxoci: Login 0x12d5570 failed, error=ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","SQLA","tmp")
2011-09-25 18:00:40,116 Thread-12 ERROR TargetManager: Exception in computing dynamic properties of {trans, oracle_database },decideIncludeDB::ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","SQLA","tmp")
- skipping category property
2011-09-25 19:11:48,023 Thread-11 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 19:11:49,023 Thread-11 ERROR : (nmecmgr.c,3230):Memory 0x0 encountered, expect struct_id=11011
2011-09-25 19:11:49,648 Thread-1 WARN upload: Truncating value of "SHORT_NAME" from "Average Synchronous Single-Block Read Latency (ms)" to "Average Synchronous Single-Block Read La"
2011-09-25 19:11:49,648 Thread-1 WARN upload: Truncating value of "SHORT_NAME" from "Average Synchronous Single-Block Read Latency (ms)" to "Average Synchronous Single-Block Read La"
2011-09-25 19:11:50,494 Thread-1 WARN upload: Truncating value of "COLUMN_LABEL" from "Total messages processed per queue per subscriber per minute in the last interval" to "Total messages processed per queue per subscriber per minute in "
2011-09-25 19:11:50,495 Thread-1 WARN upload: Truncating value of "COLUMN_LABEL" from "Total messages received per queue per subscriber per minute in the last interval" to "Total messages received per queue per subscriber per minute in t"
2011-09-25 19:11:50,495 Thread-1 WARN upload: Truncating value of "COLUMN_LABEL" from "Messages processed per queue (%) per subscriber per minute in the last interval" to "Messages processed per queue (%) per subscriber per minute in th"
2011-09-25 19:11:50,499 Thread-1 WARN upload: Truncating value of "COLUMN_LABEL" from "Age of the first message in persistent queue per subscriber (seconds)" to "Age of the first message in persistent queue per subscriber (sec"
2011-09-25 19:11:50,501 Thread-1 WARN upload: Truncating value of "COLUMN_LABEL" from "Age of the first message in the buffered queue per queue (seconds)" to "Age of the first message in the buffered queue per queue (second"
2011-09-25 19:11:50,861 Thread-1 WARN collector: the column name host_proc_zombie_percnt in this condition does not exist in metric proc_zombie
2011-09-25 19:11:50,872 Thread-1 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2011-09-25 19:11:51,535 Thread-1 WARN collector: the column name host_proc_zombie_percnt in this condition does not exist in metric proc_zombie
2011-09-25 19:11:51,549 Thread-1 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2011-09-25 19:11:53,596 Thread-22 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:11:53,596 Thread-22 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:11:53,598 Thread-22 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:11:53,598 Thread-22 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:11:54,113 Thread-5 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:11:54,113 Thread-5 ERROR command: nmejcn: failed http connection to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:11:56,116 Thread-5 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:11:56,116 Thread-5 ERROR command: nmejcn: failed http connection to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:12:00,118 Thread-5 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:12:00,118 Thread-5 ERROR command: nmejcn: failed http connection to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:12:30,880 Thread-35 WARN collector: the column name host_proc_zombie_percnt in this condition does not exist in metric proc_zombie
2011-09-25 19:12:30,887 Thread-35 WARN collector: the column name host_proc_zombie_percnt in this condition does not exist in metric proc_zombie
2011-09-25 19:12:30,912 Thread-35 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2011-09-25 19:12:30,948 Thread-35 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2011-09-25 19:12:31,013 Thread-35 ERROR recvlets.aq: duplicate registration of metric instance_throughput for target trans oracle_database
2011-09-25 19:12:31,013 Thread-35 ERROR recvlets.aq: Unable to add metric instance_throughput to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,013 Thread-35 ERROR recvlets: Error adding metric instance_throughput, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,014 Thread-35 ERROR recvlets.aq: duplicate registration of metric wait_bottlenecks for target trans oracle_database
2011-09-25 19:12:31,014 Thread-35 ERROR recvlets.aq: Unable to add metric wait_bottlenecks to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,014 Thread-35 ERROR recvlets: Error adding metric wait_bottlenecks, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,015 Thread-35 ERROR recvlets.aq: duplicate registration of metric file for target trans oracle_database
2011-09-25 19:12:31,015 Thread-35 ERROR recvlets.aq: Unable to add metric file to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,015 Thread-35 ERROR recvlets: Error adding metric file, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,015 Thread-35 ERROR recvlets.aq: duplicate registration of metric service for target trans oracle_database
2011-09-25 19:12:31,016 Thread-35 ERROR recvlets.aq: Unable to add metric service to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,016 Thread-35 ERROR recvlets: Error adding metric service, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,016 Thread-35 ERROR recvlets.aq: duplicate registration of metric system_response_time_per_call for target trans oracle_database
2011-09-25 19:12:31,016 Thread-35 ERROR recvlets.aq: Unable to add metric system_response_time_per_call to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,017 Thread-35 ERROR recvlets: Error adding metric system_response_time_per_call, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,017 Thread-35 ERROR recvlets.aq: duplicate registration of metric Database_Resource_Usage for target trans oracle_database
2011-09-25 19:12:31,017 Thread-35 ERROR recvlets.aq: Unable to add metric Database_Resource_Usage to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,017 Thread-35 ERROR recvlets: Error adding metric Database_Resource_Usage, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,018 Thread-35 ERROR recvlets.aq: duplicate registration of metric instance_efficiency for target trans oracle_database
2011-09-25 19:12:31,018 Thread-35 ERROR recvlets.aq: Unable to add metric instance_efficiency to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,018 Thread-35 ERROR recvlets: Error adding metric instance_efficiency, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,019 Thread-35 ERROR recvlets.aq: duplicate registration of metric wait_sess_cls for target trans oracle_database
2011-09-25 19:12:31,019 Thread-35 ERROR recvlets.aq: Unable to add metric wait_sess_cls to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,019 Thread-35 ERROR recvlets: Error adding metric wait_sess_cls, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,020 Thread-35 ERROR recvlets.aq: duplicate registration of metric UserBlock for target trans oracle_database
2011-09-25 19:12:31,020 Thread-35 ERROR recvlets.aq: Unable to add metric UserBlock to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,020 Thread-35 ERROR recvlets: Error adding metric UserBlock, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,020 Thread-35 ERROR recvlets.aq: duplicate registration of metric sga_pool_wastage for target trans oracle_database
2011-09-25 19:12:31,021 Thread-35 ERROR recvlets.aq: Unable to add metric sga_pool_wastage to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,021 Thread-35 ERROR recvlets: Error adding metric sga_pool_wastage, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,022 Thread-35 ERROR recvlets.aq: duplicate registration of metric streams_pool for target trans oracle_database
2011-09-25 19:12:31,022 Thread-35 ERROR recvlets.aq: Unable to add metric streams_pool to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,022 Thread-35 ERROR recvlets: Error adding metric streams_pool, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,023 Thread-35 ERROR recvlets.aq: duplicate registration of metric problemTbsp for target trans oracle_database
2011-09-25 19:12:31,023 Thread-35 ERROR recvlets.aq: Unable to add metric problemTbsp to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,023 Thread-35 ERROR recvlets: Error adding metric problemTbsp, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,024 Thread-35 ERROR recvlets.aq: duplicate registration of metric Suspended_Session for target trans oracle_database
2011-09-25 19:12:31,024 Thread-35 ERROR recvlets.aq: Unable to add metric Suspended_Session to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,025 Thread-35 ERROR recvlets: Error adding metric Suspended_Session, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,025 Thread-35 ERROR recvlets.aq: duplicate registration of metric Recovery_Area for target trans oracle_database
2011-09-25 19:12:31,025 Thread-35 ERROR recvlets.aq: Unable to add metric Recovery_Area to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,025 Thread-35 ERROR recvlets: Error adding metric Recovery_Area, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,026 Thread-35 ERROR recvlets.aq: duplicate registration of metric Snap_Shot_Too_Old for target trans oracle_database
2011-09-25 19:12:31,026 Thread-35 ERROR recvlets.aq: Unable to add metric Snap_Shot_Too_Old to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,026 Thread-35 ERROR recvlets: Error adding metric Snap_Shot_Too_Old, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,029 Thread-35 ERROR recvlets.aq: duplicate registration of metric WCR for target trans oracle_database
2011-09-25 19:12:31,029 Thread-35 ERROR recvlets.aq: Unable to add metric WCR to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,029 Thread-35 ERROR recvlets: Error adding metric WCR, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,030 Thread-35 ERROR recvlets.aq: duplicate registration of metric wrc_client for target trans oracle_database
2011-09-25 19:12:31,030 Thread-35 ERROR recvlets.aq: Unable to add metric wrc_client to AQDatabase [oracle_database trans] for oracle_database trans
2011-09-25 19:12:31,030 Thread-35 ERROR recvlets: Error adding metric wrc_client, target trans oracle_database, to recvlet AQMetrics
2011-09-25 19:12:31,044 Thread-35 WARN upload: Upload manager has no Failure script: disabled
2011-09-25 19:12:36,200 Thread-41 WARN recvlets.aq: no matching registered alert type for instance_efficiency.pxdwngrd_ps
2011-09-25 19:12:36,203 Thread-41 WARN recvlets.aq: no matching registered alert type for instance_efficiency.pxdwngrdserial_pt
2011-09-25 19:12:36,216 Thread-41 WARN recvlets.aq: no matching registered alert type for wait_bottlenecks.userio_wait_cnt
2011-09-25 19:12:36,216 Thread-41 WARN recvlets.aq: no matching registered alert type for wait_bottlenecks.other_wait_cnt
2011-09-25 19:12:36,590 Thread-41 WARN recvlets.aq: no matching registered alert type for instance_efficiency.pxdwngrd_ps
2011-09-25 19:12:36,593 Thread-41 WARN recvlets.aq: no matching registered alert type for instance_efficiency.pxdwngrdserial_pt
2011-09-25 19:12:36,606 Thread-41 WARN recvlets.aq: no matching registered alert type for wait_bottlenecks.userio_wait_cnt
2011-09-25 19:12:36,607 Thread-41 WARN recvlets.aq: no matching registered alert type for wait_bottlenecks.other_wait_cnt
2011-09-25 19:12:53,682 Thread-36 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
2011-09-25 19:12:53,682 Thread-36 ERROR ssl: nzos_Handshake failed, ret=28862
2011-09-25 19:12:53,683 Thread-36 ERROR http: 13: Unable to initialize ssl connection with server, aborting connection attempt
2011-09-25 19:12:53,683 Thread-36 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:14:16,164 Thread-85 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2011-09-25 19:14:16,193 Thread-85 ERROR : (nmevrr.c,328):Memory 0x0 encountered, expect struct_id=12201
2011-09-25 19:14:16,194 Thread-85 ERROR : (nmevrr.c,328):Memory 0x0 encountered, expect struct_id=12201
2011-09-25 19:14:20,541 Thread-41 ERROR recvlets: Recvlet AQMetrics reported invalid column pxdwngrd99_ps for trans oracle_database instance_efficiency
2011-09-25 19:14:20,541 Thread-41 ERROR recvlets.aq: Failed (-1) to report clear severity on instance_efficiency.pxdwngrd99_ps [] for oracle_database trans
2011-09-25 19:14:20,600 Thread-85 ERROR : (nmevrr.c,328):Memory 0x0 encountered, expect struct_id=12201
2011-09-25 19:14:20,600 Thread-85 ERROR : (nmevrr.c,328):Memory 0x0 encountered, expect struct_id=12201
2011-09-25 19:14:20,600 Thread-85 ERROR : (nmevrr.c,328):Memory 0x0 encountered, expect struct_id=12201
2011-09-25 19:14:20,600 Thread-85 ERROR : (nmevrr.c,328):Memory 0x0 encountered, expect struct_id=12201
2011-09-25 19:14:21,526 Thread-86 ERROR fetchlets.os: Process stderr = em_error= Invalid number of arguments passed
2011-09-25 19:14:21,527 Thread-86 ERROR engine: [oracle_database,trans,pwd_expiry] : nmeegd_GetMetricData failed : em_error= Invalid number of arguments passed
2011-09-25 19:14:21,527 Thread-86 WARN collector: <nmecmc.c> Error exit. Error message: em_error= Invalid number of arguments passed
2011-09-25 19:24:54,422 Thread-225 WARN vpxoci: OCI Error -- ErrorCode(1722): ORA-01722: invalid number
SQL = "/* OracleOEM */
SELECT /*+ INDEX(ts) */
o.object_type, u.name, o.object_name"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server20)(PORT=1522))(CONNECT_DATA=(SID=trans)))
2011-09-25 19:24:54,422 Thread-225 WARN vpxoci: OCI Error -- ErrorCode(1722): ORA-01722: invalid number
SQL = "/* OracleOEM */
SELECT /*+ INDEX(ts) */
o.object_type, u.name, o.object_name"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server20)(PORT=1522))(CONNECT_DATA=(SID=trans)))
2011-09-25 19:36:02,961 Thread-353 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:36:02,961 Thread-353 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:36:02,963 Thread-353 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:36:02,963 Thread-353 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:36:32,967 Thread-356 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:36:32,967 Thread-356 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:36:32,969 Thread-356 WARN http: nmehl_connect_internal: connect failed to (server20:1158): Connection refused (error = 146)
2011-09-25 19:36:32,969 Thread-356 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://server20:1158/em/upload/: retStatus=-1
2011-09-25 19:36:44,742 Thread-3 WARN http: nmehl_httpListener: signaled to exit from emctl
2011-09-25 19:36:45,743 Thread-3 WARN : Signalled to Exit Normally. Signaled to exit from emctl
Thanks