Re: need help with sql*plus
Date: Thu, 01 Apr 1999 14:00:18 GMT
Message-ID: <37037CB6.60C7524_at_sympatico.ca>
Try the TNSPING utility.
It's like a TCP/IP ping but at the SQL*Net level.
If this does not work, your SQL*Net config is wrong. Check your tnsnames.ora file.
If this works, SQL*Plus has a problem. Post again on a newsgroup..... ;-)
Regards,
Marc Mazerolle
Peter Choe wrote:
> i installed orcale lite on a windows nt workstation so that i can use
> sql*plus. i set up the net config as instructed. but when i try to
> connect i get the following error message:
>
> SQL*Plus: Release 3.3.3.0.0 - Production on Thu Apr 01 08:48:39 1
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved
>
> ERROR: ORA-12154: TNS:could not resolve service name
>
> Enter user-name:
>
> when i tested it using net config, it said it was ok. i can ping the
> server so i know that, that is working. does anyone have any
> suggestions?
>
> thanks for any help
> peter
Received on Thu Apr 01 1999 - 16:00:18 CEST