-
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
-
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
-
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
-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|