search

oracle / docker-images

Official source of container configurations, images, and examples for Oracle products and projects
https://developer.oracle.com/use-cases/#containers
Universal Permissive License v1.0
6.45k stars 5.4k forks source link

DB oracle error [FATAL] ORA-03114: not connected to ORACLE #2781

Open skmar2 opened 2 months ago

skmar2 commented 2 months ago

I am using Mac M2 and getting below error while running the docker image. 2024-04-11 09:53:45 Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: 2024-04-11 09:53:45 Confirm the password: 2024-04-11 09:53:45 Configuring Oracle Listener. 2024-04-11 09:53:48 Listener configuration succeeded. 2024-04-11 09:53:48 Configuring Oracle Database XE. 2024-04-11 09:53:59 Enter SYS user password: 2024-04-11 09:53:59** 2024-04-11 09:53:59 Enter SYSTEM user password: 2024-04-11 09:53:59 2024-04-11 09:53:59 Enter PDBADMIN User Password: 2024-04-11 09:53:59 ** 2024-04-11 09:53:59 Prepare for db operation 2024-04-11 09:53:59 7% complete 2024-04-11 09:53:59 Copying database files 2024-04-11 09:54:07 8% complete 2024-04-11 09:54:07 [WARNING] ORA-03113: end-of-file on communication channel 2024-04-11 09:54:07 2024-04-11 09:54:07 9% complete 2024-04-11 09:54:07 [FATAL] ORA-03114: not connected to ORACLE 2024-04-11 09:54:07 2024-04-11 09:54:07 29% complete 2024-04-11 09:54:07 100% complete 2024-04-11 09:54:07 [FATAL] ORA-03114: not connected to ORACLE 2024-04-11 09:54:07 2024-04-11 09:54:09 7% complete 2024-04-11 09:54:09 0% complete 2024-04-11 09:54:09 Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details. 2024-04-11 09:54:09 2024-04-11 09:54:09 Database configuration failed. Check logs under '/opt/oracle/cfgtoollogs/dbca'. 2024-04-11 09:54:09 2024-04-11 09:54:09 Executing user defined scripts

Anyone can help here?

yunus-qureshi commented 2 months ago

@skmar2 I assume you are trying XE which is not supported on Mac M2. However you can get Oracle Free working following the instructions here

https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/FAQ.md#running-oracle-database-23c-free-on-apple-silicon-arm-chip

skmar2 commented 2 months ago

Can I use docker instead of podman?

yunus-qureshi commented 2 months ago

Yes, docker should also work with Lima/Colima though we haven't tested it. Basically you need a cross architecture virtualisation that Lima provides since XE/Free images are amd64 based and not arm64 used in Mac M2

skmar2 commented 2 months ago

Now I am getting the below error.... setup % docker run --name oracle-db \ -p 1575:1521 \ -e ORACLE_PWD=deralf241 \ -e ORACLE_CHARACTERSET=AL32UTF8 \ -v /Users/skumar/IdeaProjects/der/implementierung/der-reactor/docker/oracle-db/volumes/scripts/setup:/opt/oracle/oradata \ container-registry.oracle.com/database/free:latest Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: 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 Cannot create directory "/opt/oracle/oradata/FREE". 7% complete 100% complete [FATAL] Prepare Operation has failed. 0% complete Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.

oraclesean commented 2 months ago

@skmar2 it looks like the error is caused by this line:

-v /Users/skumar/IdeaProjects/der/implementierung/der-reactor/docker/oracle-db/volumes/scripts/setup:/opt/oracle/oradata

The log output indicates that the database creation process could not add a directory under /opt/oracle/oradata. You should confirm that the directory exists and that your user can create files there. The path looks odd to me—is this under the default Volume directory on your machine, created by Docker? If so, try setting the volume to a different path, or try calling docker run without the -v option to confirm everything else is working as expected.

skmar2 commented 2 months ago

I updated the exposed volume path and it worked. docker run --name oracle-db \ -p 1575:1521 \ -e ORACLE_PWD=deralf241 \ -e ORACLE_CHARACTERSET=AL32UTF8 \ -v /Users/skumar/IdeaProjects/der/implementierung/der-reactor/docker/oracle-db/volumes/scripts/setup:/opt/oracle/scripts/startup \ container-registry.oracle.com/database/free:latest

But now I am getting this error [FATAL] [DBT-10330] Container database (CDB) creation option is not selected. CAUSE: You have specified the database template (FREE Database) which represents container database (CDB) information. But, you have not selected to create container database (CDB). Only container database (CDB) can be created using this template. ACTION: Select container database (CDB) creation option. Alternatively specify different database template [FATAL] [DBT-10333] Container database (CDB) creation option is not selected. CAUSE: Non-CDB creation is not supported. ACTION: Make sure container database (CDB) option is selected.

oraclesean commented 2 months ago

@skmar2 I just ran this successfully (OEL 8.8, Docker 24.0.6). Will you please try running this same command without assigning the volume?

docker run --name oracle-db
-p 1575:1521
-e ORACLE_PWD=deralf241
-e ORACLE_CHARACTERSET=AL32UTF8
container-registry.oracle.com/database/free:latest

I suspect there's a script in the entrypoint directory that's attempting to do something that's causing the error.

If it still fails without the entrypoint, please share the full output of the docker run command and the results of running docker info?

qingzhu521 commented 2 weeks ago

same problem