How to connect Oracle Database Instant Client 11g + PLSQL Developer to oracle server
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!