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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Solaris 10 Project(4)

Re: Solaris 10 Project(4)

From: Paul van den Bogaard <paul_at_vdbogaard.com>
Date: 2006-01-10 19:51:37
Message-id: 43C40239.8050803@vdbogaard.com


Hi Charlotte,

you basically need these project definitions to define how much IPC resources can be used. The default setting calculated by the OS are not always what you want :-( Everything is allright except the allowed shared memory.
You need to define a project and kind of attach a max shared memory to it. I assume you already have a user 'oracle' and a group 'dba'. If not add these to you system.

Create a default project like:

projadd -c "Oracle default project" group.dba

This assigns a default project (called group.dba) to the UNIX group dba (the one that user oracle is a member of).

Now modify this project so adequate shared memory can be used:

projmod -sK "project.max-shm-memory=(privileged,2G,deny)" group.dba

Thats it. You can now use SGA up to 2G in size.

Good luck and have fun with that best OS in the world :-)

Cheers
Paul

Look in /etc/passwd, /etc/shadow, /etc/group and /etc/project to see how this info is stored in these files.

Charlotte Hammond wrote:
> Dear All,
>
> I've just been given a Solaris 10 system to play with
> for the first time and am attempting to install Oracle
> 10gR2. Could anyone offer me a quick short cut to
> understanding Solaris 10 projects for setting kernel
> parameters? I (very) vaguely understand these as
> groupings of attributes or resource settings which may
> be applied to groups of users. Is this correct?
>
> In the Quick Installation Guide (p29) you are expected
> to check/set these (prctl) for the user.root project.
> However, the user "oracle" is not a member of
> "user.root" project (it is in "default"). Does this
> matter? Is this because oradism runs as suid root?
> Or am I barking up the wrong tree completely?
>
> I don't really want to get down to all the
> nitty-gritty about Solaris projects but I'd be happier
> having at least some inkling of what I am doing!
>
> Many thanks!
> Charlotte
>
>
>
> __________________________________________
> Yahoo! DSL – Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 10 2006 - 19:51:37 CST

Original text of this message

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