On Saturday 28 February 2004 11:02 am, Matt Alexander wrote: > 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 I got this far! I searched all night for this file, and never found it... Thanks for the tip!!!! > > 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: To do this I need to know where or how to modify the profile. I need to know either the path to .bash_profile or am I modifying it frrom the command line in a terminal, using vi ? I am able to start splplus now, it just doesn't know where to connect to! > > 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 -- 11:07am up 73 days 18:20, 5 users, load average: 0.84, 0.57, 0.25 Linux linux 2.4.20-4GB #1 Mon Mar 17 17:54:44 UTC 2003 i686 unknown unknown GNU/Linux --------------------------------------------------- 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