Oracle 10g 설치(Docker)

방화벽 열기

$ sudo firewall-cmd --permanent --zone=public --add-port=10022/tcp
$ sudo firewall-cmd --permanent --zone=public --add-port=18080/tcp
$ sudo firewall-cmd --reload
$ sudo firewall-cmd --list-all

Docker 이미지

$ docker pull dragonbest520/oracle-xe-10g

실행 스크립트 작성

$ vi ora10g_run.sh

--> 내용

#!/bin/sh

docker run --name oracle10g -d -p 1521:1521 -p 10022:22 -p 18080:8080 --mount source=oracle_xe_10g_vol,target=/usr/lib/oracle -e "TZ=Asia/Seoul" -e ORACLE_ALLOW_REMOTE=true --restart=always dragonbest520/oracle-xe-10g

실행

$ chmod u+x ora10g_run.sh
$ ./ora10g_run.sh

Oracle 세팅 값

hostname: localhost
port: 1521
sid: xe
username: system
password: oracle

SSH 접속

$ ssh root@localhost -p 10022
password: admin

timezone 변경

# rm /etc/localtime && rm /etc/timezone
# ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone
# ls -alh /etc/local*
# cat /etc/timezone

캐릭터셋 UTF8 변경

# sqlplus /nolog;

SQL> conn /as sysdba;
SQL> update sys.props$ set value$='UTF8' where name='NLS_CHARACTERSET';
SQL> update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET';
SQL> update sys.props$ set value$='KOREAN_KOREA.UTF8' where name='NLS_LANGUAGE';
SQL> commit;
SQL> shutdown immediate;
SQL> startup;