Jump-start with Oracle’s Instant Client and Incanto
April 10, 2006
I just did a test-drive with Oracle’s new free-of-charge Instant Client to see how it fit’s with the Incanto <sqlplus> Ant task. I was pleasantly surprised how well and simple it works. The Oracle Instant Client has a very small footprint and can be used with minimal installation efforts. Therefore it’s particular valuable for those cases where you don’t want or can’t install a full Oracle Client.
To use the Oracle Instant Client with Incanto, you have to consider the following:
1) Deploy the Oracle Instant Client and the SQL*Plus package into any directory.
2) Make sure this directory is on the path when running Ant.
N.b.: If you already have another Oracle Client installed, then you won’t be able to add the Instant Client directory to the PATH variable. In this case you can either set the Instant Client directory as the working directory for your Ant build or change the PATH variable within Ant’s launch script.
3) Set the TNS_ADMIN environment variable or registry setting to the full path of the tnsnames.ora file. This way you can use alias names specified in the tnsnames.ora.
February 9, 2007 at 7:28 pm
Will this work with the full Oracle client?
I’m trying to get this working using Ant within Eclipse and have so far been unsuccessful…
I’m getting:
[ora:sqlplus] ORA-12154: TNS:could not resolve service name
And I’m assuming I’m missing something in my path or somewhere??
February 9, 2007 at 8:11 pm
[...] I initially ran this – it bombed. I found another post at the Incanto site regarding using it with the Oracle thin client. In it – it mentioned you needed to add TNS_ADMIN to your environment path. So (in Windows [...]