postclone task (3) fix dba_directories

Database directories are not updated during the cloning procedure. You have to update them manually.

Select owner,directory_name,directory_path from dba_directories;

Use create or replace directory “directory_name” as “directory_path”; to update directories. Run from sys.

Use following query in the source system to find out the required priviledges that were granted:

Select * from dba_tab_privs where table_name in (select directory_name from dba_directories);


Directory has read and write privilege in database 10g.

Here is an example:

Drop Directory POWL_OUTBOUND_ACSIS;
Drop Directory POWL_OUTBOUND_EDI;
Drop Directory POWL_OUTBOUND_CERIDIAN;
Drop Directory CCR_CONFIG_DIR;
Drop Directory EBS_LL_CONFIG_DIR;
Drop Directory POWL_INBOUND_AMEX;
Drop Directory POWL_WIP_TRANS;

create or replace directory ADMIN_DIR
as '/opt/oracle/product/10.2.0/PTCH/md/admin';

create or replace directory WORK_DIR
as '/opt/oracle/product/10.2.0/PTCH/work';

create or replace directory DATA_PUMP_DIR
as '/opt/oracle/product/10.2.0/PTCH/rdbms/log';

create or replace directory ORACLE_OCM_CONFIG_DIR
as '/opt/oracle/product/10.2.0/PTCH/ccr/state';
grant ALL on dirctory ORACLE_OCM_CONFIG_DIR to ORACLE_OCM;


Create Directory CCR_CONFIG_DIR
As '/opt/oracle/product/10.2.0/db_2/ccr/state';

Create Directory EBS_LL_CONFIG_DIR
As '/opt/oracle/product/10.2.0/db_2/ccr/state';
grant ALL on dirctory EBS_LL_CONFIG_DIR to apps;

Create Directory POWL_INBOUND_GL
As '/pcp/applptch/common/xx_custom/inbound/gl';
Grant ALL on Directory POWL_INBOUND_GL to APPS;
Grant ALL on Directory POWL_INBOUND_GL to XX_CUSTOM;

Create Directory POWL_OUTBOUND_ACSIS
As '/pcp/applptch/common/xx_custom/outbound/acsis';
Grant ALL on Directory POWL_OUTBOUND_ACSIS to APPS;
Grant ALL on Directory POWL_OUTBOUND_ACSIS to XX_CUSTOM;

Create Directory POWL_OUTBOUND_EDI
As '/pcp/applptch/common/xx_custom/outbound/edi';
Grant ALL on Directory POWL_OUTBOUND_EDI to APPS;
Grant ALL on Directory POWL_OUTBOUND_EDI to XX_CUSTOM;

Create Directory POWL_OUTBOUND_CERIDIAN
As '/pcp/applptch/common/xx_custom/outbound/ceridian';
Grant ALL on Directory POWL_OUTBOUND_CERIDIAN to APPS;
Grant ALL on Directory POWL_OUTBOUND_CERIDIAN to XX_CUSTOM;

create or replace directory POWL_INBOUND_AMEX
As '/pcp/applptch/common/xx_custom/inbound/amex';
Grant ALL on Directory POWL_INBOUND_AMEX to APPS;
Grant ALL on Directory POWL_INBOUND_AMEX to XX_CUSTOM;

create or replace directory POWL_WIP_TRANS
As '/pcp/applptch/common/temp';
Grant ALL on Directory POWL_WIP_TRANS to APPS;
Grant ALL on Directory POWL_WIP_TRANS to XX_CUSTOM;