Category Archives: OEM13c

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

OEM Blackout Stuck in “Stop Pending” Status

OEM OMS Version 13.2.0.0.0 There is one blackout stuck in “Stop Pending” Status, when manually stopped it with errors: Error: The blackout is already pending stop 1) Implemented “Blackout Stuck in ‘Stop Pending’ Status ( Doc ID 2014040.1 )”, but it … Continue reading

Posted in 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

How to Change or Remove Partner Agent In OEM 13.2

Environment : OEM OMS  : 13.2 OEM Agent: 13.2 Monitored Agent:           racnode1.virtuallab:3872 Current Partner Agent:  host1.virtuallab:3872 New Partner Agent:        host2.virtuallab:3872 Check Associated Partner Agent 1)On  OEM Agent Home Page. 2) Run below … Continue reading

Posted in OEM13c | 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

“SELECT MEDIA FROM V$BACKUP_PIECE_DETAILS” Query Takes Long Time and Uses Huge Temp Space after Upgrading to OEM 13.2

The below query from OEM agent keeps failing, after upgrading Enterprise Manager Cloud Control and a monitoring agent to 13.2, this query is run in the 11.2.0.4 target database: SELECT MEDIA FROM V$BACKUP_PIECE_DETAILS WHERE SESSION_KEY=:B3 AND SESSION_RECID=:B2 AND SESSION_STAMP=:B1 AND … Continue reading

Posted in OEM, OEM13c, Performance Tunning, RMAN Restore and Recovery | Tagged , , , , , | 4 Comments