Setup Menus in Admin Panel

DBATalent

What Oracle DBA needs to know about Solairs – Projects

Considering the number of new implementations on Sparc  and migration to Sparc increasing, it is important to know the basics of Projects.

The kernel parameter related to Shared Memory, Semaphore were configured in /etc/system prior to Solaris 10. Starting from Solaris 10, Projects should be used to do the same.

We will be seeing an example of how to change the Shared Max Memory of a user using profiles and in the similar way, you can change other kernel parameters as well:

  • To know the current Projects details, we can use:

1. projects -l

2. cat /etc/projects

  • To find current project being used by a User, use “id -p”

#id -p

uid=59008(oracle) gid=10001(dba) projid=3(default)

  • To find the current Max Shared Memory for the specific Profile,

#prctl -n project.max-shm-memory -i project 3

project: 3: default

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT

project.max-shm-memory

privileged      7.84GB      –   deny                                 –

system          16.0EB    max   deny

  • To increase the shared memory for the specific Project (In this case Project 3)

% prctl -n project.max-shm-memory -r -v 10G -i project 3

  • Check if the Setting took effect

% prctl -n project.max-shm-memory -i project 3

project: 3: default

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT

project.max-shm-memory

privileged      10.0GB      –   deny                                 –

system          16.0EB    max   deny                             –

In the below example, we will see how to change the default profile of a user:

  • create project for oracle user

# projadd user.oracle

  • current max shared memory

# prctl -n project.max-shm-memory

  • How to change it

# projmod -sK “project.max-shm-memory=(privileged,3221225472,deny)” user.mysql

  • view current project attribs

# projects -l user.mysql

or

grep user.mysql /etc/project

  • Change default project of Oracle

projmod -U oracle user.oracle

February 17, 2015

3 Responses on What Oracle DBA needs to know about Solairs - Projects"

  1. Hi,
    Nice article, the article content is very helpful for beginner who wants to make a career in Hadoop. I think this article mostly helping to who want to start their learning with Oracle 11g DBA online training.

  2. Hi,
    Nice article, the article content is very helpful for beginner who wants to make a career in Hadoop. I think this article mostly helping to who want to start their learning with Oracle DBA online training.

Leave a Message