From the course: Oracle 12c: New Features
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Connect to the CDB - Oracle Database Tutorial
From the course: Oracle 12c: New Features
Connect to the CDB
- [Narrator] Once you have configured your Oracle database as a CDB, or container database, connecting to it is similar to what you knew from previous Oracle versions, such as Oracle 11G. Let's show this by opening a terminal window. First of all, the Oracle SID parameter, which you have used previously to connect to your Oracle instance, still remains and has a similar effect. For example, in my environment, which is a simple Oracle VM, installed locally on my MAC, I can see by looking at the Oracle pmon process that the Oracle instance I have created has an SID of ORCL. Setting the Oracle SID environment variable to ORCL and connecting as SYSBDA still works as the way it was in previous Oracle versions. However, now that you know about the multi-tenant architecture of Oracle 12c, you might ask yourself, to which container exactly did I just connect? Well, let's check it out. We have a couple of ways of showing the container to which we have connected. First is by running the show…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
DB consolidation and multitenancy needs2m 57s
-
Pre-12c: Dedicated servers4m 11s
-
Pre-12c: Instance consolidations2m 47s
-
Pre-12c: Schema consolidations4m 15s
-
Oracle 12c multitenant core concepts7m 39s
-
Multitenant Container Database (CDB)2m
-
The CDB architecture5m 53s
-
The root container1m 52s
-
Pluggable databases (PDBs)4m 19s
-
The SEED PDB and PDB cloning2m 34s
-
Enable the Oracle 12c CDB architecture2m 54s
-
Connect to the CDB3m 7s
-
Create, connect, and drop PDBs8m 49s
-
PDB portability between different CDBs6m 15s
-
Unplug a PDB8m 18s
-
Clone a PDB5m 45s
-
Use of the new data dictionary views8m 29s
-
Local and common users concepts5m 42s
-
Create a local user in a PDB5m 17s
-
Create a common user in cdb$root5m 33s
-
-
-
-
-
-
-
-
-
-
-