Open ggordham opened 10 months ago
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.
FYI SR SR 3-34267816511 opened.
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 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.
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):
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