Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot install 23.6.0.0 on ZHAOXIN (x86) #2901

Open
Gerhard1970 opened this issue Jan 12, 2025 · 11 comments
Open

Cannot install 23.6.0.0 on ZHAOXIN (x86) #2901

Gerhard1970 opened this issue Jan 12, 2025 · 11 comments
Assignees
@yunus-qureshi

Comments

@Gerhard1970
Copy link

Gerhard1970 commented Jan 12, 2025 •
edited
Loading

The installation of the image "container-registry.oracle.com/database/free:23.6.0.0" is not possible. The issue seems to occur exclusively during the setup process. After an upgrade from the AMD Ryzen V1500B to the ZHAOXIN KaiXian [email protected], the container continued to function without issues. However, reinstallation of the container is not possible. In contrast, the image "container-registry.oracle.com/database/express:latest" installs without any problems.

Docker:

docker run -d --name oracledb \
-p 1522:1521 \
-v /share/Container/Docker-Volumes/OraDB23ai/oradata:/opt/oracle/oradata \
container-registry.oracle.com/database/free:latest

Error:

Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password: 
********
Enter SYSTEM user password: 
*******
Enter PDBADMIN User Password: 
******
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
[WARNING] ORA-01012: not logged on

/opt/oracle/cfgtoollogs/dbca/FREE/cloneDBCreation.log

ORA-01109: database not open
Help: https://docs.oracle.com/error-help/db/ora-01109/


Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1603787624 bytes
Fixed Size                  5421928 bytes
Variable Size             402653184 bytes
Database Buffers         1191182336 bytes
Redo Buffers                4530176 bytes
NO
USERS
alter user system account unlock identified by ******
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01012/


alter session set "_oracle_script"=TRUE
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01012/


alter pluggable database PDB$SEED CLOSE IMMEDIATE

CpuInfo:

processor       : 0
vendor_id       : CentaurHauls
cpu family      : 7
model           : 59
model name      : ZHAOXIN KaiXian [email protected]
stepping        : 1
cpu MHz         : 2500.000
cache size      : 4096 KB
physical id     : 0
siblings        : 8
core id         : 0
cpu cores       : 8
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology nonstop_tsc cpuid pni pclmulqdq monitor vmx smx est tm2 ssse3 cx16 xtpr pcid sse4_1 sse4_2 movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand rng rng_en sm3 sm4 sm3_en sm4_en ace ace_en ace2 phe phe_en pmm pmm_en parallax rng2 rng2_en phe2 phe2_en rsa rsa_en lahf_lm abm 3dnowprefetch invpcid_single tpr_shadow vnmi ept vpid fsgsbase tsc_adjust bmi1 smep bmi2 invpcid rdseed adx xsaveopt dtherm ida umip arch_capabilities
vmx flags       : vnmi invvpid ept_x_only ept_1gb tsc_offset vtpr mtf ept vpid unrestricted_guest ple
bugs            : spectre_v1
bogomips        : 4989.86
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:
@yunus-qureshi yunus-qureshi self-assigned this Jan 13, 2025
@yunus-qureshi
Copy link
Member

Please check if /share/Container/Docker-Volumes/OraDB23ai/oradata has the right perms.

Alternatively try using docker volumes.

@Gerhard1970
Copy link
Author

Gerhard1970 commented Jan 13, 2025 •
edited
Loading

I have set the permission (owner) for the folder oradata to ID 54321 (oracle). Copying the database files and creating subfolders still works.

bash-4.4$ ls -laR oradata
oradata:
total 24
drwxrwx---+ 3 oracle oinstall 4096 Jan 13 08:27 .
drwxr-xr-x  1 oracle oinstall 4096 Dec 16 05:59 ..
drwxrwx---+ 4 oracle oinstall 4096 Jan 13 08:29 FREE

oradata/FREE:
total 2364328
drwxrwx---+ 4 oracle oinstall       4096 Jan 13 08:29 .
drwxrwx---+ 3 oracle oinstall       4096 Jan 13 08:27 ..
drwxrwx---+ 2 oracle oinstall       4096 Jan 13 08:27 FREEPDB1
-rw-rw----+ 1 oracle oinstall   18759680 Jan 13 08:29 control01.ctl
-rw-rw----+ 1 oracle oinstall   18759680 Jan 13 08:29 control02.ctl
drwxrwx---+ 2 oracle oinstall       4096 Jan 13 08:29 pdbseed
-rw-rw----+ 1 oracle oinstall  209715712 Jan 13 08:29 redo01.log
-rw-rw----+ 1 oracle oinstall  209715712 Jan 13 08:29 redo02.log
-rw-rw----+ 1 oracle oinstall  209715712 Jan 13 08:29 redo03.log
-rw-rw----+ 1 oracle oinstall  639639552 Jan 13 08:29 sysaux01.dbf
-rw-rw----+ 1 oracle oinstall 1080041472 Jan 13 08:29 system01.dbf
-rw-rw----+ 1 oracle oinstall   20979712 Jan 13 08:29 temp01.dbf
-rw-rw----+ 1 oracle oinstall   26222592 Jan 13 08:29 undotbs01.dbf
-rw-rw----+ 1 oracle oinstall    7348224 Jan 13 08:29 users01.dbf

oradata/FREE/FREEPDB1:
total 16
drwxrwx---+ 2 oracle oinstall 4096 Jan 13 08:27 .
drwxrwx---+ 4 oracle oinstall 4096 Jan 13 08:29 ..

oradata/FREE/pdbseed:
total 798776
drwxrwx---+ 2 oracle oinstall      4096 Jan 13 08:29 .
drwxrwx---+ 4 oracle oinstall      4096 Jan 13 08:29 ..
-rw-rw----+ 1 oracle oinstall 419438592 Jan 13 08:29 sysaux01.dbf
-rw-rw----+ 1 oracle oinstall 293609472 Jan 13 08:29 system01.dbf
-rw-rw----+ 1 oracle oinstall 104865792 Jan 13 08:29 undotbs01.dbf

On the database:

bash-4.4$ ps -ef|grep mon
oracle      38     1  0 08:42 ?        00:00:00 db_pmon_FREE
oracle      96     1  0 08:42 ?        00:00:00 db_smon_FREE
oracle     118     1  0 08:42 ?        00:00:02 db_mmon_FREE
oracle     183     1  0 08:42 ?        00:00:00 db_tmon_FREE
oracle    1873   243  0 08:47 pts/1    00:00:00 grep mon
bash-4.4$ 
bash-4.4$ 
bash-4.4$ 
bash-4.4$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Production on Mon Jan 13 08:47:35 2025
Version 23.6.0.24.10

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

Connected.
SQL> 
SQL> 
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01012/

@Gerhard1970
Copy link
Author

I create the container without a Docker volume.

Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.

The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
No patches have been applied
===========================================================
Completed: ALTER DATABASE OPEN
2025-01-13T08:49:55.473664+00:00
Exception [type: SIGIOT, unknown code (-6)] [ADDR:0xD431000001F0] [PC:0x7F2F3A3515EF, gsignal()+271] [exception issued by pid: 496, uid: 54321] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_496.trc  (incident=10222) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [gsignal()+271] [SIGIOT] [ADDR:0xD431000001F0] [PC:0x7F2F3A3515EF] [unknown code (-6)] []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_10222/FREE_ora_496_i10222.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2025-01-13T08:50:05.434183+00:00

On database:

bash-4.4$ ps -ef|grep mon
oracle      38     1  0 08:42 ?        00:00:00 db_pmon_FREE
oracle      96     1  0 08:42 ?        00:00:00 db_smon_FREE
oracle     118     1  0 08:42 ?        00:00:02 db_mmon_FREE
oracle     183     1  0 08:42 ?        00:00:00 db_tmon_FREE
oracle    1873   243  0 08:47 pts/1    00:00:00 grep mon
bash-4.4$ 
bash-4.4$ 
bash-4.4$ 
bash-4.4$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Production on Mon Jan 13 08:47:35 2025
Version 23.6.0.24.10

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

Connected.
SQL> 
SQL> 
SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Help: https://docs.oracle.com/error-help/db/ora-01012/

@Gerhard1970
Copy link
Author

I create the container with a Docker volume. The result with and without volume is very similar.

2f3d97a3d50bab90d47be1990805e75abaffec2584b72dadd1ca4aac85fde022 | /opt/oracle/oradata | Writable

Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.

The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
ORA-07445: exception encountered: core dump [gsignal()+271] [SIGIOT] [ADDR:0xD431000001C6] [PC:0x7FF571AF05EF] [unknown code (-6)] []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_8075/FREE_ora_454_i8075.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2025-01-13T08:56:34.712831+00:00
===========================================================
Dumping current patch information
===========================================================
No patches have been applied
===========================================================
2025-01-13T08:56:44.285393+00:00
Exception [type: SIGIOT, unknown code (-6)] [ADDR:0xD4310000020E] [PC:0x7F3F7B3995EF, gsignal()+271] [exception issued by pid: 526, uid: 54321] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_526.trc  (incident=8651) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [gsignal()+271] [SIGIOT] [ADDR:0xD4310000020E] [PC:0x7F3F7B3995EF] [unknown code (-6)] []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_8651/FREE_ora_526_i8651.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

@Gerhard1970
Copy link
Author

As mentioned, on the other system with an AMD CPU, the creation works without any issues (example without a volume).
System1: QNAP TS-473A with AMD Ryzen
System2: QNAP TVS-675 with KXU6580

Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.

The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
FREEPDB1(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN
2025-01-13T09:06:54.798139+00:00
===========================================================
Dumping current patch information
===========================================================
No patches have been applied
===========================================================
2025-01-13T09:06:54.849937+00:00
Completed: Pluggable database FREEPDB1 opened read write 
Completed: ALTER DATABASE OPEN

@yunus-qureshi
Copy link
Member

yunus-qureshi commented Jan 13, 2025 •
edited
Loading

What is the available memory? It should be at least 4 GiB. Also I assume this is a 64 bit processor (x86-64)

Alternatively you may want to try the
container-registry.oracle.com/database/free:23.6.0.0-lite

@Gerhard1970
Copy link
Author

I have already tried a lot so far – I'm slowly running out of ideas. In the meantime, I installed a graphics card. I will remove it again for testing.
I'm really looking forward to the new database features.

Sorry – it's a 64BIT CPU: Zhaoxin KX-U6580 8-core/-thread 64-bit x86 processor @ 2.5GHz with FPU, AES-NI accelerator, 8MB L2 cache, ZhaoXin C-960 Graphics; 16nm process.
The system has sufficient memory – 32GB. On the AMD system, I only have 8GB and it runs the FREE edition. Memory shouldn't be the issue.
Unfortunately, the FREE-Lite version doesn't work either. As can be seen from the memory usage, it requires almost as much memory as the FULL edition. And I have around 2 TB of free hard drive space.

image

Startup - Lite-Version

Expanding oracle data
/home/oracle
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.
Pluggable Database FREEPDB1 opened.

#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
ORA-07445: exception encountered: core dump [gsignal()+271] [SIGIOT] [ADDR:0xD4310000010E] [PC:0x7F8C46A60B8F] [unknown code (-6)] []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_2280/FREE_ora_270_i2280.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2025-01-13T16:35:35.399416+00:00
Exception [type: SIGIOT, unknown code (-6)] [ADDR:0xD4310000011C] [PC:0x7EFCA3FA5B8F, gsignal()+271] [exception issued by pid: 284, uid: 54321] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_284.trc  (incident=2304) (PDBNAME=CDB$ROOT):

@Gerhard1970
Copy link
Author

The issue persists even after removing the graphics card.
Do I have an option to install the older image (container-registry.oracle.com/database/free:23.6.0.0, ID 0e168a7f991a)? Unfortunately, it is the same version.

@ranjitnoronha
Copy link

Can you send us these two files:
/opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_496.trc
/opt/oracle/diag/rdbms/free/FREE/incident/incdir_2280/FREE_ora_270_i2280.trc

@Gerhard1970
Copy link
Author

Interim Status: Yesterday, I downloaded older versions, and version 23.2.0 can be installed without any issues. However, I am encountering the same problems with versions 23.5.0 and 23.4.0.
Exact Version: container-registry.oracle.com/database/free:23.2.0 (ID d45af382bf76 | 2023/08/02 09:04:06)

Image

@Gerhard1970
Copy link
Author

I reinstalled container-registry.oracle.com/database/free:23.6.0.0-lite and uploaded the trace (trc) files. I uploaded a few additional files – they are not particularly large. The errors occur repeatedly at regular intervals.

FREE_trc.zip

Expanding oracle data
/home/oracle
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.
Pluggable Database FREEPDB1 opened.

#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
See Note 411.1 at My Oracle Support for error and packaging details.
2025-01-17T09:09:31.059784+00:00
Exception [type: SIGIOT, unknown code (-6)] [ADDR:0xD43100000181] [PC:0x7F5406E81B8F, gsignal()+271] [exception issued by pid: 385, uid: 54321] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_385.trc  (incident=673) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [gsignal()+271] [SIGIOT] [ADDR:0xD43100000181] [PC:0x7F5406E81B8F] [unknown code (-6)] []
Incident details in: /opt/oracle/diag/rdbms/free/FREE/incident/incdir_673/FREE_ora_385_i673.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2025-01-17T09:09:35.731581+00:00
Exception [type: SIGIOT, unknown code (-6)] [ADDR:0xD4310000018F] [PC:0x7F22597B5B8F, gsignal()+271] [exception issued by pid: 399, uid: 54321] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_399.trc  (incident=681) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [gsignal()+271] [SIGIOT] [ADDR:0xD4310000018F] [PC:0x7F22597B5B8F] [unknown code (-6)] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2025-01-17T09:09:51.030250+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_420.trc  (incident=705) (PDBNAME=CDB$ROOT):
2025-01-17T09:10:06.359270+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_436.trc  (incident=713) (PDBNAME=CDB$ROOT):
2025-01-17T09:10:21.670815+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_452.trc  (incident=66) (PDBNAME=CDB$ROOT):
2025-01-17T09:10:36.986277+00:00
Errors in file /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_467.trc  (incident=514) (PDBNAME=CDB$ROOT):

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yunus-qureshi yunus-qureshi

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@yunus-qureshi @ranjitnoronha @Gerhard1970