PL/SQL Developer Oracle Instant Client setup¶

This configuration allows the PL/SQL Developer IDE to connect to Oracle databases by utilizing the Oracle Instant Client.^[600-developer-database-oracle-oracle-plsql.md]

OCI.dll Configuration¶

To enable the connection, the application must be pointed to the oci.dll file located within the Oracle Instant Client directory.^[600-developer-database-oracle-oracle-plsql.md]

A typical path configuration for a 32-bit client looks like this: D:\JavaTool\database\PLSQL Developer\PLSQL Developer 9.0.0.1601\oracle_instantclient_12.1.0.2.0_32\oci.dll^[600-developer-database-oracle-oracle-plsql.md]

Connection Definitions¶

Database connections are configured using a tnsnames.ora file. This file supports connecting via SERVICE_NAME or SID.^[600-developer-database-oracle-oracle-plsql.md]

SERVICE_NAME Example¶

Connects to a database service named sdb1.^[600-developer-database-oracle-oracle-plsql.md]

DB1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xxx.xx.xx)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SERVICE_NAME = sdb1)
  )
)

SID Example¶

Connects to a database with a specific System Identifier sdb2.^[600-developer-database-oracle-oracle-plsql.md]

DB2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xxx.xx.xxx)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SID =sdb2)
  )
)

Related Concepts¶

• [[Oracle Database]]
• [[Docker]]

Sources¶

^[600-developer-database-oracle-oracle-plsql.md]