[ 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]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3206]
PSQL [143]
CUBRID [5]
기타정보 [194]
운영체제 [634]
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, 조회 : 795



추가 관련 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 /

216.73.216.200


  LIST

제목 작성자 작성일 조회
Linux  No package ssmtp available. / Error: Nothing to do    최길호 2022/05/26 217
Windows  Windows 10 한글 사용자명 변경    최길호 2022/04/06 219
AIX (IBM)  ftp backup delete script / ftp 백업, 삭제 script    최길호 2022/03/30 1768
Windows  .bat .cmd file error keep running / .bat .cmd 에러 다음 계속 실행 / call 추가    최길호 2022/03/16 228
Windows  forfiles 200M 이상 파일 확인    최길호 2022/02/16 188
Windows  [ regedit ] reg add    최길호 2022/02/15 202
Windows  windows tail    최길호 2022/02/10 242
Solaris  solaris dns ping: unknown host    최길호 2022/02/08 308
Linux  /dev/mapper/mpathf: read failed after 0 of 4096 at 0: Input/output error    최길호 2021/12/14 274
Linux  wget --no-check-certificate    최길호 2021/11/11 1507
Windows  Windows VPN 지정한 포트가 이미 열려 있습니다. [ ipTIME vpn ]    최길호 2021/10/20 416
Solaris  solaris 11.4 crontab    최길호 2021/10/03 1652
Linux  lsblk [ disk mount view ]    최길호 2021/06/02 404
AIX (IBM)  AIX ssh very slow    최길호 2021/04/15 568
AIX (IBM)  aix 7.2 /etc/resolv.conf    최길호 2021/04/15 400
Linux  yum install tigervnc-server / noVNC     최길호 2021/03/08 437
Windows  I/O 장치 오류로 인해 요청이 수행될 수 없습니다.    최길호 2021/01/18 673
Linux  ssmtp install / mail script    최길호 2020/11/25 4308
Linux  SEGIO sasl auth fail [ smtpd_tls_auth_only = yes ]    최길호 2020/11/16 684

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

Copyright 1999-2025 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/03
[ORACLE]
create type ORA-39083 ORA-0230....
by 최길호
07/03
[ORACLE]
sms recovery check ORA-00278 ....
by 최길호
07/02
[운영체제]
rsync -auv.
by 최길호