Comparison:
Plsqldev: Third-party, fast startup software, slow execution of SQL queries
Sqldeveloper:oracle company, slow startup software, fast execution of SQL queries
Objective:
To connect a local Oracle Server service-side instance using Sqldeveloper
Using Sqldeveloper to connect to a remote Oracle client instance
Environment:
Oracle 11g
OracleClient 11g ODAC
Oracle SQL Developer
Premise:
Copy Oracle client's Tnsnames.ora file to its top level directory admin
F:\app\Administrator\product\11.2.0\client_1\Network\Admin\Sample\tnsnames.ora
connecting to a local Oracle Server -End Instances
Premise: the instance Server service and the listening service need to be turned on
Operation:
Connection type, select "Basic"
Problem:
Status: Failed-Test failed: IO error: The Network Adapter could not establish the connection
Solve:
Remove the host name to
connecting to a remote Oracle Client -End Instances
Premise:
Server services and monitoring services, you can disable
Steps:
1. Configuring the TNS Directory
Tools--Preferences
2, connection type, select "TNS"
Oracle SQL Developer uses