Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rename an Oracle 91 database

Re: Rename an Oracle 91 database

From: koert54 <nospam_at_nospam.com>
Date: Tue, 04 Feb 2003 19:59:37 GMT
Message-ID: <JYU%9.30605$Jd.3982@afrodite.telenet-ops.be>


> Yeah, I'm not saying that it wouldn't. Of course it needs to be changed as
> well, just that you don't need to do it in advance of anything else, and
> that it can subsequently be changed to anything you like. There's no
> checking it matches the 'actual' name of the database, for example. It's
> used in tns operations, so it's important. But it's not in itself
sufficient
> to change it to effect a 'real' database name change.

oh yeah - 100% true

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:rCU%9.40485$jM5.102968_at_newsfeeds.bigpond.com...
>
> "koert54" <nospam_at_nospam.com> wrote in message
> news:vmU%9.30516$Jd.3966_at_afrodite.telenet-ops.be...
> > Wow - how fast of a typer are you !!! I can type 150 characters a minute
> > blind - but you must be
> > way faster than me ! :-) (isn't it hot enough where you're sitting ?)
> >
> > > True enough, but not required actually to effect a change in database
> > name,
> > > which is stored in the control file, and thus gets changed with the
> create
> > > controlfile business.
> >
> > Dunno about that - all the databases I've cloned so far I had to do an
> > 'alter database rename global_name' or
> > a 'select from global_name' would still reflect the old global name -
even
> > when I recreated the controlfile ...
>
> Yeah, I'm not saying that it wouldn't. Of course it needs to be changed as
> well, just that you don't need to do it in advance of anything else, and
> that it can subsequently be changed to anything you like. There's no
> checking it matches the 'actual' name of the database, for example. It's
> used in tns operations, so it's important. But it's not in itself
sufficient
> to change it to effect a 'real' database name change.
>
> Come to that, it means our OP will need to look to his tnsnames.ora and
his
> listener.ora to make ripple-through changes there, too!
>
> Regards
> HJR
>
> > The db name will be fine by looking at v$database but global db name
will
> > not - only found out when a collegue
> > started running scripts that queried global_name and they all gave the
> same
> > response :-)
>
>
Received on Tue Feb 04 2003 - 13:59:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US