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
(text/plain)