OpenVMS: SELECT SDO_GEOMETRY('POINT(-79 37)') FROM DUAL results in ORA-3113
(Doc ID 793063.1)
Last updated on APRIL 16, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |