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

Oracle Database Bounce automatically shell scripts

 Dear All,

In this post i am going to share you the step by step Oracle database bounce automation steps .

Note : this scripts works in my demo instance this is purely education purpose you can test before you implement on any important servers .

Start the database automatically script : 

Below script will help you to start the database automatically , you need to schedule cron jobs and schedule the below scripts as per your requirement.

export ORACLE_HOME=/u01/db/product/12C/db_home

export ORACLE_SID=racsinfo

export NLS_LANG=******.AL32UTF8

export LD_LIBRARY_PATH=/u01/db/product/12C/db_home/lib:/usr/X11R6/lib:/u01/db/product/12C/db_home/ctx/lib

export PATH=$ORACLE_HOME/bin:$PATH

export TNS_ADMIN=/u01/db/product/12C/db_home/network/admin

date > database_instance_start.log

sqlplus -s / as sysdba << EOF

spool database_instance_start.log append;

startup;

spool off;

EOF

lsnrctl start racsinfo > database_listener_start.log

Stop the database automatically script : 

Below script will help you to stop the database automatically , you need to schedule cron jobs and schedule the below scripts as per your requirement.

export ORACLE_HOME=/u01/db/product/12C/db_home

export ORACLE_SID=racsinfo

export NLS_LANG=*******.AL32UTF8

export LD_LIBRARY_PATH=/u01/db/product/12C/db_home/lib:/usr/X11R6/lib:/u01/db/product/12C/db_home/ctx/lib

export PATH=$ORACLE_HOME/bin:$PATH

export TNS_ADMIN=/u01/db/product/12C/db_home/network/admin

date > database_instance_stop.log

sqlplus -s / as sysdba << EOF

spool database_instance_stop.log append;

--select to_char(sysdate,'YYYY/MM/DD HH24:MI:SS') from dual;

shutdown immediate;

spool off;

EOF

lsnrctl stop racsinfo > database_listener_stop.log

Happy Learning from Racsinfotech ... Lab Video will be available in youtube cannel @RACSINFOTECH

Thanks,

Srini