Re: Rename an Oracle 91 database

"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:45:01 CST