Do not install Oracle client program locally, connect to remote database directly using PL/SQL developer
Given the limited resources of the machine itself, a client consumes a lot of resources and attempts to connect remotely using a method that does not install the client.
Software required: instantclient-basic-win32-10.2.0.5.zip, PL/SQL developer
The process is as follows:
Extract Instantclient-basic-win32-10.2.0.5.zip to any directory, directory folder name requires no parentheses, create a network folder under that directory, go to create Admin folder, create Tnsnames.ora file, write content such as Under
Educloud (instance name) =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 112.33.2.95 (IP address)) (PORT = 1521))
)
(Connect_data =
(Service_Name = Educloud (instance name))
)
)
Open PL/SQL developer when not logged in, open tools, preferences, connect
Fill in the Oracle Master directory name: D:\install\other\instantclient_10_2
Fill in the OCI library: D:\install\other\instantclient_10_2\oci.dll
OK save, restart PL/SQL developer
Enter the appropriate user name and password to
PL/SQL developer connecting to remote databases