How to upgrade EBS(R12.2) DB to 19c Database
Server Steps: -
Check OS version
cat /etc/os-release |
Check kernel version
uname -r |
RPM installation
yum install gdbm-1.10-8.el7.i686 rpm -qa | grep -i |
Kernel Parameter Check
/cat/sysctl.conf |
Swap space check
Recommended to set DB and apps swap space
to on-perm server
/proc/meminfo |
Domain Name System (DNS) Resolver
Parameters Check
/etc/resolv.conf |
Add etc/hosts entry
Check the ulimit settings in limits.conf
values
/etc/security/limits.conf Ex:- * hard nofile 65536 * soft nofile 4096 * hard nproc 16384 * soft nproc 2047 * hard stack 16384 * soft stack 10240 |
Install the VPN server
Setup firewall
OS User and group creation
Open Firewall port b/w on-perm to OCI
19C DB pre upgrade STEPS
· Run ETCC on application nodes to check for missing patches
·
Validate Application and
weblogic/Middle tier patches pre-request patches
Ref. - Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)
· Run Hcheck (hcheck.sql)script
to pre-check 19c upgrade issues
Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)
· EXECUTE ADGRANTS ON DB NODE
· Compile all the invalids
· RUN Autoconfig DB/Apps Node
·
Create Initialization parameter
file setup
$ORACLE_HOME/dbs/_initparam.sql and $ORACLE_HOME/dbs/_datatop.txt files.
· 19c DB Home installation
· Download and apply al needed 19c Patches
·
Create the nls/data/9idata
directory on 19c Home
$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl
· Create appsutil.zip and copy it to the database tier
· Install/Verify JRE 8 in the appsutil
· Create CDB DB using DBCA
·
Create URL file directory
Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1)
· Run the pre upgrade java file and preupgrade_fixups.sql file generated by the previous pre upgrade script step
· Verify the timezone version and update if needed
· Purge recycle bin
· Take Backup before upgrade
· Run DBUA to upgrade database to 19c and If it is RAC,set cluster_database =false
Post upgrade Task: -
·
Recreate 19c env file and setup
env
·
Recreate the SPFILE
·
Compile EBS logon trigger
·
Verify key parameters like
sec_case_sensitive_logon
·
Execute postupgrade_fixups
scripts
·
Check/Correct COMPATIBLE
parameters
·
Run Datapatch
·
Create the CDB MGDSYS schema
·
Run adgrants after copying from
apps server
· Gather statistics for the SYS schema and fixed table stats.
Comments
Post a Comment