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

Home -> Community -> Usenet -> c.d.o.misc -> HELP, OpenVMS, TNS-12545 error

HELP, OpenVMS, TNS-12545 error

From: <gtran_at_karavela.com>
Date: 4 Feb 1999 11:31:01 -0600
Message-ID: <36bbd941.25570818@news2.newscene.com> 





Hello,



I need a help, want to connect to Oracle server on Alpha/OpenVMS from
my NT/Oracle8 client. There is a problem with starting listener
process on OpenVMS side.



Oracle people installed Oracle7 Server Release 7.1.5.2.3 on our
Alpha/OpenVMS server.



When I want to start listener process I get the following messages:




LSNRCTL> start


Starting TELPAZ$DKA200:[ORACLE7.NETWORK]tnslsnr: please wait...



TNSLSNR for VMS: Version 2.1.5.1.0 - Production
System parameter file is


TELPAZ$DKA200:[ORACLE7.NETWORK.ADMIN]listener.ora
Log messages written to DISK2:[ORACLE7.network.log]listener.log
Trace information written to disk2:[oracle7.network.trace]listener.trc
Listening on:


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=ipc)(key=tkk8.


world)))


Listening on:


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=ipc)(key=tkk8)


))


Attempted to listen on:


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=TCP)


(Host=192.168.16.66)(port=1521)))




TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error


  TNS-00515: Connect failed because target host or object does not
exist


   VMS Error: 5: i/o error




Obviously, TCP protocol listener was not started correctly.
When I try to start listener from DCL level I get only:




$ lsnrctl start


%RUN-S-PROC_ID, identification of created process is 000026B7
LSNRCTL: listener has been started




But there is no such process existing!




The LISTENER.ORA is listed bellow




listener = (address_list =

              (address = 
		(protocol = ipc)
	        (key = tkk8.world)
              )
	      (address = 
		(protocol = ipc)
	        (key = tkk8)
              )
		(address =
		  (protocol = TCP)
		  (Host = 192.168.16.66)
		  (port = 1521)
		)
		(address =
		  (protocol = TCP)
		  (Host = 192.168.16.66)
		  (port = 1526)
		)
           )




startup_wait_time_listener = 0


connect_timeout_listener = 10

trace_directory_listener = disk2:[oracle7.network.trace]
trace_file_listener = listener
trace_level_listener = admin
sid_list_listener = 
             (sid_list=
                (sid_desc=
                   (sid_name=tkk8)



(program='disk2:[oracle7.network.admin]orasrv_netv2.com')


                   (timeout = 0)
                )
             )
-----------------------------




The LISTENER.TRC is listed bellow





TNSLSNR for VMS: Version 2.1.5.1.0 - Production on 02-FEB-99 16:56:23



Copyright (c) Oracle Corporation 1994.  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 <-
  startup_wait_time_listener = 0


  trace_file_listener = listener


  connect_timeout_listener = 10


  trace_directory_listener = disk2:[oracle7.network.trace]
  trace_level_listener = admin


  listener = (address_list = (address = (protocol = ipc) (key =

tkk8.world)) (address = (protocol = ipc) (key = tkk8)) (address =




(protocol = TCP) (Host = 192.168.16.66) (port = 1521)) (address =


(protocol = TCP) (Host = 192.168.16.66) (port = 1526)))


  sid_list_listener = (sid_list= (sid_desc= (sid_name=tkk8)


(program='disk2:[oracle7.network.admin]orasrv_netv2.com') (timeout =


0)))


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


34 bytes from transport


got NSPTCN packet


recving connect data


260 bytes from transport


250 bytes from NS buffer


discarding connect data (250 bytes)


connection inherited


connected


Resolved "CONNECT_TIMEOUT_LISTENER" to: 10
Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=ipc)(key=tkk8.world)))



a[0]=(null)
a[1]=(null)
a[2]=(null)
a[3]=tkk8.world
a[4]=(null)
a[5]=(null)
a[6]=(null)
a[7]=(null)




ntmadmb1=tkk8.world


opening transport...


transport is open


global context check-in (to slot 1) complete
Listening on:


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=ipc)(key=tkk8.world)))


(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))



a[0]=(null)
a[1]=(null)
a[2]=(null)
a[3]=(null)
a[4]=(null)
a[5]=(null)
a[6]=(null)
a[7]=(null)




opening transport...


transport is open


global context check-in (to slot 2) complete


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=ipc)(key=tkk8)))



a[0]=(null)
a[1]=(null)
a[2]=(null)
a[3]=tkk8
a[4]=(null)
a[5]=(null)
a[6]=(null)
a[7]=(null)




ntmadmb1=tkk8


opening transport...


transport is open


global context check-in (to slot 3) complete
Listening on:


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=ipc)(key=tkk8)))


(DESCRIPTION=(CONNECT_TIMEOUT=10)(address=(protocol=TCP)(Host=192.168.16.66)(port=1521)))


port resolved to 1521


using host IP address: 192.168.16.66


opening transport...


No PROTOCOL.ORA file is found


Validnode Table IN use; err 0x0


-<ERROR>- 


soc -1 error - operation=3, ntresnt[0]=515, ntresnt[1]=49,
ntresnt[2]=5


-<ERROR>- 


nsres: id=0, op=65, ns=12545, ns2=12560; nt[0]=515, nt[1]=49, nt[2]=5
-<ERROR>- 


unable to open transport


Deallocating cxd 0x28cd70.


-<ERROR>- 


Reporting the following error stack:


TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error


  TNS-00515: Connect failed because target host or object does not
exist


   VMS Error: 5: i/o error


sending NSPTRF packet


12 bytes to transport


sending 754 bytes connect data


502 bytes to NS buffer


512 bytes to transport


252 bytes to NS buffer


no timer allocated


262 bytes to transport


closing transport


global context check-out (from slot 0) complete
no timer allocated


closing transport


global context check-out (from slot 2) complete
no timer allocated


closing transport


global context check-out (from slot 1) complete
Deallocating cxd 0x265cf8.


no timer allocated


closing transport


global context check-out (from slot 3) complete
Deallocating cxd 0x28b8a0.




The TNSNAMES.ORA is listed bellow




tkk8 =

           (description =
		(address = 
		  (protocol = TCP)
		  (Host = 192.168.16.66)
		  (port = 1521)
		)
		(address = 
		  (protocol = TCP)
		  (Host = 192.168.16.66)
		  (port = 1526)
		)
	     (connect_data = (sid = tkk8))
	   )
-----------------------------






Does anybody know what the problem is or could be ?
I would appreciate any help. 


Thanks for being patient.



goran
Received on Thu Feb 04 1999 - 11:31:01 CST












Original text of this message













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