Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: can not sqlnet in local server

Re: can not sqlnet in local server

From: <rspeaker_at_my-deja.com>
Date: Wed, 23 Jun 1999 13:49:16 GMT
Message-ID: <7kqoko$7bd$1@nnrp1.deja.com>


hi,

first, if you are locally on the server, you should not need the @sales_db connect string. Set the environment variable ORACLE_SID=sales_db, and simply issue $sqlplus scott/tiger.

however, if you specifically want to connect using the @sales_db string, make sure your local tnsnames.ora file contains an entry for the local database.

HTH,
Roy

In article <7kq5o4$1f3$1_at_news6.jaring.my>,   "william" <stamfod_at_po.jaring.my> wrote:
> hi, i can not sqlnet in local server. i try to type $sqlplus
> scott/tiger_at_sales_db
> it said, tns: could not resolve service name. what is that?
> how to solve it. thanks
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 08:49:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US