Hi, I'm having problem starting the EM Console.
This is the output of the "emctl start dbconsole" command:
Oracle Enterprise Manager 11g Da
tabase Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://evort-01:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ............................................................................................. failed.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/evort-01_EVORT/sysman/log
Here is the emagent.log:
2016-04-05 10:54:47,436 Thread-1035306752 Starting Agent 10.2.0.4.4 from /u01/app/oracle/product/11.2.0/dbhome_1 (00701)
2016-04-05 10:54:47,518 Thread-1035306752 Undefined column name __intervalONNECT_DATA in expression ((gc_cr_recv < _gc_cr_recv) ? 0 : (gc_cr_recv - _gc_cr_recv))/__intervalONNECT_DATA=(SID=%SID%)))
(00104)
2016-04-05 10:54:47,519 Thread-1035306752 Undefined column name __intervalCT_DATA in expression ((gc_cur_recv < _gc_cur_recv) ? 0 : (gc_cur_recv - _gc_cur_recv))/__intervalCT_DATA=(SID=%SID%)))
(00104)
2016-04-05 10:54:47,519 Thread-1035306752 Undefined column name __intervalrvalCT_DATA in expression ((gc_cr_serv < _gc_cr_serv) ? 0 : (gc_cr_serv - _gc_cr_serv))/__intervalrvalCT_DATA=(SID=%SID%)))
(00104)
2016-04-05 10:54:47,519 Thread-1035306752 Undefined column name __intervalCT_DATA in expression ((gc_cur_serv < _gc_cur_serv) ? 0 : (gc_cur_serv - _gc_cur_serv))/__intervalCT_DATA=(SID=%SID%)))
(00104)
2016-04-05 10:54:47,519 Thread-1035306752 Undefined column name __intervalATA in expression ((msg_sent_dir < _msg_sent_dir) ? 0 : (msg_sent_dir - _msg_sent_dir))/__intervalATA=(SID=%SID%)))
(00104)
2016-04-05 10:54:47,519 Thread-1035306752 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/__intervalinterval=%SID%)))
(00104)
2016-04-05 10:54:47,594 Thread-1035306752 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
2016-04-05 10:54:54,977 Thread-1035306752 EMAgent started successfully (00702)
And here is the emagent.trc:
2016-04-05 10:54:36,275 Thread-1219000352 WARN http: nmehl_httpListener: signaled to exit from emctl
2016-04-05 10:54:37,275 Thread-1219000352 WARN : Signalled to Exit Normally. Signaled to exit from emctl
2016-04-05 10:54:47,437 Thread-1035306752 WARN http: nmehl_connect_internal: connect failed to (evort-01:1158): Connection refused (error = 111)
2016-04-05 10:54:47,437 Thread-1035306752 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://evort-01:1158/em/upload/: retStatus=-1
2016-04-05 10:54:47,438 Thread-1035306752 WARN command: Job Subsystem Timeout set at 600 seconds
2016-04-05 10:54:47,441 Thread-1035306752 WARN upload: Upload manager has no Failure script: disabled
2016-04-05 10:54:47,455 Thread-1035306752 WARN metadata: Metric VirtualHosts does not have any data columns
2016-04-05 10:54:47,517 Thread-1035306752 WARN metadata: Metric hung_system_traces does not have any data columns
2016-04-05 10:54:47,674 Thread-921212960 WARN vpxoci: OCI Error -- ErrorCode(1031): ORA-01031: insufficient privileges
SQL = " OCISessionBegin"...
LOGIN = ASMSNMP/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=evort-01-vip)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2016-04-05 10:54:47,674 Thread-921212960 ERROR vpxoci: ORA-01031: insufficient privileges
2016-04-05 10:54:47,674 Thread-921212960 WARN vpxoci: Login 0xdc001650 failed, error=ORA-01031: insufficient privileges
2016-04-05 10:54:47,674 Thread-921212960 WARN TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },Config::ORA-01031: insufficient privileges
2016-04-05 10:54:47,704 Thread-921212960 WARN vpxoci: OCI Error -- ErrorCode(1031): ORA-01031: insufficient privileges
SQL = " OCISessionBegin"...
LOGIN = ASMSNMP/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=evort-01-vip)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2016-04-05 10:54:47,704 Thread-921212960 ERROR vpxoci: ORA-01031: insufficient privileges
2016-04-05 10:54:47,704 Thread-921212960 WARN vpxoci: Login 0xdc0009c0 failed, error=ORA-01031: insufficient privileges
2016-04-05 10:54:47,704 Thread-921212960 WARN TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },GetDumpDestination::ORA-01031: insufficient privileges
2016-04-05 10:54:47,704 Thread-921212960 WARN engine: Missing Properties : [background_dump_dest]
2016-04-05 10:54:47,704 Thread-921212960 WARN TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },DeduceAlertLogFile::Missing Properties : [background_dump_dest]
2016-04-05 10:54:47,744 Thread-921212960 WARN vpxoci: OCI Error -- ErrorCode(1031): ORA-01031: insufficient privileges
SQL = " OCISessionBegin"...
LOGIN = ASMSNMP/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=evort-01-vip)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2016-04-05 10:54:47,745 Thread-921212960 ERROR vpxoci: ORA-01031: insufficient privileges
2016-04-05 10:54:47,745 Thread-921212960 WARN vpxoci: Login 0xdc000bd0 failed, error=ORA-01031: insufficient privileges
2016-04-05 10:54:47,745 Thread-921212960 WARN TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },RacLocknamespaceMemberInfo::ORA-01031: insufficient privileges
2016-04-05 10:54:47,752 Thread-927852576 WARN TargetManager: The execution of the query for dyn_from_instance in {EVORT, rac_database} is missing the following required property values : DBName;InstanceName;TimeFormat;Version;TimedStatistics;OpenMode;CPUTimingEnabled;StatisticsLevel;VersionBanner
2016-04-05 10:54:47,778 Thread-921212960 WARN vpxoci: OCI Error -- ErrorCode(1031): ORA-01031: insufficient privileges
SQL = " OCISessionBegin"...
LOGIN = ASMSNMP/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=evort-01-vip)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2016-04-05 10:54:47,778 Thread-921212960 ERROR vpxoci: ORA-01031: insufficient privileges
2016-04-05 10:54:47,778 Thread-921212960 WARN vpxoci: Login 0xdc0015e0 failed, error=ORA-01031: insufficient privileges
2016-04-05 10:54:47,778 Thread-921212960 WARN TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },RacClusterMemberInfo::ORA-01031: insufficient privileges
2016-04-05 10:54:47,808 Thread-921212960 WARN vpxoci: OCI Error -- ErrorCode(1031): ORA-01031: insufficient privileges
SQL = " OCISessionBegin"...
LOGIN = ASMSNMP/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=evort-01-vip)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2016-04-05 10:54:47,808 Thread-921212960 ERROR vpxoci: ORA-01031: insufficient privileges
2016-04-05 10:54:47,809 Thread-921212960 WARN vpxoci: Login 0xdc000a20 failed, error=ORA-01031: insufficient privileges
2016-04-05 10:54:47,809 Thread-921212960 WARN TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },GetDBVersion::ORA-01031: insufficient privileges
2016-04-05 10:54:47,809 Thread-921212960 WARN engine: Missing Properties : [Version]
2016-04-05 10:54:47,809 Thread-921212960 ERROR TargetManager: Exception in computing dynamic properties of {+ASM1_evort-01, osm_instance },ComputeVC::Missing Properties : [Version] - skipping category property
2016-04-05 10:54:47,809 Thread-925837344 ERROR TargetManager: nmeetm.c : Target +ASM1_evort-01 has a failed critical dynamic property
^X2016-04-05 10:54:54,933 Thread-1035306752 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2016-04-05 10:54:54,935 Thread-1035306752 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2016-04-05 10:54:54,967 Thread-1035306752 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2016-04-05 10:54:54,969 Thread-1035306752 WARN collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2016-04-05 10:54:54,977 Thread-925837344 WARN http: nmehl_connect_internal: connect failed to (evort-01:1158): Connection refused (error = 111)
2016-04-05 10:54:54,977 Thread-925837344 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://evort-01:1158/em/upload/: retStatus=-1
2016-04-05 10:54:54,978 Thread-925837344 WARN http: nmehl_connect_internal: connect failed to (evort-01:1158): Connection refused (error = 111)
2016-04-05 10:54:54,978 Thread-925837344 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://evort-01:1158/em/upload/: retStatus=-1
2016-04-05 10:54:55,344 Thread-929867808 WARN recvlets.aq: no matching registered alert type for instance_efficiency.pxdwngrd_ps
2016-04-05 10:54:55,345 Thread-929867808 WARN recvlets.aq: no matching registered alert type for instance_efficiency.pxdwngrdserial_pt
2016-04-05 10:54:55,351 Thread-929867808 WARN recvlets.aq: no matching registered alert type for wait_bottlenecks.userio_wait_cnt
2016-04-05 10:54:55,351 Thread-929867808 WARN recvlets.aq: no matching registered alert type for wait_bottlenecks.other_wait_cnt
2016-04-05 10:54:55,440 Thread-932169760 WARN http: nmehl_connect_internal: connect failed to (evort-01:1158): Connection refused (error = 111)
2016-04-05 10:54:55,440 Thread-932169760 ERROR command: nmejcn: failed http connection to https://evort-01:1158/em/upload/: retStatus=-1
2016-04-05 10:54:57,440 Thread-932169760 WARN http: nmehl_connect_internal: connect failed to (evort-01:1158): Connection refused (error = 111)
2016-04-05 10:54:57,440 Thread-932169760 ERROR command: nmejcn: failed http connection to https://evort-01:1158/em/upload/: retStatus=-1
When I try to access the console through the browser via the url https://evort-01:1158/em I recevie the "error loading the page" message.
Can you please drive on on what to check?
Thanks in advance,
Samuel