Category Archives: OEM12c

Use emcli Command To Get Target Detailed Information

1) emcli login: $ emcli login -username=’sysman’ Enter password : Login successful 2) To get all targets: $ emcli get_targets 3) To get all the RAC databases only: $ emcli get_targets -target=’rac_database’ 4) To list rac database TESTDB details: $emcli … Continue reading

Posted in OEM12c, OEM13c | Tagged , , , , | Leave a comment

How to Check Oracle Database Current Number of Sessions / Processes and Maximum Utilization

1)From V$LICENSE View. It shows USER sessions only excluding database system sessions. SQL> select SESSIONS_CURRENT,SESSIONS_HIGHWATER from v$license; SESSIONS_CURRENT SESSIONS_HIGHWATER —————- —————— 771 1346 — SESSIONS_CURRENT :Current number of concurrent user sessions — SESSIONS_HIGHWATER :Highest number of concurrent user sessions since the instance … Continue reading

Posted in OEM12c, OEM13c, SQL Scripts For DBA | Tagged , , , , , , , , , , , , , | Leave a comment

“ORA-01013: user requested cancel of current operation”– OEM Slow Performance SQL Metrics SQL statement (SQL ID: 4d43by1zzjfna)

Below OEM alerts are received from databases of 11R2 to 12R2: … .. . Target name=RACTEST Incident creation time=28/11/2017 9:48:17 PM AEDT Last updated time=28/11/2017 9:48:17 PM AEDT Message= ORA-01013: user requested cancel of current operation Severity=Critical Incident ID=294770 … … Continue reading

Posted in OEM12c, OEM13c | Tagged , , , , , , , | Leave a comment

Database Size History Report From OEM

A DBA is always asked about the database size growth trend for coming months  of one database  or databases, which possibly face storage or performance issue.  We can only get current database size from the database, or the size of … Continue reading

Posted in OEM12c, OEM13c, SQL Scripts For DBA | Tagged , , | Leave a comment

The agent is overloaded [current requests: 128]

Situation Below alerts are received from racnode1 -“The agent is overloaded [current requests: 128]” From: oracle Sent: Friday, 4 August 2017 7:07 PM Cc: Subject: EM Event: Warning: racnode1 – Agent Unreachable (REASON = The agent is overloaded [current requests: … Continue reading

Posted in OEM12c, OEM13c | Tagged , , , , , , , | Leave a comment

OEM Agent Throws “Internal error detected: java.lang.IllegalStateException:oracle.sysman.gcagent.target.interaction.execution.ConfigStateMgr:827”

Some of the OEM agents throw the internal errors in OEM alerts: From: oracle Sent: Tuesday, 14 February 2017 6:08 PM To: Subject: EM Event: Critical:racnode1:3872 – Internal error detected: java.lang.IllegalStateException:oracle.sysman.gcagent.target.interaction.execution.ConfigStateMgr:827. … .. . Error messages from log file: 2017-02-14 … Continue reading

Posted in OEM, OEM12c | Tagged , , , , | Leave a comment

OEM Agent Throws Error “Internal error detected: oracle.sysman.gcagent.task.TaskZombieException:oracle.sysman.gcagent.task.TaskFutureImpl$WrappedTask:620”

A couple of OEM agents reported some below internal errors  : From: oracle Sent: Monday, 13 February 2017 10:41 AM To: Subject: EM Event: Critical:ractest:3872 – Internal error detected: oracle.sysman.gcagent.task.TaskZombieException:oracle.sysman.gcagent.task.TaskFutureImpl$WrappedTask:620. Host=ractest Target type=Agent Target name=ractest:3872 Categories=Diagnostics Message=Internal error detected: oracle.sysman.gcagent.task.TaskZombieException:oracle.sysman.gcagent.task.TaskFutureImpl$WrappedTask:620. … Continue reading

Posted in OEM, OEM12c | Tagged , , , , , , , | Leave a comment

ME ( Metric Extension ) Metric Is Not Collected For Some Databases

For one of the databases, ME ( Metric Extension ) is not collecting data. But for the rest databases, it is working fine. Checking the ME ( Metric Extension ) definition and found an advanced option is not selected. After creating … Continue reading

Posted in OEM, OEM12c | Tagged , , , , , | Leave a comment

Use Corrective Action ( CA ) to Automate Archivelog Backup When FRA Usage is Over Threshold of Metric Extension ( ME ) in OEM 12C

In Previous posts, we have created below related posts: Create a Metric Extension (ME) to Monitor FRA Usage on OEM 12C Create an Incident Rule for Metric Extension ( ME ) to Monitor FRA Used in OEM 12C Now and then, FRA … Continue reading

Posted in OEM, OEM12c, RMAN Restore and Recovery | Tagged , , , , , , , , | Leave a comment

Create an Incident Rule for Metric Extension ( ME ) to Monitor FRA Used in OEM 12C

In another post, we created a Metric Extension (ME) to Monitor FRA Usage on OEM 12C. Here we need create an Incident Rule for creating an incident and notification for all events of Warning or Critical. 1) Click Setup->Incidents->Incidents Rules->Create Rules Set … Continue reading

Posted in OEM, OEM12c | Tagged , , , , , | 1 Comment