Re: Oracle8/Nt How do I rename instance?

In article <363F3345.44D2FDD5_at_syntegra.bt.co.uk>, Simon Quinn <simon.qui nn_at_syntegra.bt.co.uk> writes
This works on NT too (at least it does for version 7.3) but you also need access to the console to stop the oracle services and rename the default sid in the registry.

>Haven't tried it on NT but the following method works on Unix:
>
>backup the control file, ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
>
>Shutdown the database normally.
>
>Rename your initORCL.ora to the new database name and change the DB_NAME
>parameter
>
>Edit the trace file which contains the create controlfile statement and
>change the line
> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG
> to
> CREATE CONTROLFILE SET DATABASE "newname" RESETLOGS ARCHIVELOG
>
>Delete the control files.
>
>Start the database using STARTUP NOMOUNT;
>
>Run the above script that you've modified.
>
>Open the database using ALTER DATABASE OPEN RESETLOGS;
>
>
>arivlin_at_my-dejanews.com wrote:
>>
>> I installed Oracle Personal8 on NT4. Default name for the database is ORCL. I
>> want to rename it to something more meaningful. How can I do that?
>> Unfortunately I already put some data in the database, so I do not want to
>> build a new parallel DB. Thank you in advance. Alex
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Diane Received on Tue Nov 03 1998 - 12:23:10 CST