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

Steve Ashmore wrote:

> 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
> >

Makes sense. Though had I known that the 17 hosted 100 apps ... I would have suggested more servers rather than more consolidation. Sounds like the real constraint here is budgetary.

Dan Morgan Received on Fri Dec 06 2002 - 16:07:34 CST