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