topic Re: Oracle JDBC: Insufficient global memory in Operating System - OpenVMS

Oracle JDBC: Insufficient global memory

Francesco Gennai — Fri, 22 Oct 2010 08:01:23 GMT

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?

Re: Oracle JDBC: Insufficient global memory

Hein van den Heuvel — Fri, 22 Oct 2010 11:54:46 GMT

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

Re: Oracle JDBC: Insufficient global memory

Hein van den Heuvel — Fri, 22 Oct 2010 12:10:14 GMT

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.