Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 10, 2013 at 12:05 PM

    Change LOCATION and possibly DEFAULT_DIRECTORY for external tables to reflect TST system not PRD. Please read Managing External Tables for more info.

    Add comment
    10|10000 characters needed characters exceeded