Apply Release 12.1.3 – R12.ATG_PF.B.delta.3

-
I have applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) in  the following steps
Instance 12.1.1Database version 11.2.0.7OS OEL 5.8
Before Applying Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) required to apply R12.AD.B.DELTA.3, Patch 9239089
unzip -o p9239089_R12.AD.B_R12_LINUX.zip
As oracle user Copy adgrants.sql from this patch/admin directory to $ORACLE_HOME/appsutil/admin.
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
Enable the maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=8
Apply patch 9239089
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9239089.log patchtop=~/upgrade12.1.3/9239089 driver=u9239089.drv
Apply patch 8919491 (Applications Technology Release 12.1.3)
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=8919491.log patchtop=~/upgrade12.1.3/8919491 driver=u8919491.drv
Post-Install Steps
Apply post-install Oracle E-Business Suite Applications Technology patches
Apply the following mandatory patches:
9869602:R12.OWF.B, Patch 9869602
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9869602.log patchtop=~/upgrade12.1.3/9869602 driver=u9869602.drv
9888158:R12.FND.B, Patch 9888158
Need to shut down all Application tier services before performing the task
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9888158.log patchtop=~/upgrade12.1.3/9888158 driver=u9888158.drv
9583541:R12.TXK.B, Patch 9583541
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9583541.log patchtop=~/upgrade12.1.3/9583541 driver=u9583541.drv
9794874:R12.FND.B, Patch 9794874
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9794874.log patchtop=~/upgrade12.1.3/9794874 driver=u9794874.drv
9907182:R12.FND.B, Patch 9907182
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9907182.log patchtop=~/upgrade12.1.3/9907182 driver=u9907182.drv
9951283:R12.FND.B, Patch 9951283
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9951283.log patchtop=~/upgrade12.1.3/9951283 driver=u9951283.drv
9951284:R12.FND.B, Patch 9951284
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9951284.log patchtop=~/upgrade12.1.3/9951284 driver=u9951284.drv
Required to update database tier nodes to the Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) code level.
After that applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3), perform the following required post-install steps to update all database tier nodes to the AutoConfig code level that is provided by this release:
As the APPLMGR user, run the environment
$APPL_TOP/APPS$CONTEXT_NAME.env
$perl AD_TOP/bin/ admkappsutil.pl
Database tier:
As the oracle user, run the environment
Copy or FTP the appsutil.zip file to the .
Uncompress appsutil.zip under the .
Run AutoConfig on the .
Run AutoConfig on all nodes with an Appl_Top
Database tier and application tier:
Run adpreclone.pl on the database tier and the application tier. Since updates included in Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) were applied to the system, you must run the adpreclone again in order to apply the updates to the clone directory structures used during cloning.
perl adpreclone.pl dbTierperl adpreclone.pl appsTier
Apply Oracle E-Business Suite Applications Technology Online Help
Apply Patch 9400185
unzip -o p9400185_R12_GENERIC.zip
adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9400185.log patchtop=~/upgrade12.1.3/9400185 driver=u9400185.drv
Disable the maintenance mode
adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=DISABLE_MAINT_MODE workers=8
Startup all Application tier services

Comments

Post a Comment

Popular posts from this blog

ORA-06512: at SYS.DBMS_METADATA_UTIL Error

-
 If you face an error like the following while performing “impdp” operations: Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3343 ORA-06512: at "SYS.KUPM$MCP", line 2636 ORA-39097: Data Pump job encountered unexpected error -1001 Solution: execute the following command: SQL> exec dbms_metadata_util.load_stylesheets; If the above query executes sucessfully then try the “impdp” command again. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> exec dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed. SQL>
Read more

RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase

-
Error Occurred :– Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() –> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oratest.tipl.com)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=TIR12.ticfg.com))) Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection Connection could not be obtained; returning null RC-00118: Error occurred during creation of database StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:661) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.re...
Read more

The install cannot proceed as service OracleServiceXE is present on the system

-
If you are not able to remove oracle from the above workaround. Please follow below steps to remove OracleServiceXE. Solution:– Try to delete the service using the command prompt: Click Start, type ‘cmd’ in the search field, and when ‘cmd’ shows up in the list of options, right click it and select ‘Run as Administrator’. At the Command Prompt window, type “sc delete OracleServiceXE” without the quotes and press Enter. Type “Exit” and press Enter. Hope it helps. C:\> sc stop OracleServiceXE                      (to Stop service) C:\> sc delete OracleServiceXE                      (to remove)
Read more