新建文件系统
        crfs  -v jfs  -g  rootvg  -m /arch -a \ size=32768 -a frag=512 -a nbpi=8192  也可以 smit。
开启归档模式
     $ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 13:38:57 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 5016387584 bytes
Fixed Size                  2027744 bytes
Variable Size             922750752 bytes
Database Buffers         4076863488 bytes
Redo Buffers               14745600 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode& ......

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
         where c.type# = 231
                    and o.obj# = c.obj#
                    and u.user# = o.owner#;
  执行此句，如果能查询到数据进行第2步操作，否则转到3
2.执行下列语句
  --创建一个临时表
  create table ttt(
     order_id number ,
     oeder_Date date
  );
  --导入数据
  insert into ttt(order_id,oeder_date) select order_id,order_date from oe.orders
  --修改oe.orders表
  alter table oe.orders drop column order_date
&nb ......

//使用自定义函数定义日期格式
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   -------||
//jdbc-odbc
//1.加载驱动 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//2.得到连接 conn = DriverManager.getConnection("jdbc:odbc:oracle_source","scott","tiger");
//jdbc直连
//1.加载驱动 Class.forName("oracle.jdbc.driver.OracleDriver");
//2.得到连接 conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","tiger");
||-------  oracle的事物处理  -------||
dml语句 //增删改
当执行事务操作时（dml语句），oracle会在被作用的表上加锁，防止其它用户改表的结构，这里对我们用户来讲是非常重要的
//回滚命令
savepoint a; //存储回滚点
rollback to a; //回滚到存储点
rollback //取消全部事物
commit;&nb ......

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_BYPASS_RAC_VMM CAP_PROPAGATE CAP_NUMA_ATTACH >
by running </usr/bin/chuser> command then 'crsctl stop crs' and 'crsctl start crs'.
The CSS daemon, ocssd.bin, will not run in realtime without  this change
Oracle strongly recommends that the CSS daemon run realtime
Creating pre-patch directory for saving pre-patch clusterware files
 
# 未对这个错误做处理也能正常的运行Oracle RAC。但是在errpt -a中会出现以下报错
---------------------------------------------------------------------------
LABEL:          CORE_DUMP
IDENTIFIER:     C69F5C9B
Date/Time:       Mon Mar 29 16:34:52 BEI ......

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 ......

推荐crs版本高于db版本
If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
hould always be at the same or later version as the database.
涉及到数据库而不是实例的，都只需要在节点1上执行即可。
 Update Oracle Time Zone Definitions
SELECT version from v$timezone_file;
If this query reports version 4, no action is required; in this case, continue with steps described in section 7.6.
If this reports a version lower or higher then 4, see OracleMetalink document 553812.1 Actions for the DSTv4 update in the Release 10.2.0.4 patchset.
running utltzpv4.sql  (node1)
If a "select * from sys.sys_tzuv2_temptab;" gives no rows then there is no action to take for the Oracle time zone definitions
SQL> select * from sys.sys_tzuv2_temptab;    
no rows selected
2, Stop All Processes (node1)
$ srvctl stop database -d  ec ......