Can 2 users own one file_system together?

trantuananh24hg · July 4, 2008, 4:17am

Hi all!

I have one disk /dev/dsk/c1t2d0s0, and it's mounted on /Billingoracle, and I had one user - oracle, belonged to dba group whom owned this directory.

$ df -k /oracle
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/dsk/c1t1d0s0    103275934 2902406 99340769     3%    /Billingoracle

$ ls -l
total 1792958
-rw-r--r--   1 oracle   oinstall 917512192 May 24 17:10 10gr2_db_sol.cpio
drwxr-xr-x  10 oracle   oinstall     512 May 28 09:02 Log4plsql
drwxr-xr-x   2 oracle   oinstall     512 May 24 17:47 TEMP
drwxr-xr-x   2 root     other        512 May 24 17:55 TT_DB
-rw-r--r--   1 oracle   oinstall    1075 May 24 17:59 initBilling.ora
-rw-r--r--   1 oracle   oinstall    4055 May 28 09:30 install.log
drwxrwx---   3 oracle   oinstall     512 May 24 17:46 oracle
-rw-r--r--   1 oracle   oinstall     195 Jun 13 10:49 spcpkg.lis
-rw-r--r--   1 oracle   oinstall    4156 Jun 13 10:49 spctab.lis
-rw-r--r--   1 oracle   oinstall    2133 Jun 13 10:48 spcusr.lis
-rw-r--r--   1 oracle   oinstall    2790 May 24 18:47 sqlnet.log
drwxr-xr-x   4 oracle   oinstall     512 Jun 26 17:14 tmp
$ cd ..
$ cd ..
$ pwd
/
$ ls -l
total 17396
drwxr-xr-x   2 root     root         512 Nov 24  2007 Desktop
drwxr-xr-x   2 root     root         512 Nov 24  2007 Documents
drwx------   2 root     root         512 Nov 24  2007 Mail
drwxrwxr-x  12 oracle   dba         1024 Jun 26 17:14 Billingoracle
drwxrwxrwx   4 oracle   dba         1024 May 24 17:28 BillingoradataTBSUSERS
drwxr-xr-x   4 oracle   dba          512 May 24 17:28 BillingoradataUSERS
drwxr-xr-x   2 root     other        512 Nov 24  2007 TT_DB
lrwxrwxrwx   1 root     root           9 Nov 24  2007 bin -> ./usr/bin
drwxr-xr-x   3 root     nobody       512 May 26 09:12 cdrom
-rw-------   1 root     root     8356350 May 27 10:46 core
drwxr-xr-x  20 root     sys         4096 May 26 09:12 dev
drwxr-xr-x   2 root     sys          512 May 26 09:12 devices
drwxr-xr-x  82 root     sys         4608 Jun 19 17:39 etc
drwxr-xr-x   3 root     sys          512 Nov 24  2007 export
dr-xr-xr-x   1 root     root           1 May 26 09:12 home
drwxr-xr-x  14 root     sys          512 Nov 24  2007 kernel
drwxr-xr-x   7 root     bin         5632 Nov 24  2007 lib
drwx------   2 root     root        8192 Nov 24  2007 lost+found
drwxr-xr-x   2 root     sys          512 Nov 24  2007 mnt
dr-xr-xr-x   1 root     root           1 Jul  4 14:29 net
drwxr-xr-x   8 root     sys          512 Nov 24  2007 opt
drwxr-xr-x  40 root     sys         1536 Nov 24  2007 platform
dr-xr-xr-x 125 root     root      480032 Jul  4 15:15 proc
drwxr-xr-x   2 root     sys         1024 Nov 24  2007 sbin
drwxr-xr-x   4 root     root         512 Nov 24  2007 system
drwxrwxrwt   8 root     sys         1854 Jul  4 14:18 tmp
drwxr-xr-x   3 root     root         512 May 24 17:12 u01
drwxr-xr-x  41 root     sys         1024 Nov 24  2007 usr
drwxr-xr-x  44 root     sys         1024 Nov 24  2007 var
dr-xr-xr-x   6 root     root         512 May 26 09:12 vol
$

And I have one question:

Can I create one new user, new group, and the user can own /Billingoracle?

Example:

$su - root
password:
#groupadd -g 116 loyalty   <<-- Create parent group
#groupadd -g 115 loyaltyvnp <<-- Create child group
#mkdir -p /Billingoracle/loyalty <<- Make one directory to be used by users loyalty
useradd -u 175 -c "Loyalty Software Owner" -d /Billingoracle/loyalty -g loyalty -G loyaltyvnp -m -s /bin/ksh loyalty <<-- Create user loyalty

trantuananh24hg · July 4, 2008, 6:20am

Hi!

I've just understood that 2 users belong to other groups do not own the same file system. Only 2 users (or many users) belong to only group can do it.

So that, I add

#useradd -G dba  -d /Billingoracle/loyalty -m loyalty

Am I right?

Thank you!

incredible · July 4, 2008, 7:32am

Yes you're right!

trantuananh24hg · July 4, 2008, 10:24pm

Thank you!

Would I like to ask more than?
If I do not grant the ID to the loyalty user, then, what's the ID? It'll be random generated?

And the loyalty user will connect to the host normally?

trantuananh24hg · July 4, 2008, 11:58pm

Oah! I knew the decrease one by one if I add the more user to one group.

$id -a 
uid=176(loyalty) gid=116(oinstall) groups=116(oinstall),115(dba)

But unfortunately, I am a newbie on Solaris when I can not execute any oracle application after this loyalty user was added.

$ ORACLE_HOME=/Billingoracle/oracle/product/10.2.0/NEF
$ export ORACLE_HOME
$ sqlplus /nolog
sqlplus: not found
$ /Billingoracle/oracle/product/10.2.0/NEF/bin/sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:52:43 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SQL> exit
$ bash
bash-3.00$ /Billingoracle/oracle/product/10.2.0/NEF/bin/lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 05-JUL-2008 10:53:18

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
bash-3.00$ /Billingoracle/oracle/product/10.2.0/NEF/bin/sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:54:09 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/a0289@NEF as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> exit
bash-3.00$ ORACLE_SID=BILLING
bash-3.00$ export ORACLE_SID=BILLING
bash-3.00$ /Billingoracle/oracle/product/10.2.0/NEF/bin/sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:55:35 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/a0289@NEF as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


SQL> exit

bash-3.00$ su - oracle
Password:
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 5 10:56:05 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string     NEF
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ exit
bash-3.00$

I did not call sqlplus application from the Oracle_Home, although the Oracle_Home and Oracle_SID was exported right now.

Would you tell me why?

Thank you very much!