RE: renaming an instance

  • From: Brian Pardy <brianpa@xxxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Fri, 10 May 2013 18:29:40 +0000

You know that, I know that, but devs looking to showcase their nifty idea to 
auto-tune their app in a "configuration free" way based on details gleaned from 
the environment may not know that.

And as for what happens, I can tell you what happened at one of my previous 
jobs when stuff had to change... we had no proper source control available from 
which to regenerate a fixed version of code currently in production, so we 
added a bunch of aliases in DNS and extra bogus entries in /etc/hosts just to 
placate this bit of fun. 

Of course, if we didn't get a new server naming standard from every new CIO 
upon their promotion, this would have stayed nice and hidden.

Niall Litchfield wrote:
But dbname != instance name. What happens if their predictions of global 
dominance come true and they find themselves on RAC etc etc. IIRC nid will 
change the dbid of the database and/or the dbname. 
On May 10, 2013 6:53 PM, "Brian Pardy" <brianpa@xxxxxxxxxx> wrote:
This just feels like something leading up to some of the 'cute' things 
developers can do.  Like electing not to add any configuration file 
functionality and instead hardcoding the app so that it runs as development if 
dbname = X and as production is dbname = Y.

> From: Niall Litchfield
> Why would they care? Do they want the database hostname renamed as well?
> I'd say the quickest way would be to not do it at all and just provide 
> appropriate
> service names.
> On May 10, 2013 6:36 PM, "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
> > Ok, the dev group wants the instance name changed.
> > I saw some articles when I googled but wondered what is the quickest
> > way to rename an instance?
> > ciao,
> > Brian
--
//www.freelists.org/webpage/oracle-l


Other related posts: