MEMORY_TARGET not supported on this system ORA-00845:

Label 11g OracleORA-00845
1827 people read comment(0) Collection report
Classification:

1, Oracle11g settings file to restart the error

Startup SQL>;
ORA-00845MEMORY_TARGETNotSupportedOn This System                                                                                                                                          
SQL>

2, to see the official explanation is that oracle:

Starting with Oracle Database 11g, the automatic memory management feature requires more shared memory (SHM) and file descriptors. the size of the shared memory should be at least the greater of memory max target and memory target for each Oracle instance on the computer. If memory max target or memory target is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.

Is memory max target setting can't exceed SHM size, memory automatic management of added in Oracle11g parameters the memory target, it can automatically adjust the SGA and PGA, this feature requires the use of SHM shared file system, and the requirements of SHM must be greater than the memory target. If SHM than memory target would be wrong.

PS: the original blog address:Http://prog3.com/sbdm/blog/mchdba/article/details/47847579, without the original CSDN blogger mchdba allowed, may not be reproduced.

3, solution

2 changes place:
In the /etc/fstab inside, one is behind the swap into defaults, size=11G, two is behind the TMPFS into defaults, size=11G, modified, as follows

Oracle]# VIM /etc/fstab [root@testoracle1


#
# /etc/fstab
Created by Anaconda on # Tue Aug 18 16:46:25 2015
#
# 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
#
/dev/mapper/vg_testoracle1-lv_root / defaults ext4One One
UUID=e10af7be-cb8b-Four thousand four hundred and fifty-four-Nine hundred and sixty-fiveD-Zero/boot ext4 defaults c2275fe75b9One Two
Swap swap defaults /dev/mapper/vg_testoracle1-lv_swap, size=ElevenGZero Zero
/dev/shm TMPFS defaults TMPFS, size=ElevenGZero Zero
/dev/pts devpts gid= devptsFiveMode=.Six hundred and twenty  Zero Zero
/sys sysfs defaults sysfsZero Zero
/proc proc defaults procZero Zero
~

After modification, the need to re mount, to take effect:

[root@testoracle1Oracle]# mount -o remount, size=11G /dev/shm
[root@testoracle1Oracle]#

3, once again start the database, it will not be reported to the wrong, the normal start:

SQL>Startup;
Instance started ORACLE.                                                                                                                                                                       

System TotalGlobalArea1.1358E+10 Bytes
Size FixedTwo million two hundred and sixteen thousand seven hundred and forty-four Bytes
VariableSizeEight billion nine hundred and twenty-five million four hundred and eighty-two thousand and two hundred Bytes
Buffers DatabaseTwo billion four hundred and fifteen million nine hundred and nineteen thousand one hundred and four Bytes
Buffers RedoThirteen million nine hundred and forty-six thousand eight hundred and eighty Bytes
Mounted Database.                                                                                                                                                                              
Opened Database.                                                                                                                                                                               
SQL>  

4,Standard mode of ban:

SQL> alter system set log_archive_start=false scope=spfile; # disable self archiving

Shutdown immediate SQL>;
SQL> startup mount; # restart the database to mount mode
SQL> alter database NOARCHIVELOG; # modified for non Archive Mode
SQL> alter database open; # a data file
SQL> archive log list; # view again before.

Alter database NOARCHIVELOG SQL>;
Database NOARCHIVELOG alter
*
线路1错误:
ora-38774:不能禁用媒体恢复启用闪回数据库

SQL >

去查看闪回是否已经开启:

SQL >选择闪回_on V $数据库;

flashback_on
------------------
可以

SQL >

去关闭闪回功能:

闪回数据库使用SQL >关闭;

数据库更改。

SQL >

闪回数据库使用SQL >关闭;

数据库更改。

再关闭归档。

SQL数据库NOARCHIVELOG >;

数据库更改。

SQL >档案日志 列表;
数据库日志模式无存档模式
自动存档禁用
归档目的地/甲骨文/应用程序/ Oracle / flash_recovery_area /归档
网上最古老的日志序列三百三十七
电流日志序列三百三十九
SQL >
猜你在找
查看评论
*以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:1017455次
    • 积分:一万六千二百四十七
    • 等级:
    • 排名:316名第
    • 原创:439篇
    • 转载:3篇
    • 译文:2篇
    • 评论:525条
    我的课程
    博客专栏
    技术网址连接
    http://dev.mysql.com/doc/
    文章分类
    文章存档
    Latest comments