Mac使用Docker安装Mysql和Oracle

傷城~ 2022-12-15 14:17 204阅读 0赞

## 安装docker ##

brew cask install docker

![20201017192923710.png][]

### 镜像加速 ###

[https://promotion.aliyun.com/ntms/act/kubernetes.html][https_promotion.aliyun.com_ntms_act_kubernetes.html]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1][]

{
      "registry-mirrors": [
        "https://u9irc6iy.mirror.aliyuncs.com"
      ],
      "features": {
        "buildkit": true
      },
      "experimental": false
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2][]

## 安装Mysql ##

### 查找镜像 ###

docker search mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3][]

### 拉取 MySQL 镜像 ###

docker pull mysql:latest

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4][]

### 查看本地镜像 ###

docker images

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5][]

### 运行容器 ###

docker run -itd --name mysql-8.0 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql

### 进入docker本地连接mysql ###

docker exec -it mysql-8.0 bash

登陆mysql -uroot -p123456

### ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6][]工具连接 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7][]

### 停止 ###

docker stop mysql-8.0

### 删除容器 ###

docker rm 容器id

### 删除镜像 ###

docker rmi 镜像id

## 安装oracle11g ##

### 拉取镜像 ###

docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle\_11g

### 查看镜像 ###

docker images

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8][]

### 创建容器 ###

docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle\_11g

### 启动容器 ###

docker start oracle11g

![20201017222108440.png][]

### 进入镜像进行配置 ###

docker exec -it --user root  oracle11g /bin/bash

vi /etc/profile

![20201017222647162.png][]

### 配置环境变量 ###

export ORACLE\_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome\_2  
export ORACLE\_SID=helowin  
export PATH=$ORACLE\_HOME/bin:$PATH

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9][]

### 创建软连接 ###

ln -s $ORACLE\_HOME/bin/sqlplus /usr/bin

### 切换到oracle用户 ###

su - oracle![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10][]

### 登录sqlplus并修改sys、system用户密码 ###

sqlplus /nolog

conn /as sysdba;  
alter user system identified by system;  
alter user sys identified by sys;  
create user test identified by test;  
grant connect,resource,dba to test;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11][]

### 查看lsnrctl 服务 ###

lsnrctl status

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12][]

### navicat连接 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 13][]

### 创建表空间 ###

create tablespace prepolicy datafile '/home/oracle/app/oracle/oradata/helowin/prepolicy.dbf' size 200M autoextend on next 50M;  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 14][]

# #

[20201017192923710.png]: /images/20221123/ea21ac55393d4546bb5bacd3f30f0f15.png
[https_promotion.aliyun.com_ntms_act_kubernetes.html]: https://promotion.aliyun.com/ntms/act/kubernetes.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70]: /images/20221123/8808acd5ff194afea9951e44cbb63d86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 1]: /images/20221123/6c6c5832885a42fca5372395cfd2d7c1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 2]: /images/20221123/85ad87c34a7a4f16a8e2815f4c612696.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 3]: /images/20221123/4f41de671c554233a30de1f505617997.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 4]: /images/20221123/6537cca589914a37ae5be0838bd31e82.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 5]: /images/20221123/6753e59a53fd4c23955a7d65d21976c0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 6]: /images/20221123/4b73305d6315444686782b067425f831.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 7]: /images/20221123/69e3f32a899f4bc8b21531ca471af6f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 8]: /images/20221123/c6e6f74ae8c7477eb8076f4fbba34ad4.png
[20201017222108440.png]: /images/20221123/a3922dbeeb8f414092bb1cddd4d7cccd.png
[20201017222647162.png]: /images/20221123/c079f1b7f45a4de8a6ddd861e7683144.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 9]: /images/20221123/cc82de66bebd47cc87de9b1b398ce47c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 10]: /images/20221123/0a244aa9f4074e34b4340d170566ac1b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 11]: /images/20221123/44c6543db42741c1b5d885d6920ee814.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 12]: /images/20221123/40787223e74047208fa8105a66438b70.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 13]: /images/20221123/74e43f8370574e56865124dc2442b06d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70 14]: /images/20221123/246e4c2c3f3e4831b09996880145820d.png