/vipca Error 0(Native: listNetInterfaces:[3])  在搭建RAC过程中再最后台Node运行root.sh，最后如果出现Error 0(Native: listNetInterfaces:[3])错误，则通过以下方法解决。 rac2 ~] #cd /oracle/product/crs/binrac2 bin] #./oifcfg iflist[root @rac2 bin] #./oifcfg setif-global eth0/172.24.18.0:public[root @rac2 bin] #./oifcfg setif-global eth2/10.0.0.0:cluster_interconnect[root @rac2 bin] #./oifcfg getif结束后再运行VIPCA

10G RAC建库报错PRKS-1009 CRS-0215报错解决 好久没有安装10g的RAC了，今天装了个，妈的竟然报错，报错如下：   google了一把也没有找到方案。实例ASM2无法启动，但是手工是可以的啊。看了下后台报错妈的什么terminated，也不知道是啥原因。反复做了好几遍都是同样的报错。 最后用如下方案是可以的： 由于dbca建库会自动创建ASM实例，所以先关闭正在运行的ASM实例，然后从OCR中移除ASM实例的相关配置，然后用DBCA删除安装信息。再次启动DBCA一切OK。 步骤如下： 1.停止两个节点上的ASM实例[root@elvis101 bin]# ./srvctl stop asm -n elvis101[root@elvis101 bin]# ./srvctl stop asm -n elvis102[root@elvis101 bin]# ./crs_stat -tName Type Target State Host ------------------------------------------------------------ora....SM1.asm application OFFLINE OFFLINE ora....01.lsnr application ONLINE ONLINE elvis101 ora....101.gsd application ONLINE ONLINE elvis101 ora....101.ons application ONLINE ONLINE elvis101 o...

 RAC重新建库和报单实例错误和解决办法。     重新建立ASM实例    1、停止实例。    [oracle@ora2 ~]$ srvctl stop asm -n ora1[oracle@ora2 ~]$ srvctl stop asm -n ora2   2、删除服务[oracle@ora2 ~]$ srvctl remove asm -n ora1[oracle@ora2 ~]$ srvctl remove asm -n ora2      3、删除配置文件，在两个节点运行   [oracle@ora2 ~]$ rm -f $ORACLE_HOME/dbs/*ASM*[oracle@ora2 ~]$ rm -fr $ORACLE_BASE/admin/*ASM*   4、删除/etc/oratab实例注册，在两个节点运行。删除一下条目，其中以+ASM开头的为asm实例。        +ASM2:/u01/app/oracle/product/10.2.0/db_1:N   5、创建asm实例    使用dbca重新创建。  如果不清理/etc/oratab内容，会在建asm实例时抱一下错误：The ASM instance configured on the local node is a single-instance ASM.To create a single-instance database using this ASM instance ,restart DBCA and select the single-instance database...

crs_stop -all 命令后遇到 UNKNOWN crs_stop -all 命令后遇到 UNKNOWNcrs_stop -all 命令后遇到 UNKNOWNRAC中执行crs_stop -all后提示一些服务停不了，再用crs_stat -t查看状态的时候，停不掉的服务会显示状态是UNKNOWN，服务在UNKNOWN状态下用 crs_start 不能启动服务例如：[oracle@rac1 ~]$ crs_stop -allAttempting to stop `ora.rac1.gsd` on member `rac1`Attempting to stop `ora.rac1.ons` on member `rac1`Attempting to stop `ora.rac2.gsd` on member `rac2`Attempting to stop `ora.ora9i.db` on member `rac1`Attempting to stop `ora.rac2.ons` on member `rac2`Stop of `ora.rac1.gsd` on member `rac1` succeeded.Stop of `ora.rac2.gsd` on member `rac2` succeeded.Stop of `ora.rac2.ons` on member `rac2` succeeded.Stop of `ora.rac1.ons` on member `rac1` succeeded.Stop of `ora.ora9i.db` on member `rac1` succeeded.Attempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`Attempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2``ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` has experienced an unrecoverable fail...

如何完全删除CRS OS:Red Hat Linux As 5DB:10.2.0.1   在安装好CRS后发现CRS无法启动,每次CRS启动异常都导致机器不停的重启动,超级郁闷,获取日志信息如下:2012-08-01 11:50:18.491: [ CSSCLNT][5177872]clsssInitNative: connect failed, rc 92012-08-01 12:15:47.441: [ CSSCLNT][5547712]clsssInitNative: connect failed, rc 92012-08-02 09:03:11.045: [ CSSCLNT][9479872]clsssInitNative: connect failed, rc 9  网上说引起这个问题的原因很多,能找到的办法都尝过了,问题依旧,最后回想想第一次安装CRS后不成功,可能是没有完全删除导致的,最后在网上找到了一份完全删除CRS的方法,按照这个方法完全删除后重新安装CRS,问题解决. 1. Run the rootdelete.sh script. then the rootdeinstall.sh script. from the$ORA_CRS_HOME/install directory on any nodes you are removing CRS from.  Runningthese scripts should be sufficent to clean up your CRS install.  Rootdelete.shaccepts options like nosharedvar/sharedvar, and nosharedhome/sharedhome. Makeyourself familiar with these options by reading the Oracle C...

CentOS 5上搭建10gRAC 一、资源规划：1. VM名字规划:CentOS_5.7_Oracle10g_RAC_node1_192.168.0.31CentOS_5.7_Oracle10g_RAC_node2_192.168.0.322. rac的ip规划:    ip \ nodeNode 1 Node 2public ip(eth0)192.168.0.31 192.168.0.32private ip(eth1)100.0.0.10100.0.0.20vip192.168.0.231192.168.0.2323. 硬盘空间规划:OS 12G * 2 = 24G  => oracle+crs = 2G *2Share storage 16G => raw device4. 操作系统规划:CentOS 5.5 32bit5. Oracle软件规划:Oracle Clusterware 10.2.0.1.0Oracle Database 10.2.0.1.0二、系统安装及配置1. CentOS 5.5 32bit的安装。2. 安装完毕后，关闭一些不必要的系统服务(Bluetooth, cups, iptables, ip6talbes, sendmail)：chkconfig bluetooth offchkconfig cups offchkconfig iptables offchkconfig ip6tables offchkconfig sendmail offservice bluetooth stopservice cups stopservice iptables stopservice ip6tables stopservice sendmail stop操作系统安装完毕后，占用大概2.7G。3. 把oracle的软件上传到node 1上配置yum，把vsftpd软件装上，从宿主系统上传 或 登录宿主系统的ftp server去下载。...

centos ssh无密码互信登录失败解决方法 最近使用RAC时，需要ssh无密登录， 配置好后，一直主机正常，另外一台，必需要密码才能登陆。配置ssh互信方式 都一样，却有一个主机有问题。后来发现， Oracle 用户家目录权限，不一样。# chmod 775 /home/oracle然后，就可以正常使用了。

您所在的组无权查看该日志

虚拟机安装10g rac的几点备忘 虚拟机安装10g rac的几点备忘 一、重新安装CRS需要做的事在机群中的所有节点上执行$ORA_CRS_HOME/install/rootdelete.sh；在机群中的任意一个节点上执行$ORA_CRS_HOME/install/rootdeinstall.sh；dd清除ocr和vote diskdd if=/dev/zero of=/dev/sdb1 bs=1M count=256dd if=/dev/zero of=/dev/sdc1 bs=1M count=256dd if=/dev/zero of=/dev/sdd1 bs=1M count=256dd if=/dev/zero of=/dev/sde1 bs=1M count=256rm -rf /var/tmp/.oracle /tmp/.oracle /etc/oracle /etc/oraInst.locrm -rf /etc/init.d/init.cssd /etc/init.d/init.crs /etc/init.d/init.crsd /etc/init.d/init.evmdrm -rf /etc/rc2.d/K96init.crs /etc/rc2.d/S96init.crsrm -rf /etc/rc3.d/K96init.crs /etc/rc3.d/S96init.crsrm -rf /etc/rc5.d/K96init.crs /etc/rc5.d/S96init.crsrm -rf /opt/app/oracle/oraInventory/* /opt/crs/oracle/product/10.2.0/crs_1/*chown -R oracle:oinstall /opt/crschown -R oracle:oinstall /opt/app/oraclechown -R oracle:oinstall /dev/rawchown -R oracle:oinstall /...

RedHat(RHEL)6 support ASMLIB (RHEL6支持asmlib) With the annoucement of Oracle’s database support on RHEL6 and OEL6, they have decided to stop making ASMLIB for RHEL compatible kernels. ASMLIB is now only available if you are using Oracle Unbreakable Linux Kernel. RHEL6 has also deprecated the use of setting LUN permissions using multipath.conf therefore we have to fall back to UDEV rules. Recent events enabled Red Hat and Oracle to work together, and Oracle is now officially supporting ASMlib on Red Hat Enterprise Linux 6.4 and newer. ORACLE sound: All ASMLib installations require that the ‘kmod-oracleasm’,'oracleasmlib’ and ‘oracleasm-support’ packages be installed on the system. The ‘oracleasmlib’ and ‘oracleasm-support’ packages are available for download at the locations listed below. The kernel driver package ‘kmod-oracleasm’ is available directly fro...