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.55k stars 5.43k forks source link

Oracle 12c / Database setup was not successful #2646

Open maquejp opened 1 year ago

maquejp commented 1 year ago

Hello, I am trying to instantiate a container with the 12c image but I have error

`LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 12-JUN-2023 12:55:51

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Starting /opt/oracle/product/12.2.0.1/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production System parameter file is /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/6a0f2a288709/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER

Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 12-JUN-2023 12:55:51 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/6a0f2a288709/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The listener supports no services The command completed successfully [WARNING] [DBT-10102] The listener configuration is not selected for the database. EM DB Express URL will not be accessible. CAUSE: The database should be registered with a listener in order to access the EM DB Express URL. ACTION: Select a listener to be registered or created with the database. Copying database files 1% complete /opt/oracle/createDB.sh: line 65: 29 Killed dbca -silent -createDatabase -responseFile $ORACLE_BASE/dbca.rsp cat: /opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log: No such file or directory cat: /opt/oracle/cfgtoollogs/dbca/ORCLCDB.log: No such file or directory mv: cannot stat '/opt/oracle/product/12.2.0.1/dbhome_1/dbs/spfileORCLCDB.ora': No such file or directory mv: cannot stat '/opt/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora': No such file or directory 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: Network throttle feature is disabled as mount time

2023-06-12T12:56:03.357387+00:00 Successful mount of redo thread 1, with mount id 173005983 2023-06-12T12:56:03.357576+00:00 Database mounted in Exclusive Mode Lost write protection disabled Using STANDBY_ARCHIVE_DEST parameter default value as /opt/oracle/product/12.2.0.1/dbhome_1/dbs/arch Create Relation IPS_PACKAGE_UNPACK_HISTORY Completed: ALTER DATABASE MOUNT 2023-06-12T12:56:05.328216+00:00 Instance Critical Process (pid: 8, ospid: 474, SA00) died unexpectedly PMON (ospid: 460): terminating the instance due to error 12752 2023-06-12T12:56:05.340279+00:00 System state dump requested by (instance=1, osid=460 (PMON)), summary=[abnormal instance termination]. System State dumped to trace file /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_diag_480_20230612125605.trc 2023-06-12T12:56:05.408438+00:00 Dumping diagnostic data in directory=[cdmp_20230612125605], requested by (instance=1, osid=460 (PMON)), summary=[abnormal instance termination]. 2023-06-12T12:56:06.441884+00:00 Instance terminated by PMON, pid = 460 ` This is the config of my docker-compose.yml

`
velomai_php56_database:

image: oracle-database-12201

deploy:

  resources:

    limits:

      memory: 3000M

container_name: velomai_php56_database

ports:

  - "1596:1521"

environment:

  - ORACLE_SID=ORCLCDB
  - 
  - ORACLE_PDB=ORCLPDB
  - 
  - ORACLE_PWD=Oracle4System
  - 
  - ORACLE_MEM=2000

volumes:

  - ./database/OracleDB/oradata:/opt/oracle/oradata

  - ./database/scripts/setup:/opt/oracle/scripts/setup

  - ./database/scripts/startup:/opt/oracle/scripts/startup

network:

  - velomai_php56

` I have create the folder OracleDB and oradata and chmod -R 777 I cannot gather more information a the container stop working immediately

Any idea?