Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记

jarjava

2014-04-15

============================================================
Oracle® Database 10g Release 2 (10.2.0) RAC for RedHat4
Oracle Rac 10.2.0.1升级至10.2.0.4
============================================================
升级集群件-滚动升级

升级数据库软件-停用后升级

升级数据库

共计耗时5小时Orz...

第一部分：集群件滚动升级【OUI crs_home】

1、系统环境

操作系统版本

[10:42:13oracle@node1 ~]uname -a

Linux node1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:46:26 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux

[10:42:17oracle@node1 ~]

集群件版本

[10:42:18oracle@node1 ~]crsctl query crs softwareversion

CRS software version on node [node1] is [10.2.0.1.0]

[10:42:27oracle@node1 ~]

数据库版本

[10:43:08oracle@node1 ~]sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 28 10:43:11 2010

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

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

SYS@NODE1:null1>select * from v$version;

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

集群状态

[10:44:55oracle@node1 ~]crs_stat -t

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node1

ora....name.cs application ONLINE ONLINE node1

ora....ll1.srv application ONLINE ONLINE node2

ora....l1.inst application ONLINE ONLINE node1

ora....l2.inst application ONLINE ONLINE node2

ora.dba.rac.cs application ONLINE ONLINE node1

ora....ll1.srv application ONLINE ONLINE node1

ora....ll2.srv application ONLINE ONLINE node2

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

2、关闭节点1

关闭节点1 dbconsole

[11:14:47oracle@node1 db_1]emctl stop dbconsole

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

http://node1.wang.com:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Database Control ...

... Stopped.

关闭节点1 isqlplus

[11:15:03oracle@node1 db_1]isqlplusctl stop

iSQL*Plus 10.2.0.1.0

getnameinfo failed

iSQL*Plus instance on port 5560 is not running ...

关闭节点1 instance

[11:15:26oracle@node1 db_1]srvctl stop instance -d dba -i null1

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node1

ora....name.cs application ONLINE ONLINE node1

ora....ll1.srv application ONLINE ONLINE node2

ora....l1.inst application OFFLINE OFFLINE

ora....l2.inst application ONLINE ONLINE node2

ora.dba.rac.cs application ONLINE ONLINE node1

ora....ll1.srv application ONLINE OFFLINE

ora....ll2.srv application ONLINE ONLINE node2

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

============================================================

关闭节点1 ASM

[11:17:22oracle@node1 db_1]srvctl stop asm -n node1

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node1

ora....name.cs application ONLINE ONLINE node1

ora....ll1.srv application ONLINE ONLINE node2

ora....l1.inst application OFFLINE OFFLINE

ora....l2.inst application ONLINE ONLINE node2

ora.dba.rac.cs application ONLINE ONLINE node1

ora....ll1.srv application ONLINE OFFLINE

ora....ll2.srv application ONLINE ONLINE node2

ora....SM1.asm application OFFLINE OFFLINE

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

============================================================

关闭节点1 NODEAPPS

[11:18:27oracle@node1 db_1]srvctl stop nodeapps -n node1

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node2

ora....name.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node2

ora....l1.inst application OFFLINE OFFLINE

ora....l2.inst application ONLINE ONLINE node2

ora.dba.rac.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE OFFLINE

ora....ll2.srv application ONLINE ONLINE node2

ora....SM1.asm application OFFLINE OFFLINE

ora....E1.lsnr application OFFLINE OFFLINE

ora.node1.gsd application OFFLINE OFFLINE

ora.node1.ons application OFFLINE OFFLINE

ora.node1.vip application OFFLINE OFFLINE

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

============================================================

3、升级节点1 集群件

[11:23:39oracle@node1 oracle_linux_64]unzip p6810189_10204_Linux-x86-64.zip

[11:23:58oracle@node1 Disk1]./runInstaller

To complete the installation of this patchset, you must perform the following tasks on each node:

1.Log in as the root user.

2.As the root user, perform the following tasks:

a.Shutdown the CRS daemons by issuing the following command:

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

b.Run the shell script located at:

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

This script will automatically start the CRS daemons on the

patched node upon completion.

3.After completing this procedure, proceed to the next node and repeat.

[11:31:04root@node1 ~]crsctl stop crs

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

[11:31:27root@node1 ~]/u01/app/oracle/product/10.2.0/crs/install/root102.sh

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

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

Relinking some shared libraries.

Relinking of patched files is complete.

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

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

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

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

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

Preparing to recopy patched init and RC scripts.

Recopying init and RC scripts.

Startup will be queued to init within 30 seconds.

/etc/profile: line 55: ulimit: max user processes: cannot modify limit: Operation not permitted

Starting up the CRS daemons.

Waiting for the patched CRS daemons to start.

This may take a while on some systems.

10204 patch successfully applied.

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Successfully accumulated necessary OCR keys.

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

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

node 1: node1 node1-priv node1

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

Operation successful.

clscfg -upgrade completed successfully

[11:35:41root@node1 ~]

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node2

ora....name.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node2

ora....l1.inst application ONLINE ONLINE node1

ora....l2.inst application ONLINE ONLINE node2

ora.dba.rac.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....ll2.srv application ONLINE ONLINE node2

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

============================================================

4、关闭节点2

[11:42:41root@node1 ~]su - oracle

[11:42:43oracle@node1 db_1]ssh node2

Last login: Thu May 27 11:14:50 2010 from node2.wang.com

关闭节点2 dbconsole

[11:42:45oracle@node2 ~]emctl stop dbconsole

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

http://node1.wang.com:1158/em/console/aboutApplication

Stopping Oracle Enterprise Manager 10g Database Control ...

... Stopped.

[11:43:05oracle@node2 ~]

关闭节点2 isqlplus

[11:43:07oracle@node2 ~]isqlplusctl stop

iSQL*Plus 10.2.0.1.0

getnameinfo failed

iSQL*Plus instance on port 5560 is not running ...

关闭节点2 instance

[11:43:37oracle@node2 ~]srvctl stop instance -d dba -i null2

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node2

ora....name.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....l1.inst application ONLINE ONLINE node1

ora....l2.inst application OFFLINE OFFLINE

ora.dba.rac.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....ll2.srv application ONLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application ONLINE ONLINE node2

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

============================================================

关闭节点2 ASM

[11:45:25oracle@node2 ~]srvctl stop asm -n node2

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node2

ora....name.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....l1.inst application ONLINE ONLINE node1

ora....l2.inst application OFFLINE OFFLINE

ora.dba.rac.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....ll2.srv application ONLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application OFFLINE OFFLINE

ora....E2.lsnr application ONLINE ONLINE node2

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2

============================================================

关闭节点2 NODEAPPS

[11:46:45oracle@node2 ~]srvctl stop nodeapps-n node2

============================================================

Name Type Target State Host

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

ora.dba.db application ONLINE ONLINE node2

ora....name.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....l1.inst application ONLINE ONLINE node1

ora....l2.inst application OFFLINE OFFLINE

ora.dba.rac.cs application ONLINE ONLINE node2

ora....ll1.srv application ONLINE ONLINE node1

ora....ll2.srv application ONLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE node1

ora....E1.lsnr application ONLINE ONLINE node1

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora....SM2.asm application OFFLINE OFFLINE

ora....E2.lsnr application OFFLINE OFFLINE

ora.node2.gsd application OFFLINE OFFLINE

ora.node2.ons application OFFLINE OFFLINE

ora.node2.vip application OFFLINE OFFLINE

oracle rac oracle数据库

jarjava

0 关注 0 粉丝 0 动态

关注关注

rac（二）

#Public IP10.10.10.10 shdb110.10.10.20 shdb2#Virtual IP10.10.10.30 shdb1-vip10.10.10.40 shdb2-vip#Private IP192.

LuoXinLoves 2020-08-09

Oracle 19c RAC 升级RU 从19.3 升级到19.6 操作手册（使用nonrolling 方式）

Oracle 19c RAC 升级RU 从19.3 升级到19.6 操作手册。从MOS上我们可以看到19.6的RU 有GI和DB 2个版本，但从GI Patch的readme上看，GI 的Patch 已经包含了DB HOME和GI HOME的补丁，只需要用

dataminer 2020-06-21

关于使用PLSQL Developer时出现报错ora-12514的问题

　　在登陆PLSQL Developer时报ora-12513错误，需要修改本地数据库的监听配置文件，其过程相对简单。　　在Oracle安装目录中搜索找到listener.ora文件，并修改成txt格式后打开，需要添加的代码及添加位置如下图所示：。　　确认

lklong 2020-11-22

oracle锁表该如何解决

where l.object_id　=　o.object_id and l.session_id=s.sid;如果杀不掉可以加个 immediate 立即杀掉试试；如果利用上面的命令杀死一个进程后，进程状态被置为"killed"，但是

oraclemch 2020-11-06

Oracle表字段有Oracle关键字出现异常解决方案

现在进行项目改造，数据库需要迁移，由原来的使用GBase数据库改为使用Oracle数据库，今天测试人员在测试时后台报了一个异常。把SQL语句单独复制出来进行查询，还是报错，仔细分析原因才知道是表中的字段使用了Oracle中的关键字size。一般来说建表的时

shilukun 2020-10-10

甲骨文推出Oracle Exadata云服务X8M

甲骨文推出Oracle Exadata云服务X8M，已可在Oracle云基础设施上使用。企业可以通过26个全球云区域和Oracle专有云本地化解决方案，使用Oracle Exadata云服务X8M，加速运行具挑战性的事务处理和数据分析项目。无论是在云端还

周嘉笙 2020-11-09

oracle备份之备份测试脚本的方法（冷备、热备、rman)

2、没有备份参数文件，参数文件可以另外备份，没有必要每次都备份，只需要在改变设置后备份一次。

warden00 2020-08-31

限制ip访问Oracle数据库的方法步骤

本次实验环境是Centos6.10 + Oracle 11.2.0.4单实例，数据库服务器ip地址为192.168.31.71. 这里需要注意的是必须把本机ip地址加进来，否则监听启动会报错。tcp.invited_nodes的意思是开通白名单，不在白名单

zhuzhufxz 2020-09-16

Oracle和MySQL的数据导入为何差别这么大

经常会有一些朋友咨询我一些数据库的问题，我注意到一个很有意思的现象，凡是数据导入的问题，基本上都是Oracle类的，MySQL类的问题脑子里想了下竟然一次都没有。我们来梳理一下这个问题，分别从导出导入的方式来聊聊。导出有哪些工具呢，主要有exp，expdp

bfcady 2020-08-16

Oracle数据库的实例/表空间/用户/表之间关系简单讲解

完整的Oracle数据库通常由两部分组成：Oracle数据库和数据库实例。1) 数据库是一系列物理文件的集合；2) Oracle数据库实例则是一组Oracle后台进程/线程以及在服务器分配的共享内存区。Oracle有一个很大的内存快，成为全局区。Oracl

Hody 2020-08-16

浅谈入门级oracle数据库数据导入导出步骤

Oracle数据库是通过表空间来存储物理表的，一个数据库实例可以有N个表空间，一个表空间下可以有N张表。表空间是数据库的逻辑划分，每个数据库至少有一个表空间。

FightFourEggs 2020-08-16

oracle数据库的删除方法详解

使用DBCA进行删除的数据库必须处于OPEN状态，否则不能删除。到此这篇关于oracle数据库的删除方法详解的文章就介绍到这了,更多相关oracle数据库的删除方法内容请搜索安科网以前的文章或继续浏览下面的相关文章希望大家以后多多支持安科网！

数据库设计 2020-08-16

Oracle通过LogMiner实现数据同步迁移

最近在研究如何实现Oracle数据库之间的数据同步，网上的资料确实比较少。最好用的Oracle数据库同步工具是：GoldenGate ，而GoldenGate是要收费的。那么还有什么好的办法来同步Oracle的数据吗？没错，就是使用LogMiner来实现O

yanghuatong 2020-08-16

ORACLE数据库中Rownum用法详解

ORACLE 中ROWNUM用法总结!对于 Oracle 的 rownum 问题，很多资料都说不支持>,>=,=,between...and，只能用以上符号(<、<=、!=)，并非说用>,& gt;=,=,betwee

dbasunny 2020-08-16

oracle数据库关于索引建立及使用的详细介绍

罗罗 2020-08-16

Oracle 11g 数据库的部署的图文教程

Oracle Database，又名Oracle RDBMS，或简称Oracle。是甲骨文公司的一款关系数据库管理系统。它是在数据库领域一直处于领先地位的产品。可以说Oracle数据库系统是目前世界上流行的关系数据库管理系统，系统可移植性好、使用方便、功能

ihuaqiang 2020-08-16

静默安装卸载 ORACLE

dbca -silent -deleteDatabase -sourceDB adbtest -sysDBAUserName sys -sysDBAPassword leo

choice0 2020-07-30

oracle数据库跟踪工具

有没有一个能跟踪oracle数据库中执行SQL代码的跟踪工具？通过Oracle企业管理器建立跟踪从Top Consumers页面开始。该页面显示服务、模块、客户和动作对系统资源的当前使用情况。您可以单击Top Services、Top Modules、To

娜娜 2020-07-28

踩坑了！踩坑了！NHibernate使用批量插入Oracle数据，Batch属性

今天看NHibernate文档，发现了NHibernate提供批量操作数据的支持，目前仅支持sql server和Oracle，果断要试试啊。结果发现，竟然批量插入Oracle数据无效。--启动批量操作，可有效减少nh与数据库的连接。设置为0时，默认不启动

solarspot 2020-07-28

oracle 11g修改归档日志目录及大小

NAME TYPE VALUE. ------------------------------------ ----------- -----------------------

踩风火轮的乌龟 2020-07-26

Logstash Oracle同步设置

# 是否清除sql_last_value的记录，需要增量同步时此字段必须为false；# 同步频率，默认每分钟同步一次；where updated_at>:sql_last_value and updated_at<sysdate order

娜娜 2020-07-20

服务器断电导致的ORACLE异常 : ORA-00214 ORA-01033 ORA-01034 ORA-00172 ORA-27101

工作环境中的集群迁移之后，oracle出了挺多问题，最开始一直没找到原因，后来发现做迁移的人是冷迁移的，且数据库节点是硬关机的，惊了（。ORACLE 例程已经启动。数据库装载完毕。ORA-01151：如需要，请使用介质恢复以…SQL> recover

xwb 2020-07-19

关于ORACLE索引的几种扫描方式

一条sql执行的效率因执行计划的差异而影响，经常说这条sql走索引了，那条sql 全表扫了。索引是怎么走的呢，说说我了解到的几种索引走的方式。具体来说，仅当查询谓词使用等号运算符引用唯一索引键中的所有列时，数据库才执行唯一扫描.数据库从索引条目中获取行标识

娜娜 2020-07-18

Oracle期末复习

数据库是存储数据的多个物理文件的集合，如控制文件，数据文件，参数文件，日志文件，临时文件等，它是静态的、永久的，只要文件存在它就存在。数据库名就是对数据库的标识。就是由内存空间和工作进程两部分组成。容器数据库是Oracle 12c引入的新特性，允许容器数

流云追风 2020-07-04

Oracle 导入数据库dmp文件

场景：windows2008 R2系统，往新安装的oracle11g数据库导入同事给的dmp文件到指定的新建的用户。在导入dmp文件之前，先打开查看dmp文件的表空间名称。使用数据库dba用户创建用户并赋予相应的导入导出等权限。个人试过几次，最后选择命令

dataminer 2020-06-25

oracle 授予权限和收回权限 grant和revoke 以及角色的创建删除

ALLON数据对象名,SELECTON数据对象名,UPDATEON数据对象名,DELETEON数据对象名,INSERTON数据对象名,--用户授权GRANTCONNECT,RESOURCETO用户名;GRANTSELECTON表名TO用户名;GRANTSE

娜娜 2020-06-22

oracle执行计划打印

下班逗猫闲得无聊，写写自己对几种oracle执行计划打印的认识。废话少说开始吧方式一：explain plan for使用explain plan for，这种查询方式适合查看单条执行SQL的执行计划。explain plan for的查看方式也有两种：1

zhangchaoming 2020-06-21

Oracle数据库视图创建以及优点分析

select s.xh,s.classid,s.xm,s.sex,s.birthday,c.cname from student s,classstu c where s.classid=c.classid

goodriver 2020-06-17

Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记

相关推荐