RDBPROD: How To Access a JDBC Log File While the Server is Running (Doc ID 783674.1)

Last updated on AUGUST 12, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2.5.1 and later
Oracle JDBC for Rdb - Version 7.1.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium


Goal

While a JDBC for Rdb Thin Server process is running, it is not possible to access the corresponding log file. For example:

$ spawn/nowait java -jar rdb$jdbc_home:rdbthinsrv.jar -tl -1 -log my.log

$ type my.log
%TYPE-W-OPENIN, error opening $1$DGA113:[RDBJDBC]MY.LOG;1 as input
-RMS-E-FLK, file currently locked by another user

The reason is that the JDBC for Rdb driver is using the DriverManager class for writing into log files. This class does not have an option to create a file for shared access (this is the default for other operating systems, but not for OpenVMS). However, sometimes it is desirable to access the log files without stopping the thin server process.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms