Solved

Consultation for changing the parameter MEMORY_TARGET

Posted on 2015-01-12
6
187 Views
Last Modified: 2015-01-12
Hi experts,
In a RAC ASM 11g, Linux  (RedHat  2.6.18), with 2 instance, I need to modify:
memory_max_target parameters (static parameter) 
memory_target (dynamic).

Open in new window

Both in 8G ( currently have 6G)
I received a recommendation that tells me tweak in /etc/fstab:
 /dev/shm ----> defaults, size = 8G,

Open in new window

and then:
mount -o remount / dev / shm

Open in new window

In addition to the statements:
ALTER SYSTEM SET MEMORY_MAX_TARGET = 7680M SCOPE = SPFILE; 
ALTER SYSTEM SET MEMORY_TARGET = 7680M SCOPE = SPFILE; 

Open in new window

then, in both nodes:
shutdown immediate
startup

Open in new window

Currently the line in fstab says:
tmpfs /dev/shm tmpfs defaults, nosuid, nodev 0 0

Open in new window

Is it necessary to make this change in the fstab?
Would appreciate a look from you and the basic steps to perform the task.
Thank you very much
Regards
0
Comment
Question by:carlino70
  • 3
  • 3
6 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 40545068
yes, you need to make your tmpfs large enough to hold your MEMORY_MAX_TARGET.

You are trying to hold 7.6G of oracle memory inside 6G of allocation.

my guess is you are seeing ORA-00845 errors because of this.

So, make /dev/shm larger or your memory_max_target lower
0
 

Author Comment

by:carlino70
ID: 40545136
I'm not seeing errors like ORA-00845 in AlertLog
But if the base, shows slow queries and runs Oracle jobs.
Thanks
0
 

Author Comment

by:carlino70
ID: 40545142
sorry, I wrote bad:
But the database, shows slow queries and runs Oracle jobs.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40545149
The instance shouldn't start if you have memory_target (or max_memory_target) of 7.6G with only 6G of shared memory.

Maybe I misunderstood what you posted above, are all of those code boxes suggestions or are some of them what you currently have?

I thought the 8G change was the suggestion and the rest was what you actually had, in which case I would expect an error.


If all of it is a suggestion, then yes, go with that.  It should work.
0
 

Author Closing Comment

by:carlino70
ID: 40545166
Excellent!, Thanks
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40545168
Glad I could help.

Making sure your shared memory at the OS level is big enough for the instance's memory is just an extension of the same thing you would have had to do when the database was created.

Configuring /dev/shm to be big enough is one of the preinstallation requirements

http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1096

Here you're already installed, but if you're making your instance bigger, then same idea as the preinstall.  You must also make the /dev/shm big enough to hold it.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question