Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EX

edited Nov 26, 2019 1:35PM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

When doing export (expdp) of 11.2.0.4.0 Standard Edition database for the upgrade to 12C (12.2.0.1.0)  -

I am getting  multiple errors like this:

ORA-39127:
unexpected error from call to export_string :=SYS.
DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP('AW$AWCREATE','SYS',1,2,0,'SYS',1,'11.01.00.00.00',newblock)

ORA-06550:
line 1, column 35:

PLS-00302:
component 'INSTANCE_EXTENDED_INFO_EXP' must be declared

ORA-06550:
line 1, column 7:

PL/SQL:
Statement ignored

ORA-06512: at
"SYS.DBMS_METADATA", line 9926

Note:

We do not use OLAP   (VALUE=FALSE  in V$OPTION where  parameter='OLAP' )

It seems ORACLE in general recommends to delete from exppkgact$ where package =
'DBMS_CUBE_EXP' and schema = 'SYS';  (

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center