Programming > Docker

docker oracle 12e 최신 기동

Docker 에서 Oracle12e 개발용 설치하기

## checkout
https://hub.docker.com/_/oracle-database-enterprise-edition?tab=resources

Oracle12e 다운로드 및 실행(image & contailer)

docker run -d -it --name ora12e -p 1521:1521 store/oracle/database-enterprise:12.2.0.1-slim
docker logs -f ora12e

타임존을 변경한다.

docker exec -it ora12e bash
/home/oracle/.bashrc   export TZ='Asia/Seoul'
source .bashrc

 

sqlplus sys/Oradoc_db1@ORCLCDB as sysdba
update sys.props$ set value$='KOREAN_KOREA.UTF8' where name='NLS_LANGUAGE';
update sys.props$ set value$='UTF8' where name='NLS_CHARACTERSET';
update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET';
COMMIT;

SQL> shutdown immediate;
SQL> conn / as sysdba
SQL> startup;

Container 접속해 사용자 생성

docker exec -it ora12e bash
sqlplus sys/Oradoc_db1@ORCLCDB as sysdba

alter session set "_ORACLE_SCRIPT"=true;
** 하지 않으면 ORA-65096: invalid common user or role name
create user emcdb identified by 9999;
grant connect,resource,dba to emcdb;