oracle soa login plugin db

env: Oracle 12c

Oracle 12c 開始有Pluggable database, 在Oracle Cloud for SOA也開始使用
Oracle Pluggable database與SQL Server  Containser DB有異曲同工之妙

Login Oracle Pluggable database
command:

step1: login Oracle by sqlplus
 

[oracle@B2B ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 7 10:18:45 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.
 

Connected to:

 

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

SQL>

step2: list pluggable database 
SQL> select pdb from v$services;

PDB------------------------------
B2BPDB
CDB$ROOT
CDB$ROOT
CDB$ROOT
CDB$ROOT

step3: swith session and connect to plugged database

SQL> alter session set container=B2BPDB;

Session altered.
step4: list pluggable database
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
SP954682_IAS_UMS

5 rows selected.