如何使用docker安装oracle

• 操作
• navicat连接

• 首先在服务器上安装docker:安装docker

• 拉取官方镜像

docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

• 查看镜像信息

docker images

• 运行oracle镜像变成容器(默认端口是1521)

docker run -d -p 1521:1521 --name oracle01 镜像id

• 演示服务器中对oracle配置等操作如下(傻瓜式操作)

[root@e2ab0x9jme3furrd ~]# docker exec -it 容器id /bin/bash
[oracle@a49ca77e4a58 /]$ cd /home/oracle
[oracle@a49ca77e4a58 ~]$ source .bash_profile
[oracle@a49ca77e4a58 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 3 15:10:28 2021

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 system;

User altered.

SQL> create user edt identified by edt666;

User created.

SQL> grant connect, resource, dba to mike;

Grant succeeded.

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL> alter system set processes=2000 scope=spfile;

System altered.

SQL> select * from dba_users t where t.username='EDT';      

USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
MIKE           91

USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OPEN

USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
USERS          TEMP         03-DEC-21

USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
DEFAULT          DEFAULT_CONSUMER_GROUP

USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------


USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G  N PASSWORD

USERNAME     USER_ID PASSWORD
------------------------------ ---------- ------------------------------
ACCOUNT_STATUS    LOCK_DATE EXPIRY_DA
-------------------------------- --------- ---------
DEFAULT_TABLESPACE        TEMPORARY_TABLESPACE       CREATED
------------------------------ ------------------------------ ---------
PROFILE          INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ------------------------------
EXTERNAL_NAME
--------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------


SQL>