Help: Got stuck when start SQL*Net

From: Tang Wai Shing Wilson <cswstang_at_cs.ust.hk>
Date: 1996/04/27
Message-ID: <4lt9ai$ddu_at_ustsu10.ust.hk>#1/1


Hi Oracle Guru,

I got stuck when my Oracle server (Oracle 7.2.3, SQL*Net 2.2, over Sparc20, Solaris 2.4) got reboot. When I start the lsnrctl, it stuck with error:

Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=CS.ust.hk))) TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error
  SVR4 Error: 80: Name not unique on network

Here's part of the trace file:

....
Resolved "CONNECT_TIMEOUT_LISTENER" to: 10 Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0 (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=CS.ust.hk))) KEY = CS.ust.hk
opening transport...
-<ERROR>- sd=8, op=1, resnt[0]=530, resnt[1]=80, resnt[2]=0
-<ERROR>- nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=80, nt[2]=0
-<ERROR>- unable to open transport

Deallocating cxd 0x1a52b8.
-<ERROR>- Reporting the following error stack:
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error
  SVR4 Error: 80: Name not unique on network ...

Trying lot of stuff I finally comment out the IPC section of the listener.ora and it works! Here is my listener:

LISTENER =
  (ADDRESS_LIST =

#        (ADDRESS=
#         (PROTOCOL=IPC)
#         (KEY= CS.ust.hk)
#        )
#       (ADDRESS=
#         (PROTOCOL=IPC)
#         (KEY= ORACLE_CS)
#        )
        (ADDRESS =
          (COMMUNITY = cs.ust.hk)
          (PROTOCOL = TCP)

...

Well, though it works, but it is much slower. My listener.ora works at Day 1. Any idea the reason behind? Thanks.

Wilson.

--
---
Tang Wai Shing, Wilson		Email: cswstang_at_cs.ust.hk
Dept. of Computer Science, 	Tel# : (852)-2358-7004  Fax: (852)-2358-1477
HKUST, Clear Water Bay Road,    Fingerprint: 	54 8D 55 F5 B5 1E AC 7E  
Hong Kong.					80 40 23 18 8B 8C ED C4
Received on Sat Apr 27 1996 - 00:00:00 CEST

Original text of this message