It doesn't make sense, and just forget to find a 'workaround', as that would
imply setting all of the Oracle architecture upside down. You are asking way
too much. Anyway this is Oracle, and not some cheap toy.
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"Useko Netsumi" <usenets_at_nyc.rr.com> wrote in message
news:b2e56t$1ac87u$1_at_ID-159205.news.dfncis.de...
> Thank you Howards, it seems that I have to use the1st option(have 2
> instances running)
>
> Just to explain my reason, that I have a very limited resources(diskspace,
> memory, and an AMD box) . Diskspace I can add an external SCSI but I have
> limited memory.
>
> It would be nice if I can find a workaround to create both 9i and 8i
> database in the same box using one(1) instance only - so it does not take
up
> more memory. I guess what I'm asking is that can oracle share SGA with
> different version of Oracle? Does it make any sense?
>
> Thanks again in advance.
>
> PS: Please forgive my lack of knowledge...
>
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:pan.2003.02.12.17.07.30.744587_at_yahoo.com.au...
> > On Wed, 12 Feb 2003 11:37:23 +0000, Useko Netsumi wrote:
> >
> > > First, would it be possible to run 2 Oracle instances with different
> > > version of Oracle(8i and 9i)?
> >
> > On the same box? Yes. Presuming you mean 'can you have an 8i and a 9i
> > *database* open on the same box at the same time?'
> >
> > > If it possible, how do we go with the
> > > 'oracle:dba' account home directory?.
> >
> > You will have different ORACLE_HOMEs, but one Oracle user and one dba
> > group. Membership of the dba group will grant you privileged user access
> > to both databases. If you want different people to be privileged on
> > different databases, according to version, you'll need to implement
> > password file authentication.
> >
> > >Do we have to have 2 oracle account
> > > with group dba? Or, can we get away with one oracle account with the
> same
> > > home directory?
> > >
> > > Second, I just have to ask, can we run 1 oracle instances with 2
version
> > > of Oracle(9i & 8i) so I can create 9i DB as well 8i DB? Thanks
> >
> > That question doesn't make sense. One database means one instance. Two
> > databases mean two instances. Regardless of version. But if you mean
'can
> > I create an 8i and a 9i database on the same box', the answer is yes...
> > but that's the question you started out with anyway!
> >
> > Perhaps I'm missing your point.
> >
> > Regards
> > HJR
> >
> >
> >
> >
>
>
Received on Wed Feb 12 2003 - 13:22:09 CST
