Oracle Library Oci.dll could not being loaded

Source: Internet
Author: User
Tags postgresql



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


Alibaba Cloud Hot Products

Elastic Compute Service (ECS) Dedicated Host (DDH) ApsaraDB RDS for MySQL (RDS) ApsaraDB for PolarDB(PolarDB) AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL) Data Transmission Service (DTS) Server Load Balancer (SLB) Global Accelerator (GA) Cloud Enterprise Network (CEN)
Object Storage Service (OSS) Content Delivery Network (CDN) Short Message Service (SMS) Container Service for Kubernetes (ACK) Data Lake Analytics (DLA)

ApsaraDB for Redis (Redis)

ApsaraDB for MongoDB (MongoDB) NAT Gateway VPN Gateway Cloud Firewall
Anti-DDoS Web Application Firewall (WAF) Log Service DataWorks MaxCompute
Elastic MapReduce (EMR) Elasticsearch

Alibaba Cloud Free Trail

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.