Oracle RAC 10.2.0.1 升级 10.2.0.4 简单描述
推荐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 ecsdb
$ srvctl stop nodeapps -n ecsrac01
$ srvctl stop nodeapps -n ecsrac02
$ crs_stop -all
./runInstaller (node1) -- upgrade CRS
Name: OraCrs10g_home
4. cd /u01/product/crs/install
# ./root102.sh (each node)
5. ./runInstaller (node1) -- upgrade RDBMS
name : OraDb10g_home1
6. cd /u01/product/oracle/
# ./root.sh (each node)
7. upgrade database
manually : ingore --- Run the Pre-Upgrade Information Tool
$ srvctl start listener -n ecsrac01
$ srvctl start listener -n ecsrac02
If you are using Automatic Storage Management, start the Automatic Storage Management instance.
$ sqlplus /nolog
SQL> CONNECT SYS AS SYSDBA
Enter password: SYS_password
SQL> STARTUP NO
相关文档：
第一种：
select b.* from
( select a.*, rownum row_num from
(select t.* from A05_ORGANIZATION t order by org_name_en asc) a
) b
where b.row_num between 1 and 5 order by b.row_num asc
第二种（更高效）：
select b.* from
( select a.*, rown ......
如下，表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 ......
第一章：日志管理
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfile [group 4]
sql> ('/disk3/log4a.rdo','/disk4/lo ......
//使用自定义函数定义日期格式
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 ......
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 ......
