Re: Database > 1 per Instance

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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Mon May 10 1999 - 12:02:33 CDT