Greetings DBA Experts,
I have changed my Oracle SID in the past by updating the init.ora file, and updating
my environment (vars, tns, lintener, etc..), yet not since we moved to 11g with ASM.
I come from an app development team, and when I ask our system-level DBA's the best way to do this, they just reply with "Why would you want to do that?".
Is there anything extra or different I need to do in renaming a SID with respect to our ASM instance?
Thanks very much!