oracle容器

创建用户

1.输入：sqlplus /nolog //进入oralce控制台
2.输入：conn /as sysdba //以管理员权限登录
3.输入：create user abc identified by 123456; //创建用户名adc密码123456
4.输入：grant dba to abc; //授予DBA权限

docker 容器

//拉取镜像
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 oracle11g bash
//切换管理员密码是helowin
su root
//修改profile，文件最底部添加三行。
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
//连接数据库，添加navavat访问用户
[[email protected] ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 10 12:54:06 2018
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> alter user system identified by system;
User altered.

SQL> alter user sys identified by sys;
User altered.
SQL> create user ETS identified by ETS ;
User created.
SQL> grant connect,resource,dba to ETS ;
Grant succeeded.