Performace Tuning (DB/EBS)

perf

How to Start ? 

———————————————————>Course<———
Learn SQL Performance Tuning in this Free Online Course
The Ultimate SQL Tuning Formula by Diana Robete
———————————————————>Course<——–

How do I learn to tune SQL?
Oracle Database 2 Day + Performance Tuning Guide provides an introduction to the principal SQL tuning tools.

http://facedba.blogspot.com/2014/01/performance-tuning-for-beginners.html
https://blogs.oracle.com/sql/category/sql-query-optimization

My Posts    Tuning (WIP)-Private

Oracle SQL Plan Changed?
Configuring Oracle SGA/PGA ?

( Still Writing Notes for below..)
What is Table Fragmentation in Oracle ? ( Finding & Removing)
What is Oracle Partitioning – ( Why ?,How ? &Benefits)
OS Watcher-OSWbb/RDA-Remote Diagnostics Agent/ORAchk – Health Checks
Locks vs Latch/Enqueues & Its Types 

Database Performance ( Article Collection)

Oracle Statistics (All About)–>An Excellent Article about end to end to Statistics for DB/SCHEAMA/object level
DBMS_ADVISOR–>Details of How to execute SQL access advisor (DBMS_ADVISOR)?
DB Performance Toolkit –> Overview of Performance tools (AWR/ADDM/ASH,SQLT & SQLHC) & What data you need to collect for Performance Issues for Oracle SR?
Performace Tuning DB level->Collection of articles related to DB Time,Hints ,Execution plans,Shared pool,WAIT EVENTS,Latch Issues & Sql Trace & Autotrace

================ Newly Added on 01-JAN-2019=================== (Gavin Soorma(Oracle ACE) Articles)

Oracle Wait Events Causes And Resolutions->Just going through
Why Do My Execution Plans Not Change After Gathering Statistics?->Just going through
Performance Tuning Tips And Techniques->Just going through
ASH And AWR Performance Tuning Scripts->Just going through
Using The Awr History Tables To Compare Performance – Part 1->Just going through
Using The Awr History Tables To Compare Performance – Part 2>->Just going through
LOB’S – SOME PERFORMANCE TUNING CONSIDERATIONS>->Just going through
DBMS_ADVANCED_REWRITE – TUNING WITHOUT TOUCHING THE CODE>->Just going through

EBS Performance ( Article Collection)

Gathering EBS Database Statistics
Recommended Database Parameters for EBS
Approach to Performance Tuning Oracle Apps
Webcast:EBS performance tuning
Troubleshooting Performance Issues??
Debugging ??
Database Partitioning-EBS
Tuning the EBS Database Layer
Tuning All Layers of EBS
Queries for Troubleshooting Adv Typologies
Pinning Objects to Improve Apps Performance
SR Data for Perf Issue

#tuning

3

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/
https://mauro-pagano.com/2015/05/04/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;
0

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;

0

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

o Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory(PATCH/admin/adgrants.sql)

o 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

0

TLS 1.2 Upgrade EBS R12.1.3

In Summary
Source Document: Enabling TLS in Oracle E-Business Suite Release 12.1 (Doc ID 376700.1)

Step 1 : Upgrade to Latest JDK (JDK_7_181_32bit_27411505) & apply 10.1.2 Patches ==> Completed Successfully
Step 2 : Apply the October 2015 CPU (10.1.3) –>21845960 ==> Completed Successfully
Step 3 : Apply the 10.1.3.5 OpenSSL patches. –> All Other 10.1.3 Patches==> Completed Successfully
Step 4 : Apply product-specific patches(ad patches) –Ad patches ==> Completed Successfully

Error Faced:
Only Error , is OPMN Services are timed-out.
ERROR : Timed out( 100000 ): Interrupted Exception - This is JDK Upgrade (10.1.2 Pathes) , this can be safely ignored

One patch needs OUI and needs to be enabled with unix team and using 1301320.1

Pacthes ==> adpacthes , 10.1.2,10.1.3
JDK ==> JDK Pacth Version & Details
Certificates ==> Certificates Required for TLS1.2

Sample Steps (Other)

Enabling TLS in Oracle E-Business Suite Release 12.1 (Doc ID 376700.1)

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

Apply patches 16545472, 17309237 (EBS patches – adpatch)

Install new JDK version on server

Create new JDK folder in $IAS_ORACLE_HOME/applutil

Copy new JDK folder (jdk1.7.0_181-i586) from installation directory to $IAS_ORACLE_HOME/applutil/jdk1.7.0_181-i586 .

in $IAS_ORACLE_HOME/applutil/ rename existing jdk directory (mv jdk jdk_old)
in $IAS_ORACLE_HOME/applutil/ rename new jdk1.7.0_181-i586 jdk directory (mv jdk1.7.0_181-i586 jdk)

Install Fonts

cp $FND_TOP/resource/ALBANYWT.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTJ.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTK.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTS.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTT.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts

apply patch 5659594 to 10.1.2 oracle home (opatch)

mv $ORACLE_HOME/jdk $ORACLE_HOME/jdk_old

In ORACLE_HOME:

cp -rp $IAS_ORACLE_HOME/appsutil/jdk .

apply patches (IN THIS ORDER) 16271876, 17907988, 17653437, 17645157, 16241466 to 10.1.2 home (opatch)

ignore conflict on 17653437

ignore conflict on 17645157

refer to 1569998.1 for make commands

Please create the below softlink:

cd $ORACLE_HOME/lib/stubs
ln -s libjvm-1.7-stub.so libjvm.so

cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk sharedlib install

cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install

Run ADAdmin and select the Forms and Reports regeneration
1, 2 and 1,3

Enter the number of workers [X] :

take all defaults when asked

apply patches 27078378, 27208670 to 10.1.3 home (opatch)

27208670 could error due to no OUI 10.1 support

OPATCH_JAVA_ERROR=CheckConflict: OPatch cannot process overlay patches because of no OUI support. Please take latest OUI 10.1 patchset from “My Oracle Support” and try again.
Cannot check bug/file conflict and component prerequisite checks.

ERROR: OPatch failed during prerequisite check.

apply 6640838 using UltraVNC, refer to below note

How to patch OUI for installing overlay patches on top of Forms Bundle Patch – 9593176 (Doc ID 1301320.1)

source 10.1.3 home

./runInstaller -ignoreSysPrereqs

Once installed, then apply 27208670

apply patches 23645824, 22974534 (EBS patches – adpatch)

Punchout in Oracle iProcurement and Exchange Fails After Supplier Site Migrates From SSLv3 to TLS Protocol (with SSL Handshake SSLIOClosedOverrideGoodbyeKiss) (Doc ID 1937220.1)

apply patch 21473055 (EBS patch – adpatch)

source 10.1.3

/d01/oracle/SUPPORT1/apps/tech_st/10.1.3

Follow 376700.1 instructions for requesting a new certificate

copy files to $INST_TOP/certs/Apache: ca.crt, intermediate.crt, new.cnf, new.csr, server.crt, server.key

make $PATH and $LD_LIBRARY_PATH per 376700.1

export OPENSSL_CONF=$INST_TOP/certs/Apache/new.cnf

cat server.crt intermediate.crt ca.crt > opmn.crt

Copy files to custom directory and make changes as per 376700.1

cp -rp $FND_TOP/admin/template/opmn_xml_1013.tmp $FND_TOP/admin/template/custom/opmn_xml_1013.tmp

cp -rp $FND_TOP/admin/template/httpd_conf_1013.tmp $FND_TOP/admin/template/custom/httpd_conf_1013.tmp

cp -rp $FND_TOP/admin/template/ssl_conf_1013.tmp $FND_TOP/admin/template/custom/ssl_conf_1013.tmp

make file changes as per 5.2 Step 6 in 376700.1

Copy files to custom directory and make changes as per 376700.1

cp -rp $FND_TOP/admin/template/oc4j_properties_1013.tmp $FND_TOP/admin/template/custom/oc4j_properties_1013.tmp

cp -rp $FND_TOP/admin/template/oafm_oc4j_properties_1013.tmp $FND_TOP/admin/template/custom/oafm_oc4j_properties_1013.tmp

cp -rp $FND_TOP/admin/template/forms_oc4j_properties_1013.tmp $FND_TOP/admin/template/custom/forms_oc4j_properties_1013.tmp

make file changes as per 5.3 Step 1 in 376700.1

Run autoconfig and pray it all works

====================================================================
JDK_7_181_32bit & 10.1.2 Patches
For JDK 7 upgrade, follow the instructions in  (Doc ID 1467892.1)
====================================================================
27411505 --> JDK_7_181_32bit_27411505

1)12848228
2)16271876 -- Follow Read me
3)17907988 -- Follow Read me
4)17653437-- Follow Read me
5)17645157-- Follow Read me
6)16241466--- Follow Read me

====================================================================
10.1.3 Patches
Refer DOc: 376700.1 ,Step 5
====================================================================
1) 21845960-CPUOCT2015--> -- Follow Read me
2) 27078378
3) 22322938-- Support for Oracle Workflow
4) 6640838 -->OUI 10.1 : apply 6640838 using UltraVNC, refer to below note 1301320.1
5) 27208670
====================================================================
AD Pacthes
Refer DOc: 376700.1 ,Step 6
====================================================================

16545472
17309237
23645824
22974534 --NLS
27881758 --NLS
22724663 --NLS

TLS_JDK_Upgrade_7u181_32bit_workflog

http://123.srinalla.com:8011/OA_HTML/AppsLogin

apps4ebsdb
manager

/interface/patches/TLS_1.2_Patches
####################################################################################################################################################

Take backup of 10.1.3 and 10.1.2 Homes

appltst@of223:/ebsdb/tech_st $
cp -pr 10.1.3 10.1.3_bkp_after_jdk_upgrade &
cp -pr 10.1.2 10.1.2_bkp_after_jdk_upgrade &
####################################################################################################################################################
Apply 10.1.3 Oracle Home using Opatch.

====================================================================
10.1.3 Patches
Refer DOc: 376700.1 ,Step 5
====================================================================
1) 21845960-CPUOCT2015–> — Follow Read me
2) 27078378
3) 22322938– Support for Oracle Workflow
4) 6640838 –>OUI 10.1 : apply 6640838 using UltraVNC, refer to below note 1301320.1
5) 27208670

====================================================================
AD Pacthes
Refer DOc: 376700.1 ,Step 6
====================================================================

16545472
17309237
23645824
22974534 –NLS
27881758 –NLS
22724663 –NLS

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

echo $OPATCH_PLATFORM_ID
unset OPATCH_PLATFORM_ID

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch lsinventory|grep 21845960
cd /interface/patches/TLS_1.2_Patches/10.1.3/21845960
export OPATCH_PLATFORM_ID=46
$ORACLE_HOME/OPatch/opatch napply
unset OPATCH_PLATFORM_ID

——————-WORKLOG…………………………
Applying patch 9273888…

Patching copy files…

Inventory is good and does not have any dangling patches.

Updating inventory…

Verifying patch…
Backing up comps.xml …

OPatch succeeded.

OPatch succeeded.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/21845960 $

appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/21845960 $ unset OPATCH_PLATFORM_ID
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/21845960 $

——————————————————————————————————————>
2) 27078378

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch lsinventory|grep 27078378
cd /interface/patches/TLS_1.2_Patches/10.1.3/27078378
$ORACLE_HOME/OPatch/opatch apply

——————-WORKLOG…………………………——————-WORKLOG…………………………
OPatch succeeded.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27078378 $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 27078378

1) Patch 27078378 applied on Fri Dec 07 01:04:10 EST 2018
[ Bug fixes: 22447165 25859264 27078378 24483815 ]
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27078378 $

——————————————————————————————————————>
3) 22322938

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch lsinventory|grep 22322938
cd /interface/patches/TLS_1.2_Patches/10.1.3/22322938
$ORACLE_HOME/OPatch/opatch apply

——————-WORKLOG…………………………——————-WORKLOG…………………………

OPatch succeeded.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/22322938 $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 22322938
1) Patch 22322938 applied on Fri Dec 07 01:30:56 EST 2018
[ Bug fixes: 22322938 ]

——————————————————————————————————————>
4) 6640838

####################################################################################################################################################
OUI Pacth 6880880 ——————————–> GUI Setiings

Invoking fuser to check for active processes.

OPATCH_JAVA_ERROR=CheckConflict: OPatch cannot process overlay patches because of no OUI support. Please take latest OUI 10.1 patchset from “My Oracle Support” and try again.
Cannot check bug/file conflict and component prerequisite checks.
##########################################################
MobaXterm GUI Settings——————————————————————————————–>
[srinalla@of223 ~]$ xauth list
123.srinalla.com/unix:10 MIT-MAGIC-COOKIE-1 6bb0f2dd724792d1fa72abbb87f3c8a6
appltst@of223:~ $ xauth add 123.srinalla.com/unix:10 MIT-MAGIC-COOKIE-1 6bb0f2dd724792d1fa72abbb87f3c8a6
appltst@of223:~ $ xclock
——————————————————————————————–>
##########################################################
Download 32bit 10106 Version=========> p6640838_10106_LINUX.zip
. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.pre_6640838
unzip p6640838_10106_LINUX.zip
appltst@of223:/interface/patches/TLS_1.2_Patches $ cd cd/Disk1/install/
appltst@of223:/interface/patches/TLS_1.2_Patches/cd/Disk1/install $ chmod +x *
appltst@of223:/interface/patches/TLS_1.2_Patches/cd/Disk1/install $ ./runInstaller -ignoreSysPrereqs

Follow (Doc ID 1301320.1) –> for GUI steps

appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ opatch version

Oracle Interim Patch Installer version 1.0.0.0.62
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

OPatch Version: 1.0.0.0.62
####################################################################################################################################################

5) 27208670

Follow Read me

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;
$ORACLE_HOME/OPatch/opatch lsinventory|grep 27208670
cd /interface/patches/TLS_1.2_Patches/10.1.3/27208670
$ORACLE_HOME/OPatch/opatch apply

–> First time , we had error & rollbacked the patch as per
–> And pacth went fine

—————> Refer Error Details on below of Document

——————-WORKLOG…………………………——————-WORKLOG…………………………

Verifying patch…
Backing up comps.xml …

OPatch succeeded.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 27208670
1) Patch 27208670 applied on Tue Dec 11 10:51:12 EST 2018
[ Bug fixes: 27208670 22458773 24484104 ]

####################################################################################################################################################
Error Details for 27208670
####################################################################################################################################################

appltst@of223:~ $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 27208670

appltst@of223:~ $ cd /interface/patches/TLS_1.2_Patches/10.1.3/27208670/
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 1.0.0.0.62
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /ebsdb/tech_st/10.1.3
Oracle Home Inventory : /ebsdb/tech_st/10.1.3/inventory
Central Inventory : /im/finupg/oraInventory
from : /etc/oraInst.loc
OUI location : /ebsdb/tech_st/10.1.3/oui
OUI shared library : /ebsdb/tech_st/10.1.3/oui/lib/linux/liboraInstaller.so
Java location : /ebsdb/tech_st/10.1.3/jre/1.4.2/bin/java
Log file location : /ebsdb/tech_st/10.1.3/.patch_storage//*.log

Creating log file “/ebsdb/tech_st/10.1.3/.patch_storage/27208670/Apply_27208670_12-11-2018_10-43-00.log”

Invoking fuser to check for active processes.

Patch “27208670” overlays ” 21845942 “. Conflict check between them is skipped.

Backing up comps.xml …

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /ebsdb/tech_st/10.1.3)
Is this system ready for updating?
Please respond Y|N >
Y
Applying patch 27208670…

Patching copy files…

OPatch encounters the following issues during file patching:
The following files had problems with being patched:
1. /ebsdb/tech_st/10.1.3/opmn/bin/opmn
[ Couldn’t copy /interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/bin/opmn to /ebsdb/tech_st/10.1.3/opmn/bin/opmn from /interface/patches/TLS_1.2_Patches/10.1.3/27208670. ]

Replying ‘Y’ will terminate the patch installation immediately. It WILL NOT restore any updates that have been performed to this point. It WILL NOT update the inventory.
Replying ‘N’ will update the inventory showing the patch has been applied.
NOTE: After replying either ‘Y’ or ‘N’ it is critical to review:
My Oracle Support Note 312767.1 How to rollback a failed Interim patch installation.
Do you want to STOP?
Please respond Y|N >
N

Inventory is good and does not have any dangling patches.

Updating inventory…

Verifying patch…
Verifying that patch ID is in Oracle Home inventory.
Verifying copy files.

Comparing “/interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/bin/opmn” and “/ebsdb/tech_st/10.1.3/opmn/bin/opmn”
Source file name is : /interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/bin/opmn, size is : 501295
Destination file name(from OracleHome) is : /ebsdb/tech_st/10.1.3/opmn/bin/opmn, size is : 509724
Copy failed: failed to update “/ebsdb/tech_st/10.1.3/opmn/bin/opmn” with updated “/interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/bin/opmn”

Comparing “/interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/lib/libopmnoraclessl.so” and “/ebsdb/tech_st/10.1.3/opmn/lib/libopmnoraclessl.so”

Comparing “/interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/lib/libopmnopenssl.so” and “/ebsdb/tech_st/10.1.3/opmn/lib/libopmnopenssl.so”

Comparing “/interface/patches/TLS_1.2_Patches/10.1.3/27208670/files/opmn/lib/libmodapi.so” and “/ebsdb/tech_st/10.1.3/opmn/lib/libmodapi.so”
There are 1 issues copying files to Oracle Home.
FILE PROBLEM: some files are not patched.
OPATCH_JAVA_ERROR: Patch was not successfully applied.
Verification of the patch failed.

ERROR: OPatch failed as verification of the patch failed.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ opatch version

Oracle Interim Patch Installer version 1.0.0.0.62
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

OPatch Version: 1.0.0.0.62

appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 27208670
1) Patch 27208670 applied on Tue Dec 11 10:48:26 EST 2018
[ Bug fixes: 27208670 22458773 24484104 ]

appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ opatch rollback -id 27208670

Oracle Interim Patch Installer version 1.0.0.0.62
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /ebsdb/tech_st/10.1.3
Oracle Home Inventory : /ebsdb/tech_st/10.1.3/inventory
Central Inventory : /im/finupg/oraInventory
from : /etc/oraInst.loc
OUI location : /ebsdb/tech_st/10.1.3/oui
OUI shared library : /ebsdb/tech_st/10.1.3/oui/lib/linux/liboraInstaller.so
Java location : /ebsdb/tech_st/10.1.3/jre/1.4.2/bin/java
Log file location : /ebsdb/tech_st/10.1.3/.patch_storage//*.log

Creating log file “/ebsdb/tech_st/10.1.3/.patch_storage/27208670/RollBack_27208670_12-11-2018_10-50-20.log”

Invoking fuser to check for active processes.

Backing up comps.xml …

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /ebsdb/tech_st/10.1.3)
Is this system ready for updating?
Please respond Y|N >
Y
Removing patch 27208670…

Restoring copied files…

Updating inventory…
Backing up comps.xml …

Inventory is good and does not have any dangling patches.

OPatch succeeded.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 27208670

appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 1.0.0.0.62
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /ebsdb/tech_st/10.1.3
Oracle Home Inventory : /ebsdb/tech_st/10.1.3/inventory
Central Inventory : /im/finupg/oraInventory
from : /etc/oraInst.loc
OUI location : /ebsdb/tech_st/10.1.3/oui
OUI shared library : /ebsdb/tech_st/10.1.3/oui/lib/linux/liboraInstaller.so
Java location : /ebsdb/tech_st/10.1.3/jre/1.4.2/bin/java
Log file location : /ebsdb/tech_st/10.1.3/.patch_storage//*.log

Creating log file “/ebsdb/tech_st/10.1.3/.patch_storage/27208670/Apply_27208670_12-11-2018_10-50-53.log”

Invoking fuser to check for active processes.

Patch “27208670” overlays ” 21845942 “. Conflict check between them is skipped.

Backing up comps.xml …

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /ebsdb/tech_st/10.1.3)
Is this system ready for updating?
Please respond Y|N >
Y
Applying patch 27208670…

Patching copy files…

Inventory is good and does not have any dangling patches.

Updating inventory…

Verifying patch…
Backing up comps.xml …

OPatch succeeded.
appltst@of223:/interface/patches/TLS_1.2_Patches/10.1.3/27208670 $ $ORACLE_HOME/OPatch/opatch lsinventory|grep 27208670
1) Patch 27208670 applied on Tue Dec 11 10:51:12 EST 2018
[ Bug fixes: 27208670 22458773 24484104 ]

0

JRE Upgrade

1 Stop the Application services
2 Apply patch 19568561 (MERGE REQUEST ON TOP OF 10.1.0.5.0 FOR BUGS 18128233 19358438)
3 mv $FND_TOP/bin/txkSetPlugin.sh $FND_TOP/bin/txkSetPlugin-4377566.sh
4 Apply patch 21624242:R12.TXK.B (APPLICATIONS R12 INTEROPERABILITY PATCH FOR JRE PLUGIN)
5 “Download the latest “”JRE”” update (Do not download the “”Server JRE”” version)
from the Java SE Downloads page or as a patch from My Oracle Support as listed in the JRE Parameter Settings table.
•Click the JRE Download button for the appropriate Java version
•Click the Accept License Agreement button
•Download the Windows x86 Offline (32-bit) or Windows x64 (64-bit) version as required”
6 “Rename the JRE Plugin File
jre-8u73-windows-i586.exe or jre-8u73-windows-x64.exe would be renamed j2se18073.exe”
7 “Place the Renamed JRE Plugin on the Web Application Tier
$[COMMON_TOP]/webapps/oacore/util/jinitiator/”
8 “upgrade the JRE
$FND_TOP/bin/txkSetPlugin.sh 18073”
9 Start the application services and validate

0

Blog at WordPress.com.

Up ↑

%d bloggers like this: