RE: 11g RedHat 5 and Hugepages? anybody successful ?

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: "Don Seiler" <don@xxxxxxxxx>, <s.cislaghi@xxxxxxxxx>
  • Date: Mon, 11 Oct 2010 15:11:08 -0400

The problem is if you unset or set to zero memory_max_target, you get
ORA-00849

 

From: Don Seiler [mailto:don@xxxxxxxxx] 
Sent: Monday, October 11, 2010 2:46 PM
To: s.cislaghi@xxxxxxxxx
Cc: Crisler, Jon; oracle-l@xxxxxxxxxxxxx
Subject: Re: 11g RedHat 5 and Hugepages? anybody successful ?

 

You can NOT use memory_target or memory_max_target with HugePages.
That's a non-starter.

 

Don.

On Mon, Oct 11, 2010 at 1:17 PM, Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
wrote:


Hi,

two possibile solution:

 

1. Open SQLPlus and even with instance in idle execute:

create pfile='/tmp/pfilename' from spfile='+ASM/path/to/spfile';

 

Modify the pfile and then following the same procedure create a new
spfile from memory

 

2. Create a standard pfile, startup nomount your instance and do the
step 1

3. With asmcmd you may copy the spfile from ASM to disk, using strings
command convert it in plain text and then use if as a pfile

 

BTW, I always avoid to have the spfile in ASM for this and many other
similar reasons.


Ste
-- 
http://www.stefanocislaghi.eu




-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us

Other related posts: