Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ORA-00845: MEMORY_TARGET not supported on this system Problem     - Use the top command (Linux)

- System with Windows Remote Desktop to connect Ubuntu 15.04 (Linux)

- Talk about jsonp (Programming)

- Shell Programming points to note about the function (Programming)

- Get basic information about Linux server script (Server)

- Deploy Apache Spark cluster environment in Ubuntu (Server)

- Hadoop namenode do NFS disaster recovery (Server)

- ethtool implementation framework and application in Linux (Linux)

- Effect MongoDB plan cache (Database)

- The array of C language (Programming)

- C ++ you can become a new scripting language (Programming)

- RabbitMQ user roles and access control (Linux)

- Use PXE with kickstart to install Linux automatically (Linux)

- MySQL composite partition (Database)

- Scope of variables in C # (Programming)

- Android judgment toward camera pictures (Programming)

- MyCAT separate read and write to achieve MySQL Practice (Database)

- Installation and use GAMIT / GLOBK Software (Linux)

- RocketMQ Message Queuing simple deployment (Linux)

- 10 example of the detection memory usage free Linux commands (Linux)

 
         
  ORA-00845: MEMORY_TARGET not supported on this system Problem
     
  Add Date : 2018-11-21      
         
         
         
  1, Oracle 11g archive log in again to start setting error

SQL> startup;
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
2, see Oracle's official explanation is:

Starting with Oracle Database 11g, the Automatic Memory Management feature requires more shared memory (/ dev / 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.

That MEMORY_MAX_TARGET setting can not exceed the / dev / shm size parameter MEMORY_TARGET in oracle11g add automatic memory management, which can automatically adjust the SGA and PGA, this feature need to use / dev / shm shared file system, and requires / dev / shm must be greater than MEMORY_TARGET, if / dev / shm MEMORY_TARGET smaller than an error.

3. Solution

2 Modify place:
In the / etc / fstab inside, one modification back into a swap defaults, size = 11G, the second is to modify the back tmpfs defaults, size = 11G, modifying as follows

[Root @ testoracle1 oracle] # vim / etc / fstab


#
# / 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 / ext4 defaults 1 1
UUID = e10af7be-cb8b-4454-965d-0c2275fe75b9 / boot ext4 defaults 1 2
/ Dev / mapper / vg_testoracle1-lv_swap swap swap defaults, size = 11G 0 0
tmpfs / dev / shm tmpfs defaults, size = 11G 0 0
devpts / dev / pts devpts gid = 5, mode = 620 0 0
sysfs / sys sysfs defaults 0 0
proc / proc proc defaults 0 0
~
After modification, you need to remount it, to take effect:

[Root @ testoracle1 oracle] # mount -o remount, size = 11G / dev / shm
[Root @ testoracle1 oracle] #
3 to restart the database, it is not being given the normal startup:

SQL> startup;
ORACLE instance started.

Total System Global Area 1.1358E + 10 bytes
Fixed Size 2216744 bytes
Variable Size 8925482200 bytes
Database Buffers 2415919104 bytes
Redo Buffers 13946880 bytes
Database mounted.
Database opened.
SQL>
4, the standard prohibits archive mode:

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

SQL> shutdown immediate;
SQL> startup mount; # to restart the database to mount mode
SQL> alter database noarchivelog; # amend non-archive mode
SQL> alter database open; # playing data file
SQL> archive log list; # View mode again before archiving

SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-38774: can not disable media recovery - flashback database is enabled

SQL>

Check whether to open flashback:

SQL> select flashback_on from v $ database;

FLASHBACK_ON
------------------
YES

SQL>
Close to flashback features:

SQL> alter database flashback off;

Database altered.

SQL>

SQL> alter database flashback off;

Database altered.
Then close the archive.

SQL> alter database noarchivelog;

Database altered.

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination / oracle / app / oracle / flash_recovery_area / archivelog
Oldest online log sequence 337
Current log sequence 339
SQL>
     
         
         
         
  More:      
 
- Use dump restore mode fast backup and recovery system FreeBSD (Linux)
- In-depth summary of the PHP core of object-oriented (Programming)
- Macro Analysis Performance: PHP Performance Analysis and Experiment (Programming)
- Python KNN algorithm of actual realization (Programming)
- VMware Workstation virtual machine Ubuntu achieve shared with the host (Linux)
- How to install the client sqlplus under linux (Database)
- Linux System Getting Started Learning: DeVeDe installed on Linux to create a video DVD (Linux)
- How to use Linux to download music from Grooveshark (Linux)
- Linux dmidecode command detail (Linux)
- Fedora network set up simple (Linux)
- True and false in Perl (Programming)
- The basic principles of AIX system security (Linux)
- CentOS terminal display Chinese (Linux)
- Redis master-slave replication switch (Database)
- To convert into a binary search tree sorted doubly linked list (Programming)
- Installation Enpass secure password manager on Ubuntu (Linux)
- Interesting example of Linux Sort command (Linux)
- PULL operation mechanism parsing XML Comments (Programming)
- Calling Qt libraries to implement functional processes of some summary (Programming)
- MySQL separation Amoeba achieve literacy (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.