Oracle PL/SQL Developer configuration¶

Oracle PL/SQL Developer configuration refers to the setup required to connect the PL/SQL Developer IDE to an Oracle database, specifically involving the localization of the Oracle Instant Client and the modification of network configuration files.

Oracle Instant Client Path¶

The application requires the Oracle Instant Client to function correctly. Specifically, the configuration process involves locating the oci.dll file within the installation directory.^[600-developer__database__oracle__oracle-plsql.md]

A typical path for the 32-bit Instant Client is: 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]

Network Configuration (`tnsnames.ora`)¶

Network connectivity is defined in the tnsnames.ora file. This file contains connection descriptors that distinguish between databases using a SERVICE_NAME versus a SID.^[600-developer__database__oracle__oracle-plsql.md]

Configuration Examples¶

The following examples illustrate the syntax for defining connection aliases:

Using SERVICE_NAME:

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

Using SID:

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

^[600-developer__database__oracle__oracle-plsql.md]

Connection Parameters¶

When establishing a connection, specific credentials and endpoints are required depending on the environment.

Standard Connection Example: 192.168.79.100:1521/xe^[600-developer__database__oracle__oracle-plsql.md]
Docker Environment: When running Oracle in a container (e.g., datagrip/oracle:11.2), the standard credentials are often system/oracle or SYS/oracle, connecting via localhost:1521 with the SID xe.^[600-developer__database__oracle__oracle-plsql.md]

[[Oracle Database]]
[[Docker]]

Sources¶

600-developer__database__oracle__oracle-plsql.md