Scripts for Data Patch in Oracle

pre_patch.sh

for db in ORCLD  ORCLT  ORCLSIT  ORCLUAT
do

export ORACLE_SID=$db
export ORAENV_ASK=NO
. oraenv >>/dev/null
$ORACLE_HOME/bin/sqlplus -s  “/as sysdba”<<EOF
spool pre_patch_${db}.log
@pre_patch.sql
spool off
exit;
EOF

done

pre_patch.sql
set time on
set timing on
set echo on

set head off
set linesize 100
select * from v$instance;
select MACHINE, program,   count(1)  from v$session where type !=’BACKGROUND’ group by MACHINE, program order by 3;
select owner, object_name, object_type from dba_objects where status!=’VALID’;
select comp_name, version, status from dba_registry;
select ACTION, STATUS ,PATCH_ID, ACTION_TIME , trim(BUNDLE_SERIES)||’ ‘||trim(BUNDLE_ID), version from (select * from dba_registry_sqlpatch);
archive log list;
show parameter log_archive_dest_state_2

select * from dba_registry;

select OWNER, OBJECT_TYPE, COUNT(1) from dba_objects where object_type like ‘%JAVA%’ GROUP BY OWNER, OBJECT_TYPE;
select dbms_java.get_jdk_version() from dual;