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测试连接

posted @   Gazikel  阅读(1646)  评论(0编辑  收藏  举报
编辑推荐:
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
阅读排行:
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· 百万级群聊的设计实践
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
· 永远不要相信用户的输入:从 SQL 注入攻防看输入验证的重要性
历史上的今天:
2020-12-11 Servlet2
点击右上角即可分享
微信分享提示