Upgrade Oracle 9i RAC to Oracle 10g RAC
Upgrade Oracle 9i RAC to Oracle 10g RAC
by Vincent Chan
This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
Oracle Database 10g and Oracle Real Application Cluster (RAC) 10g itself, boast many new and exciting features that simplify database manageability and provide higher availability and scalability. Compared to its predecessors, Oracle 10g RAC is much easier to install, use and manage, thereby reducing the total cost of ownership.
Overview
The RAC cluster comprises two Intel x86 servers running on RHEL3 (Kernel 2.4.21-27). Each node has access to a shared storage and connectivity to the public and private network.
This article is structured into the following steps:
1. Preliminary Installation
2. Install Oracle Clusterware
3. Install Oracle RAC Software
4. Upgrade the Database
5. Migrate Database to ASM (Optional Step)
Unless otherwise specified, you should execute all steps on both nodes.
Here's an overview of our Oracle 9i RAC environment:
Host Name
Instance Name
Database Name
$ORACLE_HOME
Database File Storage
salmon1
prod1a
prod1
/u01/app/oracle/product/9.2.0
OCFS
salmon2
prod1b
prod1
/u01/app/oracle/product/9.2.0
OCFS
File
File Name
File Storage
Quorum
/ocfs/prod1/quorum
OCFS
Shared Configuration
/ocfs/prod1/srvm
OCFS
And an overview of the Oracle 10g RAC environment:
Host Name
Instance Name
Database Name
$ORACLE_HOME
Database File Storage
salmon1
prod1a
prod1
/u01/app/oracle/product/10.2.0/db_1
OCFS
salmon2
prod1b
prod1
/u01/app/oracle/product/10.2.0/db_1
OCFS
File
File Name
File Storage
Voting Disk
/ocfs/prod1/vdisk1
/ocfs/prod1/vdisk2
/ocfs/prod1/vdisk3
OCFS
Oracle Cluster Registry
/ocfs/prod1/ocr1
/ocfs/prod1/ocr2
OCFS
Step 1: Preliminary Installation
1a. Verify s
相关文档：
公司使用linux开发机进行程序开发时，由于开发用Oracle数据库是由日方提供，所以经常使用sqlplus连接到远程数据库上进行开发,例如：
sqlplus username/password@servicename
于是想，用我的两台电脑双机互联试一试，也玩个“远程连接”。实验如下：
首先在我的台式机上安装了Oracle9i的数据库管理系统， ......
经验：
alter system set log_archive_dest=’D:\oracle\archivelog’ scope=spfile;
alter system set log_archive_start=true scope=spfile;
之后，
create pfile from spfile
可验证加上没
一、查看数据库运行模式
可以用超级用户（INTERNAL）在SQLPLUS中使用命令ARCHIVE LOG LIST查看
......
在我的上一个银行项目中，我接到编写ORACLE存储过程的任务，我是程序员，脑袋里只有一些如何使用CALLABLE接口调用存储过程的经验，一时不知如何下手，我查阅了一些资料，通过实践发现编写ORACLE存储过程是非常不容易的工作，即使上路以后，调试和验证非常麻烦。简单地讲，Oracle存储过程就是存储在Oracle数据库中的一个程序 ......
AIX Oracle RAC 升级到10.2.0.4.0过程有如下报错(直接升级到10.2.0.4不需要应用Patch:6160398)：
root@bwgl_db2:/u01/app/oracle/crs_1/bin# /u01/app/oracle/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
<CAP_BYP ......
