Can Oracle Client 11.2.0.2.0 work with an Oracle 12c Database?

Sarah Stephens
Sarah Stephens used Ask the Experts™
on
I have a perl script running SQLLoader which was working before the DB upgrade. Yes, I could upgrade the client but that involves more env touching that I want to do at the moment.  Any experience with this issue?

I dont get a .bad file, I dont get and error.. it just doesnt do anything.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Mohammed KhawajaManager - Infrastructure:  Information Technology

Commented:
Yes, it will work.  Oracle clients will work with current version as well as with three newer versions and three older versions.  Below is product support matrix link:

http://www.dba-oracle.com/t_oracle_client_versions_higher_lower_database_release.htm
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I agree that there should be no reason 11g sqlloader would not connect to a 12c database.

I'm not sure about the hard and fast three versions...


What happens if you run sqlldr from a command prompt?

Maybe Perl is trapping the actual errors.
Commented:
I'm starting to think it's just a bad install in the VM we spun up.  I have now been able to hit the DB with a 10 client from a different server.  Thanks
Sarah Stephens

Author

Commented:
Confirmed my thinking...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial