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
相关文档：
http://blog.csdn.net/flysyq/archive/2009/02/26/3939877.aspx
Oracle 概念（Oracle 10.2）
9、进程结构
这一章论述了Oracle数据库系统的进程和Oracle系统的可用的不同配置。
这一章包含下列主题：
u 进程介绍
u 用户进程概述
u Oracle进程概述
u 共享服务器架构
u 专用服务器配置
u 程序接口
进程介绍
所有连 ......
如下，表a是数据库中已经存在的表，b是准备根据表a进行复制创建的表：
1、只复制表结构的sql
create table b as select * from a where 1<>1
2、即复制表结构又复制表中数据的sql
create table b as select * from a
3、复制表的制定字段的sql
create table b as select row_id ......
解决方案：
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 sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //正确执行
SELECT name, sde.st_x (shape) "The ......
对于外连接，Oracle中可以使用“(+)”来表示，9i可以使用LEFT/RIGHT/FULL OUTER JOIN，下面将配合实例一一介绍。
1. LEFT OUTER JOIN：左外关联
SELECT e.last_name, e.department_id, d.department_name
from employees e
LEFT OUTER JOIN department ......
