Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘Java VM: Java HotSpot(TM) Server VM (1.5.0_17-b02 mixed mode)’

Problem in upgrading 10g to 11g on Linux

Posted by Pavan DBA on February 4, 2011


Hi Friends,

I have got a new learning yesterday when i about to upgrade a 10g (10.2.0.4) database to 11g (11.2.0.1). Let me explain what I did.

1. I am already having a 10.2.0.4 database
2. I installed 11g software in another location
3. I changed environmental variables pointing to new 11g home
4. I started DBUA, where it failed with following error

An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0xa2bbd36e, pid=19555, tid=3085252272
#
# Java VM: Java HotSpot(TM) Server VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
+# C [libnnz11.so+0x3c36e]+

Note: The error shown here may not be same when you face this problem.

After analyzing the error through google and oracle support, I got to know that it is because of a BUG 8670579 and will be fixed by applying a patch to newly installed 11g software.

Then i download the software from Oracle support (metalink) – p8670579_112010_LINUX.zip

I recommend to apply patch following README document (basic steps are as follows)

[oracle@server1 ~]$ export ORACLE_HOME=/u03/ora11g
[oracle@server1 ~]$ opatch lsinventory
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
Oracle Home       : /u03/ora11g
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u03/ora11g/oui
Log file location : /u03/ora11g/cfgtoollogs/opatch/opatch2011-02-03_08-09-14AM.log

Patch history file: /u03/ora11g/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /u03/ora11g/cfgtoollogs/opatch/lsinv/lsinventory2011-02-03_08-09-14AM.txt

——————————————————————————–
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
——————————————————————————–

OPatch succeeded.

[oracle@server1 ora11g]$ unzip -d /u03/ora11g /u01/p8670579_112010_LINUX.zip
Archive:  /u01/p8670579_112010_LINUX.zip
   creating: /u03/ora11g/8670579/
   creating: /u03/ora11g/8670579/files/
   creating: /u03/ora11g/8670579/files/lib/
   creating: /u03/ora11g/8670579/files/lib/libnnz11.a/
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/ahseteco.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/am11rkg.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/amsha.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/cpui32.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/sha.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/x931rand.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/am11dkg.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/am931rnd.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/amsharnd.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/ghash.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.a/shacomm.o
  inflating: /u03/ora11g/8670579/files/lib/libnnz11.so
   creating: /u03/ora11g/8670579/etc/
   creating: /u03/ora11g/8670579/etc/config/
  inflating: /u03/ora11g/8670579/etc/config/inventory.xml
  inflating: /u03/ora11g/8670579/etc/config/actions.xml
  inflating: /u03/ora11g/8670579/etc/config/deploy.xml
   creating: /u03/ora11g/8670579/etc/xml/
  inflating: /u03/ora11g/8670579/etc/xml/GenericActions.xml
  inflating: /u03/ora11g/8670579/etc/xml/ShiphomeDirectoryStructure.xml
  inflating: /u03/ora11g/8670579/README.txt
[oracle@server1 ora11g]$

Shutdown all the previous versions of oracle databases and also stop listener, EM and Grid control services (if running any). After that run below command

[oracle@server1 ora11g]$ cd 8670579
[oracle@server1 8670579]$ ls
etc  files  README.txt
[oracle@server1 8670579]$ opatch apply
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
Oracle Home       : /u03/ora11g
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u03/ora11g/oui
Log file location : /u03/ora11g/cfgtoollogs/opatch/opatch2011-02-03_08-14-07AM.log

Patch history file: /u03/ora11g/cfgtoollogs/opatch/opatch_history.txt
——————————————————————————–
The patch has more than one Archive Action but there is no Make Action.
——————————————————————————–
ApplySession applying interim patch ‘8670579’ to OH ‘/u03/ora11g’

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 = ‘/u03/ora11g’)
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 ‘8670579’ for restore. This might take a while…
Backing up files affected by the patch ‘8670579’ for rollback. This might take a while…

Patching component oracle.network.rsf, 11.2.0.1.0…
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/ahseteco.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/am11rkg.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/amsha.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/cpui32.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/sha.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/x931rand.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/am11dkg.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/am931rnd.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/amsharnd.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/ghash.o”
Updating archive file “/u03/ora11g/lib/libnnz11.a”  with “lib/libnnz11.a/shacomm.o”
Copying file to “/u03/ora11g/lib/libnnz11.so”
ApplySession adding interim patch ‘8670579’ to inventory

Verifying the update…
Inventory check OK: Patch ID 8670579 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8670579 are present in Oracle Home.

The local system has been patched and can be restarted.
OPatch succeeded.

After this step I am successful in invoking DBUA and completed my database upgrade to 11.2.0.1 version.

Hope this post will help you…….

Posted in upgradation | Tagged: , , , | Leave a Comment »

 
%d bloggers like this: