Author: dbalifeeasy

ORA-65025 when Renaming Global_Name in PDB

SQL>select * from global_name;

GLOBAL_NAME
--------------------------------------------------
OLDNAME

SQL>  alter pluggable database rename global_name to NEWNAME;
 alter pluggable database rename global_name to NEWNAME
                                                *
ERROR at line 1:
ORA-65045: pluggable database not in a restricted mode

SOLUTION

Open PDB in restricted mode, and close all other instances in RAC environment.

SQL> alter pluggable database OLDNAME open restricted;

Pluggable database altered.

SQL> alter session set container=OLDNAME;

Session altered.

SQL>alter pluggable database rename global_name to NEWNAME;

Pluggable database altered

SQL>select * from global_name;

GLOBAL_NAME
--------------------------------------------------
NEWNAME

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.

Subscribe

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

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

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.

Subscribe