In the process of development, it is often not necessary to install Oracle on their own computers, it is too big.
Here is a way to connect to Oracle using Plsql, similar to the Navicat connection to MySQL.
First download plsql, install, here is a green version: Http://pan.baidu.com/s/1c05CGTU decompression to Local.
Then download the link in the compressed package to the native C drive: http://pan.baidu.com/s/1eQDGfZk
After decompression, locate the directory:. \instantclient_12_1\network\admin in the Tnsnames.ora file, picture as follows:
Host = 192.168.100.79 represents the IP address of the destination library to connect to, Port = 1521 for the port number.
Service_Name = YSSD Indicates the name of the instance you created.
More than one library is configured.
The red line is just the equivalent of an alias, corresponding to the database to be connected at login, such as.
Open the plsql_developer8.0 green version \plsqldev.exe file in the extracted Plsql folder to see the database options you have just configured.
Enter the user name and password to connect to select the corresponding role. You can log in.
Note: The path of the C:\instantclient_12_1 cannot be changed
Oracle Free Client Installation Plsql connection