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
相关文档：
1.创建过程
与其它的数据库系统一样，Oracle的存储过程是用PL/SQL语言编写的能完成一定处理功能的存储在数据库字典中的程序。
语法:
create [or replace] procedure procedure_name
[ (argment [ { in| in out }] type,
argment [ { in | out | in out } ] type
{ is | as }
<类型 ......
'
ALTER TABLESPACE app_data
ADD DATAFILE 'u01/oradata/userdata03.dbf'
SIZE 200M;
'创建表空间
CREATE TABLESPACE userdata
DATAFILE 'u01/oradata/userdata03.dbf' SIZE 100M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M;
'创建回滚表空间
CREATE UNDO TABLESPACE undo1
DATAFILE ' ......
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 ......
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 ......
//使用自定义函数定义日期格式
to_date('1982-11-11','yyyy-mm-dd')
to_date('1982/11/11','yyyy/mm/dd')
//希望员工scott的岗位，工资，补助与smith员工一样
update emp set (job,sal,comm)=(select job,sal,comm from emp where ename='SMITH') where ename='SCOTT';
||------- java使用oracle &nbs ......
