Recientemente en la migración de bases de datos de la edición estandard en 12cR2, he visto este error, que se produce cuando una instancia es creada a partir del asistente de configuración de la base de datos ( DBCA ).
El Datapump concluye con algunos "warnings". Hay varias notas que dicen como solucionar el problema, pero la más simple es la que detallo a continuación.
Este es el mensaje que recibimos cuando se genera el Datapump.
.Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled
>>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
. . exported "WKSYS"."WK$_TDS_LOG" 0 KB 0 rows
. . exported "WKSYS"."WK$_TRACE" 0 KB 0 rows
Master table "RESPALDO"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for RESPALDO.SYS_EXPORT_FULL_01 is:
/u01/app/oracle/admin/oracle/dpdump/oracle_export.dmp
Job "RESPALDO"."SYS_EXPORT_FULL_01" successfully completed at Fri Jul 21 10:48:27 2017 elapsed 0 00:14:37
Ingresando con el usuario "SYS", proceda a borrar del objeto sys.exppkgact$ los registros en donde el esquema dueño sea SYS y el paquete tenga como nombre DBMS_AW_EXP.
[oracle@xelab1_server oracle]$
[oracle@xelab1_server oracle]$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 21 10:55:11 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> connec sys/oracle as sysdba
Connected.
SQL> delete from sys.exppkgact$ where package = 'DBMS_AW_EXP' and schema= 'SYS';
3 rows deleted.
SQL> COMMIT;
Una vez realizado el borrado, ejecute el script de compilación de objetos de la base de datos.
SQL> @?/rdbms/admin/utlrp
Finalmente, proceda a ejecutar el DATAPUMP y logrará observar que el mensaje ya no se da.
[oracle@xelab1_server oracle]$ expdp respaldo/respaldo dumpfile=oracle_export2.dmp logfile=oracle_export.log full=yes
Export: Release 12.2.0.1.0 - Production on Fri Jul 21 10:59:45 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
Starting "RESPALDO"."SYS_EXPORT_FULL_01": respaldo/******** dumpfile=oracle_export2.dmp logfile=oracle_export.log full=yes
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/RADM_FPTM
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
Processing object type DATABASE_EXPORT/PROXY
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
...
Job "RESPALDO"."SYS_EXPORT_FULL_01" successfully completed at Fri Jul 21 10:48:27 2017 elapsed 0 00:30:37
No hay comentarios:
Publicar un comentario
Te agradezco tus comentarios. Te esperamos de vuelta.