Re: SQL*NET:Listener refuses connection, please help!

From the listener trace file you can already see the listener doesn't start properly, so it's not suprising the connect doesn't work There are a few strange things in the listener.ora 1 afaik the key in the ipc block should be the sid, this is translated to a number automatically and randomly. In your case P01 2 the port number in the tcp block is strange. It should be 1521 or 1526. 3 The sequence of port and host is strange: it should be the other way around. Then we look at strange results in listener.trc (nepton.trc in your case): There is reference to the bequeath protocol with as parameter local=no. As the bequeath protocol is using interprocess communication it only runs on the server, it doesn't support connections between host. Then this all doesn't completely resolve the mystery. Please change your listener.ora as outlined above and try again and let us know the results.

Hth,

Sybrand Bakker, oracle dba

haddadiank_at_my-dejanews.com wrote:

> I have an Oracle Server(Oracle 7.0.15) over UNIX (SCO 3v4.2).
> I also have another UNIX box which I want to be the client.
> When I invoke the following command:
> sqlplus <user>/<passwd>@nepton
> from the client, the listener refuses the connection.
> I wonder if someone tell me what is wrong with the server
> configuration files which in included below.
> The log and trace files are also included.
>
> Thank you for taking your time.
>
> - Kawa Haddadian
>
> #
> # listener.ora
> #
> nepton =
> (ADDRESS_LIST =
> ( ADDRESS =
> (PROTOCOL=tcp)
> (PORT=1540)
> (HOST=nepton)
> )
> (ADDRESS =
> (PROTOCOL=ipc)
> (KEY=700)
> )
> )
> #
> SID_LIST_nepton=
> (SID_DESC=
> (SID_NAME=P01)
> (ORACLE_HOME=/u/oracle)
> )
> TRACE_LEVEL_nepton=ADMIN
>
> #***********************************************************************
> #
> # nepton.log
> #
>
> TNSLSNR for AT&T System V/386: Version 2.0.14.0.0 - Production on 01-OCT-98
> 11:56:12
>
> Copyright (c) Oracle Corporation 1993. All rights reserved.
>
> System parameter file is /etc/listener.ora
> Log messages written to /u/oracle/network/log/nepton.log
> Trace information written to /u/oracle/network/trace/nepton.trc
> Trace level is currently 6
>
> Listening on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=tcp)(PORT=1540)(HOST=nept
> on))) Listening on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=ipc)(KEY=700))) TIMESTAMP
> ** EVENT [** SID] ** RETURN CODE 01-OCT-98 11:56:12 ** status ** 0 01-OCT-98
> 11:57:12 ** establish ** P01 ** 12500 TNS-12500: TNS:listener failed to start
> a dedicated server process TNS-12538: TNS:no such protocol adapter
> TNS-00504: Operation not supported
>
> #***********************************************************************
> #
> # nepton.trc
> #
>
> TNSLSNR for AT&T System V/386: Version 2.0.14.0.0 - Production on 01-OCT-98
> 11:56:12
>
> Copyright (c) Oracle Corporation 1993. All rights reserved.
>
> --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
> New trace stream is "/u/oracle/network/trace/nepton.trc"
> New trace level is 6
> --- TRACE CONFIGURATION INFORMATION ENDS ---
>
> --- PARAMETER SOURCE INFORMATION FOLLOWS ---
> Attempted load of system pfile source /etc/listener.ora
> Parameter source loaded successfully
>
> Attempted load of command line source
> Parameter source was not loaded
>
> -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
> -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <- TRACE_LEVEL_nepton = ADMIN
> nepton = (ADDRESS_LIST = ( ADDRESS = (PROTOCOL=tcp) (PORT=1540)
> (HOST=nepton)) (ADDRESS = (PROTOCOL=ipc) (KEY=700))) SID_LIST_nepton =
> (SID_DESC= (SID_NAME=P01) (ORACLE_HOME=/u/oracle)) --- PARAMETER SOURCE
> INFORMATION ENDS ---
>
> --- LOG CONFIGURATION INFORMATION FOLLOWS ---
> Attempted open of log stream "/u/oracle/network/log/nepton.log"
> Successful stream open
> --- LOG CONFIGURATION INFORMATION ENDS ---
>
> (ADDRESS=(PROTOCOL=beq)) No process parameters set inheriting the
> connection... opening transport... NT layer IPC connection has been
> established. transport is open global context check-in (to slot 0) complete
> doing connect handshake... 127 bytes from transport got NSPTCN packet
> discarding connect data (99 bytes) connection inherited connected Resolved
> "CONNECT_TIMEOUT_nepton" to: 10 Resolved "STARTUP_WAIT_TIME_nepton" to: 0
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=tcp)(PORT=1540)(HOST=nept
> on))) port resolved to 1540 looking up IP addr for host: nepton opening
> transport... transport is open global context check-in (to slot 1) complete
> Listening on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=tcp)(PORT=1540)(HOST=nept
> on))) (ADDRESS=(PROTOCOL=tcp)(PORT=1540)(HOST=nepton)(PARTIAL=yes)) opening
> transport... transport is open global context check-in (to slot 2) complete
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=ipc)(KEY=700))) KEY = 700
> opening transport... transport is open global context check-in (to slot 3)
> complete Listening on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=ipc)(KEY=700))) begin
> registration process for 1 begin notification process for 1 registering for
> 0x1 initialising for event signal handling begin registration process for 3
> begin notification process for 3 registering for 0x1 sending NSPTAC packet 24
> bytes to transport sending 406 bytes connect data 406 bytes to NS buffer 416
> bytes to transport flushing transport connect handshake is complete NTOBROKEN
> not supported by transport 0 event(s) posted waiting for transport event... 1
> event(s) posted event is 0x1, on 1 opening transport... waiting to accept a
> connection. transport is open global context check-in (to slot 4) complete
> doing connect handshake... 137 bytes from transport got NSPTCN packet command
> = status sending NSPTAC packet 24 bytes to transport sending 325 bytes
> connect data 325 bytes to NS buffer 335 bytes to transport flushing transport
> connect handshake is complete asking transport to enable NTOBROKEN 33 bytes
> to NS buffer 43 bytes to transport flushing transport 10 bytes to transport
> closing transport global context check-out (from slot 4) complete 0 event(s)
> posted waiting for transport event... 1 event(s) posted event is 0x1, on 1
> opening transport... waiting to accept a connection. transport is open global
> context check-in (to slot 4) complete doing connect handshake... 169 bytes
> from transport got NSPTCN packet command = establish
> (ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ARGV0=oracleP01)(ARGS='(LOCAL=NO)')(S
> ID_NAME=P01)(ORACLE_HOME=/u/oracle)(ENVS='ORACLE_HOME=/u/oracle,PATH=/u/oracl
> e/bin/,ORACLE_SID=P01')) connecting... -<ERROR>- about to exec oracle
> -<ERROR>- environ[0] = "ORACLE_HOME=/u/oracle" -<ERROR>- environ[1] =
> "PATH=/u/oracle/bin/" -<ERROR>- environ[2] = "ORACLE_SID=P01" result string
> is NTP0 1421 hdl[IR]=15, hdl[IW]=14 NT layer IPC connection has been
> established. doing connect handshake... NSE=12538 -<ERROR>- nsres: id=4,
> op=8, ns=12538, ns2=0; nt[0]=504, nt[1]=0, nt[2]=0 sending NSPTRF packet 172
> bytes to transport closing transport global context check-out (from slot 4)
> complete Deallocating cxd 0x4754dc. 0 event(s) posted waiting for transport
> event...
>
> #***********************************************************************
> #
> # sqlnet.log
> #
> Fatal OSN connect error 12538, connecting to:
> (LOCAL=NO)
>
> VERSION INFORMATION: TNS for AT&T System V/386: Version 2.0.14.0.0 -
> Developer's Release Unix Domain Socket IPC NT Protocol Adaptor for AT&T
> System V/386: Version 2.0.14.0.0 - Developer's Release Oracle Bequeath
> NT Protocol Adapter for AT&T System V/386: Version 2.0.14.0.0 - Developer's
> Release Time: 01-OCT-98 11:57:12 Tracing not turned on. Tns error struct:
> nr err code: 0 ns main err code: 12538 TNS-12538: TNS:no such protocol
> adapter ns secondary err code: 12560 nt main err code: 508 TNS-00508: No
> such protocol adapter nt secondary err code: 0 nt OS err code: 0
> #***********************************************************************
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Oct 03 1998 - 02:48:10 CDT