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

mandrew_at_my-dejanews.com wrote:

> > 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

  Thanx for the response :)

  The instance itself is definitely up and running. I can connect to it via sqlplus when having set ORACLE_SID to viva: "sqlplus vvd/vvd" is successful. In tnsnames.ora the global database viva.systemconsult.de is declared but "sqlplus vvd/vvd_at_viva.systemconsult.de" fails saying:

SQL*Plus: Release 8.0.3.0.0 - Production on Wed Jun 10 11:38:19 1998

(c) Copyright 1997 Oracle Corporation. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory

and the $ORACLE_HOME/network/log/listener.log saying

10-JUN-98 11:39:59 *
(CONNECT_DATA=(SID=VIVA)(GLOBAL_DBNAME=viva.systemconsult.de)(CID=(PROGRAM=)(HOST=sun01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=194.195.169.201)(PORT=32820)) * establish * VIVA * 0

as if everything went okay.

I find this strange but I still think (hope) I've simply forgotten something... do I have to set TWO_TASK and TNS_ADMIN and if so to what values ? Received on Wed Jun 10 1998 - 04:42:46 CDT