Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming an Oracle NT server
Alton,
Although we finally renamed our server without any problem, I haven't
thought about filename with embedded server name. I guess you will have to
change them.
On another O/S, we do store/restore of Oracle DB (7.3.2), for dev/test
purpose, and I have to change the filenames too. Here is the sequence:
store on tape,
restore on different location,
adjust location of controlfile in the init file
startup mount exclusive
alter database rename file 'oldname' to 'newname';
for each occurence of v$datafile.name and v$logfile.name alter database open
HTH
michel Gauthier
<mohotta_at_my-deja.com> wrote in message news:7vqn4g$q0p$1_at_nnrp1.deja.com...
> We have a similar situation, only on a Netware server. To conform with
> our city government's naming conventions, we will have to rename our
> Netware servers, including one that houses an Oracle 7.3 database.
>
> From what I understand, we will have to alter our Listener.ora and
> Tnsnames.ora files as well.
>
> I noticed that our Control files list our datafiles with a complete path
> , which includes the server name. If the server name changes, do I have
> to somehow alter the control file as well?
>
> Alton Chinn
> SF Planning Department
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 04 1999 - 16:05:46 CST