Please mark this question ANSWERED and continue to use the duplicate thread you posted in the Sql Developer forum.
I suggest you also update that thread to include your full Oracle DB version and platform infomation.
Right. SQL*Plus doesn't connect via JDBC, it uses the Oracle Client, which in Java-speak, is a 'thick' connection.
So you're not comparing apples to apples here.
Go into preferences, define your Oracle Client location in the Advanced page - making sure it's 11203 client or higher, then try to connect and run your query again. Use the test button to make sure there are no bit level or oracle driver version conflicts.
Hi Jeff ,
Thanks for your help.
Oracle database is 126.96.36.199 on linux Ent Redhat 4.8
The oracle client is 12.1
Tools --> Preferences --> Database --> Advanced --> ClientType --> "ORACLE HOME" --> path to oracle client 12c TNS_NAMES on my local machine.
Running test return the following message : "Oracle Client Test Results terminated "
Statment still fail with the same error message.
Kindly advise ,
The full error message is :
Testing the Oracle Home located at C:\app\client12c\product\12.1.0\client_1\network\admin
Testing client directory ... OK
Testing loading Oracle JDBC driver ... Failed:
C:\app\client12c\product\12.1.0\client_1\network\admin\jdbc\lib\ojdbc6.jar is not a valid jar file
1 person found this helpful
That's not the right $ORACLE_HOME - take out everything after the 12.1.0\
Thanks. Its solve the problem