Problem:
After installing Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86, sourced the 11gR2 environment and attempted to run dbua to upgrade the 11gR1 database. The following error occurred:
[applmgr@centos53server ~]$ dbua # # An unexpected error has been detected by HotSpot Virtual Machine: # # SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode) # Problematic frame: # C [libnnz11.so+0x3c4d4] # # An error report file with more information is saved as hs_err_pid3662.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # Aborted
Solution:
Apply patch p8670579_112010_LINUX.zip.
Firstly, I ensured that host name set up correctly in /etc/hosts and environment variable LANG unset (set to “”), but this did not resolve the issue.
Downloaded patch p8670579_112010_LINUX.zip from My Oracle Support (note that this patch may not appear if you are using the HTML version of MOS, only p8670579_111100_LINUX.zip).
Unzipped p8670579_112010_LINUX.zip, then sourced the 11gR2 environment and changed to directory 8670579. Ran ‘opatch apply’ ($ORACLE_HOME/OPatch must be in the path).
[applmgr@centos53server 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 : /u01/app/oracle/product/11.2.0 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.1.0.6.6 OUI version : 11.2.0.1.0 OUI location : /u01/app/oracle/product/11.2.0/oui Log file location : /u01/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2011-10-04_21-10-48PM.log Patch history file: /u01/app/oracle/product/11.2.0/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 '/u01/app/oracle/product/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/app/oracle/product/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 '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 "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/ahseteco.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/am11rkg.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/amsha.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/cpui32.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/sha.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/x931rand.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/am11dkg.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/am931rnd.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/amsharnd.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/ghash.o" Updating archive file "/u01/app/oracle/product/11.2.0/lib/libnnz11.a" with "lib/libnnz11.a/shacomm.o" Copying file to "/u01/app/oracle/product/11.2.0/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. [applmgr@centos53server 8670579]$
Then ran dbua, and it worked.
Reference:
http://pavandba.wordpress.com/2011/02/04/problem-in-upgrading-10g-to-11g-on-linux/
0 Comments.