Win7 64-bit system PB connection to Oracle database "Oracle Library Oci.dll could not be loaded" workaround

Today, we share a note of my own study, hoping to bring help to those who meet the same problem.

I do not know if everyone in the Win7 64-bit system with PB to connect to the Oracle database, have encountered "Oracle Library Oci.dll couldnot be loaded" issue.

Today, in the Win7 64-bit system with PB to connect to the Oracle database, has been the above error, in Baidu for a long time, have not found a complete solution , consulting a lot of people, (they all said that my PB and Oracle did not install, but I do not have any problems when installed, everything is smooth, and Pb and Oracle are able to use, is the use of PB to connect Oracle How can not even, have been unable to find a solution, so listened to their views, holding a glimmer of hope, The PB and Oracle are unloaded, but, the same mistake Ah!!! To collapse) The problem remains unresolved.

However, Kung Fu is not a conscientious, after their countless attempts and failures, and finally solved the problem, so leave this essay to share with you, but also to leave a memorial.

First of all, say something about my computer system with the installed software:

(1) Win7 64-bit Professional Edition

(2) PowerBuilder11.5

(3) Oracle Database one-to-oneG Release 2 (11.2.0.1.0) for Microsoft Windows (x64)

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html (Oracle)

Specific software download process and installation process I'm not here to explain, Baidu has

Now, let me explain. PB Connection to Oracle database process and problems and solutions

Once the PB and Oracle are installed , you can connect the Oracle database in PB

The specific connection steps are: Open db profile-> select O Oracle 10g->new (you can also directly right click to select New profile ...) Fill in the profile Name,server,login Id,password in connection and the PowerBuilder Catalog Table in System Owner (Note: This is the same as the login ID in connection, if it is not the same as the following error:)

After filling it out, you can select test Connection in preview, but when I test it, I get the following error:

Cause: I installed Oracle is 64-bit, the inside of the Oci.dll is also 64-bit, PB needs to use 32-bit oci.dll, so the connection can not load Oci.dll,

Therefore, it is necessary to download a 32-bit instant client to support PB invocation. This leads to the following solutions:

The solution is really simple, just three steps

Step one: download a instant Client for Microsoft Windows (32-bit) (Note: This is the key, be sure to next 32 bits, do not make the next 64 bit )

(: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)

If it becomes a 64-bit problem, the problem will not be solved (the reason is clearly stated)

Step Two: unzip the downloaded package to get the Instantclient_11_2 folder and copy the folder to the product folder under the Oracle installation directory.

Take my example: put in the D:\Oracle\app\zy\product, namely: D:\Oracle\app\zy\product\instantclient_11_2;

Step Three: Locate the network folder under the Oracle installation directory, and then copy the entire Network folder to the D:\Oracle\app\zy\product\instantclient_11_2 folder.

(Take my example: My network folder is in the following directory D:\Oracle\app\zy\product\11.2.0\dbhome_1)

If you do not copy the network file into the Instantclient_11_2 folder or the copy is not complete, the following error will appear:

After completing the three steps above, the problem is solved. Re-open PB, according to the above connection step connection, you can connect successfully.

Such as:

The connection is successful, and you can see the connected databases in database.

Additionally: During the connection process, you may encounter the following issues:

This problem indicates that your listener is not open, the solution is very simple, to the service to open the line

Specific steps: Click Start Menu, enter "Services" in the Search box, click Open, find the following two items to turn it on:

Today and everyone to share these content, if there is not the right place, welcome to criticize correct, about the above issues, if you have a better solution, welcome everyone to come to exchange!

Win7 64-bit system PB connection to Oracle database "Oracle Library Oci.dll could not be loaded" workaround