RAC如何启动状态为UNKNOWN的资源&&PRKS-1009,CRS-1028,CRS-0223现象：RAC的一个节点起不来，crs_stat查看发现很多资源状态都为offline[Oracle@rac1 ~]$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora.rac.db application OFFLINE OFFLINE ora....c1.inst application ONLINE OFFLINE ora....c2.inst application ONLINE OFFLINE ora....test.cs application OFFLINE OFFLINE ora....ac1.srv application OFFLINE OFFLINE ora....ac2.srv application OFFLINE OFFLINE ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application ONLINE ONLINE rac1 ora....ac1.gsd application ONLINE ONLINE rac1 ora....ac1.ons application ONLINE ONLINE rac1 ora....ac1.vip application ONLINE ONLINE rac1 ora....SM2.asm application ONLINE UNKNOWN rac2 ora....C2.lsnr application ONLINE UNKNOWN rac2 ora....ac2.gsd application ONLINE ONLINE rac2 ora....ac2.ons application ONLINE ONLINE rac2 ora....ac2.vip application ONLINE ONLINE rac2 [oracle@rac1 ~]$ srvctl start asm -n...

/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...

 Windows下openVPN GUI的安装与配置  OPENVPN 简介：OpenVPN是一款功能强大，可跨平台(支持Win 2000/XP/2003, Linux, Mac OS X, Solaris, FreeBSD, NetBSD, 和 OpenBSD)使用的SSL VPN服务器软件（具体说明见官方主页官方主页）。openvpn-2.1_beta16版，下载地址 http://openvpn.net/download_action.php?openvpn-2.1_beta16-install.exe第一步：安装openvpn这一部分是服务端跟客户端都要做的工作，操作完全相同双击 openvpn-2.1_beta16-install.exe进行安装，点击NEXT，I Agree，NEXT之后开始选择安装路径，我手动修改为C:\Program Files\OpenVPN 。点击 Install 开始安装，安装过程中，弹出 硬件安装窗口，点击仍然继续，安装虚拟网卡。点击 next,Finish 完成安装。OPENVPN安装服务器配置：说明： 架设OPENVPN服务器，服务器方面做的工作比较多，客户端相对来说就比较简单。服务器采用RSA证书和密钥验证方式对客户端进行验证，默认情况下证书和用户是一对一的，多个用户使用同一证书会被踢出。所以首先要做的工作就是证书的制作。在进行操作之前，首先进行初始化工作：修改C:\Program Files\OPENVPN\easy-rsa\vars.bat.sample的以下部分set HOME=%Progr...

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

ESXI5虚拟机Centos5升级后，网络不通解决方法 。本人的ESXI5.5 中安装有centos 5 系统，然后升级的系统。重启后，网络不通了，查看配置文件都是正常的。最后想到应是vmtool 工具有问题了，要重装或是升级。解决方法：第一种: 直接在虚拟机管理界面，点 安装或升级vmtool.虚拟机系统会自动升级处理。然后网络就会正常使用了。第二种： 将vmtool源码包，再重新安装一次。重启系统后就正常使用了。

如何完全删除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去下载。...

p4679769_10201_LINUX.ZIP今天在浏览eygle的网站看到一个bug的相关帖子，猛地忽然想起前几天安装过一套rac 中遇到过一个bug，当时没有注意就直接打完bug后就不去做记录了，今日想起略感模糊故记录在此，供自己日后查看，也方便来客查阅。系统环境 redhat 5.5 64.bit  ORACLE 10g 10.2.0.5 raw设备 +lvm在执行root.sh 时出错出错信息如下failed to upgrade oracle cluster registry configuration按照常理应该是执行root后会出现扫描节点完成的信息 如下：WARNING: directory '/opt/oracle/product/10.2' is not owned by rootWARNING: directory '/opt/oracle/product' is not owned by rootWARNING: directory '/opt/oracle' is not owned by rootChecking to see if Oracle CRS stack is already configuredSetting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory '/opt/oracle/product/10.2' is not owned by rootWARNING: directory '/opt/oracle/product' is not owned by rootWARNING: directory '/opt/oracle' is not owned by rootSuccessfully...