Adding test and production server references to the Windows Registrygreenspun.com : LUSENET : OCI Best Practices : One Thread
Adding test and production server references to the Windows Registry
This procedure describes how to use RegEdit to manually set server references.
The user chooses from these references when logging on to OCI. At run-time OCI automatically creates a production server entry. In other words, OCI automatically creates a node named "HKEY_CURRENT_USER\Software\OCI\Server\" and at that node saves the name "Production" with the associated data "orcl". Therefore, this procedure is normally only followed when adding a test server. Furthermore, for users who have run OCI the Server node will already exist.
1. Run RegEdit.exe (located at the root of the WinNT directory).
2. Using the registry tree view, navigate to the "\HKEY_CURRENT_USER\Software\OCI" node.
3. Select the OCI node and use the Edit|New menu option to create a new Key named "Server".
4. Select the Server node and use Edit|New to add two new string values - "Production" and "Test" - under the "Server" node.
5. Using Edit|Modify set the Data property of Production to "orcl" and the Data property of Text to "orcl1".
-- Anonymous, January 25, 1999
Regarding step 5 of adding server references, the database aliases should be "prod" for Production and "test" for Test. The old aliases, "orcl" and "orcl1" will go away at some point.
-- Anonymous, January 27, 2000