11GR2執行DBCA報錯誤(打補丁)

zhangsharp20發表於2015-10-12
環境:
OS:Red Hat Enterprise Linux Server release 5.4 （Tikanga）
DB:11.2.0.1
 
今天在安裝好11gR2軟體後準備透過dbca建立資料庫,執行dbca的時候包如下錯誤:
[oracle@primary ~]$dbca
Oracle Net Services Configuration:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0xa44b13a8, pid=2973, tid=3086891216
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C [libnnz11.so+0x3c3a8]
#
# An error report file with more information is saved as hs_err_pid2973.log
#
# If you would like to submit a bug report, please visit:
# 
 
網上搜尋了很多相關的帖子,基本上說的是64位的機器安裝了32位的資料導致的,但我的機器是32位的,下載的oracle版本也是32位的,但也報這個錯誤.先不管了,按照網上說的需要打補丁p8670579_112010_LINUX.zip.
 
步驟如下:
1.下載p8670579_112010_LINUX.zip,並上傳到伺服器上的目錄/ftp
 
2.確認是否配置了ORACLE_HOME
[oracle@primary]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
 
3.檢查perl的版本,需要5.00503以上的版本
[oracle@primary 8670579]$ perl -v
This is perl, v5.8.8 built for i386-linux-thread-multi
 
4.Verify the OUI Inventory.
$/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory
 
5.解壓縮補丁包
$unzip p8670579_112010_LINUX.zip
 
6.確保資料庫已經停止
$cd /ftp/8670579
$/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply
 
 
README.txt裡的說明如下:

[oracle@primary 8670579]$ more README.txt
=========================================================================
Interim Patch for Base Bug: 8670579
=========================================================================
Date: 25th February 2010
-------------------------------------------------------------------------
 Platform Patch for      : Linux x86
 Product Patched         : NETWORK
 Product Version #       : 11.2.0.1
 RAC Rolling Installable : YES
 Online Installable      : NO
Bugs Fixed by this patch:
-------------------------
  8670579 - DBBETA :NETCA/DBCA FAILED WITH HOTSPOT VIRTUAL MACHINE
Patch Preinstall Steps
----------------------
1. For non-recommended patches, you must have the exact symptoms
   described in the service request (SR).
2. Confirm the version of Perl installed and configured for the ORACLE_HOME.
Oracle requires that all customers have at least Perl 5.00503 installed
and configured for patching activities inside the ORACLE_HOME.  Follow
these steps to check the Perl version for the ORACLE_HOME being patched:
  - source the ORACLE_HOME environment
  - execute "perl -v"
  - verify that the returned version of Perl is 5.00503 or higher
If the Perl configured for the ORACLE_HOME is not at 5.00503 or
higher, follow the directions in this metalink note to update to
a more recent version:
3. Verify the OUI Inventory.
OPatch needs access to a valid OUI inventory to apply patches.
Validate the OUI inventory with the following command:
  % opatch lsinventory
If the command errors out, contact Oracle Support and work to validate
and verify the inventory setup before proceeding.
4. Review and download the latest version of OPatch.
Oracle recommends that all customers be on the latest version of OPatch.
Please review the following metalink note and follow the instructions
to update to the latest version if needed:
5. Confirm executables appear in your system PATH.
The patching process will use the unzip and the opatch executables.  After
sourcing the ORACLE_HOME environment, confirm both of these exist before
continuing:
  - "which opatch"
  - "which unzip"
If either of these executables do not show in the PATH, correct the problem
before proceeding.
6. Create a location for storing the unzipped patch.  This location
will be referred to later in the document as .
7. Unzip the patch zip file into the .
  unzip -d  
8. Shut down services running from the ORACLE_HOME.
Before applying this patch, do a clean shut down of all services
running from the ORACLE_HOME.
  (a) In a non-RAC environment:
  Shut down all services that are running from this ORACLE_HOME.
  Confirm the return status from each shutdown command to verify
  the shutdown is successful and there are no errors.
  (b) In a RAC environment:
  For each node in the RAC system, shut down the services for
  the specific machine that are running from the ORACLE_HOME.
  OPatch will be used on each node in the RAC system one at
  a time.  If this patch is not rolling RAC installable treat
  it as a non-RAC environment and shut down all services.
  As an example, in the case of a two node RAC system:
     1. Stop instances running on node 1.
     2. Run 'opatch apply /8670579' on node 1.
     3. When the apply finishes, opatch asks for confirmation 
        before going on to apply the patch to node 2.
     4. Start instances on node 1.
     5. Stop instances running on node 2.
     6. Ask opatch to continue to applying the patch to node 2.
     7. Start instances on node 2.     
9.  Apply pre-requisite updates.

Patch Installation Steps:
-------------------------
1.  Set your current directory to the directory where the patch is located.
% cd /8670579
2.  Apply the patch.
Use the following command to apply the patch to the ORACLE_HOME:
% opatch apply
When OPatch starts, it will validate the patch and make sure there
are no conflicts with the software already installed in the ORACLE_HOME.
OPatch categorizes two types of conflicts:
  (a) Conflicts with a patch already applied to the ORACLE_HOME
  In this case, please stop the patch installation and contact
  Oracle Support Services.
  (b) Conflicts with subset patch already applied to the ORACLE_HOME
  In this case, please continue the install, as the new patch
  contains all the fixes from the existing patch in the ORACLE_HOME.
  The subset patch will automatically be rolled back prior to the
  installation of the new patch.
Patch Post Install Instructions:
--------------------------------

Patch Deinstallation Instructions:
----------------------------------
1. Make sure to follow the same pre-install steps when deinstalling
a patch.  This includes verifying the inventory and shutting down
any services running from the ORACLE_HOME / machine before rolling
the patch back.
2. Change to the directory where the patch was unzipped.
  % cd /8670579
3. Run OPatch to deinstall the patch.
  % opatch rollback -id 8670579
 
注意opatch命令是在$ORACLE_HOME/OPatch/目錄下,環境變數PATH中沒有包含該目錄的話,直接敲入opatch命令是提示找不到改命令的,這時需要將該目錄加入到PATH中.

轉載至http://blog.chinaunix.net/uid-77311-id-3325713.html 
-- The End --

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29802484/viewspace-1813823/，如需轉載，請註明出處，否則將追究法律責任。

相關文章