ORACLE XE 설치

 

아래 2개글 참고함

 

https://github.com/gvenzl/oci-oracle-xe

GitHub - gvenzl/oci-oracle-xe: Build scripts for Oracle Database XE container/docker images

https://dbwriter.io/oracle-installation-with-docker/

도커로 Oracle 간단 설치하기

 

 

 

@AyaanFelix:~$ docker search oracle-xe
NAME                              DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED
oracleinanutshell/oracle-xe-11g                                                   228
gvenzl/oracle-xe                  Oracle Database XE (21c, 18c, 11g) for every…   92
wnameless/oracle-xe-11g-r2        Oracle Express Edition 11g Release 2 on Ubun…   86
orangehrm/oracle-xe-11g            docker container with Oracle Express Editio…   17                   [OK]
dragonbest520/oracle-xe-10g       Oracle Express Edition 10g Release 2 (10.2.0…   9                    [OK]
christophesurmont/oracle-xe-11g   Clone of the wnameless/oracle-xe-11g.           7
pvargacl/oracle-xe-18.4.0         Oracle Express Edition 18.4.0 on Oracle Linu…   6
jaspeen/oracle-xe-11g             Fork from sath89/docker-oracle-xe-11g - smal…   6                    [OK]

.....

 

@AyaanFelix:~$ docker pull gvenzl/oracle-xe
Using default tag: latest
latest: Pulling from gvenzl/oracle-xe

 

---- ORACLE_PASSWORD는 system 계정의 패스워드임(싸랑해123!)

@AyaanFelix:~$ docker run --name=oracle21 -d -p 1521:1521 -e ORACLE_PASSWORD=Tkfkdgo123! -v oradata:/opt/oracle/oradata gvenzl/oracle-xe
a953b3e968914b596c7e679bcf452a64dbf9cf31baf8383b6022d21d9c91a324
mhchae3@AyaanFelix:~$ docker ps
CONTAINER ID   IMAGE              COMMAND                  CREATED         STATUS         PORTS                    NAMES
a953b3e96891   gvenzl/oracle-xe   "container-entrypoin…"   3 seconds ago   Up 3 seconds   0.0.0.0:1521->1521/tcp   oracle11g

 

@AyaanFelix:~$ docker exec -it oracle21 sqlplus

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Aug 8 13:26:37 2022
Version 21.3.0.0.0

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

Enter user-name: system
Enter password:        <===암호는 Tkfkdgo123! (싸랑해123!)
Last Successful login time: Sun Jul 03 2022 20:57:17 +00:00

Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL>

 

 

Docker-compose

=======================

version: '3.1' 
services: 

oracle: 
    image: gvenzl/oracle-xe 
    container_name: "oracle21"     
    ports: 
      - "1521:1521" 
    environment: 
      - ORACLE_PASSWORD=Tkfkdgo123! 
    volumes:
      - ./oracle/oradata:/opt/oracle/oradata  => oracle/oradata 디렉토리를 먼저 만들어야 함

 

실행 : docker compose up -d oracle 또는 docker-compose up -d oracle

 

 

ORACLE 접속은 아래글 참조.

 

https://goldencrab.tistory.com/entry/DBeaver-%EB%A5%BC-%EC%9D%B4%EC%9A%A9%ED%95%9C-oracle-%EC%A0%91%EC%86%8D%ED%95%98%EA%B8%B0