docker oracle12c

变量名称	变量值
oracle版本	Release 12.2.0.1.0
$ORACLE_BASE	/opt/oracle
$ORACLE_HOME	/opt/oracle/product/12.2.0.1/dbhome_1
$ORACLE_SID	ORCLCDB

安装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;