Sunday, April 5, 2020

E-Bissiness Suite 12.1.1 to 12.1.3 UPGRADE


EBS--12.1.1 TO 12.1.3 --UPGRADE

[applmgr@ebs applmgr]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Mar 31 22:35:56 2020
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
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;

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;

RELEASE_NAME
--------------------------------------------------
12.1.1


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  


DB ---11.1.0.7  to 11.2.0.4--UPGRADE



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 pathc by adpatch preinstall=y

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


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


/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

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_2of7.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

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

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
---software of 11.2.0.4



















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
 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

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile=initPROD.ora upgrade
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

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.

SQL>
SQL> SET SERVEROUTPUT OFF
SQL> SET VERIFY ON
SQL> commit; 


SQL> @?/rdbms/admin/utlu112s.sql
.
Oracle Database 11.2 Post-Upgrade Status Tool                   04-01-2020 02:36:45
.
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

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

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


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 DBA
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
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













No comments:

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...