Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Orace 64bit not working with Windows 64bit

Posted on 2011-09-30
6
Medium Priority
?
502 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 71

Accepted Solution

by:
Qlemo earned 1500 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 71

Assisted Solution

by:Qlemo
Qlemo earned 1500 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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

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 71

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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…

609 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