Progress I love it!!!
Ok, so now when I start sqlplus I try to login, but I get an error

ORA-12162: TNS:net service name is incorrectly specified

So I went back to /usr/lib/oracle/10.1.0.2/network/admin/tnsnames.ora and I 
removed the other tnsnames, ie 119dp and 164, as I got the file from the 
cisora website. When you login thru windows it asks you for the host string, 
in linux it is not, so to avoid the confusion, I removed the other 
possibilities. Also I am using SuSE so .bash_profile didn't exist so I 
modified .bashrc and .profile, as well as .bash_profile_swp

On Saturday 28 February 2004 11:25 am, Matt Alexander wrote:
> On Sat, 28 Feb 2004, Mike wrote:
> > > 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!
>
> The .bash_profile is in your home directory and is executed when you
> login.  You can use vi or any other text editor to modify this file.  Any
> file that stars with a "dot" is hidden from the ls command unless you
> provide the -a option.  So in your home directory, type:
>
> ls -a
>
> You'll see a lot of hidden config files.  Edit .bash_profile and save your
> changes.  Next, logout and log back in and you should be golden.
> ~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:42am  up 73 days 18:54,  4 users,  load average: 0.52, 0.42, 0.69
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