Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记-mysql教程-PHP中文網

首頁

資料庫

mysql教程

Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:47 PM

Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记

============================================================
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

: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 :

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

: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

linux

，

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

MySQL：世界上最受歡迎的數據庫的簡介Apr 12, 2025 am 12:18 AM

MySQL是一種開源的關係型數據庫管理系統，主要用於快速、可靠地存儲和檢索數據。其工作原理包括客戶端請求、查詢解析、執行查詢和返回結果。使用示例包括創建表、插入和查詢數據，以及高級功能如JOIN操作。常見錯誤涉及SQL語法、數據類型和權限問題，優化建議包括使用索引、優化查詢和分錶分區。

MySQL的重要性：數據存儲和管理Apr 12, 2025 am 12:18 AM

MySQL是一個開源的關係型數據庫管理系統，適用於數據存儲、管理、查詢和安全。 1.它支持多種操作系統，廣泛應用於Web應用等領域。 2.通過客戶端-服務器架構和不同存儲引擎，MySQL高效處理數據。 3.基本用法包括創建數據庫和表，插入、查詢和更新數據。 4.高級用法涉及復雜查詢和存儲過程。 5.常見錯誤可通過EXPLAIN語句調試。 6.性能優化包括合理使用索引和優化查詢語句。

為什麼要使用mysql？利益和優勢Apr 12, 2025 am 12:17 AM

選擇MySQL的原因是其性能、可靠性、易用性和社區支持。 1.MySQL提供高效的數據存儲和檢索功能，支持多種數據類型和高級查詢操作。 2.採用客戶端-服務器架構和多種存儲引擎，支持事務和查詢優化。 3.易於使用，支持多種操作系統和編程語言。 4.擁有強大的社區支持，提供豐富的資源和解決方案。

描述InnoDB鎖定機制（共享鎖，獨家鎖，意向鎖，記錄鎖，間隙鎖，下一鍵鎖）。Apr 12, 2025 am 12:16 AM

InnoDB的鎖機制包括共享鎖、排他鎖、意向鎖、記錄鎖、間隙鎖和下一個鍵鎖。 1.共享鎖允許事務讀取數據而不阻止其他事務讀取。 2.排他鎖阻止其他事務讀取和修改數據。 3.意向鎖優化鎖效率。 4.記錄鎖鎖定索引記錄。 5.間隙鎖鎖定索引記錄間隙。 6.下一個鍵鎖是記錄鎖和間隙鎖的組合，確保數據一致性。

MySQL查詢性能差的常見原因是什麼？Apr 12, 2025 am 12:11 AM

MySQL查询性能不佳的原因主要包括没有使用索引、查询优化器选择错误的执行计划、表设计不合理、数据量过大和锁竞争。1.没有索引导致查询缓慢，添加索引后可显著提升性能。2.使用EXPLAIN命令可以分析查询计划，找出优化器错误。3.重构表结构和优化JOIN条件可改善表设计问题。4.数据量大时，采用分区和分表策略。5.高并发环境下，优化事务和锁策略可减少锁竞争。

您什麼時候應該使用複合索引與多個單列索引？Apr 11, 2025 am 12:06 AM

在數據庫優化中，應根據查詢需求選擇索引策略：1.當查詢涉及多個列且條件順序固定時，使用複合索引；2.當查詢涉及多個列但條件順序不固定時，使用多個單列索引。複合索引適用於優化多列查詢，單列索引則適合單列查詢。

如何識別和優化MySQL中的慢速查詢？（慢查詢日誌，performance_schema）Apr 10, 2025 am 09:36 AM

要優化MySQL慢查詢，需使用slowquerylog和performance_schema：1.啟用slowquerylog並設置閾值，記錄慢查詢；2.利用performance_schema分析查詢執行細節，找出性能瓶頸並優化。

MySQL和SQL：開發人員的基本技能Apr 10, 2025 am 09:30 AM

MySQL和SQL是開發者必備技能。 1.MySQL是開源的關係型數據庫管理系統，SQL是用於管理和操作數據庫的標準語言。 2.MySQL通過高效的數據存儲和檢索功能支持多種存儲引擎，SQL通過簡單語句完成複雜數據操作。 3.使用示例包括基本查詢和高級查詢，如按條件過濾和排序。 4.常見錯誤包括語法錯誤和性能問題，可通過檢查SQL語句和使用EXPLAIN命令優化。 5.性能優化技巧包括使用索引、避免全表掃描、優化JOIN操作和提升代碼可讀性。

See all articles