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

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000027866
Applies ToAll Versions
RSA Identity Management and Governance
AVEKSA_DATA_DIRECTORY, ORA-06564
IssueKB-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?

Resolution

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.

Legacy Article IDa66701

Attachments

    Outcomes