Hai in this Article I will demonstrate how to
upgrade EBS (R12.1.3) database from 11.1.0.7 to 11.2.0.2 in Linux 5.7_x64
Interoperability Notes Oracle EBS R12 with Oracle Database 11gR2 (11.2.0.2) (Doc ID 1367644.1)
Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)
Pre - Upgrade
Steps:
1.
Install Oracle 11.2.0.2 Software Only
2.
Install Examples CD
3.
Copy Listner tns folder to 11gR2 Home and change
oracle HOME
4.
shutdown Application and database Listener
5.
Apply Application Patches using adpatch
Upgrade Steps:
1.
run pre upgrade Commands from 11.1.0.7 Home and
fix issues
2.
edit initfile
parameters
3.
run dbua command from 11.2.0.2 Home
Post - Upgrade Steps:
1.
Compile invalid Objects
2.
Running of Scripts
3.
Gather statistics
4.
Recreate grants and synonyms using adadmin (4à2)
5.
Running Autoconfig on db and apps Tier
My Machine's Existing software and
Directories details:
[root@rac1 ~]# cat
/etc/enterprise-release
Enterprise Linux
Enterprise Linux Server release 5.7 (Carthage)
[root@rac1 ~]# arch
x86_64
[root@rac1 ~]# hostname
rac1.dell.com
[root@rac1 ~]# hostname -i
192.168.1.11
[root@rac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 190G 13G
168G 7% /
/dev/sda5 723G 137G
550G 20% /u01
/dev/sda3 29G 364M
27G 2% /tmp
tmpfs 4.0G 0
4.0G 0% /dev/shm
/dev/sr0 3.6G 3.6G
0 100% /media/OL5.7 x86_64 dvd 20110728
.host:/ 466G 188G
279G 41% /mnt/hgfs
[root@rac1 ~]# cat
/etc/hosts
# Do not remove the
following line, or various programs
# that require network
functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.1.11 rac1.dell.com rac1
[root@rac1 ~]# cat
/etc/oratab
PROD:/u01/db/tech_st/11.1.0:N
[root@rac1 ~]# cat
/etc/oraInst.loc
inventory_loc=/u01/oraInventory/
inst_group=dbaerp
[root@rac1 ~]# chmod -R 775
/etc/oraInst.loc
[root@rac1 ~]# mkdir -p
/u01/oraInventory/
[root@rac1 ~]# mkdir -p
/u01/db/tech_st/11.2.0
[root@rac1 ~]# chown -R
oraerp:dbaerp /u01
[root@rac1 ~]# chmod -R 775
/u01/
[root@rac1 ~]# chmod -R 775
/u01/oraInventory/
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ id
uid=54322(oraerp)
gid=54323(dbaerp) groups=54323(dbaerp)
[oraerp@rac1 ~]$
Size of
Database and Apps
[oraerp@rac1 ~]$ cd /u01/
[oraerp@rac1 u01]$ du -sh *
37G apps
101G db
[oraerp@rac1 ~]$
Invalid
objects check
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ .
PROD_rac1.env
[oraerp@rac1 ~]$ sqlplus / as
sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Sun Mar 19 07:54:54 2017
Copyright (c) 1982,
2008, 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>
SQL> show user
USER is
"SYS"
SQL>
SQL> select
count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
30
SQL>
SQL> column owner
format A12
column object_type format A13
select owner,object_type,COUNT(*)
from dba_objects
where status='INVALID'
group by owner, object_type;
OWNER OBJECT_TYPE COUNT(*)
------------
------------- ----------
APPS PACKAGE BODY 30
Invalid
objects are only for the APPS user. We can move further
If
there are any invalid objects for SYS user then try to fix that first.
For better performance in Upgrade
1. Run “Gather
Schema Statistics” for ALL users
2. Compile Apps Schecma using adadmin (3à1), before upgrade
3. Run Concurrent Request “Purge Concurrent
Request and/or Manager Data”.
Let’s Check Database
version before proceeding to UPGRADE
Application and Database Patches
Application and Database Patches
Application Patches for EBS-R12.1.3
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd
/shrf/patches/apps_patches_11202/
[oracle@rac1
apps_patches_11202]$ ll
total 28412
-rwxr-xr-x 1 oraerp
dbaerp 28978624 Mar 1 16:48
p8919489_R12.TXK.B_R12_GENERIC.zip
-rwxr-xr-x 1 oraerp
dbaerp 59037 Mar 1 16:48 p9062910_12.1.0_R12_GENERIC.zip
-rwxr-xr-x 1 oraerp
dbaerp 9340 Mar 1 16:48 p9852070_R12.TXK.B_R12_GENERIC.zip
[oracle@rac1
apps_patches_11202]$
Database Patches for 11.2.0.2 RDBMS
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd /shrf/patches/db_patches_11202/
[oracle@rac1
db_patches_11202]$ ll
total 904
-rwxr-xr-x 1 oraerp dbaerp 61742 Mar
1 16:48 p10149223_112020_Linux-x86-64.zip
-rwxr-xr-x 1 oraerp dbaerp 179103 Mar 1 16:48 p10160615_112020_Linux-x86-64.zip
-rwxr-xr-x 1 oraerp dbaerp 235602 Mar 1 16:48 p10229719_112020_Linux-x86-64.zip
-rwxr-xr-x 1 oraerp dbaerp 102277 Mar 1 16:48 p12400751_112020_Linux-x86-64.zip
-rwxr-xr-x 1 oraerp dbaerp 123965 Mar 1 16:48 p12942119_112020_Linux-x86-64.zip
-rwxr-xr-x 1 oraerp dbaerp 20642 Mar
1 16:48 p13001379_112020_Generic.zip
-rwxr-xr-x 1 oraerp dbaerp 99545 Mar
1 16:48 p13004894_112020_Linux-x86-64.zip
-rwxr-xr-x 1 oraerp dbaerp 52225 Mar
1 16:48 p4247037_112020_Generic.zip
[oracle@rac1
db_patches_11202]$
Prepare to create 11.2.0. Oracle home
[oracle@rac1 ~]$
[oracle@rac1 ~]$ mkdir -p /u01/db/tech_st/11.2.0
[oracle@rac1 ~]$ mkdir -p /u01/db/tech_st/11.2.0
and
install all the required RPMS for 11gR2, check the below link for list of RPMS
Installation of RDBMS 11.2.0.2 Software
Note :Before install 11gR2 check you r central Inventory
details in /etc/oraInst.loc file and 775 permission as shown above
[oracle@rac1 db_11202_x64]$
ll
total 1704800
drwxr-xr-x 8 oraerp dbaerp 4096 Nov 16 2010 database
drwxr-xr-x 6 oraerp dbaerp 4096 Nov 12 2010 examples
-rwxrwxrwx 1 oraerp dbaerp 1307536871 Feb 19 08:51
p10098816_112020_Linux-x86-64_1of7.zip
-rwxrwxrwx 1 oraerp dbaerp 1049912579 Feb 19 09:02
p10098816_112020_Linux-x86-64_2of7.zip
-rwxrwxrwx 1 oraerp dbaerp 476740652 Feb 19 11:32
p10098816_112020_Linux-x86-64_6of7.zip
[oracle@rac1 db_11202_x64]$
Click Fix & Check
Again button
Execute Fixup Scripts
[root@rac1 ~]#
[root@rac1 ~]# /tmp/CVU_11.2.0.2.0_oraerp/runfixup.sh
/usr/bin/id
Response file being
used is :/tmp/CVU_11.2.0.2.0_oraerp/fixup.response
Enable file being used
is :/tmp/CVU_11.2.0.2.0_oraerp/fixup.enable
Log file location:
/tmp/CVU_11.2.0.2.0_oraerp/orarun.log
uid=54322(oraerp)
gid=54323(dbaerp) groups=54323(dbaerp)
[root@rac1 ~]#
Execute Configuration Scripts:
[root@rac1 ~]#
[root@rac1 ~]# /u01/db/tech_st/11.2.0/root.sh
Running Oracle 11g
root script...
The following environment
variables are set as:
ORACLE_OWNER= oraerp
ORACLE_HOME= /u01/db/tech_st/11.2.0
Enter the full
pathname of the local bin directory: [/usr/local/bin]: (PRESS
ENTER)
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added
to the /etc/oratab file as needed by
Database Configuration
Assistant when a database is created
Finished running
generic part of root script.
Now product-specific
root actions will be performed.
Finished
product-specific root actions.
[root@rac1 ~]#
Check the Installer log
file for any error
Install Oracle Database
11g Products from the 11g Examples CD
Select NEW HOME location @
“Software Location”
Before Proceeding
Further take Cold Backup
Copy of files ( vi editor :%s/11.1.0/11.2.0/g )
1. Copy Listener & tns folder
from OLD_HOME to NEW_HOME and change values of ORACLE_HOME(11.1.0) to
NEW_HOME(11.2.0)
[oraerp@rac1 network]$
[oraerp@rac1 network]$ pwd
/u01/db/tech_st/11.1.0/network
[oraerp@rac1 network]$
[oraerp@rac1 network]$ pwd
/u01/db/tech_st/11.1.0/network
[oraerp@rac1 network]$
[oraerp@rac1 network]$
cp
-R admin/ /u01/db/tech_st/11.2.0/network/
[oraerp@rac1 ~]$ vi /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/listener.ora
[oraerp@rac1 ~]$ vi /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/tnsnames.ora
[oraerp@rac1 ~]$ vi
/u01/db/tech_st/11.2.0/network/admin/PROD_rac1/sqlnet.ora
2. Copy upgrade scripts from
NEW_HOME
[oraerp@rac1 ~]$ cp
/u01/db/tech_st/11.2.0/rdbms/admin/utlu112i.sql /shrf/db_scripts/
[oraerp@rac1 ~]$ cp /u01/db/tech_st/11.2.0/rdbms/admin/utlrp.sql /shrf/db_scripts/
3. Copy files from Application
Server
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ . APPSPROD_rac1.env
[oraerp@rac1 ~]$ cp
$APPL_TOP/admin/adgrants.sql /shrf/db_scripts/
[oraerp@rac1 ~]$ cp
$AD_TOP/patch/115/sql/adctxprv.sql /shrf/db_scripts/
[oraerp@rac1 ~]$ cp
$FND_TOP/patch/115/sql/wfaqupfix.sql /shrf/db_scripts/
[oraerp@rac1 ~]$ cp
$APPL_TOP/admin/adstats.sql /shrf/db_scripts/
[oraerp@rac1 ~]$ cd
/shrf/db_scripts/
[oraerp@rac1
db_scripts]$ ll
total 580
-rwxr-xr-x 1 oraerp
dbaerp 1664 Mar 18 14:39 adctxprv.sql
-rwxr-xr-x 1 oraerp
dbaerp 53060 Mar 18 14:39 adgrants.sql
-rwxr-xr-x 1 oraerp
dbaerp 2752 Mar 18 14:39 adstats.sql
-rwxr-xr-x 1 oraerp
dbaerp 3221 Mar 18 14:42 utlrp.sql
-rw-r--r-- 1 oraerp
dbaerp 204205 Mar 18 12:44 utlu112i.sql
-rwxr-xr-x 1 oraerp
dbaerp 4631 Mar 18 14:39 wfaqupfix.sql
[oraerp@rac1
db_scripts]$
New Env. File for 11gR2
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ cat
11gR2.env
export ORACLE_SID=PROD
export
ORACLE_BASE=/u01
export
ORACLE_HOME=/u01/db/tech_st/11.2.0
export
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export
ORA_NLS10=/u01/db/tech_st/11.2.0/nls/data/9idata
export
TNS_ADMIN=$ORACLE_HOME/network/admin/PROD_rac1
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$
Create nls/data/9idata directory
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ perl
/u01/db/tech_st/11.2.0/nls/data/old/cr9idata.pl
Creating directory
/u01/db/tech_st/11.2.0/nls/data/9idata ...
Copying files to
/u01/db/tech_st/11.2.0/nls/data/9idata...
Copy finished.
Please reset
environment variable ORA_NLS10 to /u01/db/tech_st/11.2.0/nls/data/9idata!
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$
Application Patches Status
(enable maintenance mode
and apply patches using adpatch)
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ .
APPSPROD_rac1.env
[oraerp@rac1 ~]$ sqlplus
apps/apps
SQL*Plus: Release
10.1.0.5.0 - Production on Sat Mar 18 12:22:10 2017
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
bug_number from ad_bugs where bug_number='8919489';
BUG_NUMBER
------------------------------
8919489
8919489
SQL> select
bug_number from ad_bugs where bug_number='9062910';
BUG_NUMBER
------------------------------
9062910
SQL> select
bug_number from ad_bugs where bug_number='9852070';
BUG_NUMBER
------------------------------
9852070
SQL>
Apply additional 11.2.0.2 RDBMS patches
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ which opatch
/u01/db/tech_st/11.2.0/OPatch/opatch
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ opatch
version
Invoking OPatch
11.2.0.1.1
OPatch Version:
11.2.0.1.1
OPatch succeeded.
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ opatch
lsinventory
[oraerp@rac1 4247037]$
[oraerp@rac1 4247037]$
opatch
apply
Invoking OPatch
11.2.0.1.1
Oracle Interim Patch
Installer version 11.2.0.1.1
Copyright (c) 2009,
Oracle Corporation. All rights reserved.
Oracle Home : /u01/db/tech_st/11.2.0
Central Inventory :
/u01/oraInventory/
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.1
OUI version : 11.2.0.2.0
OUI location : /u01/db/tech_st/11.2.0/oui
Log file location :
/u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-18_12-26-44PM.log
Patch history file:
/u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying
interim patch '4247037' to OH '/u01/db/tech_st/11.2.0'
Running prerequisite
checks...
OPatch detected
non-cluster Oracle Home from the inventory and will patch the local system
only.
Backing up files and
inventory (not for auto-rollback) for the Oracle Home
Backing up files
affected by the patch '4247037' for restore. This might take a while...
Backing up files
affected by the patch '4247037' for rollback. This might take a while...
Patching component
oracle.sdo.locator, 11.2.0.2.0...
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/catmgdidcode.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/catnomgdidcode.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidcodetype.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidcodetype.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidcodeutl.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidcodeutl.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdiddeinstall.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidepctype.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidepctype.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidinstall.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidmetadata.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidmetatable.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdidprivs.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/mgdsys.sql"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/prvtmgdidcodetypeb.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/prvtmgdidcodeutlb.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/admin/prvtmgdidepctypeb.plb"
Copying file to
"/u01/db/tech_st/11.2.0/md/support/patchset_mgdsys_validity.sql"
ApplySession adding
interim patch '4247037' to inventory
Verifying the
update...
Inventory check OK:
Patch ID 4247037 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files
from Patch ID 4247037 are present in Oracle Home.
OPatch succeeded.
[oraerp@rac1 4247037]$
[oraerp@rac1
10149223]$
[oraerp@rac1
10149223]$ opatch apply
Invoking OPatch
11.2.0.1.1
Oracle Interim Patch
Installer version 11.2.0.1.1
Copyright (c) 2009,
Oracle Corporation. All rights reserved.
Oracle Home : /u01/db/tech_st/11.2.0
Central Inventory :
/u01/oraInventory/
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.1
OUI version : 11.2.0.2.0
OUI location : /u01/db/tech_st/11.2.0/oui
Log file location :
/u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-18_12-28-52PM.log
Patch history file:
/u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying
interim patch '10149223' to OH '/u01/db/tech_st/11.2.0'
Running prerequisite
checks...
OPatch detected
non-cluster Oracle Home from the inventory and will patch the local system
only.
Please shutdown Oracle
instances running out of this ORACLE_HOME on the local system.
(Oracle Home =
'/u01/db/tech_st/11.2.0')
Is the local system
ready for patching? [y|n]
y
User Responded with: Y
Backing up files and
inventory (not for auto-rollback) for the Oracle Home
Backing up files
affected by the patch '10149223' for restore. This might take a while...
Backing up files
affected by the patch '10149223' for rollback. This might take a while...
Patching component
oracle.rdbms, 11.2.0.2.0...
Updating archive file
"/u01/db/tech_st/11.2.0/lib/libserver11.a" with "lib/libserver11.a/kkqu.o"
Running make for
target ioracle
ApplySession adding
interim patch '10149223' to inventory
Verifying the
update...
Inventory check OK:
Patch ID 10149223 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files
from Patch ID 10149223 are present in Oracle Home.
The local system has
been patched and can be restarted.
OPatch succeeded.
[oraerp@rac1
10149223]$
Apply all the recommended
patches in same way
[oraerp@rac1
10160615]$ opatch apply
OPatch succeeded.
[oraerp@rac1
10229719]$ opatch apply
OPatch succeeded.
[oraerp@rac1
12400751]$ opatch apply
OPatch succeeded.
[oraerp@rac1
13001379]$ opatch apply
OPatch succeeded.
[oraerp@rac1
13004894]$ opatch apply
OPatch succeeded.
[oraerp@rac1
13004894]$ opatch lsinventory
Invoking OPatch
11.2.0.1.1
Oracle Interim Patch
Installer version 11.2.0.1.1
Copyright (c) 2009,
Oracle Corporation. All rights reserved.
Oracle Home : /u01/db/tech_st/11.2.0
Central Inventory :
/u01/oraInventory/
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.1
OUI version : 11.2.0.2.0
OUI location :
/u01/db/tech_st/11.2.0/oui
Log file location :
/u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch2017-03-18_12-34-17PM.log
Patch history file:
/u01/db/tech_st/11.2.0/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output
file location : /u01/db/tech_st/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2017-03-18_12-34-17PM.txt
--------------------------------------------------------------------------------
Installed Top-level
Products (2):
Oracle Database
11g 11.2.0.2.0
Oracle Database 11g
Examples
11.2.0.2.0
There are 2 products
installed in this Oracle Home.
Interim patches (7) :
Patch 13004894
: applied on Sat Mar 18 12:33:23 AST 2017
Unique Patch ID: 14143364
Created on 28 Sep 2011, 10:06:58 hrs PST8PDT
Bugs fixed:
13004894
Patch 13001379
: applied on Sat Mar 18 12:32:34 AST 2017
Unique Patch ID: 14718548
Created on 31 Mar 2012, 04:48:44 hrs PST8PDT
Bugs fixed:
13001379
Patch 12400751
: applied on Sat Mar 18 12:32:11 AST 2017
Unique Patch ID: 13880767
Created on 28 Jun 2011, 00:48:59 hrs PST8PDT
Bugs fixed:
12400751
Patch 10229719
: applied on Sat Mar 18 12:31:03 AST 2017
Unique Patch ID: 13186657
Created on 28 Nov 2010, 23:27:11 hrs PST8PDT
Bugs fixed:
10229719
Patch 10160615
: applied on Sat Mar 18 12:30:13 AST 2017
Unique Patch ID: 13348800
Created on 17 Jan 2011, 05:06:03 hrs PST8PDT
Bugs fixed:
10160615
Patch 10149223
: applied on Sat Mar 18 12:29:11
AST 2017
Unique Patch ID: 13073567
Created on 25 Oct 2010, 03:35:14 hrs PST8PDT
Bugs fixed:
10149223
Patch 4247037
: applied on Sat Mar 18 12:26:48 AST 2017
Unique Patch ID: 13016142
Created on 17 SEP 2009, 09:52:00 hrs
US/Pacific
Bugs fixed:
4247037
--------------------------------------------------------------------------------
OPatch succeeded.
[oraerp@rac1
13004894]$
2. UPGRADE STEPS
Run utlu112i.sql from 11.1.0.7 Home
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ .
PROD_rac1.env
[oraerp@rac1 ~]$ cd
/shrf/db_scripts/
[oraerp@rac1
db_scripts]$ ll utlu112i.sql
total 204
-rw-r--r-- 1 oraerp
dbaerp 204205 Mar 18 12:44 utlu112i.sql
[oraerp@rac1
db_scripts]$
[oraerp@rac1
db_scripts]$ sqlplus / as sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Sat Mar 18 12:48:23 2017
Copyright (c) 1982,
2008, 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>
SQL> @utlu112i.sql
Oracle Database 11.2
Pre-Upgrade Information Tool 03-18-2017 12:48:39
Script Version:
11.2.0.2.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: PROD
--> version: 11.1.0.7.0
-->
compatible: 11.1.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file:
V10
.
**********************************************************************
Tablespaces: [make
adjustments in the current environment]
**********************************************************************
--> SYSTEM
tablespace is adequate for the upgrade.
.... minimum required
size: 11707 MB
--> CTXD tablespace
is adequate for the upgrade.
.... minimum required
size: 16 MB
--> ODM tablespace
is adequate for the upgrade.
.... minimum required
size: 10 MB
--> APPS_UNDOTS1
tablespace is adequate for the upgrade.
.... minimum required
size: 260 MB
--> APPS_TS_TX_DATA
tablespace is adequate for the upgrade.
.... minimum required
size: 25978 MB
--> APPS_TS_QUEUES
tablespace is adequate for the upgrade.
.... minimum required
size: 173 MB
--> SYSAUX
tablespace is adequate for the upgrade.
.... minimum required
size: 1158 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters:
[Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool
was run on a lower version 64-bit database.
**********************************************************************
--> If Target
Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter
changes are required.
.
--> If Target
Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter
changes are required.
.
**********************************************************************
Renamed Parameters:
[Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed
parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated
Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-->
plsql_native_library_dir 11.2 OBSOLETE
-->
plsql_native_library_subdir_ 11.2 OBSOLETE
.
**********************************************************************
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
**********************************************************************
WARNING: -->
Database is using a timezone file older than version 14.
.... After the release
migration, it is recommended that DBMS_DST package
.... be used to
upgrade the 11.1.0.7.0 database timezone version
.... to the latest
version which comes with the new release.
WARNING: -->
Database contains INVALID objects prior to upgrade.
.... The list of
invalid SYS/SYSTEM objects was written to
....
registry$sys_inv_objs.
.... The list of
non-SYS/SYSTEM objects was written to
....
registry$nonsys_inv_objs.
.... Use utluiobj.sql
after the upgrade to identify any new invalid
.... objects due to
the upgrade.
.... USER APPS has 30
INVALID objects.
WARNING: --> Your
recycle bin contains 14 object(s).
.... It is REQUIRED
that the recycle bin is empty prior to upgrading
.... your
database. The command:
PURGE DBA_RECYCLEBIN
.... must be executed
immediately prior to executing your upgrade.
WARNING: -->
Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g
Upgrade Guide for instructions to configure Network ACLs.
.... USER APPS has
dependent objects.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends
gathering dictionary statistics prior to
upgrading the
database.
To gather dictionary
statistics execute the following command
while connected as
SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
**********************************************************************
Oracle recommends
removing all hidden parameters prior to upgrading.
To view existing
hidden parameters execute the following command
while connected AS
SYSDBA:
SELECT name,description from
SYS.V$PARAMETER WHERE name
LIKE '\_%' ESCAPE '\'
Changes will need to
be made in the init.ora or spfile.
**********************************************************************
Oracle recommends
reviewing any defined events prior to upgrading.
To view existing
non-default events execute the following commands
while connected AS
SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),'
')) FROM sys.v$parameter2
WHERE
UPPER(name) ='EVENT' AND isdefault='FALSE'
Trace Events:
SELECT (translate(value,chr(13)||chr(10),'
')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND
isdefault='FALSE'
Changes will need to
be made in the init.ora or spfile.
**********************************************************************
The DMSYS schema
exists in the database. Prior to
performing an
upgrade Oracle
recommends that the DMSYS schema, and its associated
objects be removed
from the database.
Refer to the Oracle
Data Mining Administration Guide for the
instructions on how to
perform this task.
**********************************************************************
SQL>
SQL>
Clear Your Recycle bin as per
above WARNING
SQL>
SQL> show user
USER is
"SYS"
SQL>
SQL> PURGE
DBA_RECYCLEBIN;
SQL>
Gather Dictionary statistics as
per Recommendations
SQL>
SQL> show user
USER is
"SYS"
SQL> EXECUTE
dbms_stats.gather_dictionary_stats;
SQL>
Stop application Services and Database Listener for EBS
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ .
APPSPROD_rac1.env
[oraerp@rac1 ~]$ adopmnctl.sh
status
You are running
adopmnctl.sh version 120.6.12010000.4
Checking status of
OPMN managed processes...
Processes in Instance:
PROD_rac1.rac1.dell.com
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm |
7834 | Alive
OC4JGroup:default_group | OC4J:forms |
7762 | Alive
OC4JGroup:default_group | OC4J:oacore |
7612 | Alive
HTTP_Server | HTTP_Server |
7555 | Alive
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adopmnctl.txt for more
information ...
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ adstpall.sh
apps/apps
adstpall.sh: exiting
with status 0
[oraerp@rac1 ~]$ adopmnctl.sh status
You are running
adopmnctl.sh version 120.6.12010000.4
Checking status of
OPMN managed processes...
Unable to connect to
opmn.
Opmn may not be up.
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adopmnctl.txt for more
information ...
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ .
PROD_rac1.env
[oraerp@rac1 ~]$ lsnrctl stop
PROD
LSNRCTL for Linux:
Version 11.1.0.7.0 - Production on 18-MAR-2017 13:03:33
Copyright (c) 1991,
2008, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.dell.com)(PORT=1531)))
The command completed
successfully
[oraerp@rac1 ~]$
Editing Pfile Comment on local_listener
In order to avoid the following error during upgrade remove local_listener parameter, else you will get following error
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘*******‘
ORA-01078: failure in processing system parameters
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ .
PROD_rac1.env
[oraerp@rac1 ~]$ sqlplus / as
sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Sat Mar 18 13:05:03 2017
SQL> show
parameter local_listener
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
local_listener string PROD_LOCAL
SQL>
SQL> shut
immediate
Database closed.
Database dismounted.
ORACLE instance shut
down.
SQL>
SQL> exit
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraerp@rac1 ~]$
[oraerp@rac1 dbs]$ cd
/u01/db/tech_st/11.1.0/dbs/
[oraerp@rac1 dbs]$ vi
initPROD.ora
[oraerp@rac1 dbs]$ sqlplus / as
sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Sat Mar 18 13:11:41 2017
Copyright (c) 1982,
2008, Oracle. All rights reserved.
Connected to an idle
instance.
SQL> startup
Database mounted.
Database opened.
SQL> show
parameter local_listener
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
local_listener string
SQL>
NOTE: I have commented(#) on local_listener parameter
Upgradation almost 1hr on 8Gb Ram
NOTE: Before you run dbua check
/etc/oratab file for entry of your Current
database details as shown above
PROD:/u01/db/tech_st/11.1.0:N
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ cd
/u01/db/tech_st/11.2.0/bin/
[oraerp@rac1 bin]$ ll dbua
-rwxr-xr-x 1 oraerp
dbaerp 7873 Mar 18 12:04 dbua
[oraerp@rac1 bin]$ ./dbua
-initParam "_disable_fast_validate=TRUE"
You can check the log file during upgrade
[root@rac1 ~]# cd
/u01/cfgtoollogs/dbua/PROD/upgrade1/
[oraerp@rac1
upgrade1]$ ll
total 29952
-rw-r----- 1 oraerp
dbaerp 4688 Mar 18 13:30 mapfile.txt
-rw-r----- 1 oraerp
dbaerp 30323250 Mar 18 13:57 Oracle_Server.log
-rw-r----- 1 oraerp
dbaerp 2850 Mar 18 13:39
Oracle_Text.log
-rw-r----- 1 oraerp
dbaerp 1499 Mar 18 13:39
PreUpgrade.log
-rw-r----- 1 oraerp
dbaerp 9274 Mar 18 13:39
PreUpgradeResults.html
-rw-r----- 1 oraerp
dbaerp 257 Mar 18 13:39
SpaceUsage.txt
-rw-r----- 1 oraerp
dbaerp 68370 Mar 18 13:42 sqls.log
-rw-r----- 1 oraerp
dbaerp 187190 Mar 18 13:56 trace.log
-rw-r----- 1 oraerp
dbaerp 1127 Mar 18 13:30
Upgrade_Directive.log
-rw-r----- 1 oraerp
dbaerp 3320 Mar 18 13:29 upgrade.xml
[oraerp@rac1
upgrade1]$
[oraerp@rac1
upgrade1]$ tail -f /u01/cfgtoollogs/dbua/PROD/upgrade1/Oracle_Server.log
Ignore the following error ORA-01408
Check the Upgrade Log for any Errors
Check the invalid objects and compile
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ cd
/shrf/db_scripts/
[oraerp@rac1
db_scripts]$ sqlplus / as sysdba
SQL*Plus: Release
11.2.0.2.0 Production on Sat Mar 18 15:59:23 2017
Copyright (c) 1982,
2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL> select
count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
71
SQL>
SQL> column owner
format A12
column object_type format A13
select owner,object_type,COUNT(*)
from dba_objects
where status='INVALID'
group by owner, object_type;
OWNER OBJECT_TYPE COUNT(*)
------------
------------- ----------
APPS PACKAGE BODY 58
APPS MATERIALIZED 13
VIEW
SQL>
SQL> @/u01/db/tech_st/11.2.0/rdbms/admin/utlrp.sql
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP
UTLRP_BGN 2017-03-18 16:00:59
DOC> The following PL/SQL block invokes
UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time
is proportional to the
DOC> number of invalid objects in the database,
so this command may take
DOC> a long time to execute on a database with a
large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track
recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid
objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status
IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects
compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM
UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or
parallel recompilation
DOC> based on the number of CPUs available
(parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter
parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC
nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create
jobs for parallel
DOC> recompilation. Jobs are created without
instance affinity so that they
DOC> can migrate across RAC nodes. Use the
following queries to verify
DOC> whether UTL_RECOMP jobs are being created
and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM
dba_scheduler_jobs
DOC> WHERE job_name like
'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are
running
DOC> SELECT job_name FROM
dba_scheduler_running_jobs
DOC> WHERE job_name like
'UTL_RECOMP_SLAVE_%';
DOC>#
PL/SQL procedure
successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP
UTLRP_END 2017-03-18 16:01:30
DOC> The following
query reports the number of objects that have compiled
DOC> with errors
(objects that compile with errors have status set to 3 in
DOC> obj$). If the
number is higher than expected, please examine the error
DOC> messages
reported with each object (using SHOW ERRORS) to see if they
DOC> point to
system misconfiguration or resource constraints that must be
DOC> fixed before
attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
0
DOC> The following
query reports the number of errors caught during
DOC> recompilation.
If this number is non-zero, please query the error
DOC> messages in
the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to
misconfiguration or resource constraints that must be
DOC> fixed before
objects can compile successfully.
DOC>#
ERRORS DURING
RECOMPILATION
---------------------------
43
Function created.
PL/SQL procedure successfully
completed.
Function dropped.
PL/SQL procedure
successfully completed.
SQL>
SQL> select
count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
59
SQL>
SQL> column owner format A12
column object_type format A13
select owner,object_type,COUNT(*)
from dba_objects
where status='INVALID'
group by owner, object_type;
OWNER OBJECT_TYPE COUNT(*)
------------
------------- ----------
APPS PACKAGE BODY 58
APPS MATERIALIZED 1
VIEW
SQL>
SQL> exit
3. POST UPGRADE STEPS
Run adgrants,.sql
[[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ cd
/shrf/db_scripts/
[oraerp@rac1
db_scripts]$ sqlplus / as sysdba
SQL*Plus: Release
11.2.0.2.0 Production on Sat Mar 18 16:04:48 2017
Copyright (c) 1982,
2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL> @adgrants.sql
Connected.
---------------------------------------------------
--- adgrants.sql
started at 2017-03-18 16:04:58 ---
Enter value for 1: APPLSYS
Creating PL/SQL
profiler objects.
---------------------------------------------------
--- profload.sql
started at 2017-03-18 16:05:04 ---
Package created.
Grant succeeded.
Synonym created.
Library created.
Package body created.
Testing for correct
installation
SYS.DBMS_PROFILER
successfully loaded.
PL/SQL procedure
successfully completed.
-----------------------------------------------------
--- profload.sql
completed at 2017-03-18 16:05:06 ---
--------------------------------------------------
--- proftab.sql
started at 2017-03-18 16:05:06 ---
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.
-----------------------------------------------------
--- profltab.sql
completed at 2017-03-18 16:05:06 ---
Creating PL/SQL
Package AD_DBMS_METADATA.
Package created.
Package body created.
End of Creating PL/SQL
Package AD_DBMS_METADATA.
PL/SQL procedure
successfully completed.
Commit complete.
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraerp@rac1
db_scripts]$
Grant create procedure privilege on CTXSYS
[oraerp@rac1
db_scripts]$
[oraerp@rac1
db_scripts]$ sqlplus apps/apps @adctxprv.sql manager CTXSYS
SQL*Plus: Release
11.2.0.2.0 Production on Sat Mar 18 16:06:37 2017
Copyright (c) 1982,
2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
Connecting to SYSTEM
Connected.
PL/SQL procedure
successfully completed.
Commit complete.
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraerp@rac1
db_scripts]$
Set CTXSYS parameter
[oraerp@rac1
db_scripts]$
[oraerp@rac1
db_scripts]$ sqlplus / as sysdba
SQL*Plus: Release
11.2.0.2.0 Production on Sat Mar 18 16:07:12 2017
Copyright (c) 1982,
2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL> exec
ctxsys.ctx_adm.set_parameter('file_access_role','public');
PL/SQL procedure
successfully completed.
SQL>
Start database Listener form 11.2.0.2 Home
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ lsnrctl
start PROD
LSNRCTL for Linux:
Version 11.2.0.2.0 - Production on 18-MAR-2017 16:09:26
Copyright (c) 1991,
2010, Oracle. All rights reserved.
Starting
/u01/db/tech_st/11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux:
Version 11.2.0.2.0 - Production
System parameter file
is /u01/db/tech_st/11.2.0/network/admin/PROD_rac1/listener.ora
Log messages written
to /u01/db/tech_st/11.2.0/network/admin/prod.log
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.dell.com)(PORT=1531)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1.dell.com)(PORT=1531)))
STATUS of the LISTENER
------------------------
Alias PROD
Version TNSLSNR for Linux: Version
11.2.0.2.0 - Production
Start Date 18-MAR-2017 16:09:26
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter
File
/u01/db/tech_st/11.2.0/network/admin/PROD_rac1/listener.ora
Listener Log File
/u01/db/tech_st/11.2.0/network/admin/prod.log
Listening Endpoints
Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac1.dell.com)(PORT=1531)))
Services Summary...
Service
"PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN,
has 1 handler(s) for this service...
The command completed
successfully
[oraerp@rac1 ~]$
Validate Workflow ruleset
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . APPSPROD_rac1.env
[oraerp@rac1 ~]$ cd
/shrf/db_scripts/
[oraerp@rac1
db_scripts]$ sqlplus apps/apps @wfaqupfix.sql APPLSYS APPS
SQL*Plus: Release
10.1.0.5.0 - Production on Sat Mar 18 16:09:51 2017
Copyright (c) 1982,
2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
PL/SQL procedure
successfully completed.
Commit complete.
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraerp@rac1
db_scripts]$
Creation of Appsutil Direcorty
[[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ .
APPSPROD_rac1.env
[oraerp@rac1 ~]$ perl
$AD_TOP/bin/admkappsutil.pl
Starting the
generation of appsutil.zip
Log file located at
/u01/inst/apps/PROD_rac1/admin/log/MakeAppsUtil_03181612.log
output located at
/u01/inst/apps/PROD_rac1/admin/out/appsutil.zip
MakeAppsUtil completed
successfully.
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ cp
/u01/inst/apps/PROD_rac1/admin/out/appsutil.zip /u01/db/tech_st/11.2.0/
[oraerp@rac1 ~]$
[oraerp@rac1 ~]$ cd /u01/db/tech_st/11.2.0/
[oraerp@rac1 11.2.0]$
[oraerp@rac1 11.2.0]$ unzip -o
appsutil.zip
[oraerp@rac1 11.2.0]$
Buliding xml file for database using adbldxml.pl
[root@rac1 ~]#
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ cd
/u01/db/tech_st/11.2.0/appsutil/bin/
[oraerp@rac1 bin]$ perl
adbldxml.pl
Starting context file
generation for db tier..
Using JVM from
/u01/db/tech_st/11.2.0/jdk/jre/bin/java to execute java programs..
APPS Password: apps
The log file for this
adbldxml session is located at:
/u01/db/tech_st/11.2.0/appsutil/log/adbldxml_03181617.log
UnsatisfiedLinkError
exception loading native library: njni11
java.lang.UnsatisfiedLinkError:
no njni11 in java.library.path
Could not Connect to
the Database with the above parameters, Please answer the Questions below
Enter Hostname of
Database server: rac1.dell.com
Enter Port of Database
server: 1531
Enter SID of Database
server: PROD
Enter the value for
Display Variable: 1.0
The context file has
been created at:
/u01/db/tech_st/11.2.0/appsutil/PROD_rac1.xml
[oraerp@rac1 bin]$
Run Auto config on dbTier using adconfig.pl
[root@rac1 ~]# su – oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ cd
u01/db/tech_st/12.1.0/appsutil/bin
[oraerp@rac1 bin]$ perl adconfig.pl
Enter the full file path to the Context file: /u01/db/tech_st/11.2.0/appsutil/PROD_rac1.xml
Enter the APPS user password:apps
The log file for this session is located at:
/u01/db/tech_st/11.2.0/appsutil/log/PROD_rac1/03181618/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME
location : /u01/db/tech_st/11.2.0
Classpath :
:/u01/db/tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/u01/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u01/db/tech_st/11.2.0/appsutil/java:/u01/db/tech_st/11.2.0/jlib/netcfg.jar:/u01/db/tech_st/11.2.0/jlib/ldapjclnt11.jar
Using Context
file :
/u01/db/tech_st/11.2.0/appsutil/PROD_rac1.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.
[oraerp@rac1 bin]$
Gather Statistics for “SYS” schema
[root@rac1 ~]# su – oraerp
[oraerp@rac1 ~]$ . 11gR2.env
[oraerp@rac1 ~]$ cd
/shrf/db_scripts/
[oraerp@rac1
db_scripts]$ ll adstats.sql
-rwxr-xr-x 1 oraerp
dbaerp 2752 Mar 18 14:39 adstats.sql
[oraerp@rac1
db_scripts]$ sqlplus / as sysdba
SQL*Plus: Release
11.2.0.2.0 Production on Sat Mar 18 16:23:16 2017
Copyright (c) 1982,
2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL>
System altered.
SQL> @adstats.sql
Connected.
--------------------------------------------------
--- adstats.sql
started at 2017-03-18 16:23:31 ---
Checking for the DB
version and collecting statistics ...
PL/SQL procedure
successfully completed.
------------------------------------------------
--- adstats.sql ended
at 2017-03-18 16:32:02 ---
Commit complete.
Disconnected from
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
[oraerp@rac1
db_scripts]$
[oraerp@rac1
db_scripts]$
[oraerp@rac1
db_scripts]$ sqlplus / as sysdba
SQL*Plus: Release
11.2.0.2.0 Production on Sat Mar 18 16:35:41 2017
Copyright (c) 1982,
2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL> alter system
disable restricted session;
System altered.
SQL>
SQL> exit
SQL> exit
Re-create Grants and Synonyms using ADADMIN (4-2)
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ .
APPSPROD_rac1.env
[oraerp@rac1 ~]$ adadmin
Saving product
information.
AD code level : [B.3]
AD Administration Main Menu
--------------------------------------------------
1.
Generate Applications Files menu
2.
Maintain Applications Files menu
3.
Compile/Reload Applications Database Entities menu
4.
Maintain Applications Database Entities menu
5.
Change Maintenance Mode
6.
Exit AD Administration
Enter your choice [6]
: 4
Maintain Applications Database
Entities
---------------------------------------------------
1.
Validate APPS schema
2.
Re-create grants and synonyms for APPS schema
3.
Maintain multi-lingual tables
4.
Check DUAL table
5.
Return to Main Menu
Enter your choice [5]
: 2
AD utilities can
support a maximum of 999 workers. Your
current database
configuration supports a maximum of 123 workers.
Oracle recommends that
you use between 2 and 4 workers.
Enter the number of
workers [2] : (PRESS ENTER)
Run Autoconfig on AppsTier
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ .
APPSPROD_rac1.env
[oraerp@rac1 ~]$ cd
$ADMIN_SCRIPTS_HOME
[oraerp@rac1 scripts]$
./adautocfg.sh
Enter the APPS user
password: apps
The log file for this
session is located at: /u01/inst/apps/PROD_rac1/admin/log/03061800/adconfig.log
AutoConfig is
configuring the Applications environment...
AutoConfig will
consider the custom templates if present.
Using CONFIG_HOME location : /u01/inst/apps/PROD_rac1
Classpath :
/u01/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/apps/apps_st/comn/java/classes
Using Context file :
/u01/inst/apps/PROD_rac1/appl/admin/PROD_rac1.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.
[oraerp@rac1 scripts]$
Restart Applications server processes
[root@rac1 ~]# su - oraerp
[oraerp@rac1 ~]$ .
APPSPROD_rac1.env
[oraerp@rac1 ~]$ cd
$ADMIN_SCRIPTS_HOME
[oraerp@rac1 scripts]$
adstrtall.sh
----
----
----
adstrtal.sh: Exiting
with status 0
adstrtal.sh: check the
logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adstrtal.log for more
information ...
[oraerp@rac1 scripts]$
adopmnctl.sh
status
You are running
adopmnctl.sh version 120.6.12010000.4
Checking status of
OPMN managed processes...
Processes in Instance:
PROD_rac1.rac1.dell.com
---------------------------------+--------------------+---------+---------
ias-component | process-type |
pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm |
7834 | Alive
OC4JGroup:default_group | OC4J:forms |
7762 | Alive
OC4JGroup:default_group | OC4J:oacore |
7612 | Alive
HTTP_Server | HTTP_Server |
7555 | Alive
adopmnctl.sh: exiting
with status 0
adopmnctl.sh: check
the logfile /u01/inst/apps/PROD_rac1/logs/appl/admin/log/adopmnctl.txt for more
information ...
[oraerp@rac1 scripts]$
Check the Database status from Front end and run Active user
req.
Hope this
Artice Helps who are looking for upgrading their EBS database from 11.10.7 to
11.2.0.2
Thanks for
Reading
Thanks for Reading
Regards,
Mohammed Areefuddin.
Suggested Topics :
Linux
|
DATABASE
|
RMAN
|
RAC
|
EBS
|
EBS DataGuard
| ||||
No comments:
Post a Comment