OraFAQ Forum: Windows » Test Failed. Provider cannot be found

Home » Infrastructure » Windows » Test Failed. Provider cannot be found (Oracle 11g, Windows Server 2008R2, 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Test Failed. Provider cannot be found [message #578189]

Mon, 25 February 2013 09:02

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).

Report message to a moderator

Re: Test Failed. Provider cannot be found [message #578195 is a reply to message #578189]

Mon, 25 February 2013 09:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: Test Failed. Provider cannot be found [message #578196 is a reply to message #578189]

Mon, 25 February 2013 09:36

Michel Cadot
Messages: 68509
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

Report message to a moderator

Re: Test Failed. Provider cannot be found [message #578198 is a reply to message #578196]

Mon, 25 February 2013 09:45

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.

Report message to a moderator

Previous Topic:	select insttallation Method does not display
Next Topic:	Oracle on more than 64 cores?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 08:08:28 CDT 2023