You'll likely need to set memory_target and memory_max_target = 0 with scope=spfile, then set sga_target (or the individual pools) accordingly with scope=spfile and then bounce. Note 749851.1 makes it plain that Hugepages and Oracle 11g AMM do not mix. Don. On Mon, Oct 11, 2010 at 2:11 PM, Crisler, Jon <Jon.Crisler@xxxxxxx> wrote: > 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 > -- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us