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 Sat, 28 Feb 2004, Mike wrote:

> 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...


In Linux you can specify it like this:

sqlplus username/password@connect-string

or...

sqlplus username@connect-string

or...

Set the default environment variable to always use your particular
connect-string in your profile config file:

export TWO_TASK=cis119abc



---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss