iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 12c New Features (Part I)

Online Oracle Training

Oracle12c Multitenant Architecture

Multitenant Container (CDB) and Pluggable Databases (PDBs)

 

LESSON 01

What you need to know about Oracle12c New Features
You will learn about: Containers, The Root, PDBs, Pros to have PDBs, Naming PDBs, Data Dictionary Architecture in a CDB, Metadata link, Object link, PROs of using Multitenant Architecture, Data Objects in a CDB, A CDB contains

More ...

 

LESSON 02
How to install Oracle12c using the Multitenant Architecture feature

More ...

 

LESSON 03

Creating a profile to access to your instances

The following is an example of global variables that you can define to access to you instances. Make sure to change your SID (mycdb) and Oracle home (product/12.1.0.1/Db_1) where applicable.

More…

 

LESSON 04

Exploring created instance (mycdb) and pluggable database (mypdb1)

Note on the instance “mycdb” and service name “mypdb1” and “mycdb.” Users can access to the mypdb1 pluggable database using the service name “mypdb1.”

More…

Oracle creates services automatically for each container (cdb, seed and pluggable database including SYS$BACKGROUND and SYS$USERS). Let us check and query them.

More…

Notice that the MYPDB pluggable database is in READ WRITE open mode and the seed PDB (PDB$SEED) is in READ ONLY open mode. The number 2 always assigned to the seed since it is the second created containers.

More…

 

LESSON 05

Create a net service name using the netca tool

In this lesson, you will create the mypdb1 net service name for the mypdb1 pluggable database of mycdb in the tnsnames.ora file.

More …

 

LESSON 06

How to login to a pluggable database and query from it

Let us connect to mypdb1 pluggable database. First you need to open the pluggable database.

More …

Query the data files using the DBA_DATA_FILES view. Assume you are connected to the mypdb1 pluggable database.

More …

 

LESSON 07

Create a new pluggable database

You use the seed read only pluggable database to create a pluggable database. In this lesson, you will create a new PDB pluggable database named mypdb2 in mycdb.

More …

You can use either the dbca tool or SQL Developer or SQL command to create a pluggable database. In this lesson, we use the SQL tool to create a PDB.

More …

 

LESSON 08

How to clone a pluggable database

In this lesson, you will create a new pluggable database (mypdb2_clone) from mypdb2.

Assuming you have already connected to root.

More …

Change the mypdb2 open mode from read only to read write. First you need to close the database and then open it.

More …

You can use EasyConnect to the mypdb2_clone pluggable database as sysdba.

More …

 

.Part I      .Part II     .Part III

Good Luck!!!!

 

Google
 
Web web site