安装docker
brew cask install docker
镜像加速
https://promotion.aliyun.com/ntms/act/kubernetes.html
{
"registry-mirrors": [
"https://u9irc6iy.mirror.aliyuncs.com"
],
"features": {
"buildkit": true
},
"experimental": false
}
安装Mysql
查找镜像
docker search mysql
拉取 MySQL 镜像
docker pull mysql:latest
查看本地镜像
docker images
运行容器
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
工具连接
停止
docker stop mysql-8.0
删除容器
docker rm 容器id
删除镜像
docker rmi 镜像id
安装oracle11g
拉取镜像
docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
查看镜像
docker images
创建容器
docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
启动容器
docker start oracle11g
进入镜像进行配置
docker exec -it --user root oracle11g /bin/bash
vi /etc/profile
配置环境变量
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=helowin
export PATH=$ORACLE_HOME/bin:$PATH
创建软连接
ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
切换到oracle用户
su - oracle
登录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;
查看lsnrctl 服务
lsnrctl status
navicat连接
创建表空间
create tablespace prepolicy datafile '/home/oracle/app/oracle/oradata/helowin/prepolicy.dbf' size 200M autoextend on next 50M;