Shulou(Shulou.com)06/01 Report--

Because PLSQL Developer does not have a corresponding 64-bit program, it can only correspond to x86 Oracle clients when connecting to Oracle. This example is Oracle11g. Go to the official website to download the x86 version of instantclient_11_2. After 11g, you can use this green program directly without installing the program.

1. Configure environment variables: ORACLE_HOME=D:\ Program Files (x86)\ instantclient_11_2

TNS_ADMIN=D:\ Program Files (x86)\ instantclient_11_2\ NETWORK\ ADMIN

If NETWORK and ADMIN are not available, create a new one manually.

two。 Set up the PLSQL Developer:

1) enter the program, menu: tools-preferences

2) set the Oracle home directory and OCI library. If the environment variable is set correctly, the drop-down will find it automatically.

Oracle home directory: d:\ Program Files (x86)\ instantclient_11_2

OCI library: d:\ Program Files (x86)\ instantclient_11_2\ oci.dll

OK, save. Exit the program.

3) start the program and enter the login interface:

The drop-down of the database will have the connection name configured by tnsnames.ora in TNS_ADMIN. Enter the user name and password to log in.

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.