I just wanted to say thank you for this wonderful, clear and concise tutorial! I've been reading through the Oracle documentation as well as following a "get started" chapter of an online course for this technology...and nothing was as good and time-saving as this! Many thanks!
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.
Ehy you stop making videos, you teach like a professor 8n class room. Please make a video on how to install vm ware, how to install linux os on that and how to install oracle database and create pdb and connect it with putty.exe. Pleae reply me ❤❤
I just wanted to say thank you for this wonderful, clear and concise tutorial! I've been reading through the Oracle documentation as well as following a "get started" chapter of an online course for this technology...and nothing was as good and time-saving as this! Many thanks!
@@downloaddave-s4e I really appreciate your comment!
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!
thanks a lot!
Super helpful. Your explanation was clear and to the point.
Glad to hear it helped. 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!
Thank You Professor
You are welcome!
Thanks you very much , that was informative
Thanks for the comment!
thanks
You are welcome. Thanks for the comment.
Great video content thank you sir
Glad you liked it!
thank you really helpful
Happy to hear it was helpful. Thanks for the comment.
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.
Ehy you stop making videos, you teach like a professor 8n class room.
Please make a video on how to install vm ware, how to install linux os on that and how to install oracle database and create pdb and connect it with putty.exe.
Pleae reply me ❤❤