ora.rac1.vip_皇冠搏彩,皇冠新网址,www.cnqssd.com

Stop of `ora.rac2.vip` on member `rac2` succeeded.

a. Log in as the root user.

（3）另开一个窗口，从新指定ORACLE_HOME，PATH等参数，指定到新版本的ORACLE软件目录。

and Real Application Testing options

Stop of `ora.rac2.ons` on member `rac2` succeeded.

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

CORE 10.2.0.1.0 Production

四. 升级数据库软件

ora.dave.db OFFLINE OFFLINE

using the following command:

Relinking of patched files is complete.

ora.dave.dave2.inst ONLINE OFFLINE

Preparing to recopy patched init and RC scripts.

SYS@dave1(rac1)>select * from v$version;

[oracle@rac1 u01]$ sqlplus / as sysdba;

SYS@+ASM1(rac1)>

[n]: y

Connected to:

Stop of `ora.rac1.ons` on member `rac1` succeeded.

ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1

With the Partitioning, Real Application Clusters, OLAP, Data Mining

------------------------------ ---------- --------- -------

/u01/app/oracle/product/10.2.0/db_1/root.sh

3.3 用Nomachine工具运行runInstaller

ora.rac2.gsd ONLINE ONLINE rac2

Redhat 5.4 Orcle RAC 数据库从10.2.0.1升级到 10.2.0.4

1. On each node, do the following:

3.2 结束相干的过程

（4）在这个窗口运行dbua，选择ASM 实例进行升级。

Completed patching clusterware files to /u01/app/oracle/product/crs

BANNER

Startup will be queued to init within 30 seconds.

node 2: rac1 rac1-priv rac1

10.2.0.4的patch number 是：p6810189。

3.1 将升级包mout到linux系统

在官网看到一篇ASM 升级的文档，如下：

这局部内容参考Blog：

ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE rac2

Oracle RAC 启动与关闭

[oracle@rac1 p6810189_10204_Linux-x86]$ cd Disk1/

SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 12 22:02:26 2011

ora.rac2.ASM2.asm ONLINE ONLINE rac2

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

2.3 RAC 进程信息

The following environment variables are set as:

Copying coraenv to /usr/local/bin ...

[root@rac1 ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh

Relinking some shared libraries.

SYS@dave1(rac1)>

ora.rac2.vip ONLINE ONLINE rac2

五. 升级ASM 和DB 实例

ora.rac1.vip OFFLINE OFFLINE

Name Target State Host

多少点阐明：

Creating OCR keys for user 'root', privgrp 'root'..

[oracle@rac1 bin]$ emctl stop dbconsole

3. Wait until the script finishes and then proceed to the next node and repeat step 2.

在升级界面取舍升级ASM, 它会提醒我们的ASM 已经是最新版本了。由于咱们前面已经升级过了Oracle 软件，ASM 实例存在与ORACLE_HOME下。所以ASM 实例已经升级过了。

ora.rac2.gsd ONLINE ONLINE rac2

[oracle@rac1 u01]$ sh crs_stat.sh

TNS for Linux: Version 10.2.0.1.0 - Production

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

------------------------------ ---------- --------- -------

[root@rac1 ~]# /u01/app/oracle/product/crs/bin/crsctl stop crs

rac2

/u01/app/oracle/product/crs/install/root102.sh

Attempting to stop `ora.rac1.ons` on member `rac1`

ora.dave.dave2.inst ONLINE ONLINE rac2

一. 解释

ora.rac1.ons ONLINE ONLINE rac1

2. 能够把ASM 和 DB 一起升级，如果只升级ASM 实例的话，就像官网里供给的方式：

b. As root, shutdown the CRS daemons on the node

升级clusterware的时候，升级停止的时候会启动CRS服务,皇冠新2。我们在升级数据库的时候须要封闭这些服务。

3.2.3 停滞每个节点上的CRS

ora.rac2.LISTENER_RAC2.lsnr OFFLINE OFFLINE

The installer has detected that your Cluster Ready Services (CRS) installation is shared amongst the following nodes:

Entries will be added to the /etc/oratab file as needed by

ora.rac2.gsd OFFLINE OFFLINE

4. 3 安装结束会提示用root用户在所有节点上运行一个脚本

ora.rac1.vip ONLINE ONLINE rac1

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

4.2用Nomachine 工具衔接上服务器，进行升级包的目录,运行runInstaller

mount -o username=administrator,password=12345678 //192.168.3.115/Software /mnt

ora.rac1.vip ONLINE ONLINE rac1

ora.rac1.ASM1.asm ONLINE ONLINE rac1

clscfg: EXISTING configuration version 3 detected.

1. Clusterware的版本必需要跟DB 或者 ASM 的版本一致。假如说要升级ASM 或者DB，那么就必须先要升级clusterware。

ora.dave.dave2.inst OFFLINE OFFLINE

ora.rac2.ons ONLINE ONLINE rac2

Connected to:

ora.dave.db OFFLINE OFFLINE

[oracle@rac1 u01]$

ora.dave.taf.dave2.srv OFFLINE OFFLINE

ora.rac2.vip OFFLINE OFFLINE

WARNING: directory '/u01' is not owned by root

[oracle@rac1 ~]$ export ORACLE_SID=dave1

Shutdown request successfully issued.

ora.rac1.ons ONLINE ONLINE rac1

[oracle@rac1 bin]$ isqlplusctl stop

------------------------------ ---------- --------- -------

Attempting to stop `ora.rac2.ASM2.asm` on member `rac2`

ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE rac2

Creating pre-patch directory for saving pre-patch clusterware files

我的Patch 下到的本地的操作体系，网络又被网管限了速，所以直接就mount到linux上。

Stop of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 12 18:19:29 2011

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

ora.dave.taf.dave2.srv OFFLINE OFFLINE

ora.rac1.gsd OFFLINE OFFLINE

10204 patch successfully applied.

ora.rac1.LISTENER_RAC1.lsnr OFFLINE OFFLINE

[oracle@rac1 u01]$ sh crs_stat.sh

ora.rac2.vip OFFLINE OFFLINE

用root用户登陆系统，履行如下命令：

ora.dave.taf.cs OFFLINE OFFLINE

Running Oracle10 root.sh script...

To complete the installation of this patchset,百家乐高手, you must perform the following tasks:

WARNING: directory '/u01/app/oracle/product' is not owned by root

Connected to:

ora.dave.taf.dave1.srv OFFLINE OFFLINE

Stop of `ora.rac2.gsd` on member `rac2` succeeded.

ora.dave.taf.cs OFFLINE OFFLINE

ora.rac1.ASM1.asm OFFLINE OFFLINE

ora.rac1.vip OFFLINE OFFLINE

6.2 DB 版本

3.3.1进行升级包的目录，运行runInstaller

ora.rac1.ASM1.asm ONLINE ONLINE rac1

DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3 群：62697850(满)

------------------------------ ---------- --------- -------

ora.dave.taf.dave2.srv ONLINE ONLINE rac2

Attempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`

ora.dave.dave2.inst ONLINE OFFLINE

WARNING: directory '/u01/app' is not owned by root

How To Upgrade ASM from 10.2 to 11.1 (RAC)

所以，我们直接挑选升级DB 就好了。

聊天群：40132017 聊天2群：69087192

（1）将新版本的ASM 安装到其余目录。即安装数据库软件。

Stopping CSSD.

该工具的应用，参考：

Database Configuration Assistant when a database is created

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

ora.dave.taf.cs OFFLINE OFFLINE

六. 升级完之后，在验证下ASM 和 DB 版本

3. 在这个试验中，我们将DB 和 ASM 一起进行升级。就不在离开升级。因为虚构机的空间不够折腾。懂得这个思路就可以了。

ORACLE_OWNER= oracle

Stop of `ora.rac1.vip` on member `rac1` succeeded.

[oracle@rac1 u01]$ sqlplus / as sysdba;

ora.dave.dave1.inst ONLINE ONLINE rac1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Stop of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.

WARNING: directory '/u01/app/oracle' is not owned by root

[oracle@rac1 ~]$ sqlplus / as sysdba;

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

Attempting to stop `ora.rac2.vip` on member `rac2`

在可视化的装置窗口抉择ORACLE_HOME。看明白，不要选错了,菲律宾太阳城。而后一下步进行安装。

Recopying init and RC scripts.

10204_buglist.htm install patch_note.htm response runInstaller stage

[oracle@rac1 Disk1]$ ./runInstaller -ignoreSysPreReqs

Copying oraenv to /usr/local/bin ...

ora.rac2.ASM2.asm ONLINE ONLINE rac2

and Real Application Testing options

3.2.2 停止相关进程

Starting up the CRS daemons.

-------------------------------------------------------------------------------------------------------

Attempting to stop `ora.rac1.vip` on member `rac1`

rac1

[root@rac1 ~]#

ora.dave.taf.dave1.srv ONLINE ONLINE rac1

Copying dbhome to /usr/local/bin ...

ora.rac1.LISTENER_RAC1.lsnr ONLINE ONLINE rac1

这个可以用srvctl 命令来一个一个进行，也可以用crs_stop -all 进行。

SYS@+ASM1(rac1)>

ora.rac2.ons ONLINE ONLINE rac2

Name Target State Host

ora.rac2.gsd OFFLINE OFFLINE

ora.rac1.gsd ONLINE ONLINE rac1

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

Email: dvd.dba@gmail.com

[oracle@rac1 p6810189_10204_Linux-x86]$ pwd

----------------------------------------------------------------

[n]: y

Attempting to stop `ora.rac1.gsd` on member `rac1`

6.1 ASM 版本：

[oracle@rac1 u01]$ export ORACLE_SID=+ASM1

This script will automatically start the CRS daemons on the patched node upon completion.

[oracle@rac1 u01]$ sh crs_stat.sh

Operation successful.

Name Target State Host

[oracle@rac1 ~]$ cd /u01

Blog： http://blog.csdn.net/tianlesoftware

ora.dave.dave1.inst ONLINE OFFLINE

RAC 下数据库的升级参考：

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 12 22:04:53 2011

Connected to:

[oracle@rac1 u01]$ crs_stop -all

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

ora.rac1.gsd ONLINE ONLINE rac1

[oracle@rac1 Disk1]$ ls

[oracle@rac1 ~]$ export ORACLE_SID=+ASM1

三. 进级Clusterware

clscfg: version 3 is 10G Release 2.

ora.rac2.ons OFFLINE OFFLINE

/u01/app/oracle/product/crs/bin/crsctl stop crs

ora.rac1.ons OFFLINE OFFLINE

Stopping resources.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

ora.rac1.LISTENER_RAC1.lsnr ONLINE ONLINE rac1

ora.dave.taf.cs ONLINE ONLINE rac1

Finished running generic part of root.sh script.

Attempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`

PL/SQL Release 10.2.0.1.0 - Production

Repeat this step until the CRS daemons on all the nodes are shutdown.

2.2 ASM 实例版本

ora.dave.db OFFLINE OFFLINE

ora.dave.dave1.inst OFFLINE OFFLINE

[n]: y

ora.rac2.ons OFFLINE OFFLINE

3.3.3 安装结束会提示运行2个脚本

Name Target State Host

ora.dave.db ONLINE ONLINE rac1

Stop of `ora.rac1.gsd` on member `rac1` succeeded.

2.1 DB 版本信息

[oracle@rac1 u01]$ sh crs_stat.sh

ora.rac2.LISTENER_RAC2.lsnr OFFLINE OFFLINE

4.1 停止相关进程

SYS@dave1(rac1)>

Shutting down CSS daemon.

ora.dave.taf.dave2.srv OFFLINE OFFLINE

Successfully accumulated necessary OCR keys.

ora.rac2.vip ONLINE ONLINE rac2

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

Attempting to stop `ora.rac1.ASM1.asm` on member `rac1`

ora.rac1.ASM1.asm OFFLINE OFFLINE

Because of the shared nature of this installation, you cannot perform a rolling upgrade of your CRS software.

远程桌面工具 -- NoMachine

3.3.2 在可视化的安装窗口选择CRS_HOME。看清晰，不要选错了,皇冠投注网址。然后一下步进行安装。

ora.rac2.ASM2.asm OFFLINE OFFLINE

Either the release version of Oracle Clusterware must be equal to the ASM release to which you want to upgrade, or you must first upgrade Oracle Clusterware. For example, you can upgrade ASM release 11.1.0.6 to 11.1.0.7 if Oracle Clusterware on your system is release 11.1.0.7, but you cannot do this if Oracle Clusterware is 11.1.0.6 or an earlier release.

Attempting to stop `ora.rac2.gsd` on member `rac2`

2. After all the CRS daemons on all the nodes are shutdown, run the shell script located at:

NLSRTL Version 10.2.0.1.0 - Production

/mnt/OracleSoftware/p6810189_10204_Linux-x86

Now product-specific root actions will be performed.

Attempting to stop `ora.rac2.ons` on member `rac2`

ora.rac1.gsd OFFLINE OFFLINE

[root@rac1 ~]# /u01/app/oracle/product/crs/bin/crsctl stop crs

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 12 15:08:44 2011

ora.dave.taf.dave1.srv OFFLINE OFFLINE

-- 因为我用的是redhat 5，所以疏忽了版本检讨

DBA 超级群：63306533(满); DBA4 群： 83829929 DBA5群： 142216823

二. 查看RAC 信息

ora.rac1.LISTENER_RAC1.lsnr OFFLINE OFFLINE

clscfg -upgrade completed successfully

（2）用旧版本的ASM 启动实例实例。

Waiting for the patched CRS daemons to start. This may take a while on some systems.

Stop of `ora.rac2.ASM2.asm` on member `rac2` succeeded.

这个升级需要1个小时左右的时光。

ora.rac1.ons OFFLINE OFFLINE

ora.dave.taf.dave1.srv OFFLINE OFFLINE

3.2.1每个节点分辨停止 EM和 isqlplus

ora.rac2.ASM2.asm OFFLINE OFFLINE

[oracle@rac1 ~]$ sqlplus / as sysdba;

Stop of `ora.rac1.ASM1.asm` on member `rac1` succeeded.

ora.dave.dave1.inst ONLINE OFFLINE

Successfully stopped CRS resources

--加群需要在备注说明Oracle表空间和数据文件的关联，否则谢绝申请

(责任编辑：admin)

搜索

热门标签:

ora.rac1.vip