notfounduser's diary

## prepare oracle client (base) root@rasa-virtual-machine:~/node# wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip --2021-12-06 15:48:54-- https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip download.oracle.com (download.oracle.com)을(를) 해석하는 중... 23.53.224.11 접속 download.oracle.com (download.oracle.com)|23.53.224.11|:443... 접속됨. HTTP 요청을 전송했습니다. 응답을 기다리는 중입니다... 200 OK 길이: 79386308 (76M) [application/zip] 다음 위치에 저장: `instantclient-basic-linuxx64.zip' instantclient-basic-linuxx64.z 100%[====================================================>] 75.71M 96.4MB/s / 0.8s 2021-12-06 15:48:55 (96.4 MB/s) - `instantclient-basic-linuxx64.zip' 저장됨 [79386308/79386308]   ## prepare oracle client 2 (base) root@rasa-virtual-machine:~/node# cd /opt/ (base) root@rasa-virtual-machine:/opt# mkdir oracle (base) root@rasa-virtual-machine:/opt# cd oracle/ ## unzip oracle client (base) root@rasa-vi

  ## get docker images https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#license-lightbox ## git clone oracle docker [root@localhost ~]# git clone https://github.com/oracle/docker-images Cloning into 'docker-images'... remote: Enumerating objects: 12757, done. remote: Total 12757 (delta 0), reused 0 (delta 0), pack-reused 12757 Receiving objects: 100% (12757/12757), 9.53 MiB | 3.93 MiB/s, done. Resolving deltas: 100% (7520/7520), done. [root@localhost ~]# ll 합계 12 -rw-------. 1 root root 1696 5월 12 09:45 anaconda-ks.cfg drwxr-xr-x. 23 root root 4096 10월 15 22:08 docker-images -rw-r--r--. 1 root root 1744 5월 21 12:06 initial-setup-ks.cfg [root@localhost ~]# cd docker-images/ [root@localhost docker-images]# ll 합계 24 drwxr-xr-x. 6 root root 110 10월 15 22:08 Archive -rw-r--r--. 1 root root 760 10월 15 22:08 CODEOWNERS -rw-r--r--. 1 root root 9371 10월 15 22:08 CONTRIBUTING.md drwxr-xr-x. 3 root root 53 10월 15 22:08 Contrib drwxr-xr-x. 3

## get docker list [root@localhost ~]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 08d434228dfe jaspeen/oracle-xe-11g "/entrypoint.sh " 5 weeks ago Up 9 days 0.0.0.0:1521->1521/tcp, 0.0.0.0:9000->8080/tcp db ## get docker list [root@localhost ~]# docker exec -it db sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 6 13:15:38 2020 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: system Enter password: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL> SELECT name, value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'; SELECT name, value$ FROM sys.props$ WHERE name = 'NLS_NCHAR_CHARACTERSET'; NAME ------------------------------ VALUE$ -------------------------------------------------------------------------------- NLS_

docker위에 오라클 설치하고 간단하게 테스트 1. 환경준비     Centos 7.x      2. install docker [root@localhost ~]# yum install docker Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile  * base: data.aonenetworks.kr  * epel: fedora.cs.nctu.edu.tw  * extras: data.aonenetworks.kr  * updates: data.aonenetworks.kr Resolving Dependencies --> Running transaction check ---> Package docker.x86_64 2:1.13.1-96.gitb2f74b2.el7.centos will be installed --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================================================  Package                 Arch                    Version                                            Repository               Size ================================================================================================================================== Installing:  docker                  x86_64