Oracle JDBC: Insufficient global memory

[Francesco Gennai]

Environment:

IA64 OpenVMS 8.3
Java RTE version 1.5
Oracle RDB version 7.2-2
SQL/services version 7.3
JDBC server for RDB version 7.3
JDBC-Thin driver version 7.3

The problem:

we have a JDBC dispatcher with 20 executor processes.
We have a client application that performs connect/disconnect to the database before/after each sql select statement.

Sometimes the query doesn't terminate successfully and I get the following error in
the JDBC log file:

>> RDB$CLIENT_ID_0000038D C00000000*T 201010-21 12:19:13.409 : srv.DBActionHandler@1414306.FlushErr msg : INIT_V713 send>>>>>>>>>>>>> System Error : Insufficient global memory

any help?

[Hein van den Heuvel]

Hmmm, Certainly several RDB users read this forums, but I'm not sure any Oracle RDB engineer/support folks do. You might need those. (I'll poke Norm :-)

I recommend asking this question in some Oracle (RDB) forum. Admittedly I haven't look for one. Or ask Oracle support?

fwiw,
Hein

[Hein van den Heuvel]

Ah, I now happen to see that this possibly relates to:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1452390
At least provides additional context which would have been good to know up front.

Norm passed along the topic to an RDB JDBC person. He concurs that that contacting Oracle may be the path of best resultâ ¦

fwiw,
Hein.