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 could not be loaded" issue.
Consulted a lot of people, (they are said to be my PB and Oracle did not install well, so listened to their views, holding a glimmer of hope, the PB and Oracle have unloaded the reload, but, the same mistake Ah!!! To collapse) The problem remains unresolved.
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)
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)
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:
"Oracle Library Oci.dll could not being loaded