1.安装docker-ce
安装依赖的软件包
yum install -y yum-utils device-mapper-persistent-data lvm2
添加Docker的阿里云yum源
yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
更新软件包索引
yum makecache fast
查看docker版本,这里选择25.0.5
yum list docker-ce --showduplicates |sort –r
安装docker-ce
yum install -y docker-ce-25.0.5
2.启动Docker服务
systemctl start docker #启动Docker
systemctl enable docker.service #设置开机自启
查看docker版本
docker --version
3.获取阿里云的oracle镜像
docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
4.查看获取的镜像
docker images
5.使用docker持久化启动oracle方式如下:
docker run -d \
-p 1521:1521 \
--name oracle11g \
--restart always \
-v /data/oracle:/opt/oracle/oradata \
registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g:latest
6.进入容器
docker exec -it oracle11g(容器名或id) bash
7.添加环境变量
手动设置环境变量
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=helowin
export PATH=$ORACLE_HOME/bin:$PATH
使环境变量生效
source /etc/profile
8.验证设置
echo $ORACLE_HOME
echo $ORACLE_SID
echo $PATH
9.切换root用户
su - root
默认密码:`helowin`
登录`oracle`
su - oracle
# 登录oracle
sqlplus /nolog
登录sqlplus并修改sys、system用户密码
# 连接,需要进行操作系统验证,才可进行连接登录
conn /as sysdba
# 修改system用户账号密码system
alter user system identified by system;
# 修改sys用户账号密码sys
alter user sys identified by sys;
# 修改密码规则策略为密码永不过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
# 退出
exit;
服务名:helowin
密码:oracle
![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/ef97c07f903a48878a2f9c198f372de0.png
查询表空间位置
SELECT SUM(bytes) / (1024 * 1024) AS free_space, tablespace_name
FROM dba_free_space
GROUP BY tablespace_name;
SELECT a.tablespace_name,
a.bytes total,
b.bytes used,
c.bytes free,
(b.bytes * 100) / a.bytes "% USED ",
(c.bytes * 100) / a.bytes "% FREE "
FROM sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c
WHERE a.tablespace_name = b.tablespace_name
AND a.tablespace_name = c.tablespace_name;
查看表空间大小及使用情况
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
SELECT FILE_NAME as 数据文件,TABLESPACE_NAME as 表空间名称,AUTOEXTENSIBLE as 自动扩展,STATUS as 状态,MAXBYTES as 可扩展最大值,USER_BYTES as 已使用大小,INCREMENT_BY as 自动扩展增量 FROM dba_data_files
select name from v$datafile;
select * FROM DBA_DATA_FILES;
.查看表空间使用情况
创建表空间
create tablespace dynamic_data datafile '/data/dynamic_data.dbf' size 200M autoextend on next 200m maxsize unlimited;
create temporary tablespace dynamic_temp tempfile '/data/dynamic_temp.dbf' size 50m autoextend on next 50m maxsize 20480m
extent management local;
create user dynamic_prod identified by dynamic_1314 default tablespace dynamic_data temporary tablespace dynamic_temp; grant connect,resource,dba to dynamic_prod;
到这里我们的Oracle数据就安装完成啦!