Re: instance_name vs. db_name

On Mon, 07 Feb 2005 11:36:25 +0100, vertigo <ax178_at_wp.pl> wrote:

>Hello
>
>Which of theese two is written in control_file ?
>What steps should i do to change instance_name and what to change
>db_name ? (when i have already instance running)?
>
>
>Thanx
>Michal

database name is definitely in the controlfile, instance name likely. To change the database name you need to recreate the controlfile by using the variant
create controlfile set db_name ....

The procedures to change the instance name are platform dependent. You'll always need to change your init<sid>.ora, the control_file names, the control_files parameter in init<sid>.ora, and you would need to create new ...admin/<sid>/bdump,udump etc directories. Evidently this is described in the Oracle Server Administrators Manual, which is recommended reading for procedures like these.

--
Sybrand Bakker, Senior Oracle DBA