X86 dbca, netca give Java hotspot error if on x86_64 hardware

Source: Internet
Author: User

When you use the dbca command to create a new database, the dbca command cannot be started. The running environment is where the host machine 64bit + amd cpu, while the client is Linux 32bit + grid infrastructure (32) + Oracle database software (32. It was originally thought that the 32-bit running would be faster. I didn't expect bug 8670579 to be triggered again when dbca was executed. According to mongoel's description, similar netca would also trigger this bug.

I. Fault symptom
[Oracle @ linux1 ~] $ Dbca
#
# An Unexpected error has been detected by hotspot virtual machine:
#
# SIGSEGV (0xb) at PC = 0x9e0ea498, pid = 4242, tid = 3086584016
#
# Java VM: Java hotspot (TM) server VM (1.5.0 _ 17-b02 Mixed Mode)
# Problematic frame:
# C [libnnz11.so + 0x3c498]
#
# An error report file with more information is saved as hs_err_pid1_2.log
#
# If you wowould like to submit a bug report, please visit:
# Http://java.sun.com/webapps/bugreport/crash.jsp
#
Aborted
[Oracle @ linux1 ~] $

 

Ii. fault description
# Meatlink [ID 942076.1] provides a description of this problem, that is, the 32bit operating system and Oracle are installed on the client, while the host hardware is a 64bit platform.
# This is an Oracle bug with bug No.: 8670579

Applies:
Oracle Server-Enterprise Edition-version 11.2.0.0 and later
Linux x86

Symptoms
After successfully installing 32-bit 11gr2 (11.2.0.1.0) software onto a 32-bit Linux OS (x86) system, neither netca or dbca can be run:

Dbca error is:
#
# An Unexpected error has been detected by hotspot virtual machine:
#
# SIGSEGV (0xb) at PC = 0x9dc0c35e, pid = 8292, tid = 3086022864
#
# Java VM: Java hotspot (TM) server VM (1.5.0 _ 17-b02 Mixed Mode)
# Problematic frame:
# C [libnnz11.so + 0x3c35e]

 

Netca error is:
# An Unexpected error has been detected by hotspot virtual machine:
#
# SIGSEGV (0xb) at PC = 0xa2c2235e, pid = 8272, tid = 3086309584
#
# Java VM: Java hotspot (TM) server VM (1.5.0 _ 17-b02 Mixed Mode)
# Problematic frame:
# C [libnnz11.so + 0x3c35e]

Other problematic frame values have also been reported, and include:
[Libnnz11.so + 0x3c35e]
[Ld-linux.so.2 + 0xc1fc]

Changes
Although the Linux OS that has been installed is indeed a supported 32-bit Linux OS, the hardware that is being used is 64-bit x86_64 hardware.

Cause
You are encountering published bug 8930861, "x86 dbca, netca give Java hotspot error if on x86_64 Hardware"

You have Oracle's 32-bit 11.2.0.1.0 RDBMS Software, a supported 32-bit Linux OS, but you are on 64-bit x86_64 hardware.

The command "cat/proc/cpuinfo" shows:
Model name: quactive-core amd opteron (TM) processor 2356

 

Iii. Solutions
1. Please find out if there is any business reason that the 64-bit hardware is only running
32-bit OS. If not, then Oracle recommends that you re-install a 64-bit OS and 64-bit Oracle
Avoid published bug 8930861, "x86 dbca, netca give Java hotspot error if on x86_64 hardware"

2. If there is some business reason that you must use 64-bit hardware running a 32-bit Linux OS, then
Before you can use the 11gr2 dbca or netca tools, you will need to apply patch 8670579 "netca/dbca
Failed with hotspot virtual machine ". You need to download the 11.2.0.1.0 version of the patch
(P8670579_112010_linux.zip) and install it.

References
@ Bugs: 8670579-dbbeta: netca/dbca failed with hotspot Virtual Machine
BUG: 8930861-x86 dbca, netca give Java hotspot error if on x86_64 hardware

# Check the Local Machine
[Root @ linux1 ~] # Cat/proc/cpuinfo | grep Model
Model: 4
Model name: AMD phenom (TM) II X4 955 Processor
Model: 4
Model name: AMD phenom (TM) II X4 955 Processor

# Download the 8670579 patch and use opatch apply.
# This bug occurs when root. Sh is executed when grid infrastructure is installed. The primary cause is poor support for amd cpu and 32bit platform.
# Therefore, the host machine is installed on the 64-bit hardware platform, and the client uses 32-bit. You need to apply the patch to grid infrastructure, and then to Oracle database software.
# When you run root. Sh, you will receive the error "failed to create or upgrade OLR.

BUG: 8670579 how to implement apply, refer to: failed to create or upgrade OLR
 

 

More references

DML error logging

PL/SQL --> cursor

PL/SQL --> implicit cursor (SQL % found)

Batch SQL forall statements

Bulk collect clause for batch SQL

Initialization and assignment of PL/SQL Sets

PL/SQL Union arrays and nested tables
PL/SQL variable-length Array
PL/SQL --> PL/SQL records

SQL tuning steps

Efficient SQL statements

Parent cursor, child cursor, and shared cursor

Bind variables and their advantages and disadvantages

Use of the display_cursor function of dbms_xplan

Use of the display function of dbms_xplan

Description of each field module in the execution plan

Use explain plan to obtain the SQL statement execution plan

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.