Re: Oracle woes

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Matt Alexander
Date:  
To: plug-discuss
Subject: Re: Oracle woes
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 -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss