数据库从10.2.0.1.0升级到10.2.0.4.0,升级报告警告如下:

Warnings

DBUA has detected that the JAccelerator(NCOMP) is not Installed.Please refre to the Post-installation Tasks chapter

in ther Oracle Database Installation Guide for instructions on how to install JAccelerator(NCOMP).

软件下载:

下载companion disk

网址:http://www.oracle.com/technetwork/database/10201linx8664soft-092456.html

安装companion

解压缩

gunzip 10201_companion_linux_x86_64.cpio.gz

cpio -idmv < 10201_companion_linux_x86_64.cpio

SQL> shutdown immediate;

安装

cd companion/

运行runInstaller

sh   runInstaller

选择Advanced Installation

选择option 2：Oracle Database 10g Products 10.2.0.10

选择install完成安装

将JAccelerator升级到10.2.0.4.0

cd Disk1

sh runInstaller

[oracle@ZSGHRDB01 admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 28 14:18:45 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 2483027968 bytes

Fixed Size                  2085968 bytes

Variable Size             553651120 bytes

Database Buffers         1912602624 bytes

Redo Buffers               14688256 bytes

Database mounted.

Database opened.

 @?/rdbms/admin/catupgrd.sql

 @?/rdbms/admin/utlrp.sql

确认JAccelerator安装成功

 SQL> select dbms_java.full_ncomp_enabled from dual;

FULL_NCOMP_ENABLED

--------------------------------------------------------------------------------

OK

若JAccelerator未安装或安装不成功会报下面的错误

SQL> select dbms_java.full_ncomp_enabled from dual;

select dbms_java.full_ncomp_enabled from dual

       *

ERROR at line 1:

ORA-29558: JAccelerator (NCOMP) not installed. Refer to Install Guide for

instructions.

ORA-06512: at "SYS.DBMS_JAVA", line 236