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
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 thisby pathc adpatch =y preinstall
[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
p13390677_112040_Linux-x86-64_1of7. zip
p13390677_112040_Linux-x86-64_2of7. zip
[oracle@ebs
oracle] $ ! sq
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
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
**********************************************************************
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
[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
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
.
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
. 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
processes = 200 # Max. no . of users x 2
sessions = 400 # 2 X processes
db_name= PROD
control_files=/u01/app/oracle/PROD/
db_block_size= 8192
_system_trig_enabled=true
_system_trig_enabled = true
nls_language =
nls_territory =
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/
#background_dump_dest = /u01/app/oracle/PROD/
#core_dump_dest = /u01/app/oracle/PROD/
diagnostic_dest = /u01/app/oracle/PROD/
max_dump_file_size = 20480 # trace file size
timed_statistics = true
_trace_files_public = TRUE
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
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/
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
SQL>
select ABBREVIATION, NAME, codelevel
FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk ','ad');
ABBREVIA
NAME
--------
--------------------------------------------------
CODELEVEL
--------------------------------------------------------------------------------
B.3
B.4
[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
[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 /
[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
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 type in Context file to 64 bits
Configuring
templates from ORACLE_HOME ...
[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
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
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:
Post a Comment