Re: SQL NET connection error oracle 7.0.16 on AIX

In article <cX4Z1.104$IR2.436_at_wagner.videotron.net>,   "Jean-Luc Duval" <jlduval_at_univoc.ca> wrote:
> I'm using Oracle 7.0.16 i set up a listener from a database server, and if i
> try to connect to the database via the network or localy i receive the
> message:
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> IBM AIX RISC System/6000 Error: 2: No such file or directory
>
> this in the listener.ora entry
>
> LISTENER_PIL=
> (ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=georges)
> (PORT=1521)
> )
> )
>
> STARTUP_WAIT_TIME_LISTENER_PIL = 0
> CONNECT_TIMEOUT_LISTENER_PIL = 10
>
> SID_LIST_LISTENER_PIL=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=PIL)
> (ORACLE_HOME=/home/oracle/product/7.0.16)
> )
> )
>
> this is the tnsnames.ora entry:
>
> PIL =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = georges)
> (Port = 1521)
> )
> (CONNECT_DATA =
> (SID = PIL)
> )
> )
>
> the stiky bit of oracle and oracle0 have been set, the listener is started.
> if you have an idea
>
> Jean-Luc Duval
>
>

Hi,

 Make sure that the Oracle database you are connecting to is up and running.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 09:55:50 CST