Thursday, June 19, 2008

Something about Oracle user and Solaris project

here's the findings:

IF you primary Oracle group is not dba (say your primary group is oinstall), and you try to make project group.dba as your primary project, huhh nothing will change when you type "id -p". You still get back the project called default as your primary project. (In fact, i shouldn't use the term "primary project", as this is not accurate).

So create a project something like "user.oracle" and make it your oracle primary project, it will works.

See below:

[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=3(default)
[root@pw450 /]$
[root@pw450 /]$ projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" \
> -K "project.max-sem-nsems=(priv,256,deny)" \
> -K "project.max-sem-ids=(priv,100,deny)" \
> -K "project.max-shm-ids=(priv,100,deny)" group.dba
[root@pw450 /]$
[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=3(default)



...............oppps..........it doesn't work, you are however being added to the member list of the project group.dba.


so we will create user.oracle instead.

see below:

[root@pw450 /]$ projdel group.dba
[root@pw450 /]$
[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=3(default)
[oracle@pw450 ~]$ exit
logout
[root@pw450 /]$
[root@pw450 /]$ projadd -U oracle -K "project.max-shm-memory=(priv,4g,deny)" \
> -K "project.max-sem-nsems=(priv,256,deny)" \
> -K "project.max-sem-ids=(priv,100,deny)" \
> -K "project.max-shm-ids=(priv,100,deny)" user.oracle
[root@pw450 /]$
[root@pw450 /]$ su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
[oracle@pw450 ~]$ id -p
uid=200(oracle) gid=200(oinstall) projid=100(user.oracle)
[oracle@pw450 ~]$ cat
^C
[oracle@pw450 ~]$ cat /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::project.max-sem-ids=(priv,100,deny);project.max-sem-nsems=(priv,256,deny);project.max-shm-ids=(priv,100,deny);project.max-shm-memory=(priv,4294967296,deny)
[oracle@pw450 ~]$

....
something that's not mentioned in the Oracle RAC installation guide...

...

No comments: