# Docker 下拉取oracle 11g镜像配置

**Repository Path**: Microservice-Framework/docker_oracle_11g

## Basic Information

- **Project Name**: Docker 下拉取oracle 11g镜像配置
- **Description**: Docker 下拉取oracle 11g镜像配置
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2019-07-01
- **Last Updated**: 2024-06-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

1、拉取镜像
```
docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/153023_6b4e33ae_527982.png "1561961559225.png")
2、创建并容器信息
```
docker run -d -p 1521:1521 --name oracle_11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/155250_7fd2282b_527982.png "1561961559225.png")
3、进入控制台设置用户信息
```
docker exec -it oracle_11g bash
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/155649_c07fc419_527982.png "1561961559225.png")
登录sqlplus /nolog，此处发现sqlplus命令不可用，所以需要进行相关配置，操作步骤如下：
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/155906_458180a3_527982.png "1561961559225.png")
（1）、切换到root用户模式下
su root
输入密码helowin
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/160053_544db9f2_527982.png "1561961559225.png")
(2)、编辑profile文件配置ORACLE环境变量
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
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/160507_0158211c_527982.png "1561961559225.png")
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/160717_48e6e567_527982.png "1561961559225.png")
（3）、软件连接
```
ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/160958_521a12a4_527982.png "1561961559225.png")
（4）、切换到oracle 用户
```
su - oracle
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/161143_ea1bfeb3_527982.png "1561961559225.png")
登录sqlplus并修改sys、system用户密码
```
sqlplus /nolog
conn /as sysdba
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/161301_a50481e0_527982.png "1561961559225.png")
接着执行下面命令
```
alter user system identified by NZk89PDXK1g7CgLr;
alter user sys identified by UkxooEjWfOzaHw6a;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/161608_9d474fc7_527982.png "1561961559225.png")
创建新用户
```
create user kpiuser identified by fFlF2QY8ZW2ti2Vy;
grant connect,resource,dba to kpiuser;
```
![输入图片说明](https://images.gitee.com/uploads/images/2019/0701/162346_77a3bdab_527982.png "1561961559225.png")
修改processes和sessions值

```
SQL> alter system set processes=3000 scope=spfile;
系统已更改。
SQL> alter system set sessions=3305 scope=spfile;
系统已更改。
```