miércoles, 6 de septiembre de 2017

Oracle Database 12c SE2: Datapump error DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled

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.

Todos los Sábados a las 8:00PM

Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar