Can 2 users own one file_system together? - SUN Solaris

trantuananh24hg · #1 (**permalink**) 07-04-2008

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.

Code:

$ 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:

Code:

$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 · #2 (**permalink**) 07-04-2008

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

Code:

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

Am I right?

Thank you!

incredible · #3 (**permalink**) 07-04-2008

Yes you're right!

trantuananh24hg · #4 (**permalink**) 07-04-2008

Quote:

Originally Posted by incredible

Yes you're right!

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 · #5 (**permalink**) 07-04-2008

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

Code:

$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.

Code:

$ 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!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Users in AIX	Lost in AIX	AIX	3	06-04-2007 10:44 AM
Users on AIX 5.2	aldowsary	AIX	4	11-06-2006 06:30 PM
do i need these users?	csaunders	SUN Solaris	3	04-11-2006 10:45 AM
users of a particular dir	narsing	UNIX for Dummies Questions & Answers	1	02-07-2006 04:34 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode