docker快速安装oracle

最新推荐文章于 2024-08-17 14:56:47 发布

YongYu_IT

最新推荐文章于 2024-08-17 14:56:47 发布

阅读量167

点赞数 2

分类专栏：大数据

本文链接：https://blog.csdn.net/YongYu_IT/article/details/111830992

版权

大数据专栏收录该内容

16 篇文章 2 订阅

订阅专栏

$ docker run --name oracle_11g -p 1521:1521 -d registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
$ docker exec -it oracle_11g bash
$ su #helowin
# su - oracle
$ sqlplus /nolog
SQL> exit

$ su #helowin
# 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

# source /etc/profile
# ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
# su - oracle
$ sqlplus /nolog
SQL> conn /as sysdba
SQL> alter user system identified by system;
SQL> alter user sys identified by sys;
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> create user test identified by test;
SQL> grant connect,resource,dba to test;

####至此，用test/test即可登录