ITPub博客

The FAILOVER_MODE parameter must be included in the CONNECT_DATA section of a connect descriptor. FAILOVER_MODE can contain the parameters described in Table 13–4.Table 13–4 Additional Parameters of the FAILOVER_MODE Parameter

All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a conflict.$ OPatch/opatch apply ...

An Oracle Real Application Clusters environment enables active instances to concurrently execute transactions on a shared database. Patching in an Oracle Real Application Clusters environment is slightly different compared to patching a single node.Interim Patching using OPatch follows a similar a...

错误：官档提示：ORA-15063: ASM discovered an insufficient number of disks for diskgroup "string"Cause: ASM was unable to find a sufficient number of disks belonging to the diskgroup to continue the operation.Action: Check that the disks in the diskgroup are present ...

影响Oracle数据库字符集最重要的参数是NLS_LANG参数它的格式如下: NLS_LANG = language_territory.charset它有三个组成部分(语言、地域和字符集)，每个成分控制了NLS子集的特性。其中:Language： 指定服务器消息的语言， 影响提示信息是中文还是英文Territory： 指定服务器的日期和数字格式，Charset：&nb...

You can use the VALIDATE command to manually check for physical and logical corruptions in database files. This command performs the same types of checks as BACKUP VALIDATE, but VALIDATE can check a larger selection of objects. For example, you can validate individual blocks with t...

device checks for asm    --没安装asmlib，使用的udev绑定，可以忽略task resolv.conf integrity   --这个是因为无法访问设置的DNS ip，对安装没影响以上两种是可以忽略的检查错误

在grid的软件目录下的RPM文件夹下有这个包，找到并安装就行。

错误的原因是由于磁盘数和冗余层级不匹配：如果创建用来存放OCR和VOTEDISK的ASM磁盘组，那么External、Normal、High三种冗余级别对应的Failgroup个数是1、3、5。也就是说，创建这三种冗余级别的磁盘组至少分别需要1、3、5个ASM磁盘。如果创建用于非OCR和VOTEDISK存储的ASM磁盘组，那么External、Normal、High三种...

当两个虚拟机共享一个磁盘时，vmware对第一个获取磁盘的虚拟机进行锁定，导致第二个虚拟机申请资源的过程中无法获取资源解决方法：去磁盘所在目录将后缀为lck的文件夹删除即可

You split a range partition using the ALTER TABLE ... SPLIT PARTITION statement. You specify a value of the partitioning key column within the range of the partition at which to split the partition. The first of the resulting two new partitions includes all rows in the original par...

首先在虚拟机关机的状态下，在虚拟机系统目录里将.vmx的文件加入disk.EnableUUID="TRUE"开机运行下列命令获取uuid，如下所示：[root@node1 ~]# scsi_id  --whitelisted --device=/dev/sdb36000c29e2a80468665c53df3e89728d3

1.确认在所有RAC节点上已经安装了必要的UDEV包[root@rh2 ~]# rpm -qa|grep udevudev-095-14.21.el52.通过scsi_id获取设备的块设备的唯一标识名，假设系统上已有LUN sdc-sdpfor i in c d e f g h i j k l m n o p ;doecho "sd$i" "`scsi_id -g -u -s /block/sd$i` ";donesdc 1IET_00010001sdd 1IET_0001000...

SKIP_UNUSABLE_INDEXES参数的主要用途是当索引为usable状态时保证sql的运行，虽然它保证了系统的健壮性，但是有可能系统没有使用该索引而导致性能的低下。还有该参数对于使用hint的某些sql和唯一索引的插入、删除语句却不生效 比如使用了index。创建测试表和索引 SQL> conn test/test 已连接。  SQL> dr...

1. Query the data dictionary to determine whether an existing index or index partition is usable or unusable.For example, issue the following query (output truncated to save space):hr@PROD> SELECT INDEX_NAME AS "INDEX OR PART NAME", STATUS, SEGMENT_CREATED 2 FROM USER_INDEXES 3 U...

一、网络设置192.168.137.200 node1192.168.137.206 node2192.168.137.201 node1-vip192.168.137.207 node2-vip10.10.10.100 node1-priv10.10.10.101 node2-priv192.168.137.250 scan-vip互ping内外网，看是否可以实现通信二、存储使用nfs或使用ASM（需要官方提供ASMLIB包）三、创建需要的用户和...

两个节点的用户密码不一致所致

解决方法：如无使用DNS服务器则忽略

Network Time Protocol (NTP) - This task verifies cluster time synchronization on clusters that use Network Time Protocol (NTP).  Check Failed on Nodes: [rac2,  rac1]  Verification result of failed node: rac2 Expected Value : n/aActual Value : n/a&n...

192.168.137.200：新建一个文件目录，用于共享mkdir /sharedata将新建的磁盘挂载到此目录下mount /dev/sdb1 /sharedata注：由于nfs不支持裸设备，因此需将/dev/sdb格式化后再对/dev/sdb1创建文件系统编辑/etc/exports文件/sharedata 192.168.137.200(rw,no_root_squash) 192.168.137.206(rw,no_root_squash)刷...