Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘An unexpected error has been detected by HotSpot Virtual Machine’

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: