Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help! trouble configuring Listener on linux
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.
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)
Received on Thu Dec 03 1998 - 15:55:43 CST