RE: Setting database owner to sid

If you are doing this just so you can use ipcs and be able to tell the owner of shared memory and semaphore etc. You should check into sysresv. It can tell you which sid owns what shared memory segments and semaphores.

Richard

-----Original Message-----
Sent: Saturday, June 07, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L

Hmmmm....this may be more trouble than I originally thought. Dennis, you are right in how I installed Oracle. I suspected something like this. Hmmm...(oh, I said that already). Let me ponder on this a while.

Thanks to all who responded!

-D-

On Sat, 07 Jun 2003 14:14:20 -0800
DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:

> Dwayne - My guess is that you installed Oracle under the "oracle" account.
> This means the binaries are owned by Oracle. If you do an ls -l
> $ORACLE_HOME/bin/oracle, you will probably see the permissions something
> like:
> -rwsr-s--x 1 oracle dba 42344448 Jul 31 2000 oracle
> This means that when the Oracle binary is run it does a "setuid" so that it
> runs as Oracle no matter what who the user is. The alternative is to not do
> this, which would mean that the Oracle binary would run as the individual
> user that started it, but there would probably be permission problems
> between the Oracle server process and the user shadow processes.
> You may find it simpler to install Oracle under each of these accounts.
> This takes up more space, but will allow you to upgrade each database
> independently. Or you may find what you are trying to accomplish is more
> trouble than it is worth.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> Sent: Saturday, June 07, 2003 4:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all,
>
> Here is what I am trying to do:
>
> I want to set up three different databases: test1, test2 and test3.
> Each database is created by a user named after the sid (i.e. test1,
> test2, etc). I want each database to be owned by the user so that when
> I run ipcs to look at memory processes, each database is identified by a
> different owner.
>
> Would someone point me in the right direction to accomplish this?
> Currently, every database is owned by the oracle account and I am having
> a tough time figuring this out. I was hoping to rebuld these databases
> this weekend to reflect the above. I am running Oracle8i on RedHat 8.0
> (will be upgrading to RHAS and Oracle9i in a few months).
>
> Thanks in advance for your help.
> Dwayne
>
>
> --
> Dwayne Cox
> Corporate Database Administrator
> Info Tech, Inc.
> 5700 SW 34th Street, Suite 1235
> Gainesville, FL 32608
>
> email: [EMAIL PROTECTED]
> phone: 352.381.4521 fax: 352.381.4444

>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).