Creating a Pluggable Database
HTML-код
- Опубликовано: 17 июн 2020
- Creating a Pluggable Database
Level: Advanced
Series: Database Tutorials
Length of video: 15 minutes
Prerequisites: Installing Oracle Database 18c Express Edition
Purpose of tutorial:
This video is part of a series of tutorials that serve as an introduction to working with an Oracle database.
This video explains the process of creating a new pluggable database (PDB) in an Oracle Database multitenant environment. The steps presented here apply to the Oracle Database 12c family. The process is illustrated using the 18c Express Edition base installation.
For additional information related to connecting to a pluggable database, refer to the prerequisite video posted on this channel: Installing Oracle Database 18c Express Edition. 
Наука
This has to be the best explanation there is. Fast, to the point, no crap and no distraction. Thank you very much professor.
Thanks for your comment!
Sir !! You deserve a lot more subscribers. Great tutorial.
Appreciate the comment!
Thank you so much, greetings from Turkey
Thank you too!
Super helpful. Your explanation was clear and to the point.
Glad to hear it helped. Thanks for the comment.
thanks
You are welcome. Thanks for the comment.
Thank you professor. Your video helped me a lot.
I am happy to hear it was helpful. Thanks for the comment.
Great video Professor....Thank you a lot..
Thanks for the feedback!
Thanks you very much , that was informative
Thanks for the comment!
Thank You Professor
You are welcome!
thank you really helpful
Happy to hear it was helpful. Thanks for the comment.
Great video content thank you sir
Glad you liked it!
I have this error and I don't know how to solve it
Connection in progress...ORA-12514: TNS: listening process does not currently know the service requested in the connection descriptor
The test failed.
When you install Oracle 18c Express Edition, there will be a container database (CDB) and a pluggable database (PDB). The CDB is named XE and the PDB is named XEPDB1.
The following examples use SQL*Plus to connect to the database.
(1) Here we connect to the CBD named XE (this is the service name):
Enter user-name: system/ORACLE@xe
Connected.
(2) Here we connect to the PDB named XEPDB1 (this is the service name):
connect system/ORACLE@xepdb1
Connected.
(3) Here we attempt to connect a database named XEPDB2 (this is the service name):
connect system/ORACLE@xepdb2
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
This connection failed because there is no information about XEPDB2 for the listener.
It does not know anything about XEPDB2 because we have not included information about this database in the TNSNAMES.ORA file.
The information that must be given to the listener through the TNSNAMES.ORA file includes hostname, protocol, port, and service name.
If there is no entry in the TNSNAMES.ORA file, an attempt to connect will result in ORA-12154.
If there information is incorrect in the TNSNAMES.ORA file, an attempt to connect will result in ORA-12154.
If this is not clear, review the video on installing Oracle 18c Express Edition.
trying to create pub from another one included all its schemas but showing error
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
D:\ORACLEDB12C\ORADATA\CDB\DEV\USERS01.DBF
ORA-19504: failed to create file
"D:\ORACLEDB12C\ORADATA\CDB\LIVE\CDB\8C95858874424C96AF2B3D5315B3E714\DATAFILE\O
1_MF_USERS_KK4F2ODX_.DBF"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
You have not formulated a question. However, given the error messages you presented, it appears that there is insufficient space on the disk where you are attempting create the file. This is not an issue with the database system.
Datafiles for an Oracle database are often quite large, so you should consider the size of the current size of the datafile for the USERS tablespace, i.e., USER01.DBF.