Re: SQL*Net problem with Oracle 8.0.3/Solaris 2.5

From: Hartmann <hartmann_at_systemconsult.de>
Date: 1998/06/09
Message-ID: <357D08C0.1FA3A860@systemconsult.de>#1/1

Pluton wrote:

> >However "sqlplus vvd/vvd_at_viva" does not work: ORA-12154: TNS:could not
> resolve service name.
>
> "viva" service is not present in your tnsnames.ora. Check this file first.
>
> Hope it helps....

Actually it is. Here is the corresponding extract from my ORACLE_HOME/network/admin/tnsnames.ora file:

viva =
  (DESCRIPTION =
    (ADDRESS =

          (PROTOCOL = TCP)
          (HOST = sun01)
          (PORT = 1521)

    )
    (CONNECT_DATA = (SID = viva)(GLOBAL_NAME=viva)     )
  )

Andre. Received on Tue Jun 09 1998 - 00:00:00 CDT