Solved

Orace 64bit not working with Windows 64bit

Posted on 2011-09-30
6
495 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
  • 3
  • 3
6 Comments
 
LVL 68

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 68

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 68

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now