• wnameless/oracle-xe-11g-r2
• oracleinanutshell/oracle-xe-11g - Docker Hub
  • 개발 환경 구성: 483. docker - OracleXE 컨테이너 실행
• jaspeen/oracle-11g - Docker Hub
• jaspeen/oracle-xe-11g - Docker Hub - https://github.com/jaspeen/docker-oracle-xe-11g
• Oracle Database Enterprise Edition - Docker Hub

• wnameless/oracle-xe-11g-r2 github

  docker run -d --name==oracle11gr2 \
   -p 49161:1521 \
   -p 49180:8080 \
   -e ORACLE_ALLOW_REMOTE=true
   -e ORACLE_DISABLE_ASYNCH_IO=true
    wnameless/oracle-xe-11g-r2

• 접속정보

  hostname: localhost
  port: 49161 # container port 1521
  sid: xe
  username: system
  password: oracle

• APEX http://localhost:<dockerport>/apex/apex_admin 접속

  # container port 8080
  username: ADMIN
  password: admin

• sqlplus

  docker exec -it oracle11gr2 /bin/bash
   
  # 접속 후
  su oracle
  sqlplus /nolog
   
  # sqlplus 에서
  SQL> conn / as sysdba

• 블루레이 :: [Oracle] CREATE TABLESPACE
• [오라클] 테이블스페이스와 데이터파일

-- Table Sapace 추가
CREATE TABLESPACE <tablespace_name> 
    DATAFILE '<tablespace_name>.dbf' 
    SIZE 100M 
    AUTOEXTEND ON NEXT 10M;
 
CREATE USER <username> IDENTIFIED BY <password>
    DEFAULT TABLESPACE <tablespace_name>
    QUOTA UNLIMITED ON <tablespace_name>
    TEMPORARY TABLESPACE TEMP;
 
 
GRANT CONNECT, RESOURCE TO <username>;

• 이제 <username> 사용자로 접속해서 작업한다.
• 가급적 system 계정으로는 작업하지 말 것.

• How to check the Oracle database version | Oracle Community

SELECT * FROM V$VERSION;
SELECT version FROM V$INSTANCE;