Re: Rename existing database

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
###################################################################