推荐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 NOMOUNT
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
eview the patch.log , If necessary, rerun the catupgrd.sql script. after correcting any problems.
9. SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
10, Run the utlrp.sql script. to recompile all invalid PL/SQL packages
SQL> @?/rdbms/admin/utlrp.sql
11. SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
12. SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
13. SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
14. Start any database services that you want to use:
$ srvctl start service -d db_name -s service_name
15. To configure and secure Enterprise Manager follow these steps:
In the case of Oracle Real Application Clusters (RAC), execute
emca -upgrade db -cluster
from:http://space.itpub.net/35489/viewspace-498128
分享到:
相关推荐
OracleRAC_10.2.0.1升级到10.2.0.4安装配置参考手册
Oracle_RAC_10.2.0.1升级到10.2.0.4-安装配置参考手册
AIX下 oracle rac 10.2.0.1升10.2.0.4.4 详细步骤,内附详细步骤
Linux_RHEL_Oracle_RAC_10.2.0.1升级到10.2.0.4-安装配置参考手册
OracleRAC10.2.0.1升级到10.2.0.4-安装配置参考手册参考.pdf
Oracle 10.2.0.4 rac 详细安装文档
linux下oracle 10.2.0.4 RAC升级,怎么打psu
前言 我们知道在某些停机测试场景,是需要人为禁用crs/has的自启动的,防止过程中主机反复重启对... Oracle RAC 11.2.0.4 Oracle RAC 12.1.0.2 发现对于Oracle RAC 10.2.0.5来说: 使用root用户crsctl disable/en
115 RAC centos7.7部署oracle12.2.0.1rac 116 RAC deploying_oracle_rac_12c_rhel7_v1.1_0 117 RAC Guides_Rac11gR2OnLinux--(from redhat) 118 RAC Guides安装指南_Rac11gR1OnHPUX 119 RAC Guides安装指南_Rac...
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.6 Information in this document applies to any platform. Description The following errors may be reported: ORA-00603: ORACLE server ...
oracle-instantclient-sqlplus-10.2.0.4-1.x86_64.rpm oracle-instantclient-jdbc-10.2.0.4-1.x86_64.rpm oracle-instantclient-devel-10.2.0.4-1.x86_64.rpm oracle-instantclient-basic-10.2.0.4-1.x86_64.rpm ...
oracle客户端的安装是非常简单的,关键在tns配置,我这里使用的rpm安装包,oracle本身不是开源,那使用rpm安装时简单的。 1.要远程使用oracle,先下载下面三个文件,注意版本好一致。 oracle-instantclient-...
首先到oracle官网的这个页面下载相关的文件,注意要连数据库服务器的版本,一定要对应,否则安装成功也会连不上,同时也要区分32位、64位服务器,比如我要连的数据库服务器是oracle10.2.0.4,64位主机,那么我要下载...
今天遇到个软件要求安装oracle client端,于是考虑装精简版本的,就从http://www.oracle.com/technology/software/tech/oci/instantclient/index.html下载了instantclient-basic-win32-10.2.0.4.zip,该版本支持多种...
2 下载对应的oracle-instantclient-basic-10.2.0.4-1.i386.zip将其拷贝至Linux的Oracle账户并解压至instantclient_10_2目录 实现OCCI的六大步骤: 1 创建环境变量Environment 2 创建连
基本环境:Snow Leopard10.6.2,Oracle10.2.0.4 打开Mac的终端,执行: sudo -i 创建oinstall组和oracle用户,注意需要保证组合用户的ID与现有系统信息不冲突,这里采用700 创建组: dscl . -create /groups/...