Oraclestudy之--“ORA-00845:MEMORY_TARGETnotsupportedonthissystem"错误(二)

2015-07-24 10:06:05 · 作者: · 浏览: 28
2 UUID=c5dd449a-ce22-4d47-a6d3-2d09c0186489 /var ext4 defaults 1 2 UUID=e701d956-939e-441b-bad4-03b2057d4159 swap swap defaults 0 0 tmpfs /dev/shm tmpfs defaults,size=1300m 0 0 devpts /dev/pts devpts gid=5,mode=620 0 0 sysfs /sys sysfs defaults 0 0 proc /proc proc defaults 0 0 ~ [root@rh6 ~]# mount tmpfs [root@rh6 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 18G 5.2G 12G 32% / /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 1.3G 0 1.3G 0% /dev/shm
验证:
[root@rh6 ~]# umount /dev/shm
[root@rh6 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              18G  5.2G   12G  32% /
/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
[root@rh6 ~]# mount tmpfs
[root@rh6 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              18G  5.2G   12G  32% /
/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                 1.3G     0  1.3G   0% /dev/shm
[root@rh6 ~]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Sun Sep 29 16:52:59 2013
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
UUID=85ffcaeb-1855-4f6a-b1af-d4e13d7b8850 /                       ext4    defaults        1 1
UUID=0e7c052e-fc2a-402a-82cc-116e7629ef8f /boot                   ext4    defaults        1 2
UUID=cf98cf21-ba1f-4a3a-aac3-43406dd5fca1 /u01                    ext4    defaults        1 2
UUID=e3cf943c-48c4-4c4b-ba65-f11ba1f6a2e0 /usr                    ext4    defaults        1 2
UUID=c5dd449a-ce22-4d47-a6d3-2d09c0186489 /var                    ext4    defaults        1 2
UUID=e701d956-939e-441b-bad4-03b2057d4159 swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs    defaults,size=1300m        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
[root@rh6 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              18G  5.2G   12G  32% /
/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                 1.3G     0  1.3G   0% /dev/shm

重新启动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.