1

Topic: Error OJVM 12c

Good afternoon.
There is a DB 12
[spoiler]

SQL> SELECT * FROM V$VERSION
2;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0
PL/SQL Release 12.2.0.1.0 - Production 0
CORE 12.2.0.1.0 Production 0
TNS for Linux: Version 12.2.0.1.0 - Production 0
NLSRTL Version 12.2.0.1.0 - Production 0

[/spoiler]
ojvm version
[spoiler] SQL> SELECT dbms_java.get_ojvm_property (PROPSTRING =>'java.version ') FROM dual
2;
DBMS_JAVA.GET_OJVM_PROPERTY (PROPSTRING =>'JAVA.VERSION ')
----------
1.8.0_121
[/spoiler]
Libraries Apache POI 3.17 are loaded. (Operation about Microsoft office documents)
There is small java class for operation with POI and pl/sql a wrapper for a call java procedures.
On the version of a DB 11.2.0.4, all works. On version 12.2 causes an error.
alert
[spoiler] <msg time = ' 2018-01-31T16:34:25.765+03:00 ' org_id ='oracle ' comp_id ='rdbms'
type ='UNKNOWN ' level = ' 16 ' host_id ='oracle_serverhost'
host_addr = ' 10.x.x.x ' module ='SQL*Plus' pid = ' 8499 '>
<txt> Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x4DEE17A, sjonlib_find_sym () +26] [flags: 0x0, count: 1]
</txt>
</msg>
<msg time = ' 2018-01-31T16:34:25.795+03:00 ' org_id ='oracle ' comp_id ='rdbms'
msg_id = ' 1739638366 ' type ='INCIDENT_ERROR ' group ='Access Violation'
level = ' 1 ' host_id ='oracle_serverhost ' host_addr = ' 10.x.x.x'
pid = ' 8499 ' prob_key ='ORA 7445 [sjonlib_find_sym] ' errid = ' 21616'
detail_path ='/opt/oracle/diag/rdbms/oracle_sid/oracle_sid/trace/oracle_sid_ora_8499.trc '>
<txt> Errors in file /opt/oracle/diag/rdbms/oracle_sid/oracle_sid/trace/oracle_sid_ora_8499.trc (incident=21616):
ORA-07445: exception encountered: core dump [sjonlib_find_sym () +26] [SIGSEGV] [ADDR:0x8] [PC:0x4DEE17A] [Address not mapped to object] []
</txt>
</msg>
<msg time = ' 2018-01-31T16:34:25.797+03:00 ' org_id ='oracle ' comp_id ='rdbms'
type ='UNKNOWN ' level = ' 16 ' host_id ='oracle_serverhost'
host_addr = ' 10.x.x.x ' module ='SQL*Plus' pid = ' 8499 '>
<txt> Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
</txt>
</msg> [/spoiler]
trace
[spoiler] oracle@oracle_serverhost:/opt/oracle/diag/rdbms/oracle_sid/oracle_sid/alert$ cat /opt/oracle/diag/rdbms/oracle_sid/oracle_sid/trace/oracle_sid_ora_8499.trc
Trace file /opt/oracle/diag/rdbms/oracle_sid/oracle_sid/trace/oracle_sid_ora_8499.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME:/opt/oracle/app/product/12.2.0/db_1
System name: Linux
Node name: oracle_serverhost
Release: 3.10.0-693.11.6.el7.x86_64
Version: #1 SMP Thu Jan 4 1:06:37 AM UTC 2018
Machine: x86_64
Instance name: oracle_sid
Redo thread mounted by this instance: 1
Oracle process number: 60
Unix process pid: 8499, image: oracle@oracle_serverhost
* 2018-01-31T16:34:24.278972+03:00
* SESSION ID: (46.26343) 2018-01-31T16:34:24.279032+03:00
* CLIENT ID:() 2018-01-31T16:34:24.279045+03:00
* SERVICE NAME:(oracle_serverhost) 2018-01-31T16:34:24.279056+03:00
* MODULE NAME:(SQL*Plus) 2018-01-31T16:34:24.279069+03:00
* ACTION NAME:() 2018-01-31T16:34:24.279080+03:00
* CLIENT DRIVER:(SQL*PLUS) 2018-01-31T16:34:24.279091+03:00
SXSSFWorkbook created
* 2018-01-31T16:34:25.449988+03:00
create sheet SHEET
* 2018-01-31T16:34:25.756796+03:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x4DEE17A, sjonlib_find_sym () +26] [flags: 0x0, count: 1]
DDE: Problem Key ' ORA 7445 [sjonlib_find_sym] ' was flood controlled (0x6) (incident: 21616)
ORA-07445: exception encountered: core dump [sjonlib_find_sym () +26] [SIGSEGV] [ADDR:0x8] [PC:0x4DEE17A] [Address not mapped to object] []
Dumping swap information
Memory (Avail / Total) = 233.26M / 7823.04M
Swap (Avail / Total) = 15661.50M / 16000.00M
ssexhd: crashing the process...
Shadow_Core_Dump = partial
ksdbgcra: writing core file to directory ' /opt/oracle/diag/rdbms/oracle_sid/oracle_sid/cdump ' [/spoiler]
Creation  on streem class SXSSFWorkbook, d the moment of filling by the data, the data is thrown off on a disk in a temporary file.
The error falls out at the moment of Sheet creation (Sheet). I.e. Book creation (Workbook) there transits successfully, and on creation of Sheet an error.
The file in temporary  is, but the zero size.
Rewriting on  class XSSFWorkbook (the data on a disk is not written), all earned. But the given decision is not necessary for great volumes and very slowly works.
Grandees
[spoiler] exec DBMS_JAVA.grant_permission (' USER ', ' SYS:oracle.aurora.security.JServerPermission ', ' Verifier ', ");
exec DBMS_JAVA.grant_permission (' USER ', ' SYS:oracle.aurora.security.JServerPermission ', ' * ', null);
exec DBMS_JAVA.grant_permission (' USER ', ' SYS:java.lang. RuntimePermission ', ' getClassLoader ', ");
exec dbms_java.grant_permission (' USER ', ' SYS:java.io. FilePermission ', ' <<ALL FILES>> ', ' read, write, delete ');
exec dbms_java.grant_permission (' USER ', ' SYS:java.net. SocketPermission ', ' * ', ' connect, resolve ');
exec dbms_java.grant_permission (' USER ', ' SYS:java.net. NetPermission ', ' * ', null);
commit; [/spoiler]
On a metalink not solutions of a problem
There are at whom what thoughts?

2

Re: Error OJVM 12c

blkangel wrote:

There are at whom what thoughts?

And where grants on file system?
With 12 it is necessary.

3

Re: Error OJVM 12c

andrey_anonymous wrote:

it is passed...
And where grants on file system?
With 12 it is necessary.

Send me to the necessary direction.

4

Re: Error OJVM 12c

blkangel wrote:

Good afternoon.
There is a DB 12
Rewriting on  class XSSFWorkbook (the data on a disk is not written), all earned. But the given decision is not necessary for great volumes and very slowly works.

it is simply interesting - in Blob it turns out to write down much more slowly?

5

Re: Error OJVM 12c

wrote:

it is passed...
Simply interesting - in Blob it turns out to write down much more slowly?

More slowly in times, exact samplings did not do, but it is visible an unaided sight when the file or in five seconds is almost quickly formed.
blob  only on an output, all this time the book is formed in PGA, thereby at the big outswappings rest against its size
And session falls.
At  works faster but when in storage only the last 10 lines, not it is possible to use all functions. For example  in the lines etc.