Re: Up and down sides of using HOSTNAME instead of tnsnames.ora for SqlNet connetion info

Steve Ashmore wrote:

> 17 instances, with 17 databases. No OPS (We are running 3 or 4 diferent
> versions
> of 8i both 32 and 64 bit)
> It can get ugly, I wouldn't recommend going to that many,
> we have hit every imaginable system limit at one time or another. But it
> works.
> It is a hoot to say the least.
>
> "damorgan" <damorgan_at_exesolutions.com> wrote in message
> news:3DEFE8B0.3B2F52F6_at_exesolutions.com...
> > Steve Ashmore wrote:
> >
> > > One 'down' of the top of my head would be if you ever wanted to
> > > run multiple instances on a server. Believe it or not we have one
> > > development server with 17 instances on it.
> > >
> > > Stephen C. Ashmore
> > > Brainbench MVP for Oracle Administration
> > > http://www.brainbench.com
> > > Author of: 'So You Want to be an Oracle DBA?'
> > >
> > > "TurkBear" <john.greco_at_dot.state.mn.us> wrote in message
> > > news:mgivuu4if2iur4jgeolb682mrp9d8nke08_at_4ax.com...
> > > > Or in addition to..
> > > >
> > > > I have heard that there are some issues with this method, but not what
> > > they may be..
> > > >
> > > > It would be easier to manage new instances if all we had to do was
> > > register them with an alias in our DNS server...
> > > > ( this will all be on our Intranet)
> > > > Opinions, please?
> > > >
> > > > Thanks,
> > > >
> >
> > Not to be picky on semantics but ... 17 instances ... or 17 databases?
> >
> > Daniel Morgan
> >

What is stopping anyone from consolidating them as schemas within a single database?

Lack of excitement? Desire to work 7x24? Need to complicate your lives?

Daniel Morgan Received on Fri Dec 06 2002 - 10:36:40 CST