Oracle RAC
文章平均质量分 74
leishifei
这个作者很懒,什么都没留下…
展开
-
RAC 安装维护的 Metalink 必读文档
在进行RAC安装和维护过程中,有些Metalink文档是非常重要的参考,必读。简要列举一下文档名及文档号,备忘并供有帐号的朋友参考:1. Patch Set Updates for Oracle Products [ID 854428.1]. http://blog.csdn.原创 2011-07-20 14:04:47 · 354 阅读 · 0 评论 -
利用STANDBY将单实例数据库升级为RAC环境之三
<br /><br />这篇文章描述单实例环境与RAC环境的SWITCHOVER过程。<br />前面已经成功搭建了单实例数据库TEST11G的RAC环境STANDBY数据库TEST11GR。STANDBY数据库的两个实例可以同时以READ ONLY方式启动。<br /><br />下面为了执行SWITCHOVER操作,可以先关闭实例2:<br />$ export ORACLE_SID=test11gr2<br />$ sqlplus "/ as sysdba"<br />SQL*Plus: Releas原创 2011-04-08 09:56:00 · 332 阅读 · 0 评论 -
Migrating to RAC using Data Guard [ID 273015.1]
<br />Migrating to RAC using Data Guard [ID 273015.1]<br /> <br />--------------------------------------------------------------------------------<br /> <br /> <br /> Modified 16-SEP-2010 Type BULLETIN Status PUBLISHED<br /> <br /> <br />In this D原创 2011-04-07 21:54:00 · 230 阅读 · 0 评论 -
Oracle Switchover RAC数据库提示ORA-600(kcctrdf_2)错误解决方案
<br />Oracle 10g RAC环境数据库执行ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL DATABASE操作,<br />试图将当前的物理STANDBY数据库切换为PRIMARY数据库时,出现下面的错误:<br />SQL> CONN SYS/TEST@TESTRAC_STANDBY AS SYSDBA<br />已连接。<br />SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;<br />SWITC原创 2011-04-07 21:47:00 · 454 阅读 · 0 评论 -
利用STANDBY将单实例数据库升级为RAC环境之四
<br /><br />这篇文章描述整个操作过程中碰到的错误。<br /><br />最开始碰了几个初始化参数设置的小错误,主要问题是FLASH_RECOVERY_AREA设置到ASM实例上导致了问题:<br />SQL> startup nomount pfile=/export/home/oracle/inittest11gr1.ora<br />ORA-01261: Parameter db_recovery_file_dest destination string cannot be transla原创 2011-04-08 10:03:00 · 493 阅读 · 0 评论 -
利用STANDBY将单实例数据库升级为RAC环境之二
<br /><br />上一篇完成了绝大部分准备的工作,下面在打开数据库之前,还要设置一下目标数据库上的密码文件。<br />在STANDBY的RAC环境的两个节点上分别拷贝密码文件:<br />$ cd $ORACLE_HOME/dbs<br />$ ftp 172.0.2.61<br />Connected to 172.0.2.61.<br />220 netdb1 FTP server ready.<br />Name (172.0.2.61:oracle): oracle<br />331 Pas原创 2011-04-08 09:42:00 · 398 阅读 · 0 评论 -
How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure [ID 747457.1]
How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure [ID 747457.1] Modified 04-AUG-2010 Type HOWTO Status ARCHIVED <br />In this Document<br /> Goal<br /> Solution<br /> References<br /><br /> <br /> Applies t原创 2011-05-22 17:10:00 · 373 阅读 · 0 评论 -
RAC User Equivalence Check Failed
$ ./runcluvfy.sh comp nodecon -n ahrac1,ahrac2 -verboseVerifying node connectivity ERROR: User equivalence unavailable on all the nodes.Verification cannot proceed.Verification of node connectivity was unsuccessful on all the nodes. 简单的说,Oracle在寻找ssh命令时,去/原创 2011-04-02 14:02:00 · 700 阅读 · 0 评论 -
CRS ocrcheck 命令用法
<br />$ ocrdump -h<br />Name:<br /> ocrdump - Dump contents of Oracle Cluster Registry to a file.<br />Synopsis:<br /> ocrdump [<filename>|-stdout] [-backupfile <backupfilename>] [-keyname <keyname>] [-xml] [-noheader]<br />Description:<br />原创 2011-04-02 10:51:00 · 421 阅读 · 0 评论 -
利用STANDBY将单实例数据库升级为RAC环境之一
利用Oracle的STANDBY技术,可以将单实例数据库升级到RAC数据库。这种方式可以有效的降低单实例迁移到RAC环境的停机时间。这篇文章介绍STANDBY数据库建立的准备工作。首先需要确保目标服务器上的RAC环境已经建立,如果使用ASM作为存储机制,则ASM实例也配置完成。下面开始STANDBY数据库建立的过程,更改源数据库的FORCE LOGGING属性:$ sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on 星期三 7月 1原创 2011-04-08 09:27:00 · 389 阅读 · 0 评论 -
RAC环境移除service
操作过程:$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora.orcl.db application ONLINE ONLINE racdb_b ora....oltp.cs application ONLINE OFFLINE原创 2011-04-10 19:56:00 · 358 阅读 · 0 评论 -
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
<br />问题:<br />今天在AIX 5L 的一个双节点RAC环境测试一个数据库的备份脚本,一开始遇到了一些错误,但没能记录下来,最后就记录下来了这一个ORA-27054错误。<br />以下是操作过程:<br />RMAN-00571: ===========================================================<br /><br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ======原创 2011-04-10 22:08:00 · 1593 阅读 · 0 评论 -
OracleRAC管理基本命令总结
OracleRAC管理基本命令总结按不同层次划分1.节点层次:olsnodes2.网络层:oifcfg3.集群层:crsctl,ocrcheck,ocrdump,ocrconfig4.应用层:srvctl,onsctl,crs_stat #具体操作节点层olsnode命令 具体都原创 2011-07-23 11:47:14 · 506 阅读 · 0 评论 -
Oracle RAC 启动与关闭
<br />一. 检查共享设备<br />一般情况下, 存放OCR 和 Voting Disk 的OCFS2 或者raw 都是自动启动的。 如果他们没有启动,RAC 肯定是启动不了的。 <br /> <br />1.1 如果使用ocfs2的,检查ocfs2 状态<br />/etc/init.d/o2cb status<br /> <br />在挂载之前,/etc/init.d/o2cb status 显示为Checking O2CB heartbeat: Not active。<br />在格式化和挂载文转载 2011-05-01 18:16:00 · 292 阅读 · 0 评论 -
RAC 实例不能启动
<br />一. 发现问题<br /> <br />准备启动RAC 做升级的实验,启动后,实例无法启动, crs_stat 显示ASM 实例已经启动了。 <br /> <br />[oracle@rac1 bin]$ crs_stat -t<br />Name Type Target State Host<br />------------------------------------------------------------<br />ora.转载 2011-05-01 18:14:00 · 258 阅读 · 0 评论 -
OCRCONFIG工具主要功能是备份、恢复ocr 例子
OCRCONFIG工具主要功能是备份、恢复ocr引自:http://yangtingkun.itpub.net/post/468/512234虽然用oracle用户可以直接运行ocrconfig,但是大部分命令还需要root用户才有权限执行bash-2.03$ ocrconfig名称:ocrconfig - Oracle 集群注册表的配置工具。概要:ocrconfig [optio原创 2011-06-28 15:39:00 · 429 阅读 · 0 评论 -
Removing a Node from a 10gR1 RAC Cluster [ID 269320.1]
Removing a Node from a 10gR1 RAC Cluster [ID 269320.1] -------------------------------------------------------------------------------- Modified 20-OCT-2010 Type BULLETIN Status PUBLISHED Note: This article is only relevant for 1原创 2011-04-27 16:48:00 · 383 阅读 · 0 评论 -
RMAN: RAC Backup and Recovery using RMAN [ID 243760.1]
RMAN: RAC Backup and Recovery using RMAN [ID 243760.1] 修改时间 20-OCT-2010 类型 BULLETIN 状态 PUBLISHED "Checked for relevance on 02-JUL-2010"RAC Backup and Recovery using RMANObjectives:===========1. Verify the database mode and archive d原创 2011-04-27 10:43:00 · 388 阅读 · 0 评论 -
RAC + DG 搭建归档日志缺失遭遇记
<br />RAC + DG 搭建归档日志缺失遭遇记<br /><br />SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;<br /><br />PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS<br />--------- ------------ ---------- ---------- --原创 2011-05-31 21:15:00 · 607 阅读 · 0 评论 -
RAC的负载均衡
<br />RAC的负载均衡主要是指新会话连接到RAC数据库时,如何判定这个新的连接要连到哪个节点进行工作。在RAC中,负载均衡分为两种,一种是基于客户端连接的,另外一种是基于服务器端的。<br />客户端的负载均衡配置相对简单,只需要在tnsnames.ora中添加LOAD_BALANCE=ON这么一个选项即可。比如下面的TNS:<br />RAC =<br />(DESCRIPTION =<br />(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT =转载 2011-05-29 07:35:00 · 306 阅读 · 0 评论 -
CRS oifcfg 命令用法
<br />$ oifcfg<br />Name:<br /> oifcfg - Oracle Interface Configuration Tool.<br />Usage: oifcfg iflist [-p [-n]]<br /> oifcfg setif {-node <nodename> | -global} {<if_name>/<subnet>:<if_type>}...<br /> oifcfg getif [-node <nodename> |原创 2011-04-02 10:49:00 · 470 阅读 · 0 评论 -
CRS ocrconfig 命令用法
<br />$ ocrconfig<br />Name:<br /> ocrconfig - Configuration tool for Oracle Cluster Registry.<br />Synopsis:<br /> ocrconfig [option]<br /> option:<br /> -export <filename> [-s online]<br />原创 2011-04-02 10:47:00 · 720 阅读 · 2 评论 -
Oracle RAC tnsnames.ora文件
<br />LISTENERS_ORCL =<br /> (ADDRESS_LIST =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = racdb_a-vip)(PORT = 1521))<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = racdb_b-vip)(PORT = 1521))<br /> )<br />ORCL2 =<br /> (DESCRIPTION =<br /> (ADDRESS = (PRO原创 2011-04-01 22:23:00 · 700 阅读 · 0 评论 -
Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2
<br />After upgrade the ASM instance from release 11.1 to release 11.2 existing database is unable to start/open due to the next error:<br /> <br />/u01/app/oracle/product/11.1.0/dbs>sqlplus<br />SQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 7 15:49原创 2011-05-15 10:10:00 · 325 阅读 · 0 评论 -
Configuring raw devices (multipath) for Oracle Clusterware 10g Release 2 (10.2.0) on RHEL5/OEL5 [ID 564580.1]
Configuring raw devices (multipath) for Oracle Clusterware 10g Release 2 (10.2.0) on RHEL5/OEL5 [ID 564580.1] Modified 24-JAN-2010 Type HOWTO Status PUBLISHED <br />In this Document<br /> Goal<br /> Solution<br /> Deprecation of Support for R原创 2011-05-12 14:11:00 · 483 阅读 · 0 评论 -
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1]
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1] Modified 12-OCT-2010 Type HOWTO Status PUBLISHED <br />In this Document<br /> Goal<br /> Solution<br /> References<br /><br /> <br /> Applies to: <br />Oracle Server原创 2011-05-12 12:34:00 · 395 阅读 · 0 评论 -
Placement of Voting disk and OCR Files in Oracle RAC 10g and 11gR1 [ID 293819.1]
Placement of Voting disk and OCR Files in Oracle RAC 10g and 11gR1 [ID 293819.1] Modified 27-OCT-2010 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br /> Placement of Voting disk and OCR Files in原创 2011-05-12 12:32:00 · 336 阅读 · 0 评论 -
How To Upgrade ASM from 10.2 to 11.1 (RAC)
The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (on RAC). Solution1) Shutdown all the database instances that are using ASM as storage option. 2) Shutdown the ASM instances. 3) Install / upgrade the new 11g CRS as des原创 2011-05-15 10:07:00 · 247 阅读 · 0 评论 -
How to Clean Up After a Failed 10g or 11.1 Oracle Clusterware Installation [ID 239998.1]
How to Clean Up After a Failed 10g or 11.1 Oracle Clusterware Installation [ID 239998.1] Modified 28-OCT-2010 Type BULLETIN Status PUBLISHED <br /> Applies to: <br />Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.8 - Release: 10.1原创 2011-05-11 19:39:00 · 444 阅读 · 0 评论 -
CLUVFY Fails With Error: Could not find a suitable set of interfaces for VIPs [ID 338924.1]
<br />CLUVFY Fails With Error: Could not find a suitable set of interfaces for VIPs [ID 338924.1] Modified 29-JUL-2010 Type PROBLEM Status PUBLISHED <br />In this Document<br /> Symptoms<br /> Cause<br /> Solution<br /> References<br /><br /> <原创 2011-05-11 10:38:00 · 1495 阅读 · 0 评论 -
error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory
<br />[root@nodea ~]# /u01/app/oracle/product/10.2.0/crs/root.sh<br />WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root<br />WARNING: directory '/u01/app/oracle/product' is not owned by root<br />WARNING: directory '/u01/app/oracle'原创 2011-05-11 13:39:00 · 2012 阅读 · 0 评论 -
Oracle RAC Failover 之Client-Side Connect Time Failover 与TAF(Transparent Application Failover) 配置
<br />Oracle RAC Failover 之Client-Side Connect Time Failover 与TAF(Transparent Application Failover) 配置<br /><br /><br />ORCL_CL =<br /> (DESCRIPTION =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = nodea-vip)(PORT = 1521))<br /> (ADDRESS = (PROTOCOL = TCP原创 2011-05-19 10:28:00 · 421 阅读 · 0 评论 -
Oracle 10g RAC Server-Side TAF配置
<br /> <br />使用Server-Side TAF必须配置Service。Service可以在创建数据库时创建,也可以在数据库创建之后修改;既可以通过配置向导也可以通过命令行方式配置。下面演示采用通过命令行手工配置Service的过程。<br /><br />l 用srvctl命令配置Service<br />这种方法对于远程维护尤其有用。无论是创建还是维护都使用一个命令srvctl,先来看看有关srvctl命令的语法。<br />$ srvctl -h --这是我从真实的RAC系统原创 2011-05-19 13:38:00 · 1002 阅读 · 0 评论 -
crs_stat命令文件类容
<br />#!/bin/sh<br />ORA_CRS_HOME=/u01/app/oracle/product/10.2.0/crs<br />ORACLE_HOME=$ORA_CRS_HOME<br />export ORA_CRS_HOME ORACLE_HOME<br />case `/bin/uname` in<br />Linux) LD_LIBRARY_PATH=$ORA_CRS_HOME/lib<br /> export LD_LIBRARY_PATH<br />原创 2011-04-01 10:52:00 · 497 阅读 · 0 评论 -
CRS racgmain 参考
<br />$ racgmain -h<br />Usage racgmain [resource name] start|stop|check<br /> racgmain startorp|failsrvsa dbname instname [srvname]<br /> racgmain startorp|failsrvsa nodename<br /> racgmain cond_resname cond_state func [args...]原创 2011-04-02 10:52:00 · 331 阅读 · 0 评论 -
CRS ocrcheck 命令语法
<br />$ ocrcheck -h<br />Name:<br /> ocrcheck - Displays health of Oracle Cluster Registry.<br />Synopsis:<br /> ocrcheck <br />Description:<br /> prompt> ocrcheck<br /> Displays current usage, location and health of the cluster原创 2011-04-02 10:50:00 · 216 阅读 · 0 评论 -
CRS crs_stat crs_start crs_stop 命令语法
<br />$ crs_stat -h<br />Usage: crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member]<br /> crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member]<br /> crs_stat -p [resource_name [...]] [-q]<br /> crs_stat [-a] a原创 2011-04-02 10:46:00 · 1398 阅读 · 0 评论 -
CRS cluvfy命令语法
<br />$ cluvfy<br /><br />USAGE:<br />cluvfy [ -help ]<br />cluvfy stage { -list | -help }<br />cluvfy stage {-pre|-post} <stage-name> <stage-specific options> [-verbose]<br />cluvfy comp { -list | -help }<br />cluvfy comp <component-name> <component-sp原创 2011-04-02 10:44:00 · 346 阅读 · 0 评论 -
CRS crsctl 命令语法
<br />$ crsctl<br />Usage: crsctl check crs - checks the viability of the CRS stack<br /> crsctl check cssd - checks the viability of CSS<br /> crsctl check crsd - checks the viability of CRS<br /> crsctl check原创 2011-04-02 10:42:00 · 325 阅读 · 0 评论 -
CRS srvctl 命令语法
<br />$ srvctl -h<br />Usage: srvctl [-V]<br />Usage: srvctl add database -d <name> -o <oracle_home> [-m <domain_name>] [-p <sp<br />file>] [-A <name|ip>/netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}<br />] [-s <start_options>] [-n <db_name>]原创 2011-04-02 10:40:00 · 338 阅读 · 0 评论