Problems and Solutions for installing Oracle9i and Oracle10g on the same machine (Windows XP operating system)

Recently, due to work requirements, you need to install Oracle10g on the local machine. an Oracle9i instance has been installed on the local machine. After installing Oracle10g, you find that there is only one home in the home selector. The error is: "There is only one (1) Oracle Home defined on this machine... ", because 10 GB and 9i were not in the same directory at the time, we thought it was a directory problem, and then we uninstalled 10 Gb. This problem still exists after re-installation. At this time, we had a chance, an Oracle9i and Oracle form were originally installed on one server, but the home selector on the server can switch between Oracle9i and Oracle form, so I opened the registry and studied it, surprise:

HKEY_LOCAL_MACHINE/software/Oracle/all_homes/has an id0, which contains three key values: name, path, nls_lang. Therefore, an id1 is created in the local registry, the three key values in id0 are processed in the same way. The path points to the 10 Gb installation directory, and then the home selector is started. The problem is solved.

The modified registry content is as follows:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE/software/Oracle/all_homes]
"Home_counter" = "1"
"Default_home" = "orahome92"
"Last_home" = "0"

[HKEY_LOCAL_MACHINE/software/Oracle/all_homes/id0]
"Name" = "orahome92"
"Path" = "D: // Oracle // ora92"
"Nls_lang" = "Na"

[HKEY_LOCAL_MACHINE/software/Oracle/all_homes/id1]
"Name" = hex (7): 4f, 00, 6f, 00, 6d, 30 ,/
00, 00
"Path" = hex (7): 44,00, 3A, 00, 5C, 00, 6f, 61, 00, 6C, 00, 5C ,/
, 72, 00, 6f, 75, 00, 00, 5C, 30, 00, 2e, 00, 2e, 00, 00, 00, 00 ,/
, 00, 5C, 62, 00, 5f, 00, 00
"Nls_lang" = hex (7): 4E, 00

Finally, let's talk about the Listener Configuration and tnsnames Configuration:

Because the default port of Oracle is 1521, 1521 of the local machine has been occupied by the listener of Oracle9i, so the listener port of Oracle10g is finally set to another port 1522. Please note that, when using 10 Gb net configuration assistant for Listener Configuration, do not modify any default settings of listener: Name (listener) or port number (1521) (If the default name or port number is modified, the listener service of 10 Gb cannot be found in Windows Service Manager.) After configuration, the Oracle application will automatically stop the 9i listener because its port 1521 conflicts with the current 10g listener. Please stay calm, first, manually stop the 10g listener service (the local name is oracleoradb10g_home1tnslistener) in Windows Service Manager, and then enter D: /Oracle/product/10.2.0/db_1/Network/admin (local installation directory), modify listener in the text editor. the listener port number in ora is 1522. Save listener. ora file. Finally, manually start the listener service 9i and 10g in Windows Service Manager (the local name is oracleorahome92tnslistener and oracleoradb10g_home1tnslistener respectively). As you wish, both listener services will start successfully.

The rest is the configuration of the local net service name, that is, the configuration of tnsnames. The configuration process is the same as 9i. The only thing you need to note is to change the port number to 1522.

When debugging on the local machine, you can use the home selector to switch between 9i and 10g based on your needs. At the same time, other machines request that the 10g and 9i services on the local machine are all normal.