docker安装oracle11g

服务器8g内存,sga给4  pga给2g,把name和sid保持一致,设置data挂载

docker run -d --name dbalex -p 1521:1521 -e ORACLE_SID=dbalex -e ORACLE_PWD=oracle -e ORACLE_CHARACTERSET=AL32UTF8 -e SGA_SIZE=4G -e PGA_SIZE=2G -e DB_ROLE=primary -e ENABLE_ARCH=true -v /data/dbalex02:/opt/oracle/oradata registry-vpc.cn-hangzhou.aliyuncs.com/woqutech/oracle-database-11.2.0.4.0-ee:latest

  

进入容器,登录oracle,连接,创建用户,修改密码,

sh-4.2$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 11 03:07:48 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected.
SQL> SQL> show user;
USER is "SYS"
SQL> create user root identified by 123456;


User created.

SQL> SQL> grant connect,resource,dba to root;


Grant succeeded.

SQL> SQL>  alter user system identified by 123456;

User altered.

SQL> 
SQL> alter user sys identified by 123456;

User altered.

SQL> alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

  

docker安装oracle11g

上一篇:mysql知识点


下一篇:FreeSql.Repository (四)工作单元