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 -> NET8 interrupt marker error

NET8 interrupt marker error

From: Lacroix Pascale <placroix_at_ingr.com>
Date: 28 Sep 2001 02:12:04 -0700
Message-ID: <16e18e99.0109280112.35d81a4a@posting.google.com> 





I am running Oracle 8iEE with OraOLEDB 8.1.7 (and ORAMTS) and Net8
8.1.7.



My application is running on the server machine and I got problems
with procedure returning RAW data.



here are my net8 files:




# LISTENER.ORA Network Configuration File:
F:\oracle\ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.



LISTENER =



  (DESCRIPTION_LIST =



    (DESCRIPTION =



      (ADDRESS = (PROTOCOL = TCP)(HOST = coc_symbol)(PORT = 1521))

    )


    (DESCRIPTION =



      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))


    )


  )



SID_LIST_LISTENER =



  (SID_LIST =



    (SID_DESC =



      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = F:\oracle\ora81)

      (PROGRAM = extproc)



    )


    (SID_DESC =



      (GLOBAL_DBNAME = SP3DV3)


      (ORACLE_HOME = F:\oracle\ora81)

      (SID_NAME = SP3DV3)




    )


  )



TRACE_LEVEL_LISTENER = USER






# SQLNET.ORA Network Configuration File:
F:\oracle\ora81\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.



SQLNET.AUTHENTICATION_SERVICES= (NTS)


TRACE_LEVEL_CLIENT = SUPPORT


TRACE_LEVEL_SERVER = USER


NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)






# TNSNAMES.ORA Network Configuration File:
F:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.



SP3DV3 =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = COC_SYMBOL)(PORT = 1521))


    )


    (CONNECT_DATA =



      (SERVICE_NAME = SP3DV3)




    )


  )


####################################




# Date..........: Tue Jul 31 13:53:02 CEST 2001

####################################





EXTPROC_CONNECTION_DATA =



  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC))

    )


    (CONNECT_DATA =



      (SERVICE_NAME = extproc)

      (PRESENTATION = RO)




    )


  )





Here are the procedure ,table and the command accessor I used:




CREATE TABLE COREUserLogin (

	InstanceId RAW(16) NOT NULL ,
	UserLogin NVARCHAR2(256) NOT NULL 




)


/



CREATE OR REPLACE PROCEDURE COREGetCurrentUserIdProc
(


        p_InstanceId OUT RAW


)


as


BEGIN



select InstanceId into p_InstanceId from COREUserLogin where UserLogin
= TRANSLATE(USER USING NCHAR_CS) ;



EXCEPTION



WHEN NO_DATA_FOUND THEN



        select SYS_GUID() into p_InstanceId from DUAL;
WHEN OTHERS THEN



        raise_application_error(-20101,'ERROR: Unhandled exception in
COREGetCurrentUserIdProc');


END;



/



class CdboLoginAccessor


{


public:


        char m_InstanceId[33];



        DEFINE_COMMAND(CdboLoginAccessor,"{call 
COREGetCurrentUserIdProc(?)}");



BEGIN_PARAM_MAP(CdboLoginAccessor)

	SET_PARAM_TYPE(DBPARAMIO_OUTPUT) 
		COLUMN_ENTRY(1, m_InstanceId) 




END_PARAM_MAP()



};



and here is the client trace file for this command:


(1052) nspsend: 00 E2 00 00 06 01 00 00  |........|
(1052) nspsend: 00 00 03 5E CB 29 04 04  |...^.)..|
(1052) nspsend: 00 00 00 00 00 D8 C6 FE  |........|
(1052) nspsend: 01 2A 00 00 00 78 FE FB  |.*...x..|
(1052) nspsend: 01 0A 00 00 00 00 00 00  |........|
(1052) nspsend: 00 9C FE FB 01 00 00 00  |........|
(1052) nspsend: 00 01 00 00 00 00 00 00  |........|
(1052) nspsend: 00 18 C6 FE 01 01 00 00  |........|
(1052) nspsend: 00 00 00 00 00 00 00 00  |........|
(1052) nspsend: 00 00 00 00 00 00 00 00  |........|
(1052) nspsend: 00 9E FE FB 01 2A 42 45  |.....*BE|
(1052) nspsend: 47 49 4E 20 43 4F 52 45  |GIN CORE|
(1052) nspsend: 47 45 54 43 55 52 52 45  |GETCURRE|
(1052) nspsend: 4E 54 55 53 45 52 49 44  |NTUSERID|
(1052) nspsend: 50 52 4F 43 28 20 3A 31  |PROC( :1|
(1052) nspsend: 20 29 3B 20 45 4E 44 3B  | ); END;|
(1052) nspsend: 01 00 00 00 01 00 00 00  |........|
(1052) nspsend: 00 00 00 00 00 00 00 00  |........|
(1052) nspsend: 00 00 00 00 00 00 00 00  |........|
(1052) nspsend: 00 00 00 00 08 00 00 00  |........|
(1052) nspsend: 00 00 00 00 04 00 00 00  |........|
(1052) nspsend: 01 60 03 00 00 0B 00 00  |.`......|
(1052) nspsend: 00 00 00 00 00 10 00 00  |........|
(1052) nspsend: 00 00 00 00 00 00 00 00  |........|
(1052) nspsend: 00 1F 00 01 00 07 0B 00  |........|
(1052) nspsend: 00 00 00 00 00 00 00 00  |........|
(1052) nspsend: 00 00 AD 9E 1E 1F A1 B7  |........|
(1052) nspsend: 4B 3A BA CC EC 2C A7 C9  |K:...,..|
(1052) nspsend: DB FD 00 00 00 00 00 00  |........|


nspsend: normal exit


nsdofls: exit (0)

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit




nsdo: nsctxrnk=0


snsbitcl_ts: entry


snsbitcl_ts: normal exit

nsdo: normal exit
nsdo: entry
nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
snsbitts_ts: entry




snsbitts_ts: acquired the bit


snsbitts_ts: normal exit


nsdo: rank=64, nsctxrnk=0

snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: nsctx: state=8, flg=0x420d, mvd=0




nsdo: gtn=167, gtc=167, ptn=10, ptc=2019

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit




nsdo: switching to application buffer


nsrdr: entry


nsrdr: recving a packet


nsprecv: entry


nsprecv: reading from transport...

nttrd: entry
nttrd: socket 1028 had bytes read=27
nttrd: exit




nsprecv: 27 bytes from transport

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit




nsprecv: tlen=27, plen=27, type=12


nsprecv: packet dump

(1052) nsprecv: 00 1B 00 00 0C 01 00 00  |........|
(1052) nsprecv: 01 00 03 AD 9E 1E 1F A1  |........|
(1052) nsprecv: B7 4B 3A BA CC EC 2C A7  |.K:...,.|
(1052) nsprecv: C9 DB FD 00 00 00 00 00  |........|


nsprecv: normal exit


nsrdr: got NSPTMK packet


nsrdr: normal exit

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit




nsdo: *what=17, *bl=1

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit




nsdo: nsctxrnk=0


snsbitcl_ts: entry


snsbitcl_ts: normal exit


nsdo: normal exit

nioqrc:  found a interrupt marker...
nioqrc:  Recieve: returning error: 3111
nioqrc: exit
nioqrs: entry
nioqrs:  state = interrupted (1)
nioqrs: nioqrs: Not in send state ...
nioqsm: entry
nioqsm:  Sending reset packet (2)...




nsdo: entry


nsdo: cid=0, opcode=67, *bl=1, *what=17, uflgs=0x0, cflgs=0x3

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit




nsdo: rank=64, nsctxrnk=0

snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: nsctx: state=8, flg=0x420d, mvd=0




nsdo: gtn=167, gtc=167, ptn=10, ptc=2019

nsdofls: entry
nsdofls: DATA flags: 0x0
nsdofls: normal exit




nsdo: sending NSPTMK packet


nspsend: entry


nspsend: plen=27, type=12

nttwr: entry
nttwr: socket 1028 had bytes written=27
nttwr: exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit




snsbitcl_ts: entry


snsbitcl_ts: normal exit


nspsend: 27 bytes to transport


nspsend: packet dump

(1052) nspsend: 00 1B 00 00 0C 01 00 00  |........|
(1052) nspsend: 01 00 02 AD 9E 1E 1F A1  |........|
(1052) nspsend: B7 4B 3A BA CC EC 2C A7  |.K:...,.|
(1052) nspsend: C9 DB FD 00 00 00 00 00  |........|


nspsend: normal exit


nsdoacts: entry

nsdofls: entry
nsdofls: DATA flags: 0x0
nsdofls: normal exit




nsdoacts: flushing transport


nttctl: entry


nsdoacts: normal exit

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit




nsdo: nsctxrnk=1591796130


snsbitcl_ts: entry


snsbitcl_ts: normal exit


nsdo: normal exit

nioqsm: exit
nioqrs: nioqrs: sucking for reset marker...
nioqar: entry
nioqar: nioqar: suck pipe til I get a reset...
nscontrol: entry
nscontrol: cmd=1, lcl=0x0
nscontrol: normal exit
nscontrol: entry




nscontrol: cmd=3, lcl=0x40000


nscontrol: normal exit


nsdo: entry


nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3

snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit




nsdo: rank=64, nsctxrnk=1591796130


snsbitcl_ts: entry


snsbitcl_ts: normal exit


nsdo: error exit

nioqar:  recieve failed, no reset marker.
nioqer: entry
nioqer:  incoming err = 12151




niomapnserror: entry

niqme: entry
niqme: reporting NS-12612 error as ORA-12612
niqme: exit




niomapnserror: returning error 12612


niomapnserror: exit


....



The command is executed on the server (I also traced my application)
but it seems that the result fails to be sent over net8.



Could you help me to solve this problem ?
What is an interrupt marker for Net8 and where Can I find some
information on how to interpret this trace file ?



Thanks in advance for any help.
Received on Fri Sep 28 2001 - 04:12:04 CDT












Original text of this message













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