docker-images icon indicating copy to clipboard operation
docker-images copied to clipboard

Published 20 hours ago • verified publisher icon oracle

Mac M1 podman ARM 19.19 database - ORA-07445 on simple dbms_xplan call

Open ggordham opened this issue 2 years ago • 4 comments

When running a simple DBMS_XPLAN.COMPARE_PLANS on Oracle database 19.19 ARM edition on podman container get error: ORCLPDB1(3):Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x616E696769726F] [PC:0xFFFF968FB210, __GI_strlen()+16] [flags: 0x0, count: 2] Errors in file /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_ora_4269.trc (incident=9994) (PDBNAME=ORCLPDB1): ORA-07445: exception encountered: core dump [__GI_strlen()+16] [SIGSEGV] [ADDR:0x616E696769726F] [PC:0xFFFF968FB210] [Address not mapped to object] [] ORA-07445: exception encountered: core dump [__GI_strlen()+16] [SIGSEGV] [ADDR:0x616E696769726F] [PC:0xFFFF968FB210] [Address not mapped to object] []

Podman image was created with script: Singleinstance/buildContainerImage.sh -e -v 19.3.0 Using install media: LINUX.ARM64_1919000_db_home.zip

Simple scripts attached to re-create the error, will happen on demand. scripts (attached zip file arm-7445-sql-compare-bug-sql-scripts.zip):

  • lab-setup.sql - creates a user called perflab using USERS tablespace and grants needed rights.
  • ctables.sql - logs in as the perflab user and creates the tables for this example
  • spm-compre.sql - runs the same query six times, three with one bind value and three with different value to get two different execution plans. The does a comparison of the plans from cursor cache. ORA-7445 occurs here.
  • q1.sql - script containing the SQL statement formatted to get the same sql_id each time.

Note: update the top of each script to set user password and PDB name. Note: SQL_ID in my testing is 'fua0hb5hfst77' if the ID changes for some reason you will need to update the spm-compare.sql script with the new SQL_ID arm-7445-sql-compare-bug-sql-scripts.zip

ggordham avatar Sep 14 '23 16:09 ggordham

Thanks for reporting this, @ggordham.

For the fastest and best possible help, please open a Service Request with My Oracle Support. The GitHub Issues for this repository can only address issues with the build scripts provided in this repo, not for the underlying technologies.

gvenzl avatar Sep 14 '23 16:09 gvenzl

FYI SR SR 3-34267816511 opened.

ggordham avatar Sep 14 '23 18:09 ggordham

FYI, support says I need a minimum of 15GB of memory and 16GB of swap to run Oracle 19c at all and that is the issue with this simple example. Not sure that bodes well for running Oracle database in Docker on desktop.

ggordham avatar Sep 14 '23 21:09 ggordham

@ggordham for quick, local driver testing which doesn't hit the DB hard I have been using 19c (and then 21c and now 23c) in virtualbox VMs with 4G memory.

cjbj avatar Sep 26 '23 04:09 cjbj