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.