Oracle is not installed, and PL/SQL is directly used to connect to Oracle server within 3 minutes

Many people, especially those who do not like Oracle, must learn from Oracle and think that Oracle occupies a lot of memory.
I really don't like installing oracle on a physical machine. Most of them are Windows users, and most of them are developers.
Based on the above requirements, I provide a solution:
Attach an Oracle server to a virtual machine with the Minimum Memory
On a physical machine, most people use Windows and directly use the next installation-free PL/SQL develop.
In this way, people with the above needs can be assured to the maximum extent.
The specific steps for planning and writing are as follows:

 

① Copy all OCI packages from the Server installation package to a specific path, for example, E: \ instantclient.
Note: If you copy data to another user, you must pay attention to the version.
Oracle does not support 64-bit OCI
That is, you can only copy 32-bit OCI
For example:

 

② Configure tnsnames. ora with the same path, for example, E: \ instantclient \ Network \ admin
Configuration case:

orcl =(DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 195.167.253.115)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl.oracle.com)    ))

 

③ Configure PL/SQL
Start PL/SQL developer. On the logon window, click the cancel button to go to the main interface. Click Tools> preferences. The following two parameters must be configured for connection:

Oracle Home: e: \ instantclient
OCI Library: e: \ instantclient \ OCI. dll

For example:

So far, PL/SQL Dev can work normally.