[OracleDB] 설치하기

Docker로 설치하기

docker-compose.yml

version: "3.3"
volumes:
  oracle_data: {}
services:
  oracle: # username : system, password : oracle
    image: jaspeen/oracle-xe-11g
    ports:
      - "1521:1521"
    volumes:
      - oracle_data:/u01/app/oracle

컨테이너 실행 및 확인

ubuntu@ubuntu-server:~/.docker-compose/oracle11$ docker-compose up -d
Creating network "oracle11_default" with the default driver
Creating oracle11_oracle_1 ... done

ubuntu@ubuntu-server:~$ docker ps | grep oracle
6294a62351fe        jaspeen/oracle-xe-11g   "/entrypoint.sh "        26 minutes ago      Up 26 minutes       0.0.0.0:1521->1521/tcp, 8080/tcp           oracle11_oracle_1

컨테이너 접속

ubuntu@ubuntu-server:~/.docker-compose/oracle11$ docker exec -it oracle11_oracle_1 bash
root@72a15344021a:/# 

OracleDB 접속

• username : system
• password : oracle

root@72a15344021a:/# sqlplus system/oracle

SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar 1 05:15:28 2021

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


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>