EBS UPGRADE –12.1.1 TO 12.1.3 —

[applmgr@ebs applmgr]$ sqlplus apps/apps—connect to applmgr and apps/apps

SQL*Plus: Release 10.1.0.5.0 – Production on Tue Mar 31 22:35:56 2020

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;——check the version

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production

PL/SQL Release 11.1.0.7.0 – Production

CORE 11.1.0.7.0 Production

TNS for Linux: Version 11.1.0.7.0 – Production

NLSRTL Version 11.1.0.7.0 – Production

SQL> select release_name from fnd_product_groups;—-check the release for EBS

RELEASE_NAME

————————————————–

12.1.1

Apply all the patches..

If you are on E-Business Suite Release 12.1, apply

Patch 7303030 – Oracle E-Business Suite 12.1.1
Patch 9062910 – 11g Release 2 interoperability patch for Release 12.1
Patch 8919489 – 12.1 TXK Delta 3 patch
Patch 9868229 – CST_LAYER_ACTUAL_COST_DTLS_V Becomes Invalid After 11.2.0.2 Upgrade
Patch 10163753 – BIV_B_AGE_H_SUM_MV Fails During Index Creation
Patch 11071569 – ADBLDXML Fails On Windows Server 2008 R2 64 Bit

SQL> select ad_patch.is_patch_applied (‘R12’,-1,7303030) from dual;

AD_PATCH.IS_PATCH_APPLIED(‘R12’,-1,7303030)

——————————————————————————–

EXPLICIT

Patch 9062910—11g Release 2 Interoperability patch for release 12.1

[applmgr@ebs patch]$ unzip p27135427_R12.TXK.B_R12_GENERIC.zip—u27135427.drv

[applmgr@ebs patch]$ unzip p9868229_R12.BOM.C_R12_GENERIC.zip

[applmgr@ebs patch]$ unzip p10163753_R12.BIV.B_R12_GENERIC.zip

Apply this patch by adpatch preinstall=y

[applmgr@ebs patch]$ unzip p9738085_R12.TXK.B_R12_GENERIC.zip

11.1.07 is not supported to 12.1.3 ebs. So we need to upgrade db 11.2.0.7 to higher version

Connect to ORACLE

[oracle@ebs OPatch]$ export ORACLE_BASE=/u01/app/oracle

[oracle@ebs OPatch]$ export ORACLE_HOME=/u01/app/oracle/PROD/db/tech_st/11.2.0.4

[oracle@ebs OPatch]$ export ORACLE_SID=PROD

[oracle@ebs OPatch]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH

[oracle@ebs OPatch]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@ebs OPatch]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/lib/site_perl/5.10.0

Go to this location and run perl script——/u01/app/oracle/PROD/db/tech_st/11.2.0.4

[oracle@ebs 11.2.0.4]$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl

Directory /u01/app/oracle/PROD/db/tech_st/11.2.0.4/nls/data/9idata already exist. Overwriting…

Copying files to /u01/app/oracle/PROD/db/tech_st/11.2.0.4/nls/data/9idata…

Copy finished.

Please reset environment variable ORA_NLS10 to /u01/app/oracle/PROD/db/tech_st/11.2.0.4/nls/data/9idata!

[oracle@ebs 11.2.0.4]$ export ORA_NLS10=/u01/app/oracle/PROD/db/tech_st/11.2.0.4/nls/data/9idata

oracle@ebs OPatch]$ cd 4247037/

[oracle@ebs 4247037]$ cd ..

[oracle@ebs OPatch]$ export PATH=/u01/app/oracle/PROD/db/tech_st/11.2.0.4/OPatch:$PATH

[oracle@ebs OPatch]$ cd 4247037/

Download 11.2.0.4 software from metalink

wget –http-user=dba@ranesh.com –http-password=123456 –no-check-certificate –output-document=p13390677_112040_Linux-x86-64_1of7.zip “https://updates.oracle.com/Orion/Services/download/p13390677_112040_Linux-x86-64_6of7.zip?aru=16716375&patch_file=p13390677_112040_Linux-x86-64_1of7.zip”

p13390677_112040_Linux-x86-64_1of7.zip

p13390677_112040_Linux-x86-64_2of7.zip

[oracle@ebs oracle]$ !sq

sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 – Production on Tue Mar 31 01:51:49 2020

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size 2166536 bytes

Variable Size 452985080 bytes

Database Buffers 599785472 bytes

Redo Buffers 14000128 bytes

Database mounted.

Database opened.

Download and Apply OPatch—6880880

Download and apply patch– p6400501_111060_Linux-x86-64.zip

….in software 11.2.04 and runinstaller

11.2.0.4 terminal we need run this

SQL>@/u01/app/oracle/PROD/db/tech_st/11.2.0.4/rdbms/admin/utlu112i.sql

…OUTPUT

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

Components: [The following database components will be upgraded or installed]

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

–> Oracle Catalog Views [upgrade] VALID

–> Oracle Packages and Types [upgrade] VALID

–> JServer JAVA Virtual Machine [upgrade] VALID

–> Oracle XDK for Java [upgrade] VALID

–> Real Application Clusters [upgrade] INVALID

–> OLAP Analytic Workspace [upgrade] VALID

–> OLAP Catalog [upgrade] VALID

–> Oracle Text [upgrade] VALID

–> Oracle XML Database [upgrade] VALID

–> Oracle Java Packages [upgrade] VALID

–> Oracle interMedia [upgrade] VALID

–> Spatial [upgrade] VALID

–> Data Mining [upgrade] VALID

–> Oracle OLAP API [upgrade] VALID

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

Miscellaneous Warnings

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

[oracle@ebs patches]$ export PATH=/u01/app/oracle/PROD/db/tech_st/11.2.0.4/OPatch:$PATH

Create And Run bash_profile for 11.2.0.4

[oracle@ebs oracle]$ vi PROD1_ebs.env

[oracle@ebs oracle]$ cat PROD1_ebs.env—————–create env file for 11.2.0.4

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/PROD/db/tech_st/11.2.0.4

export ORACLE_SID=PROD

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/lib/site_perl/5.10.0

export ORA_TZFILE=/u01/app/oracle/PROD/db/tech_st/11.2.0.4/oracore/zoneinfo/timezlrg_14.dat

[oracle@ebs oracle]$ . PROD1_ebs.env

[oracle@ebs oracle]$ cd $ORACLE_HOME

[oracle@ebs dbs]$ cp initPROD.ora /u01/app/oracle/PROD/db/tech_st/11.2.0.4/dbs/

racle@ebs dbs]$ export ORACLE_SID=PROD

[oracle@ebs dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 1 01:22:05 2020

Connected to an idle instance.

SQL> startup pfile=initPROD.ora upgrade——startup by pfile

ORA-25138: PLSQL_NATIVE_LIBRARY_DIR initialization parameter has been made obsolete

ORA-25138: PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT initialization parameter has been made obsolete

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size 2260088 bytes

Variable Size 427819912 bytes

Database Buffers 624951296 bytes

Redo Buffers 13905920 bytes

Database mounted.

Database opened

Sql>@?/rdbms/admin/catupgrd.sql——excute catupgrd.sql

Oracle Database 11.2 Post-Upgrade Status Tool 04-01-2020 02:06:58

.Component Current Version Elapsed Time

Name Status Number HH:MM:SS

.Oracle Server ORA-01408: such column list already indexed VALID 11.2.0.4.0 00:15:05

JServer JAVA Virtual Machine VALID 11.2.0.4.0 00:11:20

Oracle Real Application Clusters INVALID 11.2.0.4.0 00:00:00

OLAP Analytic Workspace VALID 11.2.0.4.0 00:00:20

OLAP Catalog VALID 11.2.0.4.0 00:00:38

Oracle OLAP API VALID 11.2.0.4.0 00:00:24

Oracle XDK VALID 11.2.0.4.0 00:00:28

Oracle Text VALID 11.2.0.4.0 00:00:45

Oracle XML Database VALID 11.2.0.4.0 00:02:54

Oracle Database Java Packages VALID 11.2.0.4.0 00:00:09

Oracle Multimedia VALID 11.2.0.4.0 00:02:32

Spatial VALID 11.2.0.4.0 00:03:39

Final Actions 00:01:45

Total Upgrade Time: 00:40:07

PL/SQL procedure successfully completed.

[oracle@ebs dbs]$ vi initPROD.ora———–create pfile

db_name= PROD
control_files=/u01/app/oracle/PROD/db/apps_st/data/cntrl01.dbf,/u01/app/oracle/PROD/db/apps_st/data/cntrl02.dbf,/u01/app/oracle/PROD/db/apps_st/data/cntrl03.dbf
db_block_size= 8192
compatible=11.2.0
_system_trig_enabled=true
_system_trig_enabled = true
nls_language = american
nls_territory = america
nls_date_format = DD-MON-RR
nls_numeric_characters = “.,”
nls_sort = binary # Required 11i setting
nls_comp = binary # Required 11i setting
nls_length_semantics = BYTE # Required 11i setting
#user_dump_dest = /u01/app/oracle/PROD/db/tech_st/11.2.0.4/admin/PROD_ebs/udump
#background_dump_dest = /u01/app/oracle/PROD/db/tech_st/11.2.0.4/admin/PROD_ebs/bdump
#core_dump_dest = /u01/app/oracle/PROD/db/tech_st/11.2.0.4/admin/PROD_ebs/cdump
diagnostic_dest = /u01/app/oracle/PROD/db/tech_st/11.2.0.4/admin/PROD_ebs

max_dump_file_size = 20480 # trace file size

timed_statistics = true

_trace_files_public = TRUE

processes = 200 # Max. no. of users x 2

sessions = 400 # 2 X processes

db_files = 512 # Max. no. of database files

dml_locks = 10000

cursor_sharing = EXACT # Required 11i settting

open_cursors = 600 # Consumes process memory, unless using MTS.

session_cached_cursors = 500

sga_target = 6G

shared_pool_size = 400M

shared_pool_reserved_size = 40M

db_block_checking = FALSE

db_block_checksum = TRUE

log_checkpoint_timeout = 1200 # Checkpoint at least every 20 mins.

log_checkpoint_interval = 100000

log_checkpoints_to_alert = TRUE

log_buffer = 10485760

undo_management=AUTO # Required 11i setting

undo_tablespace=APPS_UNDOTS1 # Required 11i setting

workarea_size_policy=AUTO # Required 11i setting

undo_tablespace=APPS_UNDOTS1 # Required 11i setting

workarea_size_policy=AUTO # Required 11i setting

olap_page_pool_size = 4194304

pga_aggregate_target=2G

plsql_optimize_level = 2 # Required 11i setting

plsql_code_type = INTERPRETED # Default 11i setting

#plsql_native_library_dir = /u01/app/oracle/PROD/db/tech_st/11.2.0.4/plsql/nativelib

#plsql_native_library_subdir_count = 149

utl_file_dir = /usr/tmp,/usr/tmp,/u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/outbound/PROD_ebs,/usr/tmp

aq_tm_processes = 1

job_queue_processes = 2

parallel_max_servers = 8

parallel_min_servers = 0

sec_case_sensitive_logon = FALSE

_b_tree_bitmap_plans = FALSE # Required 11i setting

_index_join_enabled = FALSE # Required 11i setting

_like_with_bind_as_equality = TRUE

_sort_elimination_cost_ratio=5

_fast_full_scan_enabled = FALSE

query_rewrite_enabled = true

_sqlexec_progression_cost=2147483647

optimizer_secure_view_merging=false

_optimizer_autostats_job=false # Turning off auto statistics

_disable_fast_validate=TRUE

_pga_max_size=104857600

IFILE=/u01/app/oracle/PROD/db/tech_st/11.2.0.4/dbs/PROD_ebs_ifile.ora

[oracle@ebs dbs]$ !sq

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 1 04:05:24 2020

Connected to an idle instance.

SQL> startup pfile=initPROD.ora;

ORACLE instance started.

Total System Global Area 6413680640 bytes

Fixed Size 2265224 bytes

Variable Size 452988792 bytes

Database Buffers 5939134464 bytes

Redo Buffers 19292160 bytes

Database mounted.

Database opened.

Copy listener.ora,sqlnet.ora,tnsnames.ora to 11.2.0.4 database

SQL> select banner from v$version;

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

PL/SQL Release 11.2.0.4.0 – Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 – Production

NLSRTL Version 11.2.0.4.0 – Production

SQL> alter system set “_disable_fast_validate” = TRUE scope = spfile;

System altered.

SQL> alter system set recyclebin = off scope = spfile;

System altered.

[oracle@ebs admin]$ unzip p9239089_R12.AD.B_R12_LINUX.zip

[oracle@ebs admin]$ cp adgrants /u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/admin/

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 1 19:08:54 2020

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adgrants.sql apps

Connected.

Keep the application in maintainence mode

Adpatch of—9239089—AD &TXK code patch

SQL> select ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in (‘txk’,’ad’);

ABBREVIA NAME CODELEVEL

——————————————————————————–

ad Applications DB B.3

txk Techstack B.4

Adpatch —9239090—12.1.3 upgrade patch

ADPatch -9817770 — POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH

ADPatch -9966055 — TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED

[applmgr@ebs out]$ cd $AD_TOP

[applmgr@ebs 12.0.0]$ cd bin

[applmgr@ebs bin]$ perl admkappsutil.pl

Starting the generation of appsutil.zip

Log file located at /u01/app/applmgr/PROD/inst/apps/PROD_ebs/admin/log/MakeAppsUtil_04071244.log

output located at /u01/app/applmgr/PROD/inst/apps/PROD_ebs/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

[applmgr@ebs out]$ cp /u01/app/applmgr/PROD/inst/apps/PROD_ebs/admin/out/appsutil.zip /u01/app/oracle/PROD/db/tech_st/11.2.0.4/

Cd $ADMIN_SCRIPTS_HOME

[oracle@ebs bin]$ ./adconfig.sh

Enter the full path to the Context file: /u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/PROD_ebs.xml

Enter the APPS user password:

The log file for this session is located at: /u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/log/PROD_ebs/04071251/adconfig.log

AutoConfig is configuring the Database environment…

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /u01/app/oracle/PROD/db/tech_st/11.2.0.4

Classpath : :/u01/app/oracle/PROD/db/tech_st/11.2.0.4/jdbc/lib/ojdbc5.jar:/u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/java/xmlparserv2.jar:/u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/java:/u01/app/oracle/PROD/db/tech_st/11.2.0.4/jlib/netcfg.jar:/u01/app/oracle/PROD/db/tech_st/11.2.0.4/jlib/ldapjclnt11.jar

Using Context file : /u01/app/oracle/PROD/db/tech_st/11.2.0.4/appsutil/PROD_ebs.xml

Context Value Management will now update the Context file

Updating Context file…COMPLETED

Attempting upload of Context file and templates to database…COMPLETED

Updating rdbms version in Context file to db112

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME …

AutoConfig completed successfully.

[applmgr@ebs out]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@ebs scripts]$ ./adautocfg.sh——–run autocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/app/applmgr/PROD/inst/apps/PROD_ebs/admin/log/04071257/adconfig.log

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location : /u01/app/applmgr/PROD/inst/apps/PROD_ebs

Classpath : /u01/app/applmgr/PROD/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/app/applmgr/PROD/apps/apps_st/comn/java/classes

Using Context file : /u01/app/applmgr/PROD/inst/apps/PROD_ebs/appl/admin/PROD_ebs.xml

Context Value Management will now update the Context file

Updating Context file…COMPLETED

Attempting upload of Context file and templates to database…COMPLETED

Configuring templates from all of the product tops…

Configuring AD_TOP……..COMPLETED

Configuring FND_TOP…….COMPLETED

Configuring ICX_TOP…….COMPLETED

Configuring MSC_TOP…….COMPLETED

Configuring IEO_TOP…….COMPLETED

Configuring BIS_TOP…….COMPLETED

Configuring AMS_TOP…….COMPLETED

Configuring CCT_TOP…….COMPLETED

Configuring WSH_TOP…….COMPLETED

Configuring CLN_TOP…….COMPLETED

Configuring OKE_TOP…….COMPLETED

Configuring OKL_TOP…….COMPLETED

Configuring OKS_TOP…….COMPLETED

Configuring CSF_TOP…….COMPLETED

Configuring IGS_TOP…….COMPLETED

Configuring IBY_TOP…….COMPLETED

Configuring JTF_TOP…….COMPLETED

Configuring MWA_TOP…….COMPLETED

Configuring CN_TOP……..COMPLETED

Configuring CSI_TOP…….COMPLETED

Configuring WIP_TOP…….COMPLETED

Configuring CSE_TOP…….COMPLETED

Configuring EAM_TOP…….COMPLETED

Configuring FTE_TOP…….COMPLETED

Configuring ONT_TOP…….COMPLETED

Configuring AR_TOP……..COMPLETED

Configuring AHL_TOP…….COMPLETED

Configuring OZF_TOP…….COMPLETED

Configuring IES_TOP…….COMPLETED

Configuring CSD_TOP…….COMPLETED

Configuring IGC_TOP…….COMPLETED

AutoConfig completed successfully.

SQL> select banner from v$version;

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

PL/SQL Release 11.2.0.4.0 – Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 – Production

NLSRTL Version 11.2.0.4.0 – Production

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME

————————————————–

12.1.3

M Ranesh

http://raneshoracle.blogspot.com and http://raneshoracledba.wordpress.com