RAC: 日常监控 所有实例和服务的状态$ srvctl status database -d racdbInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2特定节点上节点应用程序的状态$ srvctl status nodeapps -n linux1VIP is running on node: linux1GSD is running on node: linux1Listener is running on node: linux1ONS daemon is running on node: linux1ASM 实例的状态$ srvctl status asm -n linux1ASM instance +ASM1 is running on node linux1.列出配置的所有数据库$ srvctl config databaseracdb集群中所有正在运行的实例SELECTinst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status db_status, active_state state, host_name hostFROM gv$instanceORDER BY inst_id;INST_ID INST_NO INST_NAME PAR STATUS DB_STATUS STATE HOST-------- -------- ---------- --- ------- ------------ --------- -------1 1 orcl1 YES OPEN ACTIVE NORMAL rac12 2 orcl2 YES OPEN ACTIVE NORMAL rac2位于磁盘组中的所有数据文件select name from v$datafileunionselect member from v$logfileunionselect name from v$controlf...

PRKP-1001 CRS-1028 CRS-0223: Resource 'ora.RACDB.RACDB1.inst' has placement error解决办法 Correcting our RAC problemWe have seen the CRS commands and syntax, now lets look at the practical aspect of it. I was having some trouble while running my RAC on RHEL4 (I think the problem primarily arose because I supplied my virtual machines with inadequate memory. When I noticed that I was getting some alerts on my SoRAC tool, I looked at the status of my RAC.oracle@vmora01rh4 ~]$ cd /u01/app/oracle/product/10.2.0/crs/bin [oracle@vmora01rh4 bin]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.fokerac.db application ONLINE ONLINE vmora02rh4 ora....c1.inst application ONLINE ONLINE vmora01rh4 ora....c2.inst application OFFLINE UNKNOWN vmora02rh4 ora....serv.cs application ONLINE ONLINE vmora02rh4 ora....ac1.srv application ONLINE ONLINE vmora01rh4 ...

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

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然后，就可以正常使用了。