ORA-01403: no data found in a TCPDump

  • From: nico torres <frasebook4@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Oct 2014 11:18:48 -0300

Hi list,

I Have a question for you today,  I am curious about this.

I issued for the first time a tcpdump on 3 or 4 (testing) databases, and
found out that, after any login, and and any query, Oracle responds with an
ORA-01403: no data found, besides the fetched data.

Here is a sample, on a sqlplus login, after a bunch of data:

07:50:06.398051 IP dummyserver > dummyclient: Flags [P.], seq 3125:3297,
ack 2348, win 177, options [nop,nop,TS val 3861719327 ecr 1961424219],
length 172
E....)@.@.m...C...B..J...s.N...............
.-).t..[......................{...........................................6................

.............................................................ORA-01403: no
data found


Does anyone have any idea if this is an internal normal behaviour?

Thanks

Other related posts: