[oracle@up ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 10 19:26:05 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
错误原因:tmpfs空间不能小于MEMORY_TARGET的值,tmpfs空间太小数据库无法启动
[root@up ~]# vi /u01/app/oracle/product/11.2.0/dbs/init.ora
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
数据库参数文件里memory_target参数的大小为1G
[root@up ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 26G 17G 7.4G 70% /
tmpfs 242M 0 242M 0% /dev/shm
/dev/sda1 190M 28M 153M 16% /boot
tmpfs空间大小242M,所以无法启动数据库
解决方法,在/etc/fstab里修改tmpfs的挂载选项,增大tmpfs的空间
[root@up ~]# vi /etc/fstab
UUID=a6948461-a0e3-4e64-bf75-e9a45864d48a / ext4 defaults 1 1
UUID=0d5a41b3-3988-467f-be75-93e0e4fad1e9 /boot ext4 defaults 1 2
UUID=bba460fd-bdbe-4a7e-ba49-4016f4633067 swap swap defaults 0 0
tmpfs /dev/shm tmpfs defaults,size=2G 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
修改tmpfs挂载,将tmpfs空间大小设置为2G
重启系统
[root@up ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 26G 17G 7.4G 70% /
tmpfs 2.0G 0 2.0G 0% /dev/shm
/dev/sda1 190M 28M 153M 16% /boot
更改后tmpfs为2G
[root@up ~]# su - oracle
[oracle@up ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 10 19:40:28 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 409194496 bytes
Fixed Size 2213856 bytes
Variable Size 301991968 bytes
Database Buffers 96468992 bytes
Redo Buffers 8519680 bytes
Database mounted.
Database opened.
问题解决,数据库启动完毕
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。