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的数据库管理系统， ......
由于公司业务增长较快，数据库oracle压力越来越大，公司考虑在应用服务器 Websphere 和 数据库oracle之间增加 timesten数据库来实现数据的读写分离，另外由于timesten是内存数据库，所以查询速度上要优于 oracle 数据库，两个数据库虽然都是oracle公司的产品，但是在很多sql的写法上是不相同的，� ......
解决方案：
select session_id from v$locked_object; --首先得到被锁对象的session_id
SELECT sid, serial#, username, osuser from v$session where sid = session_id; --通过上面得到的session_id去取得v$session的sid和serial#，然后对该进程进行终止。
&n ......
select dbtimezone from dual ; --查看数据库时区
select sessiontimezone from dual ; --查看会话时区
1.select u.name || '.' || o.name || '.' || c.name TSLTZcolumn
from sys.obj$ o, sys.col$ c, sys.user$ u
&nbs ......
select dbtimezone from dual ; --查看数据库时区
select sessiontimezone from dual ; --查看会话时区
1.select u.name || '.' || o.name || '.' || c.name TSLTZcolumn
from sys.obj$ o, sys.col$ c, sys.user$ u
&nbs ......
