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
相关文档：
由于公司业务增长较快，数据库oracle压力越来越大，公司考虑在应用服务器 Websphere 和 数据库oracle之间增加 timesten数据库来实现数据的读写分离，另外由于timesten是内存数据库，所以查询速度上要优于 oracle 数据库，两个数据库虽然都是oracle公司的产品，但是在很多sql的写法上是不相同的，� ......
Oracle：一个数据库有多个用户,一个用户拥有一组数据库对象,这个用户我们俗称为方案,
通常一个业务系统对应一个数据库用户。
★Oracle安装成功后会自动创建十来个系统界别的账户。默认情况下这些账户中只有四个可用，其它的帐号都被设置成了锁定或是设置为过 期状态，这四个帐户就 ......
在我的上一个银行项目中，我接到编写ORACLE存储过程的任务，我是程序员，脑袋里只有一些如何使用CALLABLE接口调用存储过程的经验，一时不知如何下手，我查阅了一些资料，通过实践发现编写ORACLE存储过程是非常不容易的工作，即使上路以后，调试和验证非常麻烦。简单地讲，Oracle存储过程就是存储在Oracle数据库中的一个程序 ......
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 ......
