Windows platform, Oracle database and client coexistence mode

Because of certain requirements, the production environment needs to have both database server and client installed on the same machine because Plsql does not have 64-bit clients. Unable to read the 64-bit database Oci.dll file, so need a 32-bit client, if the normal way to install, there will be environment variable confusion and other kinds of uncontrolled problems, I use the following way to make database The server and client can coexist on a single server without impact.
1 Normal Installation Database
2 Find a machine to install 32-bit client
3 Copy the installed client directory to the database server machine and set the path of Oracle_home and Oci.dll in Plsql.
4 You also need to write a bat script that specifies the ORACLE_HOME environment variable for plsql, and the script is as follows:
directory where CD Plsql is located
Set Oracle_home=xxxx
Plsqldev.exe

This allows the plsql to run correctly on a 64-bit database server.

Windows platform, Oracle database and client coexistence mode