Docker安装Oracle

前言

本章将使用docker安装mongo,前提条件是已经安装完docker并会使用docker。
如果还没有安装docker,可以参考在CentOS7下安装Docker。

安装Oracle

在Docker Hub上查找镜像

拉取官方镜像

镜像拉取某位大神在阿里云上分享的。

[root@e2ab0x9jme3furrd ~]# docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

镜像比较大,需要等待一段时间。

查看本地镜像

[root@e2ab0x9jme3furrd ~]# docker images

运行容器

[root@e2ab0x9jme3furrd ~]# docker run -d -p 1521:1521 --name oracle01 3fa112fd3642

查看容器状态

[root@e2ab0x9jme3furrd ~]# docker ps

进入oracle容器并创建用户

[root@e2ab0x9jme3furrd ~]# docker exec -it oracal01 /bin/bash
Error: No such container: oracal01
[root@e2ab0x9jme3furrd ~]# docker exec -it oracle01 /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 mike identified by mikeops;

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='MIKE';      

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> 

使用navicat测试连接

原文地址:https://www.cnblogs.com/Gazikel/p/15676399.html