Avatar of Sarah Stephens
Sarah Stephens
 asked on

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

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.
Oracle DatabasePerl

Avatar of undefined
Last Comment
Sarah Stephens

8/22/2022 - Mon
Mohammed Khawaja

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)

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.
ASKER CERTIFIED SOLUTION
Sarah Stephens

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Sarah Stephens

ASKER
Confirmed my thinking...
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck