Problems with SQL Developer connection to Oracle in WIN8 system

Note: All software is not finally installed under Program Files (x86)

1. PL/SQL Developer show not logged on

Open PL/SQL Developer as an administrator

2. TNS cannot parse the specified connection identifier

　　　　Check the installation directory of the Oracle client software: \oracle\product\10.2.0\client_1\network\admin the Tnsnames.ora connection string is correct, the detection method is: Under the command line with the tnsping Local service name, to see if the connection is successful, Note: The local service name should not be the same as service_name

3. PL/SQL Developer Configuration

Locate the "tools->preferences" in the Plsql Developer toolbar and locate the Oracle Home installation directory designated as Oracle client in the connection node of Oracle, specifying the OCI The path to the libiary is the path of the Oci.dll in the Oracle client.

Problems with SQL Developer connection to Oracle in WIN8 system