topic Re: Oracle RDB JDBC server in Operating System - OpenVMS

Oracle RDB JDBC server

Francesco Gennai — Mon, 18 Oct 2010 14:34: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 JDBC executor processes disappear without any log (or maybe the log is somewhere and I don't know where to find it :-).

I would like to have ANY suggestion to try to monitor and solve this problem (suggestions that I'm requesting for include also OpenVMS basic suggestions to monitor a process and discover why it crashes, but of course I'm interested also in any suggestion related to an environment with Oracle/JDBC on IA64-OpenVMS ).

Thank you
:)
Francesco

Re: Oracle RDB JDBC server

Ian Miller. — Mon, 18 Oct 2010 14:41:36 GMT

Accounting can tell you the final exit status of the process.

If
$ SHOW ACCOUNTING
shows PROCESS or DETACHED then
$ ACCOUNTING
should show you the termination record for the process.

Using Availability Manager and looking at the process quotas may be informative.

Re: Oracle RDB JDBC server

Toine_1 — Mon, 18 Oct 2010 20:18:03 GMT

Hi,

You can find the logs in RDB$JDBC_LOGS: directory.

$ dir RDB$JDBC_LOGS:

You can also set a tracelevel when starting the starting the exceutors using: -tl -1.

See: http://www.oracle.com/technetwork/database/rdb/rdbjdbc-faq-087113.html

/Toine

Re: Oracle RDB JDBC server

Francesco Gennai — Thu, 21 Oct 2010 09:44:53 GMT

Hi,

thank you for your suggestions I have been able to trace the JDBC activity.
Not sure that this is problem that I'm searching for, but surely it is a problem:

I get the following error:

>> 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 RDB JDBC server

Francesco Gennai — Fri, 22 Oct 2010 08:06:46 GMT

I have opened a new thread about the same problem.