Oracle study之--“ORA-00845: MEMORY_TARGET not supported on this system"错误

亦凉 2022-08-01 13:37 238阅读 0赞

Oracle study之—“ORA-00845: MEMORY_TARGET not supported on this system”错误

系统环境：

操作系统：RedHat EL6(64)

Oracle： Oracle 11g R2

故障案例：

在Oracle 11gR2下调整内存参数：memory_target

  1. SQL> show parameter mem
  3. NAME                                 TYPE        VALUE
  4. ------------------------------------ ----------- ------------------------------
  5. hi_shared_memory_address             integer     0
  6. memory_max_target                    big integer 400M
  7. memory_target                        big integer 400M
  8. shared_memory_address                integer     0
  9. SQL> alter system set memory_max_target=1200m scope=spfile;
  11. System altered.
  13. SQL> alter system set memory_target=1200m scope=spfile;
  15. System altered.
  17. SQL> show parameter sga
  19. NAME                                 TYPE        VALUE
  20. ------------------------------------ ----------- ------------------------------
  21. lock_sga                             boolean     FALSE
  22. pre_page_sga                         boolean     FALSE
  23. sga_max_size                         big integer 400M
  24. sga_target                           big integer 0
  25. SQL> show parameter shared
  27. NAME                                 TYPE        VALUE
  28. ------------------------------------ ----------- ------------------------------
  29. hi_shared_memory_address             integer     0
  30. max_shared_servers                   integer
  31. shared_memory_address                integer     0
  32. shared_pool_reserved_size            big integer 6710886
  33. shared_pool_size                     big integer 0
  34. shared_server_sessions               integer
  35. shared_servers                       integer     1
  36. SQL> alter system set shared_pool_size=500m scope=spfile;
  38. System altered.
  40. SQL> show parameter java
  42. NAME                                 TYPE        VALUE
  43. ------------------------------------ ----------- ------------------------------
  44. java_jit_enabled                     boolean     TRUE
  45. java_max_sessionspace_size           integer     0
  46. java_pool_size                       big integer 0
  47. java_soft_sessionspace_limit         integer     0
  48. SQL> alter system set java_pool_size=300m scope=spfile;
  50. System altered.
  52. <strong>调整完成后，重新启动Instance：</strong>

SQL> startup force;
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

查看linux系统文件系统：
[oracle@rh6 dbs]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 18G 5.2G 12G 32% /
tmpfs 878M 72K 878M 1% /dev/shm
/dev/sda1 2.0G 62M 1.8G 4% /boot
/dev/sda3 12G 5.7G 5.4G 52% /u01
/dev/sda5 9.9G 4.9G 4.6G 52% /usr
/dev/sda7 4.2G 300M 3.7G 8% /var

—-从以上可以看到，对于虚拟tmpfs的内存的文件系统，可用空间为878M，无法满足memory_target =1200M的内存需求

调整tmpfs：

  1. <strong>[oracle@rh6 dbs]$ su -
  2. Password: 
  4. [root@rh6 ~]# umount tmpfs
  5. umount: /dev/shm: device is busy.
  6.         (In some cases useful info about processes that use
  7.          the device is found by lsof(8) or fuser(1))
  8. </strong>
  10. <strong>关闭和tmpfs相关的process：</strong>
  14. <strong>[root@rh6 ~]# fuser -kc /dev/shm
  15. /dev/shm:             2204m
  16. </strong>
  18. <strong>[root@rh6 ~]# umount tmpfs
  20. [root@rh6 ~]# mount  -t tmpfs shmfs -o size=1300m /dev/shm
  21. [root@rh6 ~]# df -h
  22. Filesystem            Size  Used Avail Use% Mounted on
  23. /dev/sda2              18G  5.2G   12G  32% /
  24. /dev/sda1             2.0G   62M  1.8G   4% /boot
  25. /dev/sda3              12G  5.7G  5.4G  52% /u01
  26. /dev/sda5             9.9G  4.9G  4.6G  52% /usr
  27. /dev/sda7             4.2G  300M  3.7G   8% /var
  28. shmfs                 1.3G     0  1.3G   0% /dev/shm
  29. </strong>
  31. <strong>修改fstab文件，当系统启动时mount tmpfs</strong>
  33. <strong>[root@rh6 ~]# vi /etc/fstab
  34. #
  35. # /etc/fstab
  36. # Created by anaconda on Sun Sep 29 16:52:59 2013
  37. #
  38. # Accessible filesystems, by reference, are maintained under '/dev/disk'
  39. # See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
  40. #
  41. UUID=85ffcaeb-1855-4f6a-b1af-d4e13d7b8850 /                       ext4    defaults        1 1
  42. UUID=0e7c052e-fc2a-402a-82cc-116e7629ef8f /boot                   ext4    defaults        1 2
  43. UUID=cf98cf21-ba1f-4a3a-aac3-43406dd5fca1 /u01                    ext4    defaults        1 2
  44. UUID=e3cf943c-48c4-4c4b-ba65-f11ba1f6a2e0 /usr                    ext4    defaults        1 2
  45. UUID=c5dd449a-ce22-4d47-a6d3-2d09c0186489 /var                    ext4    defaults        1 2
  46. UUID=e701d956-939e-441b-bad4-03b2057d4159 swap                    swap    defaults        0 0
  47. tmpfs                   /dev/shm                tmpfs    defaults,size=1300m        0 0
  48. devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
  49. sysfs                   /sys                    sysfs   defaults        0 0
  50. proc                    /proc                   proc    defaults        0 0
  51. ~
  53. [root@rh6 ~]# mount tmpfs
  54. [root@rh6 ~]# df -h
  55. Filesystem            Size  Used Avail Use% Mounted on
  56. /dev/sda2              18G  5.2G   12G  32% /
  57. /dev/sda1             2.0G   62M  1.8G   4% /boot
  58. /dev/sda3              12G  5.7G  5.4G  52% /u01
  59. /dev/sda5             9.9G  4.9G  4.6G  52% /usr
  60. /dev/sda7             4.2G  300M  3.7G   8% /var
  61. tmpfs                 1.3G     0  1.3G   0% /dev/shm
  62. </strong>
  64. <strong>验证：</strong>
  66. <strong>[root@rh6 ~]# umount /dev/shm
  67. [root@rh6 ~]# df -h
  68. Filesystem            Size  Used Avail Use% Mounted on
  69. /dev/sda2              18G  5.2G   12G  32% /
  70. /dev/sda1             2.0G   62M  1.8G   4% /boot
  71. /dev/sda3              12G  5.7G  5.4G  52% /u01
  72. /dev/sda5             9.9G  4.9G  4.6G  52% /usr
  73. /dev/sda7             4.2G  300M  3.7G   8% /var
  74. [root@rh6 ~]# mount tmpfs
  75. [root@rh6 ~]# df -h
  76. Filesystem            Size  Used Avail Use% Mounted on
  77. /dev/sda2              18G  5.2G   12G  32% /
  78. /dev/sda1             2.0G   62M  1.8G   4% /boot
  79. /dev/sda3              12G  5.7G  5.4G  52% /u01
  80. /dev/sda5             9.9G  4.9G  4.6G  52% /usr
  81. /dev/sda7             4.2G  300M  3.7G   8% /var
  82. tmpfs                 1.3G     0  1.3G   0% /dev/shm
  83. [root@rh6 ~]# cat /etc/fstab
  85. #
  86. # /etc/fstab
  87. # Created by anaconda on Sun Sep 29 16:52:59 2013
  88. #
  89. # Accessible filesystems, by reference, are maintained under '/dev/disk'
  90. # See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
  91. #
  92. UUID=85ffcaeb-1855-4f6a-b1af-d4e13d7b8850 /                       ext4    defaults        1 1
  93. UUID=0e7c052e-fc2a-402a-82cc-116e7629ef8f /boot                   ext4    defaults        1 2
  94. UUID=cf98cf21-ba1f-4a3a-aac3-43406dd5fca1 /u01                    ext4    defaults        1 2
  95. UUID=e3cf943c-48c4-4c4b-ba65-f11ba1f6a2e0 /usr                    ext4    defaults        1 2
  96. UUID=c5dd449a-ce22-4d47-a6d3-2d09c0186489 /var                    ext4    defaults        1 2
  97. UUID=e701d956-939e-441b-bad4-03b2057d4159 swap                    swap    defaults        0 0
  98. tmpfs                   /dev/shm                tmpfs    defaults,size=1300m        0 0
  99. devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
  100. sysfs                   /sys                    sysfs   defaults        0 0
  101. proc                    /proc                   proc    defaults        0 0</strong>
  103. <strong>[root@rh6 ~]# df -h
  104. Filesystem            Size  Used Avail Use% Mounted on
  105. /dev/sda2              18G  5.2G   12G  32% /
  106. /dev/sda1             2.0G   62M  1.8G   4% /boot
  107. /dev/sda3              12G  5.7G  5.4G  52% /u01
  108. /dev/sda5             9.9G  4.9G  4.6G  52% /usr
  109. /dev/sda7             4.2G  300M  3.7G   8% /var
  110. tmpfs                 1.3G     0  1.3G   0% /dev/shm
  112. </strong>

重新启动Instance：

[oracle@rh6 ~]$ sqlplus ‘/as sysdba’

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 25 11:34:39 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size 2227944 bytes
Variable Size 1224737048 bytes
Database Buffers 16777216 bytes
Redo Buffers 8921088 bytes
Database mounted.
Database opened.

发表评论

表情：
评论列表 （有 0 条评论，238人围观）

还没有评论，来说两句吧...

相关阅读