Print Thread
Initialization error - oci.dll - returned 0
#43531 03/09/12 10:34 AM
Joined: May 2011
Posts: 8
W
Member
OP Offline
Member
W
Joined: May 2011
Posts: 8
Hi

I use Win7 64bit. First installed client and pl/sql Developer works. Today had to install DB in other home and cannot connect to any DB - Initialization error - oci.dll - returned 0.


Running from batch file :

set PATH=%ORACLE_HOME%\bin
set TNS_ADMIN=\\orlik\Onames
"C:\Program Files (x86)\PLSQL Developer\plsqldev.exe" prefpath=e:\inne\plsqlPreferences



--- Info ---

PL/SQL Developer
Version 8.0.4.1514
295.69589 - Unlimited user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4

Last edited by wlasiukk; 03/09/12 11:03 AM.
Re: Initialization error - oci.dll - returned 0
wlasiukk #43535 03/09/12 11:19 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?


Marco Kalter
Allround Automations
Re: Initialization error - oci.dll - returned 0
Marco Kalter #43549 03/12/12 09:05 AM
Joined: May 2011
Posts: 8
W
Member
OP Offline
Member
W
Joined: May 2011
Posts: 8
Did You get Support Info in email ?

Re: Initialization error - oci.dll - returned 0
wlasiukk #43550 03/12/12 10:04 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
I don't think so. Can you resend it?


Marco Kalter
Allround Automations
Re: Initialization error - oci.dll - returned 0
Marco Kalter #43551 03/12/12 10:20 AM
Joined: May 2011
Posts: 8
W
Member
OP Offline
Member
W
Joined: May 2011
Posts: 8
sent to support@allroundautomations.com

Re: Initialization error - oci.dll - returned 0
wlasiukk #43553 03/12/12 10:32 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Thanks, received. Can you confirm that your OraClient11g_home1 is a 32 Bit Oracle Client?


Marco Kalter
Allround Automations
Re: Initialization error - oci.dll - returned 0
Marco Kalter #43554 03/12/12 10:46 AM
Joined: May 2011
Posts: 8
W
Member
OP Offline
Member
W
Joined: May 2011
Posts: 8
It is Oracle_11gR2_client_win64
DB also

Re: Initialization error - oci.dll - returned 0
wlasiukk #43556 03/12/12 01:09 PM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
You will need to install a 32 Bit Oracle11g Client. PL/SQL Developer is a 32 Bit application, so it cannot interface with a 64 Bit Oracle Client.

The 32 Bit Oracle Client can communicate with a 64 Bit Server, even on the same machine if necessary. The 32 Bit client can coexist with a 64 Bit Oracle installation when installed in separate Oracle Home directories.


Marco Kalter
Allround Automations
Re: Initialization error - oci.dll - returned 0
Marco Kalter #43558 03/12/12 01:24 PM
Joined: May 2011
Posts: 8
W
Member
OP Offline
Member
W
Joined: May 2011
Posts: 8
It is working now (after installing instant client 32 bit), but it was also working before installing DB. Never mind, thanks for help.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.095s Queries: 15 (0.029s) Memory: 2.5326 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-05-04 01:44:51 UTC
Valid HTML 5 and Valid CSS