Increasing memory granted to user

From: <groups.user_at_gmail.com>
Date: 5 Nov 2007 11:57:48 -0800
Message-ID: <1194274618.252912.287440@t8g2000prg.googlegroups.com>

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 Received on Mon Nov 05 2007 - 13:57:48 CST