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
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 4238 Jul 31 2000 oracle
This means that when
Hthis 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
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