实验环境,vmware server 、11gr2rac

先把痛苦的经历说一下:之前配置rac时一个虚拟机分配了2.5G 、3G的内存,2.5G时安装grid时节点宕机,内存3G时创建oracle 库节点宕机,反正是折腾了好几遍,经验教训是在配置RAC时要做好快照;发现自己操作失误或者节点宕机时自己无法解决时可以用快照来恢复;终于在内存分配4G时才顺序安装;自己又安装另外一台dataguard机器,担心内存吃不消,把原来节点1和节点2的内存该为3G,dataguard改为2g,发现在启动rac后,集群在两个节点上服务都是正常的数据库没起来


oracle11g数据库在重启RAC 出现ORA-00845 MEMORY_TARGET not supported on this system_racORA-00845

[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


个人感觉这玩意吃内存吃的厉害,有条件的话就加大内存,不然在个人电脑上整不起来!!