Oracle SQL Developer uses

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