Home
Search results “Creating pluggable databases in oracle”
Multitenant : Create a Pluggable Database (PDB)
 
02:35
This video demonstrates how to create a new pluggable database (PDB) in an existing container database (CDB). For more information see: https://oracle-base.com/articles/12c/multitenant-create-and-configure-pluggable-database-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Gurcan Orhan : Blog: https://gurcanorhan.wordpress.com/ Twitter: https://twitter.com/gurcan_orhan Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 5694 ORACLE-BASE.com
Creating USER Accounts in 12c Container database and Pluggable database in Multitenant Environment
 
10:35
Creating USER Accounts and Connecting to 12c Container database and Pluggable database in Multitenant Environment.Oracle database Unbeatable,Unbreakable Platform..
Views: 3048 Oracle World
How to Create Pluggable database Manually-Oracle 12C administration
 
08:04
How to Create Pluggable database Manually-Oracle 12C administration
Views: 1205 ANKUSH THAVALI
Oracle Database 12c: How to create a pluggable database by cloning an existing local PDB
 
12:22
This video is about Oracle Database 12c: How to create a pluggable database by cloning an existing local PDB
Views: 3133 mvige
Oracle 12c dba Tutorial : How to create multitenat container Database  | Oracle Pluggable Database
 
05:32
creating pluggable database enabled container Database using DBCA
Views: 2689 Wysheid Wysheid
Oracle Database 12c - Create Container Database (CDB) and Pluggable Database (PDB)
 
03:36
Create Container Database with Pluggable Database using DBCA
Views: 4261 Yopi Setiawan
Oracle 12c Auto Startup Pluggable Databases
 
06:53
Oracle 12c Auto Startup Pluggable Databases Using a Database Trigger. This video was recorded in December 2013.
Views: 2176 Oracle By Example
create user in oracle 12c database and difference between container and pluggable database
 
10:09
This video explains- 1. Difference between plug-gable database and container database 2. How to create user in container DB 3. How to create user in plug-gable database 4. what errors you might face in the process and solutions for those errors. You may refer my other video to install oracle 12c if you want to install the s/w and want to create database.
Views: 6517 Tech Group
Oracle Database 12c Tutorial 4: How to install sample schemas / users in Oracle Database 12c
 
08:33
Learn how to install sample schemas or users in oracle database 12c, In this tutorial you will also learn how to create a pluggable database in oracle database 12c by manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-install-sample-schema-users-hr-sh-in-oracle-12c Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 51336 Manish Sharma
Oracle 12c Database New Features - Pluggable Database - Video 1
 
17:25
Oracle 12c Database New Features - Pluggable Database - Video 1 1. Pluggable Database * Oracle 12c introduces a new feature called 'Pluggable Database'. Here Oracle Metadata and user data are totally separated into two sections. One is Container DB (or CDB) which will hold Oracle Metadata. The other is Pluggable DB (or PDB) which will hold user data. How does a Pluggable Database work? In the regular database, Oracle's metadata and user's application data are integrated. For beginners, Oracle Metadata is the data that is present when you install a new Oracle Database (without any sample schemas). Even though it can be called as an empty database, it still has data provided by Oracle. This data is needed by the database to function. For example, the objects owned by SYS, SYSTEM are mostly metadata. Then user data is entered into that database. They will go under multiple user schemas. Now the database is being used by the users. Now a situation arises so that we need to create another database on the same server. Why? Let us say that you need to provide data to two clients. And you don't want one client to other's data. And your data is contained in an extensive set of application schemas. In this case, making a copy of those applications schemas into a different set of names and making them reside in the same database is very difficult. So, you provide two separate databases. This also ensures that there is no security violation. So, we install another new database, which comes with Oracle Metadata. Then we load the user data. In this method, which is currently being used (Year 2013), there will be a need for more memory for both the database instances. There will be two SGAs, two sets of smon, pmon and other background processes running. Then if we need to copy one database to another, we need to rely on extensive procedures which includes exporting the data from the source database first, then removing the data at the target and then finally loading the data in there. After that, we need to take care of the user security and object privileges etc. So, if you want to provide data for multiple tenants, that is multiple clients, then with the current set of features (till Oracle 11g), we have to create multiple databases. That is, one database for one client. In otherwords, there is no multi-tenancy. Multi-Tenancy is becoming an important requirement in cloud infrastructure, these days. You would like to have the ability of providing data to multiple clients from the same database system with full confidence in security. This can be achieved in Pluggable Database. In a Pluggable Database, Oracle basically separates its metadata entirely from the user data. Metadata is stored in a section called Container DB. Then the user data are stored in Pluggable DBs. It also stores user metadata in the Pluggable DB. By the way, what is user metadata? For example, earlier, the list of user accounts that exist in a database is tightly inegrated with Oracle Metadata. Now, with the separation of Container DB and Pluggable DB, the user accounts must exist in the Pluggable DB. So, the Pluggable DB not only contains user data, but also some user metadata. So, what are the benefits? * Multi-Tenancy - We can bring in two Pluggable DBs under one Container DB. Both will be totally segregated, but yet controlled by one instance. This is an important feature for SaaS (Software as a Service) platforms, Cloud, On-Demand and Vendor Managed Application solutions. * Easy cloning/copying. Now the cloning and copying the databases across servers would be much easier. Just clone a Pluggable DB and plug-it-in in a different server. * Very easy upgrades and patching.
Views: 76659 Sam Dhanasekaran
Plugging In  Oracle Database 12c Pluggable Databases
 
01:35:49
Now that DB12c is official, we ALL can start investigating one of the most anticipated features of the Database 12c release- Pluggable Databases. This webinar will introduce the DBA to the concepts behind pluggable databases, the main feature points, along with a live demonstration working with pluggable databases in Oracle DB12c and an introduction to Enterprise Manager Express, (EM Express). An open discussion on options to create your own Virtual DB12c environment will be included.
Views: 29319 Redgate Videos
Create PDB
 
05:49
Create a Pluggable Database in 12.2 using the Command Line
Views: 144 Hemant K Chitale
Multitenant : Connecting to Container Databases (CDBs) and Pluggable Databases (PDBs)
 
02:06
This video demonstrates how to connect to Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Neil Chandler : Twitter: https://twitter.com/ChandlerDBA Blog: https://chandlerdba.wordpress.com/ Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 4081 ORACLE-BASE.com
Oracle Database 12c: Introduction to a Multitenant Environment with Tom Kyte
 
10:47
Tom Kyte introduces Oracle Multitenant in Oracle Database 12c followed by a demo showing: multitenant architecture, moving a pluggable database (PDB) from one multitenant container database (CDB) to another, cloning a PDB, and creating a new PDB. For more information: "Multitenant Architecture" in Oracle® Database Concepts http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CNCPT89233 "Managing a Multitenant Environment" in Oracle® Database Administrator's Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ADMIN13506 "About Common Users and Local Users" in Oracle® Database Security Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG573
Views: 79019 OracleDBVision
How to create database manually in oracle | manual db creation in oracle
 
20:08
https://dbagenesis.com/p/oracle-11g-advanced-dba DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. database creation in oracle 11g, how to create oracle database manually, create database in oracle 11g, create database using sql commands, oracle 11g commands, manual database creation,
Views: 5152 DBA Genesis
How to Start,Stop Pluggable database-Oracle 12C administration
 
09:32
How to Start,Stop Pluggable database-Oracle 12C administration =================================================== Important Command SQL= show con_name; CON_NAME ------------------------------ CDB$ROOT SQL-- sho pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB MOUNTED SQL alter session set container=PDB;
Views: 4513 ANKUSH THAVALI
How to Implement TDE for Oracle 12c2 Container and pluggable databases
 
19:36
Setup Wallet: Modify the sqlnet.ora file ENCRYPTION_WALLET_LOCATION= (SOURCE= (METHOD=FILE) (METHOD_DATA= (DIRECTORY=Directory location\))) --set password based keystore - container level ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --set auto login keystore - container level ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --open the keystore in root container ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --set master key at root container level ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; --open the keystore in pdb ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --Set database master key in pdb ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; CREATE TABLESPACE encrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\encrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT); CREATE TABLESPACE unencrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\unencrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K; CREATE TABLE TEST_ENC (TEXT VARCHAR2(100)) TABLESPACE encrypted_ts; CREATE TABLE TEST_UNENC (TEXT VARCHAR2(100)) TABLESPACE unencrypted_ts; insert into TEST_ENC values ('This is a secret'); insert into TEST_UNENC values ('This is a secret');
Views: 368 SQL JUNKIESHARE
Creation of Pluggable Databases (PDB) using DBCA and Adding Sample Schemas
 
20:10
Creation of Pluggable Databases (PDB) using DBCA and Adding Sample Schema 1) Start DBCA 2) Select the option of Manage Pluggable database 3) Select the option of Create Pluggable Database 4) Select the Container Database name 5) In Create Pluggable database Tab option select the option of Create Pluggable database using PDB File Sets and provide the path of sampleschema.xml file as Metadata file: Path of file is D:\app\OracleHomeUser\product\12.1.0\dbhome_1\assistants\dbca\templates \sampleschema.xml and path of Pluggable datafile backup D:\app\OracleHomeUser\product\12.1.0\dbhome_1\assistants\dbca\templates \sampleschema.xml\sampleschema.dfb 6) Then mention the name of Pluggable database
Creating Oracle 12c Container Database using DBCA
 
10:49
Hi friends let's us create a container database by name DBTEST and one pluggable database PDB1.Oracle database Unbeatable,Unbreakable Platform..
Views: 1542 Oracle World
create pluggable database in 12c
 
08:55
create pluggable database in 12c
Views: 584 Jamaal Khan
oracle 12c - Create and Configure a Container Database (CDB) and PDB
 
04:52
oracle12c database creation using DBCA
Views: 15636 Aamir
Oracle DB 12c - Multitenant Architecture
 
10:45
Oracle DB 12c - Multitenant Architecture Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Oracle 12c Convert Non-Container DB To PDB
 
19:35
Oracle 12c Convert Non-Container DB To Pluggable Database (DBMS_PDB.Describe) This video was recorded in December 2013.
Views: 8951 Oracle By Example
CREATE PLUGGABLE DATABASE FROM SEED
 
04:43
Oracle Database 12c - Example of creating PDB from SEED
Views: 209 Ramil Rahimov
Multitenant : Manage Users and Roles for Container Databases (CDBs) and Pluggable Databases (PDBs)
 
03:37
This video demonstrates how to manage users, roles and privileges for Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Niall Litchfield, Svetoslav Gyurov and Neil Chandler (left to right) : Twitter: https://twitter.com/nlitchfield Blog: http://orawin.info/blog/ Twitter: https://twitter.com/sgyurov Blog: http://sve.to/ Twitter: https://twitter.com/ChandlerDBA Blog: https://chandlerdba.wordpress.com/ Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 3009 ORACLE-BASE.com
Multitenant : Clone a Local Pluggable Database (PDB)
 
01:58
This video demonstrates how to clone a local Pluggable Databases (PDBs) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-create-and-configure-pluggable-database-12cr1#manual-clone-pdb Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Robin Moffatt : Twitter: https://twitter.com/rmoff Blog: http://www.rittmanmead.com/author/robin-moffatt/ Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 1924 ORACLE-BASE.com
Multitenant : Unplug and Plugin a Pluggable Database (PDB)
 
03:10
This video demonstrates how to unplug and plugin a pluggable database (PDB) in an existing container database (CDB). For more information see: https://oracle-base.com/articles/12c/multitenant-create-and-configure-pluggable-database-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by London Oracle Beers : Blog: https://mwidlake.wordpress.com/london-oracle-beers/ Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 1991 ORACLE-BASE.com
Migration from Non-Container to PDB database-PART I- Oracle 12C Administration
 
09:30
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs;
Views: 642 ANKUSH THAVALI
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 50795 Manish Sharma
Multitenant : Startup and Shutdown of Container Databases (CDBs) and Pluggable Databases (PDBs)
 
02:18
This video demonstrates how to startup and shutdown Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Fiona Martin : Twitter: https://twitter.com/fionaemartin Website: http://www.ukoug.org/about-us/governance/fiona-martin/ Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 3276 ORACLE-BASE.com
How to Rename/Change PDB database name-Oracle 12C Administration
 
09:15
How to Rename/Change PDB database name-Oracle 12C Administration ============================================ 1. Shutdown the pluggable database (PDB). sqlplus '/ as sysdba' SQL- shutdown pluggable database myplugdb3 close immediate; 2. Startup the PDB in restricted mode sqlplus '/ as sysdba' SQL- alter pluggable database myplugdb3 open restricted; 3. Rename the PDBs sqlplus '/ as sysdba' SQL- connect myplugdb3 as sysdba SQL- alter pluggable database myplugdb3 rename global_name to myplugdb3_new; 4. Restart the PDB sqlplus '/ as sysbda' SQL- alter pluggable database close immediate; SQL- alter pluggable database open; =============================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 373 ANKUSH THAVALI
How to connect to pluggable database - Interview question for oracle DBA
 
07:34
Interview question for oracle DBA | Oracle database administration ==================================== Listner should be up and running DB up and running tnsnames.ora User privilages Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 177 ANKUSH THAVALI
Migration of  Non-Container Database to Pluggable-PART II- Oracle 12C Administration
 
37:16
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs; ==================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 629 ANKUSH THAVALI
Creation of new user in new Pluggable database  oracle 12c
 
04:18
How to create new user in pluggable data
Oracle DB 12c - Creation & Configure CDB & PDBs using DBCA
 
19:07
Oracle DB 12c - Creation & Configure CDB & PDBs using DBCA Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
What is Pluggable Database - New Feature of Oracle 12c Database
 
03:11
Container database and pluggable database is new feature of Oracle 12c. Container database stands as CDB and pluggable database stands as PDB where container database contain metadata of each PDB. Here is exact video presentation for understanding this feature called as multitenant. Dbametrix offers remote dba support for Oracle 12c databases.
Views: 17860 Gitesh Trivedi
Create a Pluggable Database on 12C
 
48:34
2015 Fall ISQA 8306/4300 DATABASE ADMINISTRATION Create a Pluggable Database on 12C
Oracle Database 12c (12.1.0.1.0): Creating a new pluggable database PDB001 using DBCA
 
03:55
Oracle Database 12c (12.1.0.1.0): Creating a new pluggable database PDB001 using DBCA
Views: 1420 mvige
how to configure and connect oracle 12c database for the first time
 
06:31
how to configure and connect oracle 12c database for the first time, add pluggable database services in tnsname.ora file, connect sys as sysdba, alter session set container = pdborcl, startup open; alter user name_of_user identified by password account unlock;
Views: 3201 Data Science Center
Oracle Database 12c (12.1.0.1.0): creating a pluggable database using the files of the seed
 
03:09
How to create a pluggable database PDB in a multitenant container database CDB using the files of the seed PDB$SEED Have a look at this link: http://dbaworkshop.blogspot.it/2013/07/How-to-create-a-pluggable-database-PDB-in-a-multitenant-container-database-CDB-using-the-files-of-the-seed.html Here is my sql script: CREATE PLUGGABLE DATABASE PDB002 ADMIN USER PDB002_ADMIN IDENTIFIED BY oracle storage (maxsize 5G MAX_SHARED_TEMP_SIZE 500M) DEFAULT TABLESPACE "USERS" DATAFILE '/app/oracle/oradata/CDB001/PDB002/PDB002_users01.dbf' SIZE 5M REUSE AUTOEXTEND ON file_name_convert=('/app/oracle/oradata/CDB001/pdbseed/system01.dbf','/app/oracle/oradata/CDB001/PDB002/system01.dbf','/app/oracle/oradata/CDB001/pdbseed/sysaux01.dbf','/app/oracle/oradata/CDB001/PDB002/sysaux01.dbf','/app/oracle/oradata/CDB001/pdbseed/temp01.dbf','/app/oracle/oradata/CDB001/PDB002/temp01.dbf');
Views: 1550 mvige
How to take backup of container & Pluggable database-Oracle 12C Administration
 
21:24
How to take backup of container & Pluggable database-Oracle 12C Administration ===================================================== RMAN= BACKUP DATABASE PLUS ARCHIVELOG; RMAN= BACKUP DATABASE ROOT; Pluggable Database (PDB) Backup ====================================== $ rman target=/ RMAN= BACKUP PLUGGABLE DATABASE pdb1, pdb2; $ rman [email protected] RMAN= BACKUP DATABASE; ================================================ Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 1615 ANKUSH THAVALI
What does actual mean of pluggable database in 12c
 
19:22
With Oracle 12c, you can plug your database into one server, then unplug it and move it to another server without any major trouble just like you would do with a USB drive. .Oracle database Unbeatable,Unbreakable Platform..
Views: 1343 Oracle World
how to create database in oracle 12c
 
10:21
how to create database in oracle 12c
Views: 9362 Babê Îsmaîlî
Multitenant : Backup and Recover a Pluggable Database (PDB)
 
03:25
This video demonstrates how to backup and recover a pluggable database (PDB) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Alex Nuijten : Blog: http://nuijten.blogspot.co.uk/ Twitter: https://twitter.com/alexnuijten Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 3318 ORACLE-BASE.com
Creating an Oracle database with the Database Configuration Assistant - part 1
 
12:15
Creating an Oracle database with the Database Configuration Assistant - part 1
Views: 38662 Chris Ostrowski
Multitenant : Clone a Remote Pluggable Database (PDB)
 
02:25
This video demonstrates how to clone a remote Pluggable Databases (PDBs) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-clone-remote-pdb-or-non-cdb-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Brooke Lilley Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 2328 ORACLE-BASE.com
How to Create Profiles and Users in  a Pluggable Database
 
06:40
This Video explains how to create profile in a pluggable database using Oracle Enterprise Manager Express 12c(OEM) and also SQLPLUS -. This demo only covers the idle time session. To get a full text tutorial visit my blog www.reginaoradata.blogspot.com. Subscribe to my channel to get updates on newer uploads.
Views: 320 regina nkemchor
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 326236 Chitu Okoli

Sample cover letter for student radiologic technologist
Free basic cover letter template
Cover letter for demotion
Investment banking cover letter sample analyst interview
Computer service technician cover letter