Home » Infrastructure » Windows » Test Failed. Provider cannot be found (Oracle 11g, Windows Server 2008R2, 64-bit)
Test Failed. Provider cannot be found [message #578189] Mon, 25 February 2013 09:02 Go to next message
sduritza
Messages: 2
Registered: February 2013
Junior Member
We just upgraded one of our databases to 11g on a new server. The 3rd party application that accesses the db is 32 bit. The software needs to be running on the db server in order for some transactions to occur. Since the oracle client on the db server is 64bit do we need to install a 32 bit client as well. As of right now we are getting an error in the software when trying to connect to the db that says "Test failed. provider cannot be found. it may not be properly installed." This is a live production server so uninstalling and reinstalling oracle is not really an option at this time (unless absolutely necessary). How will installing a 32 bit oracle client effect everything (if that is the route we need to take).
Re: Test Failed. Provider cannot be found [message #578195 is a reply to message #578189] Mon, 25 February 2013 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
WOW!
So much for testing prior to deployment.

If you install 32-bit client into its own ORACLE_HOME tree, nothing else will be impacted.
Re: Test Failed. Provider cannot be found [message #578196 is a reply to message #578189] Mon, 25 February 2013 09:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Since the oracle client on the db server is 64bit do we need to install a 32 bit client as well.


Yes at least an instant client.
http://www.oracle.com/technetwork/topics/winsoft-085727.html

Regards
Michel
Re: Test Failed. Provider cannot be found [message #578198 is a reply to message #578196] Mon, 25 February 2013 09:45 Go to previous message
sduritza
Messages: 2
Registered: February 2013
Junior Member
Thanks for the replies. Unfortunately this application is administered by several different people who failed to let our DBA team know every intricate piece of the software end. All the pieces from our standpoint were working fine during testing and the people who were a part of the test environment ensured us that everything looked fine, until we went live. We are not proficient with oracle either since we are mostly a SQL house, so we just want to make sure we get it right before proceeding. We did attempt to install the client a few days ago and after the install it wiped our original oracle home even though we allocated a different path for the client? We could still connect to the database from other client PCs so it didn't hurt anything but we uninstalled until we had further clarification.
Previous Topic: select insttallation Method does not display
Next Topic: Oracle on more than 64 cores?
Goto Forum:
  


Current Time: Mon Sep 01 20:22:16 CDT 2014

Total time taken to generate the page: 0.10782 seconds