To create a virtual IP address

1. Open the Network Connections.
2. Right-click the public network connection to be used and click Properties.
3. Select Internet Protocol (TCP/IP) and click Properties.
4. Click Advanced.
5. In the IP Settings tab, click Add to add a virtual IP address and subnet mask.

To verify the initialization file settings, if a PFILE is used

1. Open the Registry Editor.

   From the Start menu, choose Run. In the Open field, enter regedit and click OK.

2. Double-click the ORA_SID_PFILE registry key at HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME_ID\.

   The variable SID represents the database instance.

3. Verify that the Value data field specifies the correct path at which the initialization file, init.ora, is located.

To verify the initialization file settings, if an SPFILE is used

1. Run sqlplus.exe.
2. Connect to the database.
3. Verify the following query returns the correct path of the SPFILE.

   select value from v$parameter where name = 'spfile'

To update the Oracle configuration files

1. In the listener.ora and tnsnames.ora files, change the host name for all the TCP protocol address databases to the virtual IP address that you created.

   Replace

   HOSTNAME=machine_name
   					

   with

   HOSTNAME=virtual_IP_address
   					

2. In the initialization file, change the dispatchers parameter.

   Oracle requires an initialization file, a PFILE or an SPFILE, to start database instances. Choose the appropriate reference depending on the initialization file you use.

3. Restart the Oracle and listener services.