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

From: <mandrew_at_my-dejanews.com>
Date: Tue, 09 Jun 1998 14:29:11 GMT
Message-ID: <6ljgrn$ld4$1@nnrp1.dejanews.com>

In article <357D0017.BDB8ABD5_at_systemconsult.de>, Hartmann <hartmann_at_systemconsult.de> wrote:
>
> 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

This usually results from the database not being started. Try shutting down the database and startup open in server manager.

Try that then worry about connecting through SQL*Plus
>
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 09 1998 - 09:29:11 CDT