Re: help! trouble configuring Listener on linux

Sybrand Bakker wrote:
>
> Hi Matthias,
>
> The listener is smart enough to discover this is a local connection and
> doesn't use the tcp protocol, but the ipc protocol instead. The IPC
> protocol is directly communicating with the sga, somehow your client
> doesn't have privilege to work with the sga. The protection of
> $ORACLE_HOME/dbs/sgamnct1.dbf probably is wrong. I don't know all the
> correct chmod settings from the top of my head, but that's the direction
> to delve into.
>

hi,

thanks for this suggestion. I checked that but it seems not be the problem, sgamcnt1.dbf is of "oracle.dba" ownership. The listener runs as user "oracle".

also the problem persists when I connect from a remote machine (ORACLE not available).

matthias

> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Matthias Suencksen wrote:
>
> > Oracle keeps saying: ORA-1034 Oracle not available
> > when I connect via user/pass_at_tcp-loopback.world
> >
> > The database IS running and I can connect via user/pass :
> >
> > 1920 ? S 0:00 ora_pmon_MCNT1
> > 1922 ? S 0:00 ora_dbw0_MCNT1
> > 1924 ? S 0:00 ora_lgwr_MCNT1
> > 1926 ? S 0:00 ora_ckpt_MCNT1
> > 1928 ? S 0:00 ora_smon_MCNT1
> > 1930 ? S 0:00 ora_reco_MCNT1
> > 3518 ? S 0:00 /opt/oracle8/app/oracle/product/8.0.5//bin/tnslsnr
> >
> > The tnslistener is running. here is the config:
> >
> > nostromo_lsnr=
> > (
> > ADDRESS_LIST=
> > (ADDRESS=
> > (PROTOCOL=TCP)
> > (HOST=127.0.0.1)
> > (PORT=1526)
> > )
> > (ADDRESS=
> > (PROTOCOL=IPC)
> > (KEY=MCNT1)
> > )
> > )
> >
> > SID_LIST_nostromo_lsnr=
> > (SID_LIST=
> > (SID_DESC=
> > (SID_NAME=MCNT1)
> > (ORACLE_HOME=/disk4/oracle/oracle8/app/oracle/product/8.0.5)
> > )
> > )
> >
> > and tnsnames.ora:
> >
> >
> > Tcp-loopback.world =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS =
> > (COMMUNITY = tcp.world)
> > (PROTOCOL = TCP)
> > (Host = 127.0.0.1)
> > (Port = 1526)
> > )
> > )
> > (CONNECT_DATA = (SID=MCNT1)
> > )
> > )
> >
> > What I am doing wrong ??
> >
> > Matthias
> >
> > --
> > Out-of-order Execution
> > (Feature von modernen Microprozessoren)
>
> ------------------------------------------------------------------------
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl>
>
> Sybrand Bakker
> <postbus_at_sybrandb.demon.nl>
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Bakker
> First Name Sybrand
> Version 2.1

--
Out-of-order Execution

        (Feature von modernen Microprozessoren) Received on Fri Dec 04 1998 - 13:17:11 CST