Help: Got stuck when start SQL*Net
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 C4Received on Sat Apr 27 1996 - 00:00:00 CEST