Oracle Apps DBA post clone steps

 

Dear All,

 In this post i am going to share Oracle Apps Post clone checks and steps .

1 Check Custom Top

 

1.1 Recreate soft links in custom top

 

Remove and recreate custom links in XXRACSINFOTECH_TOP:

NOTE: On both PATCH and RUN filesystem

 

cd $XXRACSINFOTECH_TOP/bin

ls -l | grep "fndcpesr" | awk '{print "ln -fs $FND_TOP/bin/fndcpesr " $9}'

 

Run the output from the above command.

 

1.2 dba_directories

 

Update direcotires – check all of them!

Use this sql to help generate sql and run as sysdba:

 

select 'create or replace directory ' || DIRECTORY_NAME || ' as ''' || DIRECTORY_PATH || ''' ;' from dba_directories where DIRECTORY_NAME like 'XX%'

 

1.3 Invalid Objects

 

Check and compile apps owned invalid objects

 

SELECT 'ALTER ' || Decode(object_type, 'PACKAGE BODY', 'PACKAGE', object_type)

  || ' ' || owner || '.' || object_name || ' COMPILE '

  || Decode(object_type, 'PACKAGE BODY', 'BODY;', ';')

FROM dba_objects

WHERE status <> 'VALID'

and object_type <> 'UNDEFINED'

and owner='APPS'

ORDER BY object_type, object_name

/

 

These will be present, but not important:

 

ALTER VIEW APPS.PO_ENDECA_BWC_PROCPLAN_INC_V COMPILE ;

ALTER VIEW APPS.PO_ENDECA_BWC_PROCPLAN_V COMPILE ;

ALTER VIEW APPS.PO_ENDECA_ITEMS_PROCUREMENT_V COMPILE ;

ALTER VIEW APPS.PO_ENDECA_ITEMS_PROC_INC_V COMPILE ;

ALTER VIEW APPS.PO_ENDECA_UDA_ATTRS_V COMPILE ;

 

1.4 Check utl_file_dir

 Remove /usr/tmp from the beginning of the line.

1.5 Check profiles for SSO and other mandatories values 

connect to Application using sysadmin user and go to system administrator responsibilities >> system >> profile 

search values like %application%  , %color% and %site% and other custom values as per the requirements .

 

Thanks,

Srini