llmclaughlin
Programmer
Having a sporadic and unpredictable problem logging into OEM via web browser.The database is up and running not the problem, it's that sometime I can go to the OEM and login and sometimes I can't. I enter username and password and it will just sit there and never leave the login page. When it does this I'll try again using a incorrect password and it will catch the incorrect password immediatialy. Then will try again with correct password and same thing will just stay on login page. I checked the session browser to see what is executing when login button is clicked and it's the below query which appears to be hanging.
SELECT metric_name,
metric_column,
violation_level,
key_value,
key_value2,
MESSAGE
FROM mgmt$alert_current
WHERE target_name = :1
AND target_type = :2
AND metric_name IN
('capture',
'apply',
'propagation',
'streams_latency_throughput',
'apply_queue_buffq',
'capture_queue',
'propagation_msgstate_stats',
'streams_processes_status')
AND violation_level IN (20, 25)
Has anyone encountered this or know a solution?
Thanks
Louie
SELECT metric_name,
metric_column,
violation_level,
key_value,
key_value2,
MESSAGE
FROM mgmt$alert_current
WHERE target_name = :1
AND target_type = :2
AND metric_name IN
('capture',
'apply',
'propagation',
'streams_latency_throughput',
'apply_queue_buffq',
'capture_queue',
'propagation_msgstate_stats',
'streams_processes_status')
AND violation_level IN (20, 25)
Has anyone encountered this or know a solution?
Thanks
Louie
