实验环境,vmware server 、11gr2rac
先把痛苦的经历说一下:之前配置rac时一个虚拟机分配了2.5G 、3G的内存,2.5G时安装grid时节点宕机,内存3G时创建oracle 库节点宕机,反正是折腾了好几遍,经验教训是在配置RAC时要做好快照;发现自己操作失误或者节点宕机时自己无法解决时可以用快照来恢复;终于在内存分配4G时才顺序安装;自己又安装另外一台dataguard机器,担心内存吃不消,把原来节点1和节点2的内存该为3G,dataguard改为2g,发现在启动rac后,集群在两个节点上服务都是正常的数据库没起来
[grid@node1 ~]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: DATA,FLASH
Services:
Database is administrator managed
默认是自动启动数据库的 ;但是还是想手工启动试试;结果出错了;
于是想手动启动数据库
[grid@node1 ~]$ srvctl start database -d racdb
PRCR-1079 : Failed to start resource ora.racdb.db
ORA-00845: MEMORY_TARGET not supported on this system
CRS-2674: Start of 'ora.racdb.db' on 'node1' failed
ORA-00845: MEMORY_TARGET not supported on this system
CRS-2674: Start of 'ora.racdb.db' on 'node2' failed
CRS-2632: There are no more servers to try to place resource 'ora.racdb.db' on that would satisfy its placement policy
[grid@node1 ~]$ df -Th
Filesystem Type Size Used Avail Use% Mounted on
/dev/sda3 ext3 27G 19G 6.5G 74% /
/dev/sda1 ext3 99M 22M 72M 24% /boot
tmpfs tmpfs 1.5G 164M 1.4G 11% /dev/shm
是不是自己把内存改了之后的问题,于是又重新把内存加到4G,试着重新启动RAC,过了几分钟,在查看服务状态都已经起来了
[grid@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE node1
ora.FLASH.dg ora....up.type ONLINE ONLINE node1
ora.GRIDDG.dg ora....up.type ONLINE ONLINE node1
ora....ER.lsnr ora....er.type ONLINE ONLINE node1
ora....N1.lsnr ora....er.type ONLINE ONLINE node2
ora.asm ora.asm.type ONLINE ONLINE node1
ora.eons ora.eons.type ONLINE ONLINE node1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip ora....t1.type ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip ora....t1.type ONLINE ONLINE node2
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE node1
ora.racdb.db ora....se.type ONLINE ONLINE node1
ora.scan1.vip ora....ip.type ONLINE ONLINE node2
[grid@node1 ~]$ ps -ef |grep ora_
oracle 5747 1 0 12:56 ? 00:00:00 ora_pmon_racdb1
oracle 5751 1 0 12:56 ? 00:00:01 ora_vktm_racdb1
oracle 5757 1 0 12:56 ? 00:00:02 ora_gen0_racdb1
oracle 5761 1 0 12:56 ? 00:00:01 ora_diag_racdb1
oracle 5765 1 0 12:56 ? 00:00:00 ora_dbrm_racdb1
oracle 5769 1 0 12:56 ? 00:00:00 ora_ping_racdb1
oracle 5773 1 0 12:56 ? 00:00:00 ora_psp0_racdb1
oracle 5777 1 0 12:56 ? 00:00:00 ora_acms_racdb1
[grid@node2 ~]$ ps -ef |grep ora_
oracle 5625 1 0 12:53 ? 00:00:00 ora_pmon_racdb2
oracle 5629 1 0 12:53 ? 00:00:02 ora_vktm_racdb2
oracle 5635 1 0 12:53 ? 00:00:00 ora_gen0_racdb2
oracle 5639 1 0 12:53 ? 00:00:01 ora_diag_racdb2
oracle 5643 1 0 12:53 ? 00:00:00 ora_dbrm_racdb2
oracle 5647 1 0 12:53 ? 00:00:00 ora_ping_racdb2
oracle 5651 1 0 12:53 ? 00:00:00 ora_psp0_racdb2
oracle 5655 1 0 12:53 ? 00:00:00 ora_acms_racdb2
个人感觉这玩意吃内存吃的厉害,有条件的话就加大内存,不然在个人电脑上整不起来!!
转载于:https://blog.51cto.com/summervast/1199044