Sorry for my limited knowledge about Oracle but don't believe I ever implied
that its a cheap toy though.
Regards
useko
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:v4l7usgbohlgf5_at_corp.supernews.com...
> 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:34:05 CST
