Oracle Database Commands and Practical Examples

Saturday 8 August 2020

Multitenant - Unplugged and Plugged database with same GUID copy method

Multitenant - Unplugged and Plugged database with same GUID copy method on same host database

UPLUGGABLE : PDB3

PLUGGABLE :PLM2

NOTE: If we do not specify NOCOPY then with same GUID we are unable to create PLUGGABLE DATABASE on same host CDB database. In remote CDB GUID is different we can use NOCOPY method.

Keywards:

ALTER PLUGGABLE DATABASE PDB3 UNPLUG INTO '/HOME/ORACLE/PDB3.XML';

Check compatibilty of unpluggable and pluggable on both host or remote database

DECLARE
2 compatible BOOLEAN := FALSE;
BEGIN
compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY(PDB_DESCR_FILE => '/home/oracle/pdb3.xml');
if compatible then
DBMS_OUTPUT.PUT_LINE('It is compatible');
else
DBMS_OUTPUT.PUT_LINE('It is NOT compatible');
end if;
END;
/

CREATE PLUGGABLE DATABASE PLM2 USING '/HOME/ORACLE/PDB3.XML' NOCOPY TEMPFILE REUSE;

Example:

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLM1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO

SQL> set linesize 100
SQL> col name format a100
SQL> SELECT NAME FROM V$DATAFILE WHERE CON_ID = (SELECT CON_ID FROM V$PDBS WHERE NAME='PDB3');

NAME
----------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_system_hlr3x0x
l_.dbf

/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_sysaux_hlr3x0x
q_.dbf

/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_undotbs1_hlr3x
0xq_.dbf

SQL> select GUID from v$pdbs where name='PDB3';

GUID
--------------------------------
AC37117322776C58E0534938A8C02132

SQL> ALTER PLUGGABLE DATABASE pdb3 close;

Pluggable database altered.

SQL> alter pluggable database pdb3 unplug into '/home/oracle/pdb3.xml';

Pluggable database altered.

SQL> host cat /home/oracle/pdb3.xml
<?xml version="1.0" encoding="UTF-8"?>
<PDB>
<xmlversion>1</xmlversion>
<pdbname>PDB3</pdbname>
<cid>5</cid>
<byteorder>1</byteorder>
<vsn>203424000</vsn>
<vsns>
<vsnnum>12.2.0.1.0</vsnnum>
<cdbcompt>12.2.0.0.0</cdbcompt>
<pdbcompt>12.2.0.0.0</pdbcompt>
<vsnlibnum>0.0.0.0.24</vsnlibnum>
<vsnsql>24</vsnsql>
<vsnbsv>8.0.0.0.0</vsnbsv>
</vsns>
<dbid>3048296195</dbid>
<ncdb2pdb>0</ncdb2pdb>
<cdbid>3280283628</cdbid>
<guid>AC37117322776C58E0534938A8C02132</guid>
<uscnbas>1769801</uscnbas>
<uscnwrp>0</uscnwrp>
<undoscn>225</undoscn>
<rdba>4194824</rdba>
<tablespace>
<name>SYSTEM</name>
<type>0</type>
<tsn>0</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>8</bmunitsize>
<file>
<path>/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_system_hlr3x0xl_.dbf</path>
<afn>18</afn>
<rfn>1</rfn>
<createscnbas>1645738</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>33280</fileblocks>
<blocksize>8192</blocksize>
<vsn>203423744</vsn>
<fdbid>3048296195</fdbid>
<fcpsb>1769795</fcpsb>
<fcpsw>0</fcpsw>
<frlsb>1408558</frlsb>
<frlsw>0</frlsw>
<frlt>1047595884</frlt>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>1280</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<tablespace>
<name>SYSAUX</name>
<type>0</type>
<tsn>1</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>8</bmunitsize>
<file>
<path>/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_sysaux_hlr3x0xq_.dbf</path>
<afn>19</afn>
<rfn>4</rfn>
<createscnbas>1645741</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>46080</fileblocks>
<blocksize>8192</blocksize>
<vsn>203423744</vsn>
<fdbid>3048296195</fdbid>
<fcpsb>1769795</fcpsb>
<fcpsw>0</fcpsw>
<frlsb>1408558</frlsb>
<frlsw>0</frlsw>
<frlt>1047595884</frlt>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>1280</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<tablespace>
<name>UNDOTBS1</name>
<type>2</type>
<tsn>2</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>8</bmunitsize>
<file>
<path>/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_undotbs1_hlr3x0xq_.dbf</path>
<afn>20</afn>
<rfn>9</rfn>
<createscnbas>1645743</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>12800</fileblocks>
<blocksize>8192</blocksize>
<vsn>203423744</vsn>
<fdbid>3048296195</fdbid>
<fcpsb>1769795</fcpsb>
<fcpsw>0</fcpsw>
<frlsb>1408558</frlsb>
<frlsw>0</frlsw>
<frlt>1047595884</frlt>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>640</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<tablespace>
<name>TEMP</name>
<type>1</type>
<tsn>3</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>128</bmunitsize>
<file>
<path>/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC37117322776C58E0534938A8C02132/datafile/o1_mf_temp_hlr3x0xr_.dbf</path>
<afn>5</afn>
<rfn>1</rfn>
<createscnbas>1645739</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>16512</fileblocks>
<blocksize>8192</blocksize>
<vsn>203423744</vsn>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>80</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<recover>0</recover>
<optional>
<ncdb2pdb>0</ncdb2pdb>
<csid>873</csid>
<ncsid>2000</ncsid>
<options>
<option>APS=12.2.0.1.0</option>
<option>CATALOG=12.2.0.1.0</option>
<option>CATJAVA=12.2.0.1.0</option>
<option>CATPROC=12.2.0.1.0</option>
<option>CONTEXT=12.2.0.1.0</option>
<option>DV=12.2.0.1.0</option>
<option>JAVAVM=12.2.0.1.0</option>
<option>OLS=12.2.0.1.0</option>
<option>ORDIM=12.2.0.1.0</option>
<option>OWM=12.2.0.1.0</option>
<option>SDO=12.2.0.1.0</option>
<option>XDB=12.2.0.1.0</option>
<option>XML=12.2.0.1.0</option>
<option>XOQ=12.2.0.1.0</option>
</options>
<olsoid>0</olsoid>
<dv>0</dv>
<APEX>NULL</APEX>
<parameters>
<parameter>processes=800</parameter>
<parameter>nls_language='AMERICAN'</parameter>
<parameter>nls_territory='AMERICA'</parameter>
<parameter>db_block_size=8192</parameter>
<parameter>compatible='12.2.0'</parameter>
<parameter>open_cursors=300</parameter>
<parameter>pga_aggregate_target=597688320</parameter>
<parameter>enable_pluggable_database=TRUE</parameter>
<spfile>*.ddl_lock_timeout=12#HWM:12,</spfile>
</parameters>
<sqlpatches/>
<tzvers>
<tzver>primary version:26</tzver>
<tzver>secondary version:0</tzver>
</tzvers>
<walletkey>0</walletkey>
<services/>
<opatches/>
<hasclob>1</hasclob>
<awr>
<loadprofile>CPU used by this session=18.049089</loadprofile>
<loadprofile>DB time=31.254604</loadprofile>
<loadprofile>db block changes=512.911666</loadprofile>
<loadprofile>execute count=621.649994</loadprofile>
<loadprofile>logons cumulative=0.040400</loadprofile>
<loadprofile>parse count (hard)=32.055749</loadprofile>
<loadprofile>parse count (total)=303.904155</loadprofile>
<loadprofile>physical reads=141.264852</loadprofile>
<loadprofile>physical writes=38.204222</loadprofile>
<loadprofile>redo size=89106.808472</loadprofile>
<loadprofile>session logical reads=4789.740583</loadprofile>
<loadprofile>user calls=2.785056</loadprofile>
<loadprofile>user commits=1.110153</loadprofile>
<loadprofile>user rollbacks=0.037911</loadprofile>
</awr>
<hardvsnchk>0</hardvsnchk>
<localundo>1</localundo>
<apps/>
<dbedition>8</dbedition>
<ver122010>1</ver122010>
</optional>
</PDB>

SQL> SELECT PDB_NAME, STATUS FROM CDB_PDBS WHERE PDB_NAME IN ('PDB3');

PDB_NAME
----------------------------------------------------------------------------------------------------
STATUS
----------
PDB3
UNPLUGGED

SQL> DROP PLUGGABLE DATABASE PDB3 keep datafiles;

Pluggable database dropped.

SQL> SELECT PDB_NAME, STATUS FROM CDB_PDBS WHERE PDB_NAME IN ('PDB3');

no rows selected

SQL> set serveroutput on
SQL> DECLARE
2 compatible BOOLEAN := FALSE;
BEGIN
compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY(PDB_DESCR_FILE => '/home/oracle/pdb3.xml');
if compatible then
DBMS_OUTPUT.PUT_LINE('It is compatible');
else
DBMS_OUTPUT.PUT_LINE('It is NOT compatible');
end if;
END;
/ 3 4 5 6 7 8 9 10 11
It is compatible

PL/SQL procedure successfully completed.

SQL> CREATE PLUGGABLE DATABASE PLM2 USING '/home/oracle/pdb3.xml' NOCOPY TEMPFILE REUSE;

Pluggable database created.

NOTE: If we do not specify NOCOPY then with same GUID we are unable to create PLUGGABLE DATABASE on same host CDB database. In remote CDB GUID is different we can use NOCOPY method.

SQL> col pdb_name format a5
SQL> SELECT PDB_NAME, STATUS FROM CDB_PDBS WHERE PDB_NAME='PLM2';

PDB_N STATUS
----- ----------
PLM2 NEW

SQL> SELECT OPEN_MODE FROM V$PDBS WHERE NAME='PLM2';

OPEN_MODE
----------
MOUNTED

SQL> ALTER PLUGGABLE DATABASE PLM2 open;

Pluggable database altered.

SQL> SELECT GUID FROM V$PDBS WHERE NAME='PLM2';

GUID
--------------------------------
AC37117322776C58E0534938A8C02132

SQL> select GUID from v$pdbs where name='PDB3';

GUID
--------------------------------
AC37117322776C58E0534938A8C02132

Multitenant- Create PDB using db links from remote PDB

Multitenant- Create PDB using db links from remote PDB

KEYWORDS:

CREATE PLUGGABLE DATABASE pdb6 FROM TEST1@STDRAC_LINK;

EXAMPLE:

CREATE DATABASE LINK STDRAC_LINK CONNECT TO system IDENTIFIED BY system123 USING 'STDRAC';

oracle@srv3:~> . oraenv
ORACLE_SID = [SMRCDB] ?
The Oracle base remains unchanged with value /u01/app/oracle
oracle@srv3:~> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 7 12:52:47 2020

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> CREATE DATABASE LINK STDRAC_LINK CONNECT TO system IDENTIFIED BY system123 USING 'STDRAC';

Database link created.

SQL> set lines 200

SQL> col OWNER for a30
SQL> col DB_LINK for a30
SQL> col USERNAME for a30
SQL> col HOST for a30
SQL> set lines 200
SQL> select * from dba_db_links;

OWNER DB_LINK USERNAME HOST CREATED HID
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------- ---
SYS SYS_HUB SEEDDATA 26-JAN-17 NO
SYS STDRAC_LINK SYSTEM STDRAC 07-AUG-20 NO

SQL>
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
oracle@srv3:~> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 7 13:04:32 2020

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLM1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
7 PDB5 READ WRITE NO
SQL> select sysdate from dual@STDRAC_LINK;

SYSDATE
---------
07-AUG-20

SQL>
CREATE PLUGGABLE DATABASE pdb6 FROM TEST1@STDRAC_LINK;

oracle@srv3:~> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 7 13:04:32 2020

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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLM1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
7 PDB5 READ WRITE NO
SQL> select sysdate from dual@STDRAC_LINK;

SYSDATE
---------
07-AUG-20

SQL> CREATE PLUGGABLE DATABASE pdb6 FROM TEST1@STDRAC_LINK;

Pluggable database created.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLM1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB6 MOUNTED
7 PDB5 READ WRITE NO
SQL> alter pluggable database PDB6 open;

Pluggable database altered.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLM1 READ WRITE NO
4 PDB2 READ WRITE NO
5 PDB3 READ WRITE NO
6 PDB6 READ WRITE NO
7 PDB5 READ WRITE NO

NOTE : Make TNSNAMES.ORA Entry using NETCA utility

Multitenant - Creating PDB from seed by mapping names of existing files to new file names destination

Multitenant - Creating PDB from seed

Creating PDB from PDB$SEED template default by mapping names of existing files to new file names destination option below:

KEYWARDS:

DB_CREATE_FILE_DEST
FILE_NAME_CONVERT
PDB_FILE_NAME_CONVERT

EXAMPLE:

DB_CREATE_FILE_DEST:

SQL> select cdb from v$database;

CDB

---

YES

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

SQL> sho parameter create_file

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest string

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/SMRCDB/system01.dbf

/u01/app/oracle/oradata/SMRCDB/sysaux01.dbf

/u01/app/oracle/oradata/SMRCDB/undotbs01.dbf

/u01/app/oracle/oradata/SMRCDB/pdbseed/system01.dbf

/u01/app/oracle/oradata/SMRCDB/pdbseed/sysaux01.dbf

/u01/app/oracle/oradata/SMRCDB/users01.dbf

/u01/app/oracle/oradata/SMRCDB/pdbseed/undotbs01.dbf

7 rows selected.

SQL> show parameter DB_CREATE_FILE_DEST

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest string

SQL> CREATE PLUGGABLE DATABASE PDB1 ADMIN USER pdb1admin IDENTIFIED BY pdb1admin STORAGE (MAXSIZE 2G);

CREATE PLUGGABLE DATABASE PDB1 ADMIN USER pdb1admin IDENTIFIED BY pdb1admin STORAGE (MAXSIZE 2G)

ERROR at line 1:

ORA-65016: FILE_NAME_CONVERT must be specified

SQL> alter session set DB_CREATE_FILE_DEST='/u01/app/oracle/oradata/SMRCDB/';

Session altered.

SQL> sho parameter DB_CREATE_FILE_DEST

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_create_file_dest string /u01/app/oracle/oradata/SMRCDB

SQL> CREATE PLUGGABLE DATABASE PDB1 ADMIN USER pdb1admin IDENTIFIED BY pdb1admin STORAGE (MAXSIZE 2G);

Pluggable database created.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 MOUNTED

SQL> alter pluggable database PDB1 open;

Pluggable database altered.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/SMRCDB/system01.dbf

/u01/app/oracle/oradata/SMRCDB/sysaux01.dbf

/u01/app/oracle/oradata/SMRCDB/undotbs01.dbf

/u01/app/oracle/oradata/SMRCDB/pdbseed/system01.dbf

/u01/app/oracle/oradata/SMRCDB/pdbseed/sysaux01.dbf

/u01/app/oracle/oradata/SMRCDB/users01.dbf

/u01/app/oracle/oradata/SMRCDB/pdbseed/undotbs01.dbf

/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC1FFF3873F80C57E0534938A8C08B37/datafile/

o1_mf_system_hlo34nwc_.dbf

/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC1FFF3873F80C57E0534938A8C08B37/datafile/

NAME

--------------------------------------------------------------------------------

o1_mf_sysaux_hlo34nwj_.dbf

/u01/app/oracle/oradata/SMRCDB/SMRCDB/AC1FFF3873F80C57E0534938A8C08B37/datafile/

o1_mf_undotbs1_hlo34nwj_.dbf

10 rows selected.

FILE_NAME_CONVERT:

FILE_NAME_CONVERT=('/u01/app/oracle/oradata/SMRCDB/pdbseed/','/u01/app/oracle/oradata/SMRCDB/PDB2');

oracle@srv3:/u01/app/oracle/product/12.2.0/dbhome_1/network/admin> sqlplus sys/system123@SMRCDB as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 5 17:57:44 2020

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> CREATE PLUGGABLE DATABASE PDB2 ADMIN USER pdb1admin IDENTIFIED BY pdb1admin FILE_NAME_CONVERT=('/u01/app/oracle/oradata/SMRCDB/pdbseed/','/u01/app/oracle/oradata/SMRCDB/PDB2/');

Pluggable database created.

SQL>

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

4 PDB2 MOUNTED

SQL> alter pluggable database PDB2 open;

Pluggable database altered.

SQL> alter session set container=PDB2;

Session altered.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/SMRCDB/PDB2/system01.dbf

/u01/app/oracle/oradata/SMRCDB/PDB2/sysaux01.dbf

/u01/app/oracle/oradata/SMRCDB/PDB2/undotbs01.dbf

PDB_FILE_NAME_CONVERT:

PDB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/SMRCDB/pdbseed/','/u01/app/oracle/oradata/SMRCDB/PDB3/';

oracle@srv3:/u01/app/oracle/product/12.2.0/dbhome_1/network/admin> sqlplus sys/system123@SMRCDB as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 5 18:05:45 2020

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> sho parameter PDB_FILE_NAME_CONVERT

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

pdb_file_name_convert string

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

4 PDB2 READ WRITE NO

SQL> ALTER SESSION SET PDB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/SMRCDB/pdbseed/','/u01/app/oracle/oradata/SMRCDB/PDB3/';

Session altered.

SQL> sho parameter PDB_FILE_NAME_CONVERT

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

pdb_file_name_convert string /u01/app/oracle/oradata/SMRCDB

/pdbseed/, /u01/app/oracle/ora

data/SMRCDB/PDB3/

SQL> CREATE PLUGGABLE DATABASE PDB3 ADMIN USER pdb1admin IDENTIFIED BY pdb1admin;

Pluggable database created.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

4 PDB2 READ WRITE NO

5 PDB3 MOUNTED

SQL> alter pluggable database PDB3 open;

Pluggable database altered.

SQL> alter session set container=PDB3;

Session altered.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

5 PDB3 READ WRITE NO

SQL>

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/SMRCDB/PDB3/system01.dbf

/u01/app/oracle/oradata/SMRCDB/PDB3/sysaux01.dbf

/u01/app/oracle/oradata/SMRCDB/PDB3/undotbs01.dbf

SQL>

HOME

Saturday 8 August 2020

Multitenant - Unplugged and Plugged database with same GUID copy method

Multitenant- Create PDB using db links from remote PDB

Multitenant - Creating PDB from seed by mapping names of existing files to new file names destination