Re: Database > 1 per Instance

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 10 May 1999 12:03:57 -0700
Message-ID: <37372D9D.FB9F5F69@us.oracle.com>

Sherwin

I've heard of Metaface but that's about all - don't know any details of what they do.

They certainly need to change that image. There is no way for a single instance to refer to two databases. It may be they're attempting to show a distributed database, but even there you have two instances and two databases.

HTH. Pete

sherwin wrote:

> Mr. Pete,
> Thanks for your reply. Sir, I was also under the same impression as that
> of what you have said. But I had this Metaface consultant who came up to me
> the other day with a part of his manual that had an image on it depicting a
> single oracle instance referring to at least 2 databases.
>
> This rang a bell in my head, prompting me to think of creating a new database
> (like the creat<instance>.sql scripts do). Then start an instance and mount my
> second database. I may be talking rubbish, but from what I read in the
> Metaface (hope you've heard of this software) manual concerning oracle , it
> looked as if it was possible.
>
> Please enlighten me more Sir.
>
> sherwin
>
> Pete Sharman wrote:
>
> > Sherwin
> >
> > No, you can't. You can have it the other way (multiple instances, one
> > database) using Parallel Server. Generally, though, people who ask this
> > question need separate schemas in a single database, or multiple databases
> > and thus multiple instances. What exactly is it that you are trying to
> > achieve?
> >
> > Pete
> >
> > sherwin wrote:
> >
> > > Hi There,
> > > Can I have more than one Database per instance in Oracle 8. If yes,
> > > then will the normal ,,startup'' command start and mount each of these
> > > databases. where and how do I specify that my instance has more than one
> > >
> > > database. Thanks for your time.
> > >
> > > sherwin.
> >
> > --
> >
> > Regards
> >
> > Pete
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Pete Sharman Email: psharman_at_us.oracle.com
> > Project Manager Phone: +1.650.607.0109 (int'l)
> > Worldwide Internal Services Education (650)607 0109 (local)
> > Oracle Corporation
> >
> > SQL> select standard_disclaimer, witty_remark
> > 2 from company_requirements;
> >
> > Opinions are mine and do not necessarily reflect those of Oracle
> > Corporation
> >
> > "Controlling application developers is like herding cats."
> > Kevin Loney, ORACLE DBA Handbook
> > "Oh no it's not! It's much harder than that!"
> > Bruce Pihlamae, long term ORACLE DBA
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Mon May 10 1999 - 14:03:57 CDT