Dict.CN 在线词典, 英语学习, 在线翻译 ------------- MyGitee 朱秋贵内科诊所 My腾云code

Docker--oracle

1、docker pull registry.cn-hangzhou.aliyuncs.com/qida/oracle-xe-11g

是ubuntu 版

注:ubuntu apt-get install vim

2、docker run -d -p 1521:1521 --name oracle11 registry.cn-hangzhou.aliyuncs.com/qida/oracle-xe-11g

 

$ docker ps 查看当前容器
CONTAINER ID IMAGE COMMAND CREATED 
6787e5781b05 sath89/oracle-12c "/entrypoint.sh " 8 days ago 
$docker exec -it 6787e5781b05 /bin/bash 进入容器
$ su oracle 切换到oracle用户
$ $ORACLE_HOME/bin/sqlplus / as sysdba 进入sqlplus

 

######### alter user system identified by system 修改密码为system ##########################3

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.

 

3、

如果是 root 登陆,需要切换到oracle用户上:

(1)输入命令 su - oracle 切换到 oracle 用户;

(2)输入命令 echo $ORACLE_SID 打印Oracle数据库的SID

4、

XE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.131.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =XE)

)
)

 

 

 

 

SQL> alter user system identified by system;  

User altered.

 

 

 

https://www.cnblogs.com/OliverQin/p/9765808.html  【Docker】拉取Oracle 11g镜像配置

https://www.cnblogs.com/maoxianfei/p/9083426.html  Docker oracle部署使用

https://www.csdn.net/gather_27/MtTaQg3sNzczOC1ibG9n.html

posted @ 2019-07-02 22:41  cn2024  阅读(293)  评论(0编辑  收藏  举报