Xref: alice comp.databases.oracle.server:39580 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.novia.net.MISMATCH!novia!sequencer.newscene.com!not-for-mail From: gtran@karavela.com Newsgroups: comp.databases.oracle.server Subject: TNS-12545 error, OpenVMS Date: 2 Feb 1999 11:52:02 -0600 Organization: Newscene Public Access Usenet News Service (http://www.newscene.com/) Lines: 252 Message-ID: <36b73494.529551705@news2.newscene.com> X-Newsreader: Forte Agent 1.5/32.451 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. --- TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "disk2:[oracle7.network.trace]listener.trc" New trace level is 6 --- TRACE CONFIGURATION INFORMATION ENDS --- --- PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source TELPAZ$DKA200:[ORACLE7.NETWORK.ADMIN]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 <- 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 --- --- LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "DISK2:[ORACLE7.network.log]listener.log" Log stream validation requested Log stream is valid --- 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... 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 -- soc -1 error - operation=3, ntresnt[0]=515, ntresnt[1]=49, ntresnt[2]=5 -- nsres: id=0, op=65, ns=12545, ns2=12560; nt[0]=515, nt[1]=49, nt[2]=5 -- unable to open transport Deallocating cxd 0x28cd70. -- 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