Re: 11g RedHat 5 and Hugepages? anybody successful ?
- To: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- Date: Mon, 11 Oct 2010 16:30:04 -0500
Ensure that you are starting the instance as the oracle user. Review your
memlock settings in /etc/security/limits.conf so that only oracle can lock
this mem.
There is no "if" here. You MUST set memory_max_target to 0, as well as
memory_target, if you hope to use HugePages at all. If you don't, Oracle
will not use them and then you'll be using the unreserved memory, of which
there is probably not much left, which is (again probably) why you are out
of memory here. The bulk of your memory is reserved in HugePages but Oracle
is trying to use the remainder.
Don.
On Mon, Oct 11, 2010 at 4:12 PM, Crisler, Jon <Jon.Crisler@xxxxxxx> wrote:
> Don, I am way beyond that point. If you set memory_max_target = 0 then
> start the db, it generates ORA-00849 is thrown.
>
> ORA-00849 SGA_TARGET value was more than MEMORY_MAX_TARGET value.
>
> If SGA_TARGET is unset , then I get ORA-27102: out of memory
>
> Linux-x86_64 Error: 28: No space
> left on device
>
>
>
> *From:* Don Seiler [mailto:don@xxxxxxxxx]
> *Sent:* Monday, October 11, 2010 3:50 PM
> *To:* Crisler, Jon
> *Cc:* s.cislaghi@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>
> *Subject:* Re: 11g RedHat 5 and Hugepages? anybody successful ?
>
>
>
> 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
>
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
Other related posts:
