Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

trace of db_directories after system copy

Hello All,

We did a system copy last week (PRD to TST). In TST, in one of st04 functions we receive the following errors:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400
: data cartridge error

KUP-04040: file alert_PRD.log in EXT_DIR_DBAC_ALERT not found

After checking db_directories, we found some traces of PRD in TST (see below query). The mentioned directories don't exist anymore in TST. Do you have any idea how I can do the clean-up?

SQL> select * from dba_directories;

 

OWNER                          DIRECTORY_NAME

------------------------------ ------------------------------

DIRECTORY_PATH

--------------------------------------------------------------------------------

SYS                            DATA_PUMP_DIR

/oracle/admin/PRD/dpdump/

 

SYS                            EXT_DIR_DBAC_CLIENT

/usr/sap/PRD/SYS/profile/oracle

 

SYS                            ORACLE_OCM_CONFIG_DIR

/oracle/PRD/112_64/ccr/state

   

OWNER                          DIRECTORY_NAME

------------------------------ ------------------------------

DIRECTORY_PATH

--------------------------------------------------------------------------------

SYS                            EXT_DIR_DBAC_ALERT

/oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace

 

SYS                            EXT_DIR_DBAC_SERVER

/oracle/PRD/112_64/network/admin

Thank you,

Kamand

replied

I should have applied SAP note 1546456 to recreate dba_directories in the new system.

Thank you all for your help,

Kamand

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question