Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Increasing memory granted to user

Re: Increasing memory granted to user

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Nov 2007 18:50:31 -0800
Message-ID: <1194317426.960912@bubbleator.drizzle.com>


groups.user_at_gmail.com wrote:
> Hi.. I'm trying to increase the memory allocated / granted to an
> oracle user (for an Oracle DB), since I'm getting a CRS-0215 and a
> PRKP-1001 when starting up a DB using
>
> srvctl start database -d XYZ
>
> I can startup the DB fine using sqlplus on both nodes of this 10gR2
> RAC cluster on Solaris10
>
> I have 24 GB of memory on this box, and on my box running Solaris 10,
> my /etc/project file looks like the following
>
> # more /etc/project
> system:0::::
> user.root:1::::
> noproject:2::::
> default:3::::project.max-sem-ids=(priv,200,deny);project.max-sem-
> nsems=(priv,512
> ,deny);project.max-shm-ids=(priv,200,deny);project.max-shm-
> memory=(privileged,25
> 769803776,deny)
> group.staff:10::::
>
> In the above example, how much memory is granted to a non-root user,
> (like an oracle user) ?
>
> My sga parameters are as follows :
>
> SQL> show parameter sga
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> lock_sga boolean FALSE
> pre_page_sga boolean FALSE
> sga_max_size big integer 9808M
> sga_target big integer 9808M
>
> I'm using the ksh for oracle, and my ulimit parameters are as
> follows :
>
> $ ulimit -a
> time(seconds) unlimited
> file(blocks) unlimited
> data(kbytes) unlimited
> stack(kbytes) 8192
> coredump(blocks) unlimited
> nofiles(descriptors) 16384
> vmemory(kbytes) unlimited
>
>
> Thanks

Solaris 10 eh. Any chance you are using Containers or some other virtual kludge? As you SA.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 05 2007 - 20:50:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US