docker oracle12c

- 日理万妓 2022-11-01 00:58 181阅读 0赞

### docker oracle12c ###

*  安装oracle12c
 *  登录oracle查看基础信息
 *  切换容器

<table> 
 <thead> 
  <tr> 
   <th>变量名称</th> 
   <th>变量值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>oracle版本</td> 
   <td>Release 12.2.0.1.0</td> 
  </tr> 
  <tr> 
   <td>$ORACLE_BASE</td> 
   <td>/opt/oracle</td> 
  </tr> 
  <tr> 
   <td>$ORACLE_HOME</td> 
   <td>/opt/oracle/product/12.2.0.1/dbhome_1</td> 
  </tr> 
  <tr> 
   <td>$ORACLE_SID</td> 
   <td>ORCLCDB</td> 
  </tr> 
 </tbody> 
</table>

# 安装oracle12c #

[root@localhost ~]# docker pull 18951717198/oracle12c:latest
    [root@localhost ~]# docker run \
    --name oracle \
    --privileged=true \
    -d \
    -p 1521:1521 \
    -e WEB_CONSOLE=false \
    -e CHARACTER_SET=ZHS16GBK \
    18951717198/oracle12c
    [root@localhost ~]# docker exec -it oracle bash
    
    # 找到oracle的安装目录
    [oracle@778451ee7ea4 ~]$ echo $ORACLE_HOME
    /opt/oracle/product/12.2.0.1/dbhome_1
    
    # 找到oracle的SID ORCLCDB
    [oracle@778451ee7ea4 ~]$ cd /opt/oracle/oradata
    [oracle@778451ee7ea4 oradata]$ ls
    ORCLCDB  dbconfig
    
    # ORCLCDB目录下存放表空间
    [oracle@778451ee7ea4 oradata]$ ls ORCLCDB/
    ORCLPDB1  control01.ctl  control02.ctl  pdbseed  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf
    
    # echo $ORACLE_SID，打印出空字符串 设置一下ORACLE_SID
    [oracle@778451ee7ea4 ~]export ORACLE_SID=ORCLCDB
    [oracle@778451ee7ea4 ~]echo $ORACLE_SID
    ORCLCDB
    
    [oracle@0e259b3dfd1f ~]$ whereis sqlplus
    sqlplus: /opt/oracle/product/12.2.0.1/dbhome_1/bin/sqlplus

# 登录oracle查看基础信息 #

[oracle@778451ee7ea4 ~]$ sqlplus / as sysdba
    SQL*Plus: Release 12.2.0.1.0 Production on Tue Feb 23 17:24:16 2021
    
    #查看oracle版本
    SQL> select * from v$version;
    
    # 查询该容器是CDB 还是非CDB
    SQL> select name,cdb,open_mode,con_id from v$database;
    NAME      CDB OPEN_MODE                CON_ID
    --------- --- -------------------- ----------
    ORCLCDB   YES READ WRITE                    0
    
    # 查看当前容器
    SQL> show con_name;
    CON_NAME
    ------------------------------
    CDB$ROOT
    
    # 查看所创建的PDB
    SQL> show pdbs;
        CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    ---------- ------------------------------ ---------- ----------
             2 PDB$SEED                       READ ONLY  NO
             3 ORCLPDB1                       READ WRITE NO

# 切换容器 #

# 现在的容器是 CDB$ROOT， 切换容器到 ORCLPDB1
    SQL> select sys_context ('USERENV', 'CON_NAME') from dual;
    SYS_CONTEXT('USERENV','CON_NAME')
    --------------------------------------------------------------------------------
    CDB$ROOT
    
    SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
        CON_ID       DBID          NAME				OPEN_MODE
    ---------- --------------------------------------------------------------
             2 1906237005		PDB$SEED			READ WRITE
             3 3247285267		ORCLPDB1			READ WRITE
    
    # 将Pdb open：
    SQL> alter pluggable database ORCLPDB1 open;
    
    # 切换容器到 ORCLPDB1
    SQL> alter session set container=ORCLPDB1;
    
    # 再次查看
    SQL> select sys_context ('USERENV', 'CON_NAME') from dual;
    SYS_CONTEXT('USERENV','CON_NAME')
    --------------------------------------------------------------------------------
    ORCLPDB1

# 创建表空间
    SQL> create tablespace "IRS" logging datafile '/opt/oracle/oradata/ORCLCDB/irs.dbf' size 100m autoextend on next 100m extent management local;
    
    # 用定义好的表空间创建用户 用户名/密码/表空间/临时表空间：IRS/IRS/IRS/TEMP
    SQL> create user "IRS" identified by "IRS" default tablespace "IRS" temporary tablespace "TEMP";
    
    SQL> grant dba to "IRS";
    grant connect,resource to "IRS";
    grant create session, create table,create view,connect,resource,dba to "IRS";
    
    # 查看数据库的用户表
    SQL> select username,ACCOUNT_STATUS from dba_users where username = 'IRS';

# 删除表空间
    SQL> drop tablespace "IRS" including contents and datafiles;
    # 删除用户
    SQL> drop user "IRS" cascade;
    # 修改密码
    SQL> alter user "IRS" identified by 123456;
    
    # 实现登录不区分大小写 Oracle 11g以前的版本不区分大小写
    SQL> alter system set sec_case_sensitive_logon=false;