# 【DB寶3】在Docker中使用rpm包的方式安裝Oracle 19c

[TOC]

本文公眾號地址：[https://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454779129&idx=1&sn=437a48ddf1cfa30c09c1dc21cd159ef1&chksm=fe8b9981c9fc10971de5c74735c46ab638092ca19afc87e61737520de2ae8d7f7398935e5b35&scene=21#wechat_redirect](https://mp.weixin.qq.com/s?__biz=MzIzOTA2NjEzNQ==&mid=2454779129&idx=1&sn=437a48ddf1cfa30c09c1dc21cd159ef1&chksm=fe8b9981c9fc10971de5c74735c46ab638092ca19afc87e61737520de2ae8d7f7398935e5b35&scene=21#wechat_redirect)

# 一、安裝Docker軟體
CentOS 7安裝Docker: https://docs.docker.com/engine/install/centos/
```sql
1、解除安裝掉舊版本的 Docker：
yum remove -y docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-selinux docker-engine-selinux docker-engine

2、執行以下安裝命令去安裝依賴包：
yum install -y yum-utils device-mapper-persistent-data lvm2
yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo

yum -y install docker-ce docker-ce-cli containerd.io

# 若執行報錯，則配置yum源
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo

或一鍵安裝：
curl -fsSL get.docker.com -o get-docker.sh
sh get-docker.sh

systemctl start docker
systemctl status docker

3、檢查版本
docker version
docker info
```

# 二、建立CentOS7.6的容器

```sql
https://hub.docker.com/_/centos?tab=tags

--拉取映象
docker pull centos:7.6.1810

--建立容器
docker run -d --name lhr2019ocp -h lhr2019ocp -p 5500-5510:5500-5510 -p 1521:1521 -p 222:22 --privileged=true centos:7.6.1810 /usr/sbin/init

--修改時區
docker cp /usr/share/zoneinfo/Asia/Shanghai lhr2019ocp:/etc/localtime

--進入容器
docker exec -it lhr2019ocp /bin/bash

--安裝一些必要的系統包
yum install -y openssh-clients openssh-server initscripts  net-tools telnet which wget passwd e4fsprogs lrzsz sudo unzip lvm2 tree traceroute bridge-utils dos2unix rlwrap
yum -y install vim redhat-lsb

--解決agetty程式cpu佔用率100%，宿主機和容器都需要執行
systemctl stop getty@tty1.service
systemctl mask getty@tty1.service

--啟動ssh程式
systemctl restart sshd
--修改root使用者密碼
echo "root:lhr" | chpasswd

--遠端登入
ssh root@192.168.1.35 -p222

-- 配置容器內的yum源：阿里雲
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo

yum clean all
rpm --rebuilddb
```

# 三、rpm方式安裝Oracle 19c

## 3.1 、安裝database-preinstall包
```sql
# https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html
yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

```

## 3.2、下載安裝db軟體，上傳到docker容器內
下載db 19c的地址：https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
安裝19c資料庫軟體：
```sql
yum install -y oracle-database-ee-19c-1.0-1.x86_64.rpm

```

## 3.3、建立資料庫例項
引數檔案：/etc/init.d/oracledb_ORCLCDB-19c、/etc/sysconfig/oracledb_ORCLCDB-19c.conf
```sql
/etc/init.d/oracledb_ORCLCDB-19c configure #也可以重啟資料庫
```
執行過程：
```sql
[root@lhr2019ocp ~]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

```
此過程即靜默建庫的過程，我們也可以使用DBCA命令來直接建立資料庫。

# 四、資料庫配置

## 4.1、修改密碼
```sql
alter user sys identified by lhr;
```
## 4.2、修改引數
```sql
alter system set sga_max_size=1g scope=spfile;
alter system set sga_max_size=1g;
alter system set pga_aggregate_target=100m;
startup force

```

## 4.3、修改EM的展現方式
可透過如下命令切換：
```sql
##切換為Flash-based的EM Express 
SQL> @?/rdbms/admin/execemx emx 
##切換為Java JET的EM Express 
SQL> @?/rdbms/admin/execemx omx
```
訪問容器內的EM：
```sql
https://192.168.1.35:5500/em
```

## 4.3、配置使用者環境變數

```sql
cat  >>  /home/oracle/.bash_profile << "EOF"

export ORACLE_SID=ORCLCDB
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib 
export PATH=$ORACLE_HOME/bin:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin

export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias asmcmd='rlwrap asmcmd'
alias sas='sqlplus / as sysdba'

EOF

cat >> $ORACLE_HOME/sqlplus/admin/glogin.sql << "EOF"

set linesize 9999 pagesize 9999
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "

EOF

```
注意：對於18c的安裝，和19c一樣。以上程式碼中，凡是有19c的地方都修改為18c。

# 五、重啟容器後的操作
若重啟容器後，則需要重新啟動db，如下：
```sql
[root@docker35 ~]# docker start lhr2019ocp
lhr2019ocp
You have new mail in /var/spool/mail/root
[root@docker35 ~]# docker exec -it lhr2019ocp bash
[root@lhr2019ocp /]# ps -ef|grep pmon
root       971   941  0 15:22 pts/1    00:00:00 grep --color=auto pmon
[root@lhr2019ocp /]# /etc/init.d/oracledb_ORCLCDB-19c start
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance ORCLCDB.
Oracle Database instance ORCLCDB started.

[root@lhr2019ocp /]# su - oracle
Last login: Wed Jun 24 15:22:45 CST 2020 on pts/1
[oracle@lhr2019ocp ~]$ sas

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 24 15:23:19 2020
Version 19.3.0.0.0

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

SYS@ORCLCDB> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO
SYS@ORCLCDB> ! lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-JUN-2020 15:23:29

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lhr2019ocp)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                24-JUN-2020 15:22:45
Uptime                    0 days 0 hr. 0 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/lhr2019ocp/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lhr2019ocp)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=lhr2019ocp)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/product/19c/dbhome_1/admin/ORCLCDB/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "ORCLCDB" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "ORCLCDBXDB" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "a8be8cc09f902cd2e0530d0011ac912e" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "orclpdb1" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
The command completed successfully

[root@docker35 ~]# docker container stop lhr2019ocp
lhr2019ocp

[root@docker35 ~]# docker commit lhr2019ocp lhrbest/oracle19clhr_rpm_db
sha256:96b0393fbc96f2ee2c9f5de17e4cd9ee82818b112b3491c0c64bbc48ddf306b8
You have new mail in /var/spool/mail/root
[root@docker35 ~]# docker images | grep oracle19clhr_rpm_db
lhrbest/oracle19clhr_rpm_db      latest              96b0393fbc96        About a minute ago   12.5GB
oracle19clhr_rpm_db              1.0                 6749a424a440        About a minute ago   12.5GB
[root@docker35 ~]#

[root@docker35 ~]# docker login
Authenticating with existing credentials...
WARNING! Your password will be stored unencrypted in /root/.docker/config.json.
Configure a credential helper to remove this warning. See
https://docs.docker.com/engine/reference/commandline/login/#credentials-store

Login Succeeded

--後臺執行
[root@docker35 ~]# nohup docker push lhrbest/oracle19clhr_rpm_db:latest &
[1] 27202
[root@docker35 ~]# ps -ef|grep push
root     27202  4743  0 16:39 pts/5    00:00:00 docker push lhrbest/oracle19clhr_rpm_db:latest

... ...

[root@docker35 ~]# ps -ef|grep push
root     16822 14646  0 08:41 pts/0    00:00:00 grep --color push
[root@docker35 ~]# 
[root@docker35 ~]# 
[root@docker35 ~]# docker push lhrbest/oracle19clhr_rpm_db:latest
The push refers to repository [docker.io/lhrbest/oracle19clhr_rpm_db]
b70a2f017499: Layer already exists 
89169d87dbe2: Layer already exists 
latest: digest: sha256:0d1bf18e4242610d16fc342b4d6c8ff6bdefcbe39c5484eeb8b83e2c2dd016dd size: 743
```

**About Me**
***
>● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除
● 本文在個人微 信公眾號（[DB寶](https://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w)）上有同步更新
● QQ群號： 230161599 、618766405，微信群私聊
● 個人QQ號（646634621），微 訊號（db_bao），註明新增緣由
● 於 2020年7月 在西安完成
● 最新修改時間：2020年7月
● 版權所有，歡迎分享本文，轉載請保留出處
>***
>●小麥苗的微店： [https://weidian.com/s/793741433?wfr=c&ifr=shopdetail](https://weidian.com/s/793741433?wfr=c&ifr=shopdetail)
●小麥苗出版的資料庫類叢書： [http://blog.itpub.net/26736162/viewspace-2142121/](http://blog.itpub.net/26736162/viewspace-2142121/)
●小麥苗OCP、OCM、高可用、DBA學習班： [http://blog.itpub.net/26736162/viewspace-2148098/](http://blog.itpub.net/26736162/viewspace-2148098/)
●資料庫筆試面試題庫及解答： [http://blog.itpub.net/26736162/viewspace-2134706/](http://blog.itpub.net/26736162/viewspace-2134706/)
>***
>使用微信客戶端掃描下面的二維碼來關注小麥苗的微信公眾號（[DB寶](https://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w)）及QQ群（DBA寶典）、新增小麥苗微信， 學習最實用的資料庫技術。
![小麥苗資訊](https://img-blog.csdnimg.cn/20191021104734877.png)
***

【DB寶3】在Docker中使用rpm包的方式安裝Oracle 19c

相關文章