I needed a SQLPlus environment recently to access the RAC DB I have running in a VMWare image.
I'd heard of the Oracle Instant Client, so I checked it out and man, it is dead simple. There's nothing quite like something just working as it is intended to.
To run SQLPlus as a client on Windows:
Download two zip files
* Instant Client Package - Basic Lite
http://download.oracle.com/otn/nt/instantclient/instantclient-basiclite-win32-10.2.0.3-20061115.zip
* Instant Client Package - SQL*Plus
http://download.oracle.com/otn/nt/instantclient/instantclient-sqlplus-win32-10.2.0.3-20061115.zip
Once downloaded, extract them into the same directory -- which defaults to instantclient_10_2.
Then set PATH to include the directory.
And finally, set TNS_ADMIN to the directory where you have created and saved the tnsnames.ora file. I chucked my tnsnames.ora into the instantclient_10_2 directory so it was all contained.
Then it just works.
Magic!
3 comments:
Hi Steve, just found your blog and I like it ... and I like Instant Client too! I've written about it on
my blog too, where I also posted a little helper script that reorganises the Linux Instant Client installation a little to make it easier for C/C++ development (making it consistent with a full-blown client or server install).
It may not 'just work'. You were simply lucky!
You need to ad something like:
set NLS_LANG=american_america.WE8PC850
to your script as recommeded by
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410552
(search for 'Before using an Oracle command line tool ')
Tony Eastwood
ace@Etlsolutions.com
Lucky is as lucky does I guess -- I've never had to set that to run any of our command line tools.
Post a Comment