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

  • 相关阅读:
    修改Putty终端目录(ls命令)显示颜色
    在循环中进行提交的测试
    远程连接Redhat Linux配置
    如何部署Silverlight及Web Service
    SQL2008 的收缩日志
    WPF中DataGrid使用初步
    常用SQL
    DataGridView转datatable
    Ext程序规划入门
    下一代C#里的async和await
  • 原文地址:https://www.cnblogs.com/Gazikel/p/15676399.html
Copyright © 2020-2023  润新知