Recently we have upgraded our instance from R12.1.1 to R12.1.3. Our database version was 11.0.6. Here is a step by step guide on how we have
upgraded this. I have listed all the issue list in the later part of this document.
upgraded this. I have listed all the issue list in the later part of this document.
The main documents you need to follow for main patch application->
Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]
Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]
Database Initialization Parameters for Oracle Applications Release 12 [ID 396009.1]
Oracle® E-Business Suite Upgrade Guide
Set recyclebin=false and _pga_max_size=104857600 in init.ora file
Now do the following after shutting down the database.
$ sqlplus / as sysdba
Run the following commands ->
SQL> startup pfile=/dbs/init<SID>.ora
SQL> create spfile from pfile='/init<SID>.ora';
File created.
SQL> show parameter utl
Run the following commands ->
SQL> startup pfile=/dbs/init<SID>.ora
SQL> create spfile from pfile='/init<SID>.ora';
File created.
SQL> show parameter utl
Follow document Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1] step by step for your database version. As our
database version was 11.0.6 we have followed path E.
We have applied the following patches in database.
For all UNIX/Linux platforms
Follow document Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1] step by step for applying main patch.
======================================
Issue ->
During the upgrade process to 12.1.1 this issue may be seen ->
ORA-04030: out of process memory when trying to allocate 822904 bytes
(pga heap,kco buffer)
ORA-07445: exception encountered: core dump [dbgtfdFileWrite()+48]
[SIGSEGV] [ADDR:0xFFFFFFFF7FFC1C88] [PC:0x1063BD2D0] [Address not mapped
to object] []
Solution ->
For this issue set the following parameter in init.ora file.
_pga_max_size=104857600
Now do the following after shutting down the database.
$ sqlplus / as sysdba
Run the following commands ->
SQL> startup pfile=/dbs/init<SID>.ora
SQL> create spfile from pfile='/init<SID>.ora';
File created.
SQL> show parameter utl
Run the following commands ->
SQL> startup pfile=/dbs/init<SID>.ora
SQL> create spfile from pfile='/init<SID>.ora';
File created.
SQL> show parameter utl
============================================
No comments :
Post a Comment