- Docker에 Oracle 설치
|
1 2 3 4 |
docker pull oracledb19c/oracle.19.3.0-ee docker volume create oracle19c docker run --name oracle19c -p 1521:1521 -p 5500:5500 -v oracle19c:/oracle/oradate -e ORACLE_SID=ORCLCDB -e ORACLE_PDB=ORCLPDB1 -e ORACLE_PWD=oracle --restart always oracledb19c/oracle.19.3.0-ee docker exec -it {container id} /bin/bash |
- 샘플스키마 다운로드
https://github.com/oracle/db-sample-schemas/tree/v19c
- Docker Container에 다운받은 스키마 복사 및 압축 풀기
|
1 2 3 4 5 6 7 8 |
도커 컨테이너에 복사하기 docker cp .\db-sample-schemas-19c.tar.gz 884d963c8fb3:/home/oracle 도커 컨테이너 접속 docker exec -it {container id} /bin/bash 압축풀기 tar -zxvf {복사한 파일명} |
- HR 스키마 생성하기
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
sqlplus as / sysdba ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE; @hr_main.sql hr users temp oracle $ORACLE_HOME/demo/schema/log localhost:1521/ORCLCDB @hr_cre.sql @hr_popul.sql @hr_idx.sql @hr_code.sql @hr_comnt.sql @hr_analz.sql ALTER USER hr account unlock IDENTIFIED BY 1234; commit; |