How to Create Users in CDB & PDB Oracle 19C| Common Users & Local Users| Users & Roles Names in CDB
ฝัง
- เผยแพร่เมื่อ 13 ก.ค. 2020
- Oracle 19C CDB and PDBs are having different rules for the users. Here the Complete process of How to create a user in CDB and PDB has been discussed. Dr.Vipin describes the process of creating the users in CDB and PDB in Oracle 19C.
#CDB #PDB #drvipinoracle #UsersinCDB #UsersinPDB
Other Oracle Videos can be seen on the given links:
SQL Advance datatypes : CLOB, BLOB, RAW, LONG
• Oracle SQL Advance Dat...
Oracle 19C SQL Loader (get MS-Excel data into Oracle's Table)
• SQL Loader Practical :...
How to Become Oracle Certified DBA (Oracle 19C OCP DBA)
• How to Become Oracle 1...
You May get connected with Dr.Vipin at Oracle.vipin@gmail.com or on his Official Id vipin@oracleindia.com.
This is the best video for understanding CDB,PDB concept. I have just started my journey in the field of Oracle database administration So it was a great help specially freshers like me. Thank you so much sir. Salam from Dhaka, Bangladesh.
Thank you sir, i was searching for this problem for 2 days. but here is the right concept. thank you so much sir.
Indians are always great while explaining technologies!!!!!!!!!!!!!!
Excellent Video Dr. Vipin, Clarity and Delivery are simple and straight to the point. Thank you.
this is what i was looking for. great!
Thanks alot sir , I get tried for concept but you cleared everything 🙏
Very simple and very clear concept. Thanks
Great video, easy to follow. Thanks for posting!!
Thank you so much....Wonderful explanation....voice was clear, no ah ah ah , script was to the point. Really enjoyed and learned...
Only one question, if I want to create a user in CDB without C##...???
Thank you! Very informative!
Superb video, Thank you very much.
Excellent video. Please keep posting more about Oracle Database. Thank You
Thank you very much!
Nicely explained by real-time
Awesome MashAllah Good Knowledge And Good Lecture Thanks
Very Well Explained
Very informative Video sir👍👍👍
Very educative
Another very informative tutorial by Dr. Vipin on Oracle 19C enumerating/explaining steps to be followed to create users in CDB and PDBs. As usual in simple language explained the concepts very well with practical examples. Keep up the good work.
Thanks Jagdeep Ji, we are Glad it was helpful!
PERFECTOOOO!!!!
very good
Subscribed, activated the bell, and liked this video. You explained it very clear, thank you very much!! If university professors explain concepts the way you do it, I believe everybody would have become a scientist on this earth. Greetings to you sir, and god bless!
Thank you so much for the appreciation.
Hi VIPIN Sir, Very very nicely explained, thank you for the information
Thanks Mr. Reddy, will try to continue it the same way.
very well explain hank a lot sir ,, Good and Nicely Explained
Thank you so much Kumar, will keep doing our best.
Superb sir
Thank you so much.
I followed your excellent explanation but I received : ORA-12154: TNS:could not resolve the connect identifier specified
ORA-65048: error encountered when processing the current DDL statement in
pluggable database ORCLPDB
Please help sir, i have successfully login with new user , now i want to give create, update priviledges but getting this error message
RESPECTABLE SIR HOW TO CONNECT VIA SYSDBA USER IN PDB AS WHEN I TRY TO CONNECT USING PDB IT RAISE ERROR TNS COULD NOT RESOLVE THE CONNECT IDENTIFIER
CONN / AS SYSDBA IT LOG ME IN AS CDB$ROOT
have you find any solution for this problem
try to register a new database in tnsnames.ora and fill the service name with your pdb named that you created
Hi Dr.Vipin, my issue is, can not login as SQL> conn skills/skill@PDB1
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
and also can not connect from sqldeveloper but
SQL> conn skills/skill@10.xx.xx.xx:1521/PDB1
Connected.
Very simple and very clear concept. Thanks a lot