000027866 - KB-1672 - Import errors: 'ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist' Importing Database

Many "ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist" error messages are seen in the terminal output and in the mport log file (Import_AVDB_avuser.log) written to when using the ACM database import script, AVDB_Import_AVUSER.sh  to import an ACM database.

Are there any actions required when these error messages are seen?

PROBLEM:

You import a database from an earlier version of ACM to a later version of ACM. After importing the backed up database to the new version, you find the following errors in the import log. The same Oracle error is repeated several times, for different tables most of which are prefixed with ?STX?:

Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

With the Automatic Storage Management option

Master table "AVUSER"."AVDB_IMPORT_AVUSER" successfully loaded/unloaded

Starting "AVUSER"."AVDB_IMPORT_AVUSER":  avuser/********@AVDB parfile=/home/oracle/database/DBA/AVDB/export/Import_AVDB_avuser.par

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39083: Object type TABLE:"AVUSER"."STX_RES_27_61996" failed to create with error:

ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist

Failing sql is:

CREATE TABLE "AVUSER"."STX_RES_27_61996" ("APPLICATION_REF" VARCHAR2(256 BYTE), "FULLY_QUALIFIED_NAME" VARCHAR2(256 BYTE), "NAME" VARCHAR2(256 BYTE), "OBJECT_REF" VARCHAR2(256 BYTE), "OWNER_NAME" VARCHAR2(256 BYTE), "OWNER_TYPE" VARCHAR2(5 BYTE), "CAD1" VARCHAR2(50 BYTE), "CAD2" VARCHAR2(50 BYTE), "CAD3" VARCHAR2(50 BYTE), "CAD4" VARCHAR2(50 BYTE), "C

ORA-39083: Object type TABLE:"AVUSER"."STX_ENT_27_61996" failed to create with error:

ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist

PROBLEM CAUSE:

These errors are due to the fact that 6.5.x no longer uses an AVEKSA_DATA_DIRECTORY.

The errors are benign and may be safely ignored.

NOTE:

The log may contain other errors that are not benign so please check the log carefully to make sure the import succeeded.

This error will be documented in a future release as benign.