Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.