Re: Rename existing database

I just did mine last week. There is an oracle magazine issue explicitly instructing how-to. I worked perfectly for me. I changed my DB_NAME from oracle to Oracle7.

It is in the April/May 1996 issue. It can be found in the oramag website under archives!!!!

Good luck
Rich Bernat

In <323996A3.2939_at_nortel.ca>, Michael Abbey <cpb4c52_at_nortel.ca> writes:
>Hiran Chaudhuri wrote:
>>
>> Does anyone know how to rename an oracle database (like changing
>> initorcl.ora + something)?
>>
>> The manual only sais: Changing the name of an already created database
>> is difficult.
>>
>> Hiran
>
>There are 2 separate issues here - one is if you wish to rename a
>database's ORACLE_SID, the other is if you wish to rename a database. I
>have done the first many times, and it is a roundabout process that,
>if you are not familiar with it, can prove frustrating. I have never
>renamed a database itself without recreating it.
>
>With respect to renaming an ORACLE_SID - this is what to attend to
>
>1) Yes the name of the init file needs changing
>2) The entry for the old SID needs updating in /etc/oratab
>3) Entries in listener.ora and tnsnames.ora (the latter ALL OVER
> your network) need changing
>4) ORACLE_SID changes need to be propagated to all applications who
> point themselves at the old SID
>
>This is by no means a complete checklist .... good luck!
>
>Michael
>
>###################################################################
># Michael Abbey Ottawa ON Canada 613 780 2364
>#
># Co-author of: Tuning Oracle Oracle: A Beginner's Guide
># Oracle Data Warehousing
>###################################################################
Received on Mon Sep 16 1996 - 00:00:00 CEST