August 2021 – Make DBA Life Easy

Versions of Oracle Enterprise Manager Cloud Control Impacted by Adobe Flash

Adobe no longer supports Flash Player after 31 December2020 and blocked Flash content from running in Flash Player beginning 12 January2021.

We strongly recommend OEM clients to upgrade OEM Cloud Control to 13.4 RU 7 or later. Since then all Adobe flash pages are removed or redeveloped without using Adobe flash.

EM 13.3.1 (supported though January 2021):

Performance Page (SI & RAC)
Performance Home
Top consumers (SI & RAC)
Top Activity Page (SI & RAC)
Top Activity
ASH Analytics Page
ASH Analytic
SQL Monitoring Page
SQL Monitoring
SQL Details Page
SQL details page - Activity, Plan, and SQL Monitoring Tabs
Session Details Page
Session details - Activity and SQL Monitoring Tabs
AWR Pages
Emergency Performance Page
Real- Time ADDM
Real-time ADDM
Advisor Central --> ADDM Page
Cluster cache coherency page
Cluster Cache Coherency
Cluster cache coherency page --> Average Current Block Receive Time By Instance Page
Cluster cache coherency page --> Average Current Block Transfer Rate Page
Cluster cache coherency page --> Active Session History Page
Database Replay
RAC Drilldowns
RAC Cluster Cache Coherency
Database Throughput by Instance (RAC Only)
Latency for Synchronous Single Block Reads by Instance (RAC Only)
I/O Megabytes per Second By Instance For I/O Function (RAC Only)
Parallel Execution by Instance (RAC Only)
Real-time SQL Monitoring
Service Activity from Top Consumers


EM 13.3.2 (PG):

RAC Historical Drilldowns
RAC Cluster Cache Coherency
Database Throughput by Instance (RAC Only)
Latency for Synchronous Single Block Reads by Instance (RAC Only)
I/O Megabytes per Second By Instance For I/O Function (RAC Only)
Parallel Execution by Instance (RAC Only)


EM 13.4 through RU6:

RAC Historical drill downs
RAC Cluster Cache Coherency
Database Throughput by Instance (RAC Only)
Latency for Synchronous Single Block Reads by Instance (RAC Only)
I/O Megabytes per Second By Instance For I/O Function (RAC Only)
Parallel Execution by Instance (RAC Only)


EM 13.4 RU7: All Flash pages removed

ORA-39006 ORA-39113 ORA-06550 PLS-00352 PLS-00201 ORA-39097 When Datapump Impdp Using Network Link

The following errors appear when running impdp operation which uses network link.

$ impdp imp_user/password@dbname directory=IMP_DIR logfile=imp_test.log tables=test  network_link=DB_LINK

Import: Release 12.1.0.2.0 - Production on Fri Aug 27 14:44:25 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39006: internal error
ORA-39113: Unable to determine database version
ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database 'DB_LINK'
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS@DB_LINK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ORA-39097: Data Pump job encountered unexpected error -6550

CAUSE and SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

Data Pump Import Job is Hanging at SCHEMA_EXPORT/STATISTICS/MARKER

Oracle database 12.1 data pump impdp job is hanging like below:

...
..
.
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

Read more of this content when you subscribe today.

expdp did not create dumpfile while expdp is successful

A client sent the following information about the dump file of expdp is unavailable, while the datapump log shows expdp completes successfully.

$ expdp exp_user/password@testdbpdb directory=DATA_PUMP_DIR dumpfile=hr.dmp schemas=hr reuse_dumpfiles=yes logfile=exp_hr.log
..
..
.
Master table "EXP_USER"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for EXP_USER.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/hr.dmp
Job "EXP_USER"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Aug 27 11:53:13 2021 elapsed 0 00:00:57

$ ls -ltr /home/oracle/hr.dmp
ls: cannot access /home/oracle/hr.dmp: No such file or directory

CAUSE and SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

ORA-02085: database link DB_LINK connects to SOURCE_DB

After successfully created the database link called “DB_LINK”, the try to access remote table with the following errors:

SQL>  select  count(*) from remote_user.table_name@db_link;
 select  count(*) from REMOTE_USER.TABLE_NAME@DB_LINK                                                         *
ERROR at line 1:
ORA-02085: database link DB_LINK connects to SOURCE_DB

 $ oerr ora 02085
02085, 00000, "database link %s connects to %s"
// *Cause: a database link connected to a database with a different name.
//  The connection is rejected.
// *Action: create a database link with the same name as the database it
//  connects to, or set global_names=false.
//

SQL>  show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
global_names                         boolean     TRUE

SOLUTION

1)Reset parameter global_names to FALSE, and recreate the database link again with any name you want.

SQL> alter system set global_names=false;

SQL> Create public database link DB_link connect to ....

SQL>  select  count(*) from remote_user.table_name@db_link;

  COUNT(*)
----------
      1000

2) Create database link with the same name as source database / PDB GLOBAL_NAME.

SQL> select * from global_name;

GLOBAL_NAME
-----------------------------------------------------------
SOURCE_DB

SQL> Create public database link SOURCE_DB connect to ....

SQL>  select  count(*) from remote_user.table_name@source_db;

  COUNT(*)
----------
      1000

For connecting to PDB, you need be in the PDB to get right GLOBAL_NAME:

SQL> show con_name;

CON_NAME
------------------------------
SOURCEDBPDB

SQL>  select * from global_name;

GLOBAL_NAME
--------------------------------------------
SOURCEDBPDB

SQL>Create public database link SOURCEDBPDB connect to ....

SQL>  select  count(*) from remote_user.table_name@sourcedbpdb;

  COUNT(*)
----------
      1000