Remote configuration of Oracle-pl/sql Dev

First install Oracle Enterprise Edition or client lite. After that, you need to modify your Tnsnames.ora file to increase the database.

My Oracle instance is ORACLE1 and placed in the D:\oracle\ directory. My IP address is 192.168.1.102.

Modify the following: add: DEMO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.102) (PORT = 1521)) (Connect_data =      (SERVER = dedicated)  (service_name = ORACLE1)) This adds a remote database to the native Client. Then open the PL/SQL DEV software. Modify in Preferences, tools: Oracle Home directory Name: D:\oracle\OCI Library: D:\oracle\ora92\bin\oci.dll Once this is set up, you can access the remote Oracle database through PL/SQL Dev. Attach the most original Tnsnames.ora file

# TNSNames. ORA Network configuration file:d:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools. ORACLE1 =  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = TCP) (HOST = vkp1w8iqzw4qtsx) (PORT = 1521)) 
   )    (Connect_data =      (SERVER = dedicated)      (service_name = Oracle1)    )  ) inst1_http =  ( DESCRIPTION =    (address_list = (      ADDRESS = (PROTOCOL = TCP) (HOST = vkp1w8iqzw4qtsx) (PORT = 1521))    ( Connect_data =      (SERVER = SHARED)      (service_name = modose)      (PRESENTATION = http://HRService)    )  ) Extproc_connection_data =  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0)) c22/>)    (Connect_data =      (SID = Plsextproc)      (PRESENTATION = RO)    )  )