Get the App
SLTechnology News&Howtos  ›  Database  › 

How to connect Oracle Database Instant Client 11g + PLSQL Developer to oracle server

Shulou Source: shulou.com Published: 2022-05-31 13:53:21 11月17日 Update

This article mainly introduces Oracle Database Instant Client 11g + PLSQL Developer how to connect the oracle server, the article is very detailed, has a certain reference value, interested friends must read it!

1 Oracle Database Instant Client 11g this thing uses 32 bits, no matter how many bits the machine is.

2 pack these two things

3 Open PLSQL Developer Tools-preferences-connection

Configuration

Oracle Home: configure the installation directory of the client program here (D:\ Instant OracleClient)

OCI library: here configure the directory of oci.dll under the client program installation directory

Mine is under bin (D:\ Instant OracleClient\ bin\ oci.dll)

4 add the environment variable TNS_ADMIN with the value of the directory where the tnsnames.ora file is located

(d:\ Instant OracleClient\ network\ admin)

5 configure the database address in the tnsnames.ora file, there are examples

POPDB1 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.252) (PORT = 1521))

)

(CONNECT_DATA =

(SID = popdb1) / (SERVICE_NAME = css) both are written to specify oracle services

)

)

If you want to connect to multiple databases, make a copy and change the information.

POPDB1 corresponds to Database at the landing site of PLSQL Developer

The above is all the contents of the article "how to connect Oracle Database Instant Client 11g + PLSQL Developer to oracle servers". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Tags: Directory configuration service thing content customer client data database file program article two value information interest writing variable address multiple Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MySQL Shulou Information Shulou Tech Info Redmi macOS