Solved

Orace 64bit not working with Windows 64bit

Posted on 2011-09-30
6
498 Views
Last Modified: 2012-05-12
I have a virtual machine installed MS Windows Server 2008 R2 EE 64bit on it. I just installed successfully Oracle 11g R2 64bit client on it. I made a service from net manager and tested it which was successful. I also verified my oracle installation from command promt using SQLPLUS command and it confirmed me about the correct Oracle installation.

I installed Toad 10 versions 10.6.1 & 10.1.8 (one by one) and tried to connect the database, it shows dll errors mostily OCI.DLL not initilized. I tried to get it resolved with different ways but remained unsuccessful, although it is fine with Oracle 11g Client 32bit.

Please suggest the possilbe solution!
0
Comment
Question by:Netsol-NOS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 70

Accepted Solution

by:
Qlemo earned 500 total points
ID: 36891166
You are certain you installed the 32bit client in addition? Toad needs the 32bit client. Your SqlPlus you tested with is most likely the 64bit version.
You won't use the 64bit client usually, as there are only a few applications (servers) which require it.
0
 

Author Comment

by:Netsol-NOS
ID: 36891215
Yes I installed Oracle Client 32 bit first, uninstalled it and then install x64 Client to make it able to work. but it did not work although i was being said that, it is the tact to run it.

Kindly guide what should be the sequence to install both clients so the only x64 Client could work. if the only installation of Oracle x64 client is not able to work straight away.

Thanks
0
 
LVL 70

Assisted Solution

by:Qlemo
Qlemo earned 500 total points
ID: 36891236
Quote: "Note: Toad supports 64-bit for Windows 2003 / XP / Vista / 2008 / Win7 with a 32-bit Oracle Client." - and that is with the current release 11. You need the 32bit client. Why did you want to install the 64bit client? You only need it if you use 64bit software on that machine.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Netsol-NOS
ID: 36891409
ok thank you,

Can you please confirm one more think, on the same environment, I mean on windows server 2008 EE R2 x64, if I install EA Server 6.3.1 Advanced Edition? is this compatible with Oracle Client R2 x64

0
 
LVL 70

Expert Comment

by:Qlemo
ID: 36891554
That's Sybase, isn't it? It is that simple - if you have 32bit Software, use 32bit drivers, if you have 64bit Software (and I suppose EA Server is 64bit), use 64bit drivers. If you need both at the same time, you need to have a tricky setup, clearly defining the correct paths and Oracle Homes for each 64bit and 32bit drivers. If you are able to do so, just use one type of Oracle drivers, everything else will get very confusing, though it can work, with some fiddeling.
0
 

Author Closing Comment

by:Netsol-NOS
ID: 36901661
Thank you for providing me the information
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question