Zhong Weicheng Study Notes

fdisk查看磁盘[root@db11g ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.9 (Tikanga)[root@db11g ~]# [root@db11g ~]# [root@db11g ~]# fdisk -lDisk /dev/sda: 32.2 GB, 3221225472

check the open modes of all the PDBs on a RAC instance when you connect to the CDB root[oracle@zhongwc1 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.4 (Santiago)[oracle@

[root@vzwc1 ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost#publi

check votedisk and OCR [root@vzwc1 ~]# ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120

View the current Votedisk[grid@vzwc1 ~]$ crsctl query crs activeversionOracle Clusterware active version on the cluster is [11.2.0.4.0][grid@vzwc1 ~]$ [grid@vzwc1 ~]$ crsctl query css votedisk

Source  2-Nodes Oracle 11.2.0.4.0 RACTarget  Single Instance Oracle 11.2.0.4.0Source[oracle@vzwc1 oracle]$ mkdir /u01/app/oracle/bak[oracle@vzwc1 oracle]$ rman target /Recovery Manage

操作环境PrimaryStandbyClusterware11.2.0.3 Grid Infrastructure11.2.0.3 Grid InfrastructureCluster Nodesvzwc1,vzwc2,vzwc3(3-Nodes)sd-vzwc1,s

OS版本是Oracle Linux5.8 x86_64,Oracle Database和Grid Infrastructure版本是11.2.0.3,双节点RAC。[root@vzwc1 ~]# cat /etc/issueOracle Linux Server release 5.8Kernel \r on an \m[root@vzwc1 ~]# uname -p x8

11.2.0.1 ACFS new supported OS platforms and data services OL5 and RHEL5Windows 2003 R1 (64-bit)Windows 2003 R2 (64-bit) 11.2.0.2 ACFS new support

add votedisk[root@vzwc1 ~]# /u01/app/oracle/product/10.2.0/db_1/bin/crsctl add css votedisk /dev/raw/raw3 -forceNow formatting voting disk: /dev/raw/raw3successful addition of votedisk /dev/raw/ra

sourceOracle 11gR2 RAC#public IP192.168.1.51     vzwc1192.168.1.52     vzwc2#private IP172.168.1.51     vzwc1-priv172.168.1.52     vzwc2-priv#VIP192.168.1.151    vzwc1-vip192.168.1

The generic steps to follow when adding the new node to the cluster are:Install Operating SystemInstall required softwareAdd/modify users and groups required for the installationConfigure netw

The generic steps to follow when adding the new node to the cluster are:Install Operating SystemInstall required softwareAdd/modify users and groups required for the installationConfigure netw

Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid InfrastructureRAC Best Practice and Starter Kit InformationThe goal of the Oracle Real Application Clusters (RA

配置dhcp和dns服务器过程省略--root.sh[root@vzwc1 ~]# /u01/app/12.1.0/grid/roo

源端Oracle 11.2.0.4 RAC 2-NodesOracle Linux 5.8 x86_64目标端Greenplum Database 4.2.6.1 4-NodesCentOS 5.7 x86_64======================================================源端配置--本例是将OGG安

root@vzwc1:~# isainfo -namd64root@vzwc1:~# unameSunOSroot@vzwc1:~# cat /etc/release Oracle Solaris 11.1 X86 Copyright (c) 1983, 2012, Oracle and/or its affiliates.

SLES11安装参考博文Installation SUSE Linux Enterprise Server 11vzwc1:~ # cat /etc/issueWelcome to SUSE Linux Enterprise Server 11 SP3 (x86_64) - Kernel \r (\l).vzwc1:~ # 配置/etc/hosts文件192.1

vzwc1:~ # uname -aLinux vzwc1 3.0.76-0.11-default #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990) x86_64 x86_64 x86_64 GNU/Linuxvzwc1:~ # cat /etc/issueWelcome to SUSE Linux Enterprise Server 11 SP3

on  RHEL 5 / CentOS 5 / Oracle Linux 5[root@vmt ~]# cat /etc/issueOracle Linux Server release 5.7Kernel \r on an \m[root@vmt ~]# uname -px86_64[root@vmt ~]# [root@vmt ~]# scsi_id -g -u -s

[grid@vzwc1 ~]$ crsctl query crs activeversionOracle Clusterware active version on the cluster is [11.2.0.4.0][grid@vzwc1 ~]$ [grid@vzwc1 ~]$ crsctl query css votedisk## STATE File Universal I

使用VBOX模拟存储迁移的环境，OS：RHEL5.9，DB：Oracle 10.2.0.4 RAC ASM 2Nodes。ASM使用Extern Redundancy，不使用ASM的rebalance功能，ocr和votedisk存放在raw里。迁移包括controlfile，datafile，tempfile，spfile，ocr，votedisk。迁移前路径ocr

所有实例和服务的状态[oracle@vzwc1 ~]$ srvctl status database -d zwcInstance zwc1 is running on node vzwc1Instance zwc2 is running on node vzwc2单个实例的状态[oracle@vzwc1 ~]$ srvctl status instance -d zw

[oracle@zhongwc1 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.7 (Tikanga)[oracle@zhongwc1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 22 15:1

[oracle@zhongwc1 Pck]$ ls -l *.sql-rw-r--r-- 1 oracle oinstall 839 Mar 19 2012 1_grants.sql-rw-r--r-- 1 oracle oinstall 1680 Mar 17 2012 2_Types.sql-rw-r--r-- 1 oracle oinstall 82422 May 12 2

使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)在所有node上创建oracle,grid用户,创建相关目录[root@node2 ~]# groupadd -g 1000 oinstall [root@node2 ~]# groupadd -g 1200 asmadmin[root@node2 ~]# groupadd

使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三)将安装介质上传到node1,解压准备安装grid infrast

Step By Step Configuring Oracle 10gR2 (10.2.0.5) 3-Nodes RAC to Single DataguardDG配置参考上面链接。主库环境是3-nodes的 RAC,保证实例racdb1正常运行,关闭racdb2和racdb3实例。备库至于mount状态。[oracle@standby arch]$ sqlplus / a

Operating System:Oracle Linux 5.7 x86_64Oracle version:10.2.0.5RAC Primary database192.168.1.51            racnode1192.168.1.151           racnode1-vip172.168.1.51            racnode1-

如何添加节点Oracle 10g RAC 添加节点目前RAC环境如下,先要删除racdb3SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;INSTANCE_NAME HOST_N

Oracle10.2.0.5 3nodes RAC在racnode1使用DBCA创建serviceracnode1选择首选,racnode2和racnode3选择可用,TAF policy选择basic点击No各实例的service_names[oracle@racnod

Oracle 10g RAC RMAN backup Example Closed database and delete datafile[oracle@racnode1 backup]$ srvctl stop database -d racdb[oracle@racnode1 backup]$ asmcmdASMCMD> lsDATADG/FLASHDG/A

Database Version: 10.2.0.5 3nodesVerify the databases are in archivelog mode and archive destinationracnode1[oracle@racnode1 arch]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Prod

目前环境是一个版本为10.2.0.5的双节点RAC,hostname分别为racnode1,racnode2需要添加新节点racnode3。OS版本是Oracle Linux 5.7 x86_64保证RAC正常运行配置public IP,private IP,VIP,将这些信息配置到/etc/hosts文件中192.168.1.51 rac

使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)配置共享磁盘,本次实验环境是基于VMware ESXi 5搭建。和vbox配置差不多,具体过程略,关闭node1,node2,说明一下需要注意的地方SCSI

有关于Oracle Linux 6的安装可以参考Oracle Linux 6 Installation。安装两台OL6分配两个网卡内存均为3G,hostname分别为node1和node2。OS版本你也可以选择CentOS6或者是RHEL6,建议初次安装选择CentOS6/RHEL6。选择Oracle Linux6可以使用OL6提供的oracle-rdbms-server-11gR2-prei

使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三)使用UDEV在Oracle Linux 6上安装Oracle 11g R

Use "grid" user inquires the current diskgroup,disk.[grid@node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 7 15:33:06 2013Copyright (c) 1982, 2011, Oracle. All

Copy spfile with -u option - to update GPnP profile in RAC environment[grid@zhongwc1 ~]$ asmcmd lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file

这篇文章详细介绍了Oracle RAC环境下的连接管理，分别介绍了什么是 Connect Time Load Balancing、Runtime Connection Load Balancing、Connect Time Connection Failover 和 Runtime Connection Failover，以及里面所涉及到的 TAF、ONS、FCF、FAN、LBA 等诸多知识点。本