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

1. Log in to PL/SQL Developer

Omit the installation steps for the Oracle database and PL/SQL Developer here, and be careful not to install the PL/SQL Developer software in the Program Files (x86) directory, otherwise you will not be able to start PL/SQL Developer.

I wonder why you can't choose the TNS of the database here. I install the database first and then install PL/SQL Developer. Oracle Home and OCI Libaray are supposed to be recognized when you install PL/SQL Developer. Who cares? First log in to PL/SQL Developer in a non-login manner and set up Oracle Home and OCI Libaray.

Under the Oracle Home option, the Oracle Home directory is not automatically recognized, so the Oracle Home path is manually specified.

Click "OK" to exit PL/SQL Developer and log in again.

Or choose not to reach the database TNS, try logging in to numerous databases to see what errors are reported.

Finally found the crux of the problem, the installed PL/SQL Deleloper can only recognize 32 oci.dll. It seems that you want to install a 64-bit PL/SQL Deleloper, so search the Internet for the 64-bit version of PL/SQL Deleloper. However, it is found that PL/SQL Deleloper does not distinguish between 64-bit and 32-bit. Then we can only start with oci.dll. Based on the error message above, it seems that you only need to install a 32-bit version of Oracle Client.

two。 Install oracle Clinet

First, go to the Oracle website to download an Oracle 11g Client, but you need to apply for an Oracle account before you can download it.

Current download address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

This is a green version of Oracle Client, so as long as it needs to be decompressed, it can be. Extract the downloaded Oracle Client file instantclient-basic-win32-11.2.0.1.0.zip to disk C (pay attention! Cannot be 64-bit). Then create a new NETWORK\ ADMIN directory in the unzipped C:\ instantclient_11_2 directory, create a new tnsnames.ora file in the ADMIN directory, and add the database TNS.

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = chiclewu-PC) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)

(note: the tnsnames.ora file can also be copied from the NETWORK\ ADMIN directory of the Oracle database HOME directory and sqlnet.ora. Then determine whether the HOST configuration is correct. If HOST is the hostname, you need to remove the domain name after the hostname)

3. Configure Oracle Home and OCI Libaray for PL/SQL Developer

Enter PL/SQL Developer in non-login mode and specify the Oracle Home path as the Oracle Client directory (C:\ instantclient_11_2) and the OCI Libaray path as the oci.dll of the Oracle Client directory (C:\ instantclient_11_2\ oci.dll).

Click OK, now that the configuration is complete, here is the time to wait for a miracle. Exit PL/SQL Developer.

4. Verify Oracle Client

Open the new PL/SQL Developer, enter your user name and password, and under the database option, you can see the TNS you just configured.

Waiting for a miracle moment.

After a few seconds of waiting, the miracle time has finally arrived, and you can log in.

Check to see if you can query the data.

There is no problem with querying the data, and it is finally done.

The above is the whole content of PL/SQL Developer connecting to the local Oracle 11g 64-bit database. I hope you like it. I also hope that you will give us more support.

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.