oracle12c
show con_name;查看当前
show pdbs; 容器个数
desc v$containers;
启动PDB
alter pluggable database pdb open;
alter pluggable database pdb close immediate;
操作系统验证
sqlplus
进入pdb
1.网络
[oracle1@localhost ~]$ cd $ORACLE_HOME/network/admin
cat tnsnames.ora
PDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vdedu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vdedu)
)
)
sqlplus sys/oracle@PDB as sysdba;
vi tnsnames.ora
加入PDB
2.进入pdb
alter session set container=pdb;
oracle 文档38章
cdb/ 下只能创建comm user
create user c##us identified by oracle;
pdb 普通用户
create user n identified by o;
监听注册
conn / as sysdba
show parameter common_
alter system set loca_listener=' ';
题目:
1. 12c 安装
2. 容器
3. 可插拔DB
4. 创建表空间
5. 创建用户
6. 创建监听并注册