[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [72]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [28]
MySQL [47]
DB2 [79]
ORACLE [3099]
PSQL [135]
CUBRID [5]
기타정보 [170]
운영체제 [613]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: 운영체제

 회원가입

docker search / rename / commit (container to image) / oracle linux 7 OL7 / oracle linux 8 OL8 / Oracle Database 19C Install
최길호 [LIST]   2020-07-16 02:08:19, 조회 : 764



추가 관련 pkg 보관
docker run -dit --restart unless-stopped --name ol8 --hostname ol8 --cpus=2 --memory=10g --memory-swap=20g \
--shm-size=10g -v /docker/ol8:/oracle -p 1521:1521 oraclelinux:8 bash
docker exec -it ol8 bash
yum install yum-utils
yum install -y oracle-database-preinstall-19c
yumdownloader --resolve oracle-database-preinstall-19c


추가 테스트: 설치 완료후/제거/다시 설치해서 기존 DB 잘되는지 확인 ( 요약 )

docker run -dit --restart unless-stopped --name ol7 --hostname ol7 --cpus=2 --memory=10g --memory-swap=20g \
--shm-size=10g -v /docker/ol7:/oracle -p 1521:1521 oraclelinux:7 bash


dbca -silent \
         -createDatabase \
                 -sid orcl \
                 -gdbName orcl \
                 -totalMemory 8192 \
                 -templateName General_Purpose.dbc \
                 -characterSet KO16MSWIN949 \
                 -datafileDestination /oracle/oradata/ \
                 -emConfiguration NONE \
                 -sysPassword oracle \
                 -systemPassword oracle \
-J-Doracle.assistants.dbca.validate.ConfigurationParams=false

docker stop ol7
docker commit ol7 ol7:0
docker rm ol7

docker run -d -it --name ol7 --hostname ol7 --cpus=2 --memory=10g --memory-swap=20g \
--shm-size=10g -v /docker/ol7:/oracle -p 1521:1521 oraclelinux:7 bash



docker search oracle
# 만들때 port, mount 정의 / 나중에 하려면 귀찮다.
docker run --name ol7 -d -p 1511:1521 -v /docker/ol7:/oradata oraclelinux:7 bash
docker ps -a


# -p -v option 추가/변경
# 컨테이너 이름 변경
docker rename ol7 ol7old

docker ps -a
CONTAINER ID
21ab1311c5c8 <<===  

# option 변경을 위해 commit [ container -> image ]
docker commit 21ab1311c5c8 ol7  ## ol7 image
docker commit ol7 ol7:0         ## container name ol7 to image ol7:0 저장

# option을 추가/변경 해서 container 실행
docker run -it --name ol7 -d -p 1511:1521 -v /docker/ol7:/oradata ol7 bash

# --name 안준경우
# CONTAINER ID를 주고 컨테이너 이름을 만들거나 변경한다.
docker rename ec170e6f292d ol7

docker exec -it ol7 bash


# container <-> main os 파일 처리
# df 아래와 같이 mount 되어 있다.
# .../merged/ 추가,변경된 데이터
Filesystem               1K-blocks       Used Available Use% Mounted on
overlay                  124715524  117219904   7495620  94% /var/lib/docker/overlay2/f9cfb138fcc38ac4e7126ff9647a48ba0ff05c973e92f057d7ae5b69065dc651/merged
cp -R /var/lib/docker/overlay2/f9cfb138fcc38ac4e7126ff9647a48ba0ff05c973e92f057d7ae5b69065dc651/merged/oradata/ORA9 \
      /docker/ol7/



## ol7 설치 / oracle 19c 설치 따라 하기
https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7
https://oracle-base.com/articles/19c/oracle-db-19c-rpm-installation-on-oracle-linux-7

# 이거 완전 편해
yum install -y oracle-database-preinstall-19c
yum update -y

# su - oracle
su: cannot open session: Permission denied
관련 조치 : http://iotn.co.kr/power/zboard.php?id=9_3_os&no=563

                     https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
[root@node1 merged]# scp /mnt/LINUX.X64_oracle-database-ee-19c-1.0-1.x86_64.rpm .
[root@node1 merged]# pwd
/var/lib/docker/overlay2/827377572aed03b8cd6309558258ab24b066903cedae3dfeb29d90fc6a93789a/merged
[root@node1 merged]#


[root@21ab1311c5c8 /]# rpm -Uvh LINUX.X64_oracle-database-ee-19c-1.0-1.x86_64.rpm
Preparing...                          ################################# [100%]
su: cannot open session: Permission denied
[SEVERE] The su command is not configured properly or the oracle user does not have the required privileges to install the Oracle database. If you are running in a Docker environment, ensure to set the environment variable ORACLE_DOCKER_INSTALL=true and try again.
error: %pre(oracle-database-ee-19c-1.0-1.x86_64) scriptlet failed, exit status 1
error: oracle-database-ee-19c-1.0-1.x86_64: install failed
[root@21ab1311c5c8 /]#
[root@21ab1311c5c8 /]# export ORACLE_DOCKER_INSTALL=true
[root@21ab1311c5c8 /]# rpm -Uvh LINUX.X64_oracle-database-ee-19c-1.0-1.x86_64.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracle-database-ee-19c-1.0-1     ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure

[root@21ab1311c5c8 /]#
mkdir /oradata
chown oracle:dba /oradata

[root@21ab1311c5c8 /]# vi /etc/init.d/oracledb_ORCLCDB-19c

# Setting the required environment variables
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1

export ORACLE_VERSION=19c
export ORACLE_SID=ORCLCDB
export TEMPLATE_NAME=General_Purpose.dbc
export CHARSET=AL32UTF8
export PDB_NAME=ORCLPDB1
export LISTENER_NAME=LISTENER
export NUMBER_OF_PDBS=1
export CREATE_AS_CDB=true

[root@21ab1311c5c8 /]# su - oracle
[oracle@21ab1311c5c8 ~]$
cat >> .bash_profile
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ora19
export PATH=$PATH:$ORACLE_HOME/bin:.
alias sql='sqlplus "/as sysdba"'
alias oh='cd $ORACLE_HOME'

[oracle@21ab1311c5c8 ~]$ . .bash_profile
[oracle@21ab1311c5c8 ~]$
cat > /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 21ab1311c5c8)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
LOGGING_LISTENER = OFF


[oracle@21ab1311c5c8 ~]$
dbca -silent \
         -createDatabase \
                 -sid ora19 \
                 -gdbName ora19 \
                 -totalMemory 8192 \
                 -templateName General_Purpose.dbc \
                 -characterSet AL32UTF8 \
                 -datafileDestination /oradata \
                 -emConfiguration NONE \
                 -sysPassword orapwd \
                 -systemPassword orapwd \
-J-Doracle.assistants.dbca.validate.ConfigurationParams=false


C:\Users\Administrator>sqlplus system/orapwd@192.168.101.111:1511/ora19

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 15 23:52:03 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

C:\Users\Administrator>


docker stop ol7
docker start ol7
docker exec -it ol7 bash
su - oracle / lsnrctl start / db start /

3.238.121.7


  LIST

제목 작성자 작성일 조회
UNIX  find arch -newer scp    최길호 2020/09/07 400
Windows  cmd copy 파일 하나로 만들기 [ 80개 html 파일들 찾아서 합쳐서 단일 html 파일로 생성 ]    최길호 2020/08/27 342
Windows  windows 10 usb    최길호 2020/08/22 314
Linux  centos5 / yum install / Loading mirror speeds from cached hostfile YumRepo Error: All mirror URLs are not using ftp, http[s] or file.    최길호 2020/08/18 566
Docker  Docker for windows 시작~ [ Tutorial docker push ]    최길호 2020/07/27 11188
Linux  SecureCRT, putty terminal,session title 변경 [ echo -ne "\033]0;${USER}@${HOSTNAME}\007" ]    최길호 2020/07/18 479
Docker  docker save / load    최길호 2020/07/18 424
Docker  su: cannot open session: Permission denied    최길호 2020/07/18 679
Docker  docker filesystem 이동    최길호 2020/07/16 332
Docker  docker centos6 , centos7 / oracle 10 / all_no_orcl of makefile ins_rdbms.mk / snmccolm.o: could not read symbols: File in wrong format    최길호 2020/07/16 457
Docker  docker search / rename / commit (container to image) / oracle linux 7 OL7 / oracle linux 8 OL8 / Oracle Database 19C Install    최길호 2020/07/16 764
Docker  docker login / oracle 12.2    최길호 2020/07/15 415
Docker  docker ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded    최길호 2020/07/06 466
Docker  Docker 시작    최길호 2020/07/06 444
Linux  Linux 서버 붙은 Client IP list 확인    최길호 2020/06/30 310
Linux  yum , rpm -qa hang [ yum rpm --rebuilddb rpm 재구성 ]    최길호 2020/06/22 1168
Linux  linux process memory 사용 확인    최길호 2020/04/09 443

    목록보기   이전페이지   다음페이지 [1][2][3] 4 [5][6][7][8][9][10]..[31]   [다음 10개]
       

Copyright 1999-2024 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2016/06/09
201606 추가 grid/runcluvfy.sh...
by 최길호
2016/05/09
lg tab full screen VNCSERVE...
by 최길호
2013/10/17
rsync -avH /data/*

by 최길호
최근 게시물
07/22
[ORACLE]
ogg Rolling over remote file [....
by 최길호
07/15
[ORACLE]
PRKF-1125 : multiple values sp....
by 최길호
07/04
[운영체제]
NIC add cli / nmcli device sho....
by 최길호