Re: Oracle Instance ?
Date: 1995/06/28
Message-ID: <3ssej8$hv_at_booz.bah.com>#1/1
xin_at_femto (Weimin(Wayne) Xin) wrote:
>I'm posting this for a friend so any replies PLEASE direct toward him. Thanks!
..
> I am wondering anyone in this group familiar with the "instance" concept
> in Oracle ? My friend is trying to set up two seperate databases on the
> same hardware platform, and grant another person dba's priviledge for one
> db. But someone told him that he needs to worry about how many instances
> of oracle that are allowed.
< thanks,
An Oracle 'instance' is the total of the Oracle running background processes,
The shared memory segment called the SGA and the Physical datafiles log files
and control files.
How many instances you can run on a given hardware platform depends on the
total resources available (ie - RAM memory DISK storage available.
It is possible to put two 'Databases', substitue the word 'Application' here
and it makes it easier to understand, under one oracle 'Instance'.
The drawback here is that you give a person DBA access to the 'instance' and
not the 'database'. If you want that amount of seperation then build two
oracle 'instances' and give the person the user 'system' password.
There are other issues that also come into play but I am out of time
for today.
If you want a more in depth discussion sent me an e-mail and we can discuss
other security type issues.
Good luck.
-- Paul Teague Systems Engineer/Unix Admin/Oracle DBA E-mail: teague_paul_at_.bah.com #include <Standard disclaimer> "All opinions voiced are my own, etc..."Received on Wed Jun 28 1995 - 00:00:00 CEST