Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*NET:Listener refuses connection, please help!

SQL*NET:Listener refuses connection, please help!

From: <haddadiank_at_my-dejanews.com>
Date: Sat, 03 Oct 1998 05:51:50 GMT
Message-ID: <6v4e1m$3io$1@nnrp1.dejanews.com> 





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.






#


#	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.







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 ---





(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 - 00:51:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US