Restriction on Database Name

[nirasha]

Actually I will be creating a new development and QA system (with appropriate names), in production I will be changing the name maybe in a month or too. Highly nervous to do it but determined to do it.. How bad can it be anyway if I have a cold backup?

So to understand, the steps are:
-- recreate controlfile with resetlogs option
-- edit scripts use the set command
-- edit the initfiles with appropriate names
-- run the create controlfile
-- change global names etc

Right?

Nirasha

[karthiarun]

Yeah u got it.

But u have to use the set command in the control file.

I hope it works. But if u want to create the instance u can do it using the ORADIM utility and change the instance name also.

Karthi

[nirasha]

What really bothers me is that the instance name states fndryd (in the init.ora), but not when I select from the data dictionary views.

Nirasha

[karthiarun]

I think that the Instance name that is given for the database will be shown clearly in the V$Instance. The database has the instance value as per the v$Instance view. So try recreating the Instance with a different name and let the same name remain in the Init file. I havent done that but it is a suggestion.

[nirasha]

Will do as soon as I finish prepare a development system, so that I can play with their dev system when it is done. SInce I will be converting that to a qa system.

Thanks for your help,
Nirasha