| rename Oracle sid (existing) [message #62880] |
Sat, 21 August 2004 20:36  |
JKIDBA
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
I am presently working on oracle 9i. The environment is client server. The O/S is win2000.
Please help to provide the steps to rename the existing SID name. In another words, I am not moving from one databse to another or one instance to another... But I just want to rename the SID.
This I need because I have 150 clients where tnsnames.ora has different sid name. I want to use that name as SID.
|
|
|
|
| Re: rename Oracle sid (existing) [message #62900 is a reply to message #62880] |
Mon, 23 August 2004 04:42  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
The following should work (however, I suggest you test it on a non-production machine first):
1. Shutdown the Database;
2. Drop the Oracle Service, and recreate it (using oradim.exe);
3. Update the Windows REGISTRY and update all old references to the new SID name (use regedit.exe);
4. Restart the Oracle Instance.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
