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

We have several consolidated.
These 17 instances incorporate close to 100 applications. (This is just a portion of our enterprise)

We have found that keeping them separate gives us

A lack of excitement! No need to work 7x24! Less complicated lives :)

It makes scheduling of downtime, upgrades, releases a whole heck of a lot easier.

Being in a large enterprise with diverse needs can make things interesting at times.

"damorgan" <damorgan_at_exesolutions.com> wrote in message news:3DF0D215.DA54C7D1_at_exesolutions.com...
> 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 - 15:59:40 CST