SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 1 20:03:07 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup;
ORA-00845: MEMORY_TARGET not supported on this system
MEMORY_TARGET不知道在哪设置,根据网上资料,设置了系统参数,但依然无效
[root@r720-2 ~]# mount -o remount /dev/shm
[root@r720-2 ~]# df -h /dev/shm/
Filesystem Size Used Avail Use% Mounted on
shmfs 20G 0 20G 0% /dev/shm
想重启数据库也报错~~~
SQL> shutdown immediate; ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SQL> startup mount
ORA-00845: MEMORY_TARGET not supported on this system
内存泄露了吧,啥系统啊? ------解决方案-------------------- (1)登陆orcl数据库
SQLPLUS SYS/SYS@orcl AS SYSDBA
(2)设置内存大小
ALTER SYSTEM SET MEMROY_MAX_TARGET=500M SCOPE=SPFILE;(SCOPE=SPFILE表示写如SPFILE文件,在数据库重启后生效)
(3) 设置自动分配的内存大小
ALTER SYSTEM SET MEMORY_TARGET = 500M SCOPE=SPFILE;(表示自动调节PGA和SGA的总大小为500M)
ALTER SYSTEM SET SGA_TARGET =0 SCOPE=SPFILE;