|
|
Posted on7 days ago
|
|
|
|
Requirements: Recently, I am very interested in Oracle databases, and I use C# to connect to Oracle databases for adding, deleting, modifying, and checking operations, so I need to build an Oracle 19c database service and choose to use Docker containers to build it.
Oracle 19c image
doctorkirk/oracle-19c：The hyperlink login is visible.
This is a customized image based on the process available in Oracle's official GitHub repository. Since Oracle only offered a solution for the CDB + PDB architecture, I decided to customize the image to enable a single-instance, non-CDB (Non-CDB) installation.
Non-CDB / Single Instance - Non-CDB
Refers to the traditional Oracle database structure - without multitenancy architecture enabled.
The entire database is a single instance and database (similar to Oracle 11g style).
CDB$ROOT and PDB are not included, and tablespaces such as SYSTEM, SYSAUX are used directly.
Oracle official image:The hyperlink login is visible.
Oracle 19c runs
Use docker compose to enable running Oracle images, compose.yml the configuration is as follows:
You need to configure the ulimits parameter, otherwise the startup error will be as follows:
library initialization failed - unable to allocate file descriptor table - out of memory/opt/oracle/createDB.sh: line 63: 30 Aborted (core dumped) dbca -silent -createDatabase -responseFile $ ORACLE_BASE/dbca.rsp
Create a new oradata persistent directory and set the permissions as follows:
at/data/middleware/oracleCreate a compose.yml profile with the configuration as above. The startup command is as follows:
The logs are as follows:
Test the connection using DBeaver, configured as follows:
Using a SYS account, after the connection is successful, create a user with the following SQL command:
As shown below:
Reference:The hyperlink login is visible. |
Previous:NetEase 163 Enterprise Mailbox Related QuestionsNext:Solid-state NAND Flash storage: SLC, MLC, TLC, QLC
|
