Container Database (CDB)
[oracle@lnxrac121 ~]$ echo $ORACLE_SID
cdb121
[oracle@lnxrac121 ~]$
[oracle@lnxrac121 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> select name, cdb, con_id, open_mode from v$database;
NAME CDB CON_ID OPEN_MODE
--------- --- ---------- --------------------
CDB12 YES 0 READ WRITE
SQL> select instance_name, status, host_name from gv$instance;
INSTANCE_NAME STATUS HOST_NAME
---------------- ------------ ----------------------------------------------------------------
cdb121 OPEN lnxrac121.localdomain
cdb122 OPEN lnxrac122.localdomain
SQL>
SQL> select sys_context('userenv','con_name') from dual;
SYS_CONTEXT('USERENV','CON_NAME')
------------------------------------------------------------------------------------
CDB$ROOT
SQL> select con_id, dbid, CON_UID, NAME, OPEN_MODE, TOTAL_SIZE from v$pdbs;
CON_ID DBID CON_UID NAME OPEN_MODE TOTAL_SIZE
---------- ---------- ---------- ------------------------------ ---------- ----------
2 4089358177 4089358177 PDB$SEED READ ONLY 283115520
Create Pluggable Database (PDB)
SQL> create PLUGGABLE database pdb1
admin user pdbusradm1 identified by oracle
roles=(dba)
storage (maxsize 2G);
Pluggable database created.
SQL>
SQL> select con_id, dbid, CON_UID, NAME, OPEN_MODE, TOTAL_SIZE from v$pdbs;
CON_ID DBID CON_UID NAME OPEN_MODE TOTAL_SIZE
---------- ---------- ---------- ------------------------------ ---------- ----------
2 4089358177 4089358177 PDB$SEED READ ONLY 283115520
3 3354457050 3354457050 PDB1 MOUNTED 0
Start Pluggable Database (PDB)
SQL> alter pluggable database PDB1 open;Pluggable database altered.
SQL> select con_id, dbid, CON_UID, NAME, OPEN_MODE, TOTAL_SIZE from v$pdbs;
CON_ID DBID CON_UID NAME OPEN_MODE TOTAL_SIZE
---------- ---------- ---------- ------------------------------ ---------- ----------
2 4089358177 4089358177 PDB$SEED READ ONLY 283115520
3 3354457050 3354457050 PDB1 READ WRITE 283115520
SQL>
Create USER - Pluggable Database (PDB)
[oracle@lnxrac121 admin]$ sqlplus sys@pdb1 as sysdba
SQL*Plus: Release 12.1.0.1.0 Production
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> select name from v$database;
NAME
---------
CDB12
SQL> alter session set container=pdb1;
Session altered.
SQL> alter pluggable database pdb1 open;
Pluggable database altered.
SQL> create user pdb1usr identified by oracle;
User created.
SQL> grant create session, resource to pdb1usr;
Grant succeeded.
SQL> conn pdb1usr/oracle@pdb1
Connected.
SQL> show user
USER is "PDB1USR"
SQL>
SQL>
Create Service on RAC - Pluggable Database (PDB)
Configure TNSNAMES on both nodes
[oracle@lnxrac121 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u02/app/oracle/product/12.1.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
CDB12 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnxrac12-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cdb12)
)
)
pdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnxrac12-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb1)
)
)
sconnpdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnxrac12-scan.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sconnpdb1)
)
)
[oracle@lnxrac121 admin]$
Create Service
[oracle@lnxrac121 admin]$ cd $GRID_HOME[oracle@lnxrac121 grid]$ cd bin
[oracle@lnxrac121 bin]$ ./srvctl add service -db cdb12 -service sconnpdb1 -pdb pdb1 -preferred cdb121 -available cdb122
[oracle@lnxrac121 bin]$
[oracle@lnxrac121 bin]$ ./crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.DGASMFS.ASMVLACFS.advm
ONLINE ONLINE lnxrac121 Volume device /dev/a
sm/asmvlacfs-256 is
online,STABLE
ONLINE ONLINE lnxrac122 Volume device /dev/a
sm/asmvlacfs-256 is
online,STABLE
ora.DGASMFS.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.FRA.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.asm
ONLINE ONLINE lnxrac121 Started,STABLE
ONLINE ONLINE lnxrac122 Started,STABLE
ora.dgasmfs.asmvlacfs.acfs
ONLINE ONLINE lnxrac121 mounted on /u03/asmf
s,STABLE
ONLINE ONLINE lnxrac122 mounted on /u03/asmf
s,STABLE
ora.net1.network
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.ons
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE lnxrac121 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE lnxrac121 169.254.163.8 192.16
8.1.101,STABLE
ora.cdb12.db
1 ONLINE ONLINE lnxrac121 Open,STABLE
2 ONLINE ONLINE lnxrac122 Open,STABLE
ora.cdb12.sconnpdb1.svc
1 ONLINE ONLINE lnxrac121 STABLE
ora.cvu
1 ONLINE ONLINE lnxrac121 STABLE
ora.lnxrac121.vip
1 ONLINE ONLINE lnxrac121 STABLE
ora.lnxrac122.vip
1 ONLINE ONLINE lnxrac122 STABLE
ora.mgmtdb
1 ONLINE ONLINE lnxrac121 Open,STABLE
ora.oc4j
1 ONLINE ONLINE lnxrac121 STABLE
ora.scan1.vip
1 ONLINE ONLINE lnxrac121 STABLE
--------------------------------------------------------------------------------
[oracle@lnxrac121 bin]$
Testing Service on Instance 1 - Pluggable Database (PDB)
[oracle@lnxrac121 admin]$ sqlplus pdb1usr/oracle@sconnpdb1
SQL*Plus: Release 12.1.0.1.0 Production
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> show con_name
CON_NAME
------------------------------
PDB1
SQL>
Testing Service on Instance 2 - Pluggable Database (PDB)
[grid@lnxrac122 ~]$ srvctl stop service -db cdb12 -s sconnpdb1[grid@lnxrac122 ~]$ srvctl start service -db cdb12 -s sconnpdb1 -n lnxrac122
[grid@lnxrac122 ~]$
[grid@lnxrac122 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.DGASMFS.ASMVLACFS.advm
ONLINE ONLINE lnxrac121 Volume device /dev/a
sm/asmvlacfs-256 is
online,STABLE
ONLINE ONLINE lnxrac122 Volume device /dev/a
sm/asmvlacfs-256 is
online,STABLE
ora.DGASMFS.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.FRA.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.asm
ONLINE ONLINE lnxrac121 Started,STABLE
ONLINE ONLINE lnxrac122 Started,STABLE
ora.dgasmfs.asmvlacfs.acfs
ONLINE ONLINE lnxrac121 mounted on /u03/asmf
s,STABLE
ONLINE ONLINE lnxrac122 mounted on /u03/asmf
s,STABLE
ora.net1.network
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.ons
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE lnxrac121 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE lnxrac121 169.254.163.8 192.16
8.1.101,STABLE
ora.cdb12.db
1 ONLINE ONLINE lnxrac121 Open,STABLE
2 ONLINE ONLINE lnxrac122 Open,STABLE
ora.cdb12.sconnpdb1.svc
1 ONLINE ONLINE lnxrac122 STABLE
ora.cvu
1 ONLINE ONLINE lnxrac121 STABLE
ora.lnxrac121.vip
1 ONLINE ONLINE lnxrac121 STABLE
ora.lnxrac122.vip
1 ONLINE ONLINE lnxrac122 STABLE
ora.mgmtdb
1 ONLINE ONLINE lnxrac121 Open,STABLE
ora.oc4j
1 ONLINE ONLINE lnxrac121 STABLE
ora.scan1.vip
1 ONLINE ONLINE lnxrac121 STABLE
--------------------------------------------------------------------------------
[grid@lnxrac122 ~]$
[oracle@lnxrac122 admin]$ sqlplus pdb1usr/oracle@sconnpdb1
SQL*Plus: Release 12.1.0.1.0 Production
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> show con_name
CON_NAME
------------------------------
PDB1
SQL>
Relocate Service to Instance 1 (PDB)
[grid@lnxrac122 ~]$ srvctl relocate service -d cdb12 -s sconnpdb1 -i cdb122 -t cdb121
[grid@lnxrac122 ~]$
[grid@lnxrac122 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.DGASMFS.ASMVLACFS.advm
ONLINE ONLINE lnxrac121 Volume device /dev/a
sm/asmvlacfs-256 is
online,STABLE
ONLINE ONLINE lnxrac122 Volume device /dev/a
sm/asmvlacfs-256 is
online,STABLE
ora.DGASMFS.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.FRA.dg
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.asm
ONLINE ONLINE lnxrac121 Started,STABLE
ONLINE ONLINE lnxrac122 Started,STABLE
ora.dgasmfs.asmvlacfs.acfs
ONLINE ONLINE lnxrac121 mounted on /u03/asmf
s,STABLE
ONLINE ONLINE lnxrac122 mounted on /u03/asmf
s,STABLE
ora.net1.network
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
ora.ons
ONLINE ONLINE lnxrac121 STABLE
ONLINE ONLINE lnxrac122 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE lnxrac121 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE lnxrac121 169.254.163.8 192.16
8.1.101,STABLE
ora.cdb12.db
1 ONLINE ONLINE lnxrac121 Open,STABLE
2 ONLINE ONLINE lnxrac122 Open,STABLE
ora.cdb12.sconnpdb1.svc
1 ONLINE ONLINE lnxrac121 STABLE
ora.cvu
1 ONLINE ONLINE lnxrac121 STABLE
ora.lnxrac121.vip
1 ONLINE ONLINE lnxrac121 STABLE
ora.lnxrac122.vip
1 ONLINE ONLINE lnxrac122 STABLE
ora.mgmtdb
1 ONLINE ONLINE lnxrac121 Open,STABLE
ora.oc4j
1 ONLINE ONLINE lnxrac121 STABLE
ora.scan1.vip
1 ONLINE ONLINE lnxrac121 STABLE
--------------------------------------------------------------------------------
[grid@lnxrac122 ~]$
Close Pluggable Database (PDB)
SQL> alter PLUGGABLE database pdb1 close;Pluggable database altered.
SQL>
Nenhum comentário:
Postar um comentário