Re: can not sqlnet in local server

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 24 Jun 1999 09:09:59 +0200
Message-ID: <7kslhr$l1u$1@news3.saix.net>

william wrote in message <7kq5pt$1np$1_at_news6.jaring.my>...
>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?

Exactly what it says - the TNS name/alias (sales_db in your case) can not be resolved. IOW, Oracle has no clue how to connect to that database alias.

>how to solve it. i already start the lsnrctl. thanks

Nothing to do with the listener as the error is on the client (i.e. SQL*Plus) side and not the server (i.e. listener or db instance) side.

To fix - edit the file TNSNAMES.ORA in your ORACLE_HOME/network/admin directory and create an alias called sales_db that points to your local database.

regards,
Billy Received on Thu Jun 24 1999 - 02:09:59 CDT