On Fri, 27 Feb 2004, Matt Alexander wrote: On Fri, 27 Feb 2004, Mike wrote: > Why, why, why do they all have to make life difficult to install, config, and > run an APPLICATION? > Before I blow a gasket, if anyone out there knows how to get Oracle 9i client > running and SQL+ configured with tnsnames please contact me.... I am losing > hair! This is so simple to do in a win environment, why must we keep it > complicated? I've got an easy solution for you that I just figured out. :-D Download and install the following two RPMs for the 10g Instant Client: oracle-instantclient-basic-10.1.0.2-1.i386.rpm oracle-instantclient-sqlplus-10.1.0.2-1.i386.rpm Next, copy your tnsnames.ora somewhere. Here's where I put mine: /usr/lib/oracle/10.1.0.2/network/admin/tnsnames.ora You'll need to create the network/admin directories because they're not created by default with the RPM installation. Next, set TNS_ADMIN in your .bash_profile so sqlplus can find your tnsnames.ora: export TNS_ADMIN=/usr/lib/oracle/10.1.0.2/network/admin Now you can run sqlplus. :-) Let me know if you encounter any further problems. ~M --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change you mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss