AD Patch Scripts

Patch Application Steps

1. Review Downtime required or not,
a. if downtime required,
i. Get list of invalid objects.
ii. Bring Down Applications
iii. Enable Maintenance Mode through adadmin
iv. Apply patch through adpatch
v. Disable Maintenance Mode through adadmin
vi. Bring up applications.
vii. Validate the patch has been applied and any new invalid objects
viii. Ensure all services are up and release.
b. if downtime not required,
i. Get list of invalid objects.
ii. Apply patch through adpatch options=hotpatch
iii. Validate the patch has been applied and any new invalid objects.
iv. Ensure all services are functioning.

Patching Activity on EBSPRD:

Steps:

1. Bring down application.
2. Enable maintenence mode.
3. adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt
4. Enter credential till it prompt for location.
5. when prompt for location type ‘abort’
6. disable maintenence mode.
7. open screen session.
8. sudo to application user(applmgr) and source application env.
9. execute sh /apps/patches/Test2.sh
10. when it prompt for old session then say ‘NO’

Bringing down application tier.

1. concurrent node service
2. form/web services

Applying Patch:

Total 43 patch.
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt
above step we are running for recording all input we are providing to store in <strong>ERPdefaults.txt</strong><em></em> file
Merging patch's----------->If language patch then merging all language patch.

Adpatch script:

cat /apps/patches/Test2.sh
sqlplus apps @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/22673920 logfile=l22673920.log driver=u22673920.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/19066382 logfile=l19066382.log driver=u19066382.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/20086596 logfile=l20086596.log driver=u20086596.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/21471243 logfile=l21471243.log driver=u21471243.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/25611260 logfile=l25611260.log driver=u25611260.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/16972536 logfile=l16972536.log driver=u16972536.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/21424549 logfile=l21424549.log driver=u21424549.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/18426069 logfile=l18426069.log driver=u18426069.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/16966157 logfile=l16966157.log driver=u16966157.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/12802881 logfile=l12802881.log driver=u12802881.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/22653309 logfile=l22653309.log driver=u22653309.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/13692238 logfile=l13692238.log driver=u13692238.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/16970138 logfile=l16970138.log driver=u16970138.drv workers=50
adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt patchtop=/apps/patches/Test2/All_Lan_Dst logfile=Test2_lan_pth.log driver=u_Test22.drv workers=128
sqlplus apps @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE;
exit

ebsprd@apps-ebsprd01:/apps/patches/ $ cat $APPL_TOP/admin/$TWO_TASK/ERPdefaults.txt
#
# AD Default Values File
#
#
# Updated by AutoPatch on Fri Jun 16 2017 22:16:42
#

## Start of Defaults Record
  %%START_OF_TOKEN%%
        APPL_TOP
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        /im/EBSPRD/apps/apps_st/appl
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        DBNAME
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        EBSPRD_BALANCE
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        MATCH_APPL_TOP
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        Yes
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        LOG_FNAME
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        ERPdefaults.log
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        DEF_BATCH_SIZE
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        1000
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        ORACLE_HOME
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        /im/EBSPRD/apps/tech_st/10.1.2
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        CORRECT_DBENV
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        Yes
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        DEF_SYSTEM_PWD
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        7782A9A20F0B4F635CADA0EA24D095D610C0
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        ORACLE_username_Application_Object_Library
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        APPLSYS
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        ORACLE_password_Application_Object_Library
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        7782A9A282CA42FED619A93FF9202C88D75612
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        DEF_ACTIVATE_EMAIL
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        No
  %%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
  %%START_OF_TOKEN%%
        MISSING_TRANSLATED_VERSION
  %%END_OF_TOKEN%%

  %%START_OF_VALUE%%
        yes
  %%END_OF_VALUE%%
## End of Defaults Record

#notes

EBS on OCI ( My Notes)

Oracle Cloud Infrastructure (OCI), IaaS from Oracle.
There are many cloud infrastructure providers, like Amazon (AWS), Oracle (OCI), Microsoft (Azure), Google (Google Cloud).
What’s New in Oracle Cloud Infrastructure

EBS (R12) Deployment Options on Cloud
EBS Middle/Application Tier
Oracle EBS Middle Tier can only be deployed on IaaS Service Model and within IaaS Service Model, it is either on Oracle Cloud Infrastructure (OCI) or OCI Classic.
EBS Database Tier
Oracle EBS Database Tier can be deployed either on IaaS or PaaS Service Model and within PaaS Service Model, it’ll be Database Cloud Service (DBCS). DBCS has few deployment options and out of them, two are supported for EBS (R12) on Cloud i.e. Database as a Service DBaaS and Exadata Cloud Service (Exa CS).

Metalink EBS on Oracle Cloud

OLL
OCI Study Guide *********
Just-in-Time Videos

OCI Introduction
OCI -Foundation
OCI Advanced
Tips for OCI Architect Certification
Certification Path

White Paper: EBS Deployment on OCI ****

Cloud On boarding Guide

OCI Blog

EBS on OCI Blog Posts
Cloud computing concepts (HA, DR, Security), regions, availability domains, OCI terminology and services, networking, databases, load balancing, IAM, DNS, FASTCONNECT, VPN, Compartments, tagging, Terraform, with focus on how to use it with OCI and Exadata

OCI for Apps DBA **
EBS (R12) on Cloud: Architects Perspective ****
EBS (R12) On Cloud (OCI): High Level Steps *****
EBS Cloud Admin Tool
EBS Cloud Manager

EBS Cloud Admin Tool on OCI is superseded with EBS Cloud Manager
EBS Cloud Manager
Provisioning –> 2 options (Simple & Advance)
Migration –> Lift and Shift using Cloud Manager
Cloning –>
Deletion
Cloud Service Model: SaaS | PaaS | IaaS
EBS (R12) On Cloud Deployment Architecture
Role of Apps DBA in Cloud

OCI vs OCI Classic
Storage

Summary

Knowledge of Oracle Cloud (OCI & DBCS) ,EBS-OCI Lift & Shift
	Taken Oracle Cloud Internal Training on OCI(Iaas),DBCS(Paas)
	High Level understanding of Core OCI fundamentals
	Familiar with EBS-OCI Lift & Shit & High Level Deployment & Tools like EBS Cloud Manager(EBS Cloud Admin tool)

INTERNAL TRAININGS & KNOWLEDGE

Topic	Oracle Cloud offerings for EBS (OCI & DBCS-Dbas/Exacs)
Mode	Online ,Self-Paced &
Role	Cloud EBS DBA

Gained Knowledge in following Areas

•	OCI(IaaS) & DBCS (Exa CS)
•	Knowledge of OCI (Infrastructure,Compute,Database,Networking(VCN,VPN,IPSec),Storage Services(FSS,IAM,VPN IPSec tunnel functionality)
•	Knowledge in DBCS(DBaaS & ExaCS),Cloud Backup Storage Service.
•	Basic Understanding of Migrating EBS to OCI ((Lift & Shift)
•	 Familiar with High-Level Steps of deployment of EBS on OCI
•	 Knowledge in EBS Cloud Admin Tool
•	 Familiar with Install and configure EBS Cloud Manager
•	Knowledge in EBS Cloud Manager (Provisioning,Migration,Cloning,Cloning,Deletion)

#ebs-cloud, #notes

EBS Info

EBS 12.1: Premier Support to December 2021
EBS 12.2: Premier Support to At Least December 2030
db

https://blogs.oracle.com/ebs/oracle-ebs-news
https://blogs.oracle.com/ebsandoraclecloud/
https://blogs.oracle.com/stevenchan/training-3
https://blogs.oracle.com/stevenchan
E-Business Suite DBA
dba-self

Apps DBA Interview-1
Apps DBA Interview-2
Apps DBA Interview-3

Few Support Issues
Support Issues

 

#notes

EBS Maintenance ( Patching/Upgrades/Migration)

My Posts 

( Still Writing Notes for below..)
EBS Upgrades and Platform Migration
Transportable Tablespaces(TTS) for Upgrade/Migration
Working with Datapump ?

EBS Upgrades
Oracle E-Business Suite Upgrade Guide
Sizing and Best Practices
12.2 Upgrade Process Flow
Planning Your Upgrade
12.2 Upgrade Best Practices to Minimize Downtime

EBS Patching Issues
Top Patching Issues 11i & 12.x
Restart a failed patch?

Webcasts
Webcast:EBS Maintenance
Webcast: Advanced Architectures:DMZ
Webcast:Auditing and Security
Webcast: TLS 1.2 Configuration

EBS Debug and Tracing
Query : Trace/Debug Profile

Critical Patch Update Advisory

15 January 2019
16 April 2019
16 July 2019
15 October 2019

JRE Plugin Upgrade (Doc ID 393931.1)

JRE 8-->JRE 1.8.0_191/192
JRE7 -->JRE 1.7.0_201
JRE 6-->JRE 1.6.0_211 

Java Web Start and Java Plug-in ?

browser-independent architecture ,to deprecate the Java Plug-in for web browsers starting with the release of Java SE 9

#notes

Perf Tuning/ Trace/Gather Stats

How to Use AWR Reports to Diagnose Database Performance Issues (Doc ID 1359094.1)
https://carlos-sierra.net/tag/execution-plan/
http://kerryosborne.oracle-guy.com/category/oracle/plan-stability/
Historical SQL Monitor reports in 12c!
https://community.oracle.com/thread/3269017 SQL review from an DBA perspective

Enable Trace and Generate TKPROF
SELECT p.PID, p.SPID, s.SID,s.serial# FROM v$process p, v$session s WHERE s.paddr = p.addr AND s.SID = 2414 ;
PID SPID SID


552 4999 2414

ORADEBUG SETOSPID 5382
ORADEBUG UNLIMIT
ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER,LEVEL 12
ORADEBUG TRACEFILE_NAME

SQL> ORADEBUG SETOSPID 5382
Oracle pid: 366, Unix process pid: 2244, image: oracle@123.nus.sri.com
SQL> ORADEBUG UNLIMIT
Statement processed.
SQL> ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER,LEVEL 12
Statement processed.
SQL> ORADEBUG TRACEFILE_NAME
/u01/app/db_1/diag/rdbms/SR12/SR/trace/SR_ora_2244.trc
SQL>
  1. Turn off the SQL trace for the session.
    SQL> ORADEBUG SETOSPID 5382
    SQL>oradebug event 10046 trace name context off 

Others:
—————-
alter system set events ‘sql_trace[sql: cjrha4bzuupzf] level=12’;
alter system set events ‘sql_trace[sql: cjrha4bzuupzf] off’;

tkprof aa.trc aa.tkprof explain=apps/ZW48Acbrtkmts sort=prsela,exeela,fchela sys=no

SQLID TEXT AND Plan Details

SELECT inst_id,sql_id,LAST_LOAD_TIME, LAST_ACTIVE_TIME ,PLAN_HASH_VALUE,SQL_FULLTEXT,ROWS_PROCESSED,EXECUTIONS,sql_plan_baseline,sql_profile
FROM   gV$SQl a
WHERE  a.sql_id ='7ttgy18puazt6'
ORDER BY LAST_ACTIVE_TIME desc;

–> awr_high_cost_sql.sql

select p.sql_id,p.PLAN_HASH_VALUE,p.TIMESTAMP,p.cost
from dba_hist_sql_plan p,dba_hist_sqltext s
where p.id = 0 and p.sql_id = s.sql_id
and p.sql_id='8ap1zyhp2q7xd'
order by p.TIMESTAMP desc;

Select * from table(dbms_xplan.display_cursor(‘9w6zqap3f5xbw’));
Select * from table(dbms_xplan.display_awr(‘9w6zqap3f5xbw’));
Select * from table(dbms_xplan.display_awr(‘9w6zqap3f5xbw’,’2095498791′));
Select * from table(dbms_xplan.display_awr(‘9w6zqap3f5xbw’,’2716887413′));

@?/rdbms/admin/sqltrpt.sql–> SQL Tuning Advisor
coe_xfr_sql_profile.sql – -> To Create SQL Profile
@?/rdbms/admin/awrrpti.sql – -> To Create AWR by Node
@?/rdbms/admin/awrrpt.sql – -> To Create AWR by DB
@?/rdbms/admin/awrsqrpt.sql – -> To Create AWR by SQL
@?/rdbms/admin/ashrpt.sql – -> To Create ASH
@?/rdbms/admin/utlrp.sql – -> Recompile Invalids

select object_name,owner,created,status,object_type,’/*’ || created || ‘*/’ || dbms_metadata.get_ddl(‘INDEX’,object_name,owner)
from dba_objects
where object_type = ‘INDEX’ and object_name in
(select INDEX_NAME from dba_indexes where table_name in (‘GL_PERIOD_STATUSES’))
order by created desc, object_name;

select * from DBA_IND_COLUMNS where table_name=’GL_PERIOD_STATUSES’;

–> ADDMM Suggestin

Set pages 1000
Set lines 75
Select a.execution_end,a.OWNER,a.TASK_NAME,a.DESCRIPTION,a.ADVISOR_NAME, b.type, b.impact, d.rank, d.type,
'Message           : '||b.message MESSAGE,
'Command To correct: '||c.command COMMAND,
'Action Message    : '||c.message ACTION_MESSAGE
From dba_advisor_tasks a, dba_advisor_findings b,
Dba_advisor_actions c, dba_advisor_recommendations d
Where a.owner=b.owner and a.task_id=b.task_id
And b.task_id=d.task_id and b.finding_id=d.finding_id
And a.task_id=c.task_id and d.rec_id=c.rec_Id
--And a.task_name like 'ADDM%'
and a.status='COMPLETED'
and trunc(a.execution_end)>sysdate -1
Order by a.execution_end,b.impact, d.rank;

Gather Stats /Stale :

select OWNER,table_name,stale_stats,last_analyzed,NUM_ROWS,blocks,OBJECT_TYPE from
dba_tab_statistics where table_name=’WF_ITEMS’;

SELECT ob.owner, ob.object_name, ob.object_type, savtime,analyzetime,
DECODE(rowcnt,0,0,round((samplesize/rowcnt)*100,0)) "Sample(%)",
flags, rowcnt, blkcnt, avgrln ,samplesize
FROM sys.WRI$_OPTSTAT_TAB_HISTORY, dba_objects ob
WHERE 1=1
and object_name='WF_ITEMS'
and object_type in ('TABLE')
and object_id=obj#
and  savtime > SYSDATE - 30
order by savtime desc;

select ‘exec fnd_stats.gather_table_stats(”’||owner||”’,”’||table_name||”’,percent=>25,degree=>8,cascade=>true);’ ” GSS”
from dba_tables where table_name in (‘WF_ITEMS’);
set lines 300 pages 300
select ‘exec DBMS_STATS.GATHER_TABLE_STATS(ownname =>”’||owner||”’,tabname =>”’||table_name||”’,ESTIMATE_PERCENT=>DBMS_STATS.AUTO_SAMPLE_SIZE,degree=>8,cascade=>true);’ ” GSS”
from dba_tables where table_name in (‘WF_ITEMS’);

SELECT owner,
segment_name,
segment_type,
tablespace_name,
round(bytes/1048576/1024,2) GB,
initial_extent,
next_extent,
extents,
pct_increase
FROM
DBA_SEGMENTS
WHERE
SEGMENT_TYPE = ‘TABLE’
AND SEGMENT_NAME in (‘HR_LOCATIONS_ALL_TL’,’HR_LOCATIONS_ALL’);

Select * from DBA_TAB_MODIFICATIONS  where table_name='WF_ITEMS';
SELECT m.table_owner
, m.table_name
, t.last_analyzed,m.timestamp
, m.inserts
, m.updates
, m.deletes
, t.num_rows
, round(( m.inserts + m.updates + m.deletes ) / CASE WHEN t.num_rows IS NULL OR t.num_rows = 0 THEN 1 ELSE t.num_rows END,0) "Change Factor"
FROM dba_tab_modifications m
, dba_tables t
WHERE t.owner = m.table_owner
AND t.table_name = m.table_name
AND m.inserts + m.updates + m.deletes > 1
AND m.table_name='WF_ITEMS'
and round(( m.inserts + m.updates + m.deletes ) / CASE WHEN t.num_rows IS NULL OR t.num_rows = 0 THEN 1 ELSE t.num_rows END,0) >1
ORDER BY "Change Factor" DESC;
select trunc(last_analyzed),count(*)
from dba_tables
where owner  not in ('SYS','SYSTEM')
group by trunc(last_analyzed)
order by 1 desc;

#notes

EBS READ ONLY Form Access

Need to Enable all accounts (including SYSADMIN) are read only as part of DR Testing

Requirement to enable query only for all the application users.
Step 1: Create backup table for fnd_form_functions

Create table fnd_form_functions_bkp_t1 as select * from fnd_form_functions;

Step 2: update parameters as QUERY_ONLY=”YES”

update fnd_form_functions set parameters=’QUERY_ONLY=”YES”‘ where parameters is null and form_id is not null;

DECLARE
f1 number;
p1 VARCHAR2(2000 BYTE);
CURSOR C1 IS
select function_id, PARAMETERS from fnd_form_functions where form_id is not null
and parameters ‘QUERY_ONLY=”YES”‘ AND parameters ‘QUERY_ONLY=YES’
and parameters not like ‘%QUERY_ONLY=”YES”%’ AND parameters not like ‘%QUERY_ONLY=YES%’;
begin
open c1;
loop
fetch c1 into f1,p1;
exit when c1%notfound;
update fnd_form_functions set parameters=p1||’ QUERY_ONLY=”YES”‘
where function_id=f1
;
–commit;
END LOOP;
close c1;
end;
/

commit;

Rollback plan :

Step 1: update parameters to null in fnd_form_functions with backup table

update fnd_form_functions set parameters=null where function_name in (select function_name from fnd_form_functions_bkp_t1 where parameters is null and form_id is not null);

DECLARE
f1 number;
p1 VARCHAR2(2000 BYTE);
CURSOR C1 IS
select function_id, PARAMETERS from fnd_form_functions_bkp_t1 where form_id is not null
and parameters ‘QUERY_ONLY=”YES”‘ AND parameters ‘QUERY_ONLY=YES’
and parameters not like ‘%QUERY_ONLY=”YES”%’ AND parameters not like ‘%QUERY_ONLY=YES%’;
begin
open c1;
loop
fetch c1 into f1,p1;
exit when c1%notfound;
update fnd_form_functions set parameters=p1
where function_id=f1
;
–commit;
END LOOP;
close c1;
end;
/

Commit;

#notes

CPU July-2018 EBS R12.1.3

Patch Location:

/interface/patches/CPU_2018

######################################################################################################

1) Apply AD Pacthes (US) in below order

====>Enable Maintaince Mode

sqlplus apps/apps4ebsdb @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

cd /interface/patches/CPU_2018/ADPATCH_US

23231676

24840574

25110821

22284589

23200210

————————————————————>

28018146–> PRE-Steps : adgrants.sql from DB Node

  • Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory(PATCH/admin/adgrants.sql)
  • Copy the higher version of adgrants.sql (UNIX) to RDBMS “$ORACLE_HOME/appsutil/admin”

Login to DB tier & use SQL*Plus to run the script as sys user.

sqlplus “/as sysdba”

@$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

Apply Patch –28018146

——————————————————————>

====>Disable Maintaince Mode

sqlplus apps/apps4ebsdb @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

######################################################################################################

2) Apply NLS Pacthes in Hotpacth ( Screen Mode)

screen -S CPU_18JUL

cd /interface/patches/CPU_2018/ADPATCH_NLS/ADPATCH_NLS_D

adpatch options=hotpatch driver=u_merged.drv logfile=CPU_JUL2018_12_17SEP.log

######################################################################################################

Take backup of 10.1.3 and 10.1.2 Homes

cp -pr 10.1.3 10.1.3_bkp_CPU_19SEP

cp -pr 10.1.2 10.1.2_bkp_CPU_19SEP

10.1.3 Patch :

######################################################################################################

1) Apply 21845960———————–>

export OPATCH_PLATFORM_ID=46

echo $OPATCH_PLATFORM_ID

cd /interface/patches/CPU_2018/1013_PATCH/21845960

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;

$ORACLE_HOME/OPatch/opatch napply

$ORACLE_HOME/OPatch/opatch lsinventory|egrep 21845960

unset OPATCH_PLATFORM_ID

OUI Patch

applmgr@of201:/interface/patches $ unzip p6640838_10106_Linux-x86-64.zip

2) Apply 22123753———————–>

cd /interface/patches/CPU_2018/1013_PATCH/22123753

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;

$ORACLE_HOME/OPatch/opatch apply

$ORACLE_HOME/OPatch/opatch lsinventory|egrep 22123753

10.1.2 Patch

######################################################################################################

1) Apply 26825525

cd /interface/patches/CPU_2018/1012_PATCH/26825525

. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;

$ORACLE_HOME/OPatch/opatch apply

$ORACLE_HOME/OPatch/opatch lsinventory|egrep 26825525

###################

“Forms having some issues while opening

to fix the issue,Re-deploy forms.ear file

(Given in Readme,but steps are not correct,refer comments)”

“Deploying a New EAR File in Oracle Applications Release 12 (Doc ID 397174.1) –Change Password for oc4jadmin

TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start (Doc ID 1295791.1) — EBSPRD patch opmnctl”

###################

JRE Patch

Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)

Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)

R12 E-Business Suite Java / JRE Upgrade Does Not Correctly Update The 3 Digit Version Of Java Installed In The Context File,

Forms Applications, Or Java Console (Doc ID 2227147.1)

http://erpondb.blogspot.com/2015/11/ebs-r121-patching-for-jre-18.html

######################################################################################################

cd /interface/patches/CPU_2018/JRE

——–Backup of Webapps———————————

cd $COMMON_TOP

cp -rp webapps webapps_bkp_CPU_19SEP

——–Backup of Webapps———————————

==> Apply interoperability Patch 21624242:R12.TXK.B. (ALready Applied ) ******************>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

1)Download 32 Bit Microsoft Version

unzip p27890728_180181_WINNT.zip

cp -p jre-8u181-windows-i586.exe $COMMON_TOP/webapps/oacore/util/jinitiator/j2se18181.exe

$FND_TOP/bin/txkSetPlugin.sh 18181

$FND_TOP/bin/txkSetPlugin.sh 18073 –Revert to old if any issues

Issues :

#########################################################################################################################

diff -y /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp_bkp_18SEP |grep ‘|’

add diff lines

[ VERSION CONFLICTS INFORMATION ]

Template shipped by oracle is having a version different than the template lying in custom directory.

Template shipped by Oracle : /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp(version: 120.69.12010000.17)

Custom template : /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp(version: 120.69.12010000.10)

Please resolve the differences between the two templates or refer to Metalink Note 387859.1 for further details.

Issues :

===============

lsinventory is failing with below error

##############################

LsInventory: OPatch Exception while accessing O2O

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:

OPatch Exception: OUI found no such ORACLE_HOME set in the environment

Can not get details for given Oracle Home

An exception occurs

null

##############################

. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;

cd $ORACLE_HOME/oui/bin

./runInstaller -silent -attachHome ORACLE_HOME=/EBSDEV/tech_st/10.1.2 ORACLE_HOME_NAME=EBSDEV_1012_home

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;

cd $ORACLE_HOME/oui/bin

./runInstaller -silent -attachHome ORACLE_HOME=/EBSDEV/tech_st/10.1.3 ORACLE_HOME_NAME=EBSDEV_1013_home

##############################

10.1.2 runInstaller attachHome failing with below error

.The Java RunTime Environment was not found at /tmp/OraInstall2018-09-16_12-18-52PM/jre/bin/java. Hence, the Oracle Universal Installer cannot be run.

##############################

Reason for the error

On investigation,I found the following solution to the problem

The oraparam.ini file is incorrect in $ORACLE_HOME/oui directory.

The line in the oraparm.ini file that was incorrect was:

appltst@of552:/ebsdb/apps/tech_st/10.1.2/oui $ cat oraparam.ini|grep -i JRE|grep -v ^#

JRE_LOCATION=/apps/prd/apps/tech_st/10.1.2/jdk/jre ****************************************************pointing to prod Path

JRE_MEMORY_OPTIONS=”-mx256m”

1. Back up the oraparm.ini file in $ORACLE_HOME/oui

2. Modify the oraparam.ini file:

vi oraparam.ini

JRE_LOCATION=../../jdk/jre

3. Run the universal installer from $ORACLE_HOME/oui/bin/runInstaller

TXKRUN.PL Deploying a New Forms

applmgr@of201:~ $ $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /EBSDEV/inst/apps/EBSDEV_of201/logs/appl/rgf/TXK/txkCfgOC4JApp_Wed_Sep_19_05_57_14_2018.log

Program : /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Wed Sep 19 05:57:14 2018

*** Log File = /EBSDEV/inst/apps/EBSDEV_of201/logs/appl/rgf/TXK/txkCfgOC4JApp_Wed_Sep_19_05_57_14_2018.log

Enter Application name for re-deployment ? forms

Enter Oc4j Instance password for re-deployment ?

Run Autoconfig ? No

*****************************************************

Required values for starting OC4J instance “forms”:

====================================================

s_formsstatus = enabled

s_forms_nprocs = 1 (value should be greater than 0)

Existing values from the context file:

======================================

s_formsstatus = enabled

s_forms_nprocs = 1

———————————————-

*** Values for context variables are VALID ***

———————————————-

*****************************************************

Stopping all OPMN processes.

OPMN stopped.

OPMN started.

Deplolying Application : “forms” onto OC4J instance: “forms”

Application deployed successfully.

Stopping and starting OC4J instances.

Started OC4J instances.

Binding webApp : “forms” with webmodule : “formsweb” for OC4J instance: “forms”

Web application bound successfully.

Stopping OPMN.

OPMN stopped.

Program : /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl completed @ Wed Sep 19 05:57:54 2018

End of /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl : No Errors encountered

applmgr@of201:~ $

AD Pacthes
Patch –  Desciption Pre

requisities

Post

requisities

Applied Patch –  Desciption Pre-Requisities

Not Appiled

Post

requisities

Not Appiled

28018146

12.1:CPU PATCH FOR JULY 2018

Yes NoRun ADGRANTS Yes 9239089

R12.AD.B.delta.3

NA NA
Yes 19559960

R12.FRM.B.delta.4

NA NA
No 23231676

R12.JTT.B.delta.4

NA 24840574

JSP COMPILATION FAILS AFTER APPLYING R12.JTT.B.DELTA.4

25110821

ERROR ON FLEXFIELDS AFTER APPLYING R12.JTT.B.DELTA.4

Yes 8919491

R12.ATG_PF.B.delta.3

NA NA
Yes 19273341

R12.BNE.B.delta.4

NA NA
No 22284589

R12.FWK.B.delta.5

NA 23200210

PERFORMANCE ISSUE WHILE SEARCHACCOUNT FLEXFIELD( SELECT FROM FND_FLEX_VALUES_VL)

12572001:

AFTER FRAMEWORK PATCH 11894708 JAVA ERROR ON CREATE CLAIM, CLAIM LINE, SYS PARAM (Not Required as we don’t have OZF)

Required

Actions

If Not On

Apr 2018 CPU

14108961

Only if Landed Cost Management is used

Check Below Applications are used or not with Funactional Teamand see if this are applied INL Inactive select

abbreviation

,codelevel

from

ad_trackable_entities

where

abbreviation in( ‘hr_pf’,’ibe’,’prc_pf’,’inl’,’ozf’ )

order by

abbreviation;

22465286

IF have applied Patch 21198991:R12.PRC_PF.B then apply Patch 22465286:R12.PON.B after applying this CPU patch.

PON Inactive select decode(nvl(a.APPLICATION_short_name,’Not Found’),

‘SQLAP’,’AP’,’SQLGL’,’GL’,’OFA’,’FA’,

‘Not Found’,’id ‘||to_char(fpi.application_id),

a.APPLICATION_short_name) apps,

decode(fpi.status,’I’,’Installed’,’S’,’Shared’,

‘N’,’Inactive’,fpi.status) status,

fpi.product_version,

nvl(fpi.patch_level,’– Not Available –‘) Patchset,

to_char(fpi.last_update_date,’dd-Mon-RRRR’) “Update Date”

from fnd_oracle_userid o, fnd_application a, fnd_product_installations fpi

where fpi.application_id = a.application_id(+)

and fpi.oracle_id = o.oracle_id(+)

and APPLICATION_short_name in( ‘HR’,’IBE’,’PRC’,’INL’,’OZF’ )

order by 1,2

25510561

If have applied R12.HR_PF.B.delta.9, Release 12.1 HRMS RUP9, apply Patch 25510561:R12.PAY.B after applying this CPU patch.

Current Version is HR PF  DELTA 3

PAY Shared

26267391

If have applied R12.IBE.B.Delta.4, apply Patch 26267391:R12.IBE.B after applying this CPU patch.

IBE Inactive
DB Patches:
28317232

COMBO OF OJVM COMPONENT 12.1.0.2.180717 DB PSU + DBPSU 12.1.0.2.180717

12.1.0.2 NA REVIEW With CORE DBA TEAM
Java JRE
27890728

Oracle JRE 8 Update 181

Apply only 32 bit patch

No -Pre Req

10.1.3.5 Patches
21845960CPUOCT2015 TRACKING BUG FOR APPLICATION SERVER 10.1.3.5 UNIX 10.1.3.5.0 NA If you encounter conflicts with Patch 19943587 and Patch 18025250, allow OPatch to roll it back. The fix for 19943587 and 18025250 is already included in the Oct 2015 CPU Patch 21845960.mv: cannot stat `.backup/.10011970/cabo’: No such file or directory

mv: cannot stat `cabo’: No such file or directory

This message can safely be ignored.

We can apply 32 bit

version in Linux X86-64

run the below command before applying patch

$ export OPATCH_PLATFORM_ID=46

19943587/18025250

Not appliedApply 21845960. directly

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘22123753|20683632|20426272|19943587|18025250|21845960’
22123753CPUOCT2015: MLR ON TOP OF 10.1.3.5.0 FOR BUGS 20034700 8939568 20492610 10.1.3.5.0 NA If you have previously installed Patch 20683632 or Patch 20426272, use OPatch to explicitly roll it back. Then, apply Patch 22123753.why this patch ?

Slow performance of HTML-based (self-service) applications on Oracle E-Business Suite Release 12.1.

20683632/20426272

Not appliedApply 22123753 directly

Only if TLS 1.2 Configured

27078378|27208670

10.1.3.5.0 NA to enable TLS 1.2 you should update the OpenSSL libraries by applying two patches – Patch 27078378 and Patch 27208670 27078378|27208670

Not appplied

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘27078378|27208670’
10.1.2 Patches
26825525MERGE REQUEST ON TOP OF 10.1.2.3.2PSU FOR BUGS 25768948 1770039 25990479 10.1.2.3 NA Only Available for Linux X86, not with 64 bit

we have to check with Oracle for applying

Pre-Reqs are applied.

14825718 /8551790OUI 10.1 8551790

. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘14825718|8551790|26825525’. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;grep -i version= $ORACLE_HOME/oui/oraparam.ini
 Known Issue Categories, Details and Resolutions
UI issues (such as poorly rendered fonts, missing links, or buttons and fields out of place) in Oracle E-Business Suite Release 12.1.3. Refer to Solution A in Document 1348791.1, R12: Font and Links Have Changed After Patching.
Patch Type Pacth# Comments References
10.1.3 21845960
10.1.3 22123753
10.1.2 26825525 Forms having some issues while opening

to fix the issue,Re-deploy forms.ear file

(Given in Readme,but steps are not correct,refer comments)

Deploying a New EAR File in Oracle Applications Release 12 (Doc ID 397174.1)   –Change Password for oc4jadmin

TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start (Doc ID 1295791.1) — Prod patch opmn ctl

JRE Plugin 27890728 After applying JRE Plugin,Forms are not opening ,no errors.

Reverted the changes,after that forms are opening

Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)

#notes