Re: TNS Listener starting problems

In article <D9EnpE.CAv_at_sovinfo.UUCP> pdavidov_at_sovinfo.gmsys.com writes:

>Hello All,
 

>We have Oracle 7 installed on SCO UNIX platform and
>SQL*NET V2. According the installation log, V2 IPC protocol adapter has
>been installed but if I include a line like:
> (ADDRESS=(PROTOCOL=IPC)(KEY=TEST)),
>where TEST is the service name in the LISTENER parameter file,
>I can not start the listener. The error messages I have after the listener
>start command are:
 

> Attempted to listen on:(Description=(CONNECT=(CONNECT_TIMEOUT=10)
> (ADDRESS=(PROTOCOL=IPC)(KEY=TEST)))
> TNS-12560:TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> AT&T System V386 Error 97: Protocol not supported.
 

> The listener works normally if I include just the TCP communication
>address.
 

> Can anybody help me?

No, but I can empathize.
We have a very similar problem only with Oracle 7.1.4 on Solaris 2.4 . With us it is intermittent. Sometimes it works; sometimes it doesn't. When it doesn't work, it doesn't work on all. When it works, it works on all (we have 7 Solaris 2.4 Servers) We also have Oracle running on 2 HPUX 9.05 Servers where the same LISTENER parameter file works just fine. We were able to solve the problem on Solaris 2.4 only by commenting out the IPC section. We had a tar with Oracle about it. They haven't a clue. They told us that the IPC section is there to support the multi-threaded Server (this is completely undocumented in our on-line netman documentation) and that SQLNet V2.1 should run without it. I would love to get a better answer.

Hal

beumer_at_nosc.mil Received on Wed May 31 1995 - 00:00:00 CEST