Solved

Orace 64bit not working with Windows 64bit

Posted on 2011-09-30
6
494 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Generate HTML charts from SQL 4 50
select query - oracle 16 81
Oracle Subquery bad Join 11 42
Schema creation in Oracle12c 6 20
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

772 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

9 Experts available now in Live!

Get 1:1 Help Now