SQL*Net problem with Oracle 8.0.3/Solaris 2.5

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

Hi,

I installed the Oracle 8.0.3 environment on Sun SPARC, Solaris 2.5 with SQL*Net and configured tnsnames.ora etc. correctly (I think). I started up an instance and a TNS listener using the lsnrctl. On testing the connection with
Net8 Assistant I get an error message:

C: Trying:
vvd/vvd@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sun01.systemconsult.de)(PORT=1521))(CONNECT_DATA=(SID=viva)))

Logon failure
ORACLE error
ORA-01034: ORACLE not available

eventhough SID and user/pwd are correct ... checked with sqlplus and it works (setenv ORACLE_SID viva; sqlplus user/pwd). However "sqlplus vvd/vvd_at_viva" does not work: ORA-12154: TNS:could not resolve service name.

What is the problem ?? Did I forget some configuration/installation part ????

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