首页 > 代码库 > ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system

[oracle@huntdb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 17 18:39:11 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

SQL> startup mount
ORA-00845: MEMORY_TARGET not supported on this system

SQL> quit
Disconnected

[oracle@huntdb ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       18G   14G  3.4G  80% /
/dev/sda1              99M   24M   70M  26% /boot
tmpfs                 499M     0  499M   0% /dev/shm

[root@huntdb ~]# umount /dev/shm/

[root@huntdb ~]# df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      18187836  13780828   3468208  80% /
/dev/sda1               101086     24528     71339  26% /boot

修改文件 /etc/fstab

[root@huntdb ~]# cat /etc/fstab| grep shm
 tmpfs            /dev/shm        tmpfs  defaults,size=2G        0 0
 
[root@huntdb ~]# mount /dev/shm

[root@huntdb ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       18G   14G  3.4G  80% /
/dev/sda1              99M   24M   70M  26% /boot
tmpfs                 2.0G     0  2.0G   0% /dev/shm

[root@huntdb ~]# su - oracle
[oracle@huntdb ~]$ 
[oracle@huntdb ~]$ 
[oracle@huntdb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 17 18:44:08 2014
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area  839282688 bytes
Fixed Size                  2233000 bytes
Variable Size             570428760 bytes
Database Buffers          264241152 bytes
Redo Buffers                2379776 bytes
Database mounted.
Database opened.

SQL> show parameter MEMORY_TARGET
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_target                        big integer 804M
SQL>


本文出自 “HUNT” 博客,请务必保留此出处http://hunt1574.blog.51cto.com/1390776/1578950

ORA-00845: MEMORY_TARGET not supported on this system