Thiết kế website giá rẻ

Question

docker image is container-registry.oracle.com/database/enterprise:12.1.0.2
Now when trying to docker run I am getting error.

I also checked official document at oracle site (https://container-registry.oracle.com/) it shows same steps.

I tried with multiple combinations of run command but all gives same error

docker run  -e "ORACLE_SID=ORCL" -e "ORACLE_PDB=TESTDB1" -e "ORACLE_PWD=TESTDB1" -p 1521:1521 -d --name oracle container-registry.oracle.com/database/enterprise:12.1.0.2

docker run  --name oracledb12c container-registry.oracle.com/database/enterprise:12.1.0.2

docker run  --name oracledb12c 
    -p 1521:1521 
    -e ORACLE_SID=ORCL 
    -e ORACLE_PDB=TESTDB1 
    -e ORACLE_PDB_PASSWORD=TESTDB1 
    -e ORACLE_PWD=SYSDB1 
    container-registry.oracle.com/database/enterprise:12.1.0.2

Error

configDB.log

configDBora.log

Wed May 1 09:27:39 UTC 2024
Configure DB as oracle user
Check user

SQL*Plus: Release 12.1.0.2.0 Production on Wed May 1 09:27:39 2024

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

Connected to an idle instance.

SQL> ORA-00845: MEMORY_TARGET not supported on this system
SQL> 
File created.

SQL> Disconnected
NID check db name

SQL*Plus: Release 12.1.0.2.0 Production on Wed May 1 09:27:40 2024

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

Connected to an idle instance.

SQL> ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> ORACLE instance shut down.
SQL> Disconnected

SQL*Plus: Release 12.1.0.2.0 Production on Wed May 1 09:27:44 2024

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

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 3019898880 bytes
Fixed Size          3715400 bytes
Variable Size         805310136 bytes
Database Buffers     2197815296 bytes
Redo Buffers           13058048 bytes
Database mounted.
SQL> 
File created.

SQL> 
Database altered.

SQL> alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> alter database rename global_name to ORCL.localdomain
                                     *
ERROR at line 1:
ORA-01109: database not open


SQL> 
NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
spfile                   string
SQL> ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> ORACLE instance started.

Total System Global Area 3019898880 bytes
Fixed Size          3715400 bytes
Variable Size         805310136 bytes
Database Buffers     2197815296 bytes
Redo Buffers           13058048 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 182
Session ID: 414 Serial number: 5817


SQL> ERROR:
ORA-03114: not connected to ORACLE


SQL> ERROR:
ORA-03114: not connected to ORACLE


SQL> ERROR:
ORA-03114: not connected to ORACLE


SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
update password

Enter password for SYS: 
create pdb : PDB1
Enter PDBADMIN User Password: 
The database "ORCL" could not be started. Check the existence of the database.

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 01-MAY-2024 09:28:33

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

Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/f09ea59c01bf/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                01-MAY-2024 09:28:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/f09ea59c01bf/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

SQL*Plus: Release 12.1.0.2.0 Production on Wed May 1 09:28:33 2024

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

Connected to an idle instance.

SQL> BEGIN dbms_xdb_config.sethttpsport (5500); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2024, Oracle Corporation.  All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135
writing relink log to: /u01/app/oracle/product/12.1.0/dbhome_1/install/relink.log

DONE!

Thiết kế website giá rẻ

Danh mục

Oracledb 12c Docker run fails. ERROR : config DB failed