OpenVMS: SELECT SDO_GEOMETRY('POINT(-79 37)') FROM DUAL results in ORA-3113 (Doc ID 793063.1)

Last updated on FEBRUARY 10, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4 - Release: 10.2 to 10.2
HP OpenVMS Itanium

Symptoms

When running the following SQL, an ORA-3113 error is returned to the screen.


SQL> SELECT SDO_GEOMETRY('POINT(-79 37)') FROM DUAL;
SELECT SDO_GEOMETRY('POINT(-79 37)') FROM DUAL
*
ERROR at line 1:
ORA-3113: end-of-file on communication channel

An ORA-3113 error should produce a stack dump that you can review. 
Search ora_root:[network.log]*.err for "symbolic stack dump" to find the log showing the errors.

Example:


$ search ora_root:[network.log]*.err "symbolic stack dump"/win=(3,10)


ORA_ROOT:[network.log]BEQ_PROD_207341A5.ERR;1

%LIB-E-ACTIMAGE, error activating image $1$DGA4:[RAC10.LIB]ORA_JAVA_VMS_SHR.EXE
-IMGACT-F-NOT_I64, image is not an HP OpenVMS Industry Standard 64 image
%TRACE-E-TRACEBACK, symbolic stack dump follows

image module routine line rel PC abs PC
LIBRTL LIB$FIND_IMAGE LIB$FIND_IMAGE_SYMBOL
1742 0000000000002770 FFFFFFFF901BA960
ORACLE sjonlib vms_jvm_dlsym 346551 00000000000007B0 000000000D2A7220
ORACLE sjonlib sjonlib_find_sym 346811 00000000000016B0 000000000D2A8120
ORACLE jon jon_find_sym 395845 0000000000013840 000000000CFFC700
ORACLE jon jon_jni_fn 395955 0000000000014550 000000000CFFD410
ORACLE joevm joevm_first_time_setup 401250 000000000003A340 000000000CFC3160
ORACLE joevm joevm_invokeinterface_first
402058 00000000000402A0 000000000CFC90C0
***************


Changes

You recently applied the 10.2.0.4 patchset.

Cause

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