Since Oracle Database 12c release 2, oracle decided to ship only HR schema with the Oracle Database software. Which means if you want to use and unlock other sample schemas like OE, SH, OC and others then you will have to download them from GitHub. github.com/oracle/db-sample-schemas/releases/tag/v19c if you want me to do a video on how to install Sample user from GitHub in Oracle Database then comment and let me know.
Hi sir..I am unable to open hr schema in my sql developer.I am using oracle database 12c release 2.i have tried many methods to unlock it but its not working out.pls can u help me out...
I've spent approximately 10 hour trying to connect to users scott and hr, I've red enormous amount of documentation and different articles, I've droped DB 5 times because I thought I've done something wrong during the installation and only in your video I've finally understood what was the reason of all my mistakes. I forgot to restart litener and open DB. Thank you, Manish, you are my rescuer!!!
Thankyou so muchhhhh....I have been really struggling to do this. Uninstalled Oracle and SQL Developer as well but cldnt overcome the issue. Your video was very helpful. Now my HR User is unlocked.
thank you brother i was struggling alot, issue was in database hr was in mount mode and was not able to change its mode to read, write but your vedio helped alot. Again thank you.
Excellent information, thank you. I got into a new instance, created a non sys type user, and got the password error. So frustrating!! I don’t need to see all the sys tables. I’ll try this tomorrow. Thank you again.
Hello Manish, I am your new subscriber. I was able to unlock the HR user by the NetCA configuration method. Thank you for the wonderful videos. Keep up the good work.
Hi! Thank you very much for your videos about Oracle database, they've helped me a lot. Can you do a video or a blog entry explaining the multitenant architecture used by Oracle database? Container vs pluggable DBs. Thank you in advance.
WoW! You don't know for how long I have been looking for this explanation. Thank you for this video and thank you for taking the time to make it and share the knowledge. You definitely made my year!!!!! By the way, can I install Oracle database on my mac without using a virtual machine? I borrowed my girlfriend's laptop to make this possible. Appreciate immersively your work.
Hi Manish, I'm using oracle 18c and issue I'm facing is when I have connected to DB from sql developer db session is resetting frequently. How to make my db session constantly without resetting.
I'm getting the error: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error Please help to resolve this.
Hi Manish, I have installed Oracle database 19c inside a virtual machine with Windows 10 OS. Now I am trying to connect the database using SqlDeveloper v23.?? but the connection fails. Please throw some light.
Thanks Manish, that explanation was really awesome. HR user is now unlocked!!!. finally, I wonder, do we need to do that every time we to log in as hr user??
Thank you Manish for this helpful tutorial. I have a small request and that is how to connect to hr schema in oracle 19c using SQL developer, can you please make a tutorial about it as I am having trouble unlocking hr schema using SQL developer.
After unlocking HR user in Oracle Database 19c using the above video, open the SQL developer and follow the below steps: 1. add new database connection 2. name = HR, username =HR, password= hr, hostname = localhost, port = 1521, servicename = orclpdb 3. Test the connection and save it
Hi Manish, i tried the steps showed by you in this video and was able to unlock the HR user but when i was trying to connect HR user using SQL Developer i am getting error "test failed ora-01017 invalid username/password". It will be of great help if you can provide steps on how to connect to HR user using SQL Developer.
Thank you for your tutoring. HR user in unlocked now. However, I have been struggling with locking user again when I turn off laptop then I have to repeat all steps again !! I did commit but same issue. Do you know why??
Hi, I'm setting up an Oracle DB 19c on a CentOS 8 machine and I followed all your steps, but I couldn't unlock the HR user. It's a fresh instalation of both OS and DB, my PDB came out to be "ORACLEPDB1", I set the tnslistener.ora accordingly. What could be wrong?
I got the solution, I don't know why, but the user HR was not created when I executed the script to set up the sample database. So I had to manually create it in SQLPLUS, by running: SQL> @?/demo/schema/human_resources/hr_main.sql. After executing the above (which created the HR user) I was able to unlock the user and connect to it. Hope it helps somebody.
ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. the error i'm getting. What i'm doing wrong? same steps as yours!
Hi manish i am getting error while connecting to HR schema in oracle 19c TNS-01190: The user is not authorized to execute the requested listener command. Please help how to get this issue resolved and make the connection to HR schema
after doing all these stuffs, i am getting the same problem as before.. nothing changed at all.. its snhowing ORA-01017: invalid username/password; logon denied
Hi, I have problem. I did everything like in your movie but I cant alter user HR. I have properly connected to my pluggable databse (xepdb1 in oracle 21c in READ WRITE mode) but I have an error ORA-01918 user 'HR' does not exists. What can I do with that? Thank in adcance.
Hello. I try to follow your video, but... I can't find folder 'network'. I installed desktop version. Did I do something wrong during installation? I connected to SQL Developer as user SYS and can't see user HR in directory 'Other Users'. Is it ok or I have to see him there?
SQL> ALTER PLUGGABLE DATABASE open; ALTER PLUGGABLE DATABASE open * ERROR at line 1: ORA-65054: Cannot open a pluggable database in the desired mode. i did all but lastly i get above result . not opening mount database
sir please solve another issue I face this issue while connectivity java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist please solve this problem
The mistake is quite evident - the table you're trying to query hasn't been created. There's a possibility you might be misspelling the table's name. To verify, you can check if the table exists in your database by running the following query: SELECT table_name FROM all_tables; This will display a list of all tables created under your user. Make sure to double-check the table name spelling.
Check if the pluggable database containing your HR schema is open for read write or not. If not then open it. You can refer this 30 second shorts for that - th-cam.com/users/shortsbeYcobrCKG0
I got all the way to the end, but when attempting to execute the final command to connect the HR user, I am getting the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Any tips on how to solve this? Many thanks!
SQL> SELECT name, open_mode FROM v$pdbs; NAME OPEN_MODE ---------- ---------- ORCLPDB MOUNTED SQL> ALTER PLUGGABLE DATABASE open; ALTER PLUGGABLE DATABASE open * ERROR at line 1: ORA-65054: Cannot open a pluggable database in the desired mode. what is going on here worng , my database is not openging
its unlocked using this way, but get locked every time i log off the system. i have to unlock every time when i log in to system. is there any way to do it in one time..
Great tutorial, I have Oracle19c , Here are the list on commands, Any suggestions ? Thank you SQL> alter session set container =orclpdb; Session altered. SQL> show con_name; CON_NAME ------------------------------ ORCLPDB SQL> select name,open_mode from v$pdbs; NAME -------------------------------------------------------------------------------- OPEN_MODE ---------- ORCLPDB READ WRITE SQL> alter user hr identified by hr account unlock; alter user hr identified by hr account unlock * ERROR at line 1: ORA-01918: user 'HR' does not exist
Didn't worked for me. Getting Error Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (CONNECTION_ID=RIkX6sb6RAutQHHzD1d8yg==)
Give the service name as orclpdb in sql developer , dont give it in SID and username and password as showed hr / hr , connection name give a new connectin name maybe hr_conn
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-01190: The user is not authorized to execute the requested listener command
Thank you for the love! ❤️ If there's anything specific you'd like to see or if you have any questions, feel free to let me know. Your support is appreciated! 😊 By the way, where do you consider yourself in terms of SQL proficiency: beginner, intermediate, or advanced? I'm interested in knowing more about your SQL journey! 📚🤔
![How To Create [TNS Service] Using Oracle Net Configuration Assistant (netCA) BY Manish Sharma](/img/n.gif)
Since Oracle Database 12c release 2, oracle decided to ship only HR schema with the Oracle Database software. Which means if you want to use and unlock other sample schemas like OE, SH, OC and others then you will have to download them from GitHub.
github.com/oracle/db-sample-schemas/releases/tag/v19c
if you want me to do a video on how to install Sample user from GitHub in Oracle Database then comment and let me know.
thank you so much
Always a pleasure 😊
Hi sir..I am unable to open hr schema in my sql developer.I am using oracle database 12c release 2.i have tried many methods to unlock it but its not working out.pls can u help me out...
Hi Manish, I couldn't able to locate listener.ora file in my computer. Could you please is there any alternative way to find that.
I watched lots od tutorials, but none od them helped.
This one not only helped but everything is perfectly explained.
I've spent approximately 10 hour trying to connect to users scott and hr, I've red enormous amount of documentation and different articles, I've droped DB 5 times because I thought I've done something wrong during the installation and only in your video I've finally understood what was the reason of all my mistakes. I forgot to restart litener and open DB. Thank you, Manish, you are my rescuer!!!
Really happy to be of help. Wish you loads of success with DB in future. Also, please do share the video to help others in the community.
Where did you find listener .ora file. I couldn't able to locate on my computer.
@@syedmohsin3397 C:\App\db_home
etwork\admin
Best database teacher ever.. thank you so much you saved my life.
You just made my day
Thankyou so muchhhhh....I have been really struggling to do this. Uninstalled Oracle and SQL Developer as well but cldnt overcome the issue. Your video was very helpful. Now my HR User is unlocked.
thank you, ive spent over 10 hrs trying to fix this problem util i came across your channel!
I'm glad I could help you out! 😊 If you could quickly master any advanced SQL skill, what would it be and why? Your insight is valuable! 😊🌟
thank you brother i was struggling alot, issue was in database hr was in mount mode and was not able to change its mode to read, write but your vedio helped alot. Again thank you.
thank you so much for your videos about Oracle database, they've helped me a lot.
Thank you Manish for the detailed walk thru !!
I am glad you like the video. Please do share and like it. Thanks
Thank you very much Manish.
This helped me a lot.
Always a pleasure
Excellent information, thank you.
I got into a new instance, created a non sys type user, and got the password error. So frustrating!! I don’t need to see all the sys tables. I’ll try this tomorrow. Thank you again.
Hello Manish, I am your new subscriber. I was able to unlock the HR user by the NetCA configuration method. Thank you for the wonderful videos. Keep up the good work.
Great 👍All the best. Please share the video on your social media that will my channel.
One of the best tutorial video,
Upload more videos on oracle 19c so that one can become Master like u
Liked & suscribed. Manish you are the man!
thanks bro , your presentation very useful
Hi! Thank you very much for your videos about Oracle database, they've helped me a lot. Can you do a video or a blog entry explaining the multitenant architecture used by Oracle database? Container vs pluggable DBs. Thank you in advance.
This was so helpful with my homework! Thank you!!
Really thank you Manish . I did it
Thank you for such valuable knowledge sharing.
you helped me twice in my hard time.. thanks man ❤
Excellent tutorial. Thank you!
Thank you so much.. Your videos are really helpful
Thank you, Manish.
wonderful presentation , I look forward to watching all your videos.....
Great !!! Thanks Manish
Thank you bro this video very helpful to me
I'm glad you found the video helpful! If you have any more questions or need further assistance, feel free to ask. Happy learning!
Thanks! You saved my day!
Love u bro..aftr a sleepless night u came as a saviour ❤️
TNS-01190: The user is not authorized to execute the requested listener command
i am facing this error sir..
WoW! You don't know for how long I have been looking for this explanation. Thank you for this video and thank you for taking the time to make it and share the knowledge. You definitely made my year!!!!! By the way, can I install Oracle database on my mac without using a virtual machine? I borrowed my girlfriend's laptop to make this possible. Appreciate immersively your work.
Thank you so much for your lovely comment. Yes, you can install oracle on your Mac though the process is not this simple.
@@Rebellionrider is there a video on it?
Is it better to use oracle sql developer tool on mac directly or through a virtual machine?
thank you very much, good explanation!!
Glad it was helpful!
Great video, thanks for the explanation.
My pleasure always happy to be of help ☺️
Thank you so much manish :)
Hi Manish, I'm using oracle 18c and issue I'm facing is when I have connected to DB from sql developer db session is resetting frequently. How to make my db session constantly without resetting.
Thanks man it really work🙂
I'm getting the error: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error Please help to resolve this.
That really helped , thank you.
Much helpful...!!!
Thank you so much. Please do share on your social media and with your friends.
Hi Manish, I have installed Oracle database 19c inside a virtual machine with Windows 10 OS. Now I am trying to connect the database using SqlDeveloper v23.?? but the connection fails. Please throw some light.
I love you, you're the Best!!
Thanks Manish, that explanation was really awesome. HR user is now unlocked!!!. finally, I wonder, do we need to do that every time we to log in as hr user??
No you don't... Once you unlocked the schema you can use it like any other user you have in your database.
@@Rebellionrider Thank you mate, how about using sqlplus interface it doesn't accept user name and password. Is there any way to log in? Cheers.
how to configure it in oracle developer?
amazing thank you so much!
Thank you Manish
THANK YOU
Thank you very much.
Thank you!
ORA-12154: TNS:could not resolve the connect identifier specified showing me this error while connecting to hr
Subscribed on the spot :)
thank you very much
Thank you Manish for this helpful tutorial.
I have a small request and that is how to connect to hr schema in oracle 19c using SQL developer, can you please make a tutorial about it as I am having trouble unlocking hr schema using SQL developer.
am having the same problem too
After unlocking HR user in Oracle Database 19c using the above video, open the SQL developer and follow the below steps:
1. add new database connection
2. name = HR, username =HR, password= hr, hostname = localhost, port = 1521, servicename = orclpdb
3. Test the connection and save it
Thanks
Hi Manish, i tried the steps showed by you in this video and was able to unlock the HR user but when i was trying to connect HR user using SQL Developer i am getting error "test failed ora-01017 invalid username/password".
It will be of great help if you can provide steps on how to connect to HR user using SQL Developer.
Thank you for your tutoring. HR user in unlocked now. However, I have been struggling with locking user again when I turn off laptop then I have to repeat all steps again !! I did commit but same issue. Do you know why??
I have also same issue, r u able to resolve it ?
@@MoinKhan-cg8cu Try Alter pluggable database orclpdb open; log with sysdba account.
i have installed pdb after installation of 19c. so as per your step i am not able to open hr user. still error user does not exist. can you help me ?
Pls make the video on Scott user
Thanks for the feedback. Let me see what I can do.
Hi, I'm setting up an Oracle DB 19c on a CentOS 8 machine and I followed all your steps, but I couldn't unlock the HR user. It's a fresh instalation of both OS and DB, my PDB came out to be "ORACLEPDB1", I set the tnslistener.ora accordingly. What could be wrong?
I got the solution, I don't know why, but the user HR was not created when I executed the script to set up the sample database. So I had to manually create it in SQLPLUS, by running:
SQL> @?/demo/schema/human_resources/hr_main.sql.
After executing the above (which created the HR user) I was able to unlock the user and connect to it.
Hope it helps somebody.
Please make full video playlist of oracle 19 c SQL
I get this message ORA-00942: table or view does not exist after trying to execute the statement shown in 4;47
select name , con_id from v$pdbs;
Sir,
if this statement return on Row then
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
the error i'm getting. What i'm doing wrong? same steps as yours!
have you find solution for this
Hi manish i am getting error while connecting to HR schema in oracle 19c TNS-01190: The user is not authorized to execute the requested listener command. Please help how to get this issue resolved and make the connection to HR schema
after doing all these stuffs, i am getting the same problem as before.. nothing changed at all.. its snhowing ORA-01017: invalid username/password; logon denied
Hi, I have problem. I did everything like in your movie but I cant alter user HR. I have properly connected to my pluggable databse (xepdb1 in oracle 21c in READ WRITE mode) but I have an error ORA-01918 user 'HR' does not exists. What can I do with that? Thank in adcance.
did you find a solution to this problem?
Have u find the solution bro
Thank u ❤️
OMG thank you a lot
Always a pleasure. Your appreciation means a lot to me.
Hi Manish , I am getting error in win7 as ORA 12543 , please help on this
i follow your tutorial untill the end, but it keeps saying user hr does not exist, so what do i do now? download oracle 11 to have hr already?
Jow i can create and execute triggers in oracle 21c
Hello. I try to follow your video, but... I can't find folder 'network'. I installed desktop version. Did I do something wrong during installation? I connected to SQL Developer as user SYS and can't see user HR in directory 'Other Users'. Is it ok or I have to see him there?
hey I have the same issue. Have u find any way to resolve it?
How to demonstrate two sessions competing for resources as a result of a lack of using a commit or rollback in oracle 19 c
SQL> ALTER PLUGGABLE DATABASE open;
ALTER PLUGGABLE DATABASE open
*
ERROR at line 1:
ORA-65054: Cannot open a pluggable database in the desired mode.
i did all but lastly i get above result .
not opening mount database
sir please solve another issue I face this issue while connectivity java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist please solve this problem
The mistake is quite evident - the table you're trying to query hasn't been created. There's a possibility you might be misspelling the table's name. To verify, you can check if the table exists in your database by running the following query:
SELECT table_name
FROM all_tables;
This will display a list of all tables created under your user. Make sure to double-check the table name spelling.
TNS-01190: The user is not authorized to execute the requested listener command
Getting this error.What to do?
Try to run Command Prompt Screen using "Run as Administrator" and then execute the command. I was able to resolve my problem in this way.
What do we do now after we have unlocked hr user?
I am getting no listener error while connecting to tns using net configuration assistance
Could you provide link to download Oracle 19c
sir kindly help me how to unlock scott user in oracle 19c??
Really nice tutorial. Too bad the last step gave me a ORA-12154
I am getting error when connecting hr schema error code is ORA-12514
i cant find network file does someone know how to locate this file in 19c?
what it the user HR does not exist? in my case the same msg appears. "ORA-01918: user 'HR' does not exist"
Check if the pluggable database containing your HR schema is open for read write or not. If not then open it. You can refer this 30 second shorts for that - th-cam.com/users/shortsbeYcobrCKG0
how can start from oracle 19c database tutorial
Check out this blog and see if it's of some help to you. www.rebellionrider.com/how-to-learn-oracle-db/
Hi manish its saying as no rows selected what to do ?
Did you find the solution ?
Hii...I'm getting g logging denied ..plss tell me why
I got all the way to the end, but when attempting to execute the final command to connect the HR user, I am getting the following error:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Any tips on how to solve this? Many thanks!
have you solved this problem?
I ve just followed your procedure and it says, ORA-28000: The account is locked.
Plz make a video on how to create new user in oracle 19c
Thanks for the idea I will do a video on it soon.
@@Rebellionrider also make a video on how to transfer or access one database to other computer
%db_hom%
etwork\admin
not able to open this path in explorer
Watch this video to learn how to find db home th-cam.com/video/4EJcbQuaeR0/w-d-xo.html
SQL> SELECT name, open_mode FROM v$pdbs;
NAME OPEN_MODE
---------- ----------
ORCLPDB MOUNTED
SQL> ALTER PLUGGABLE DATABASE open;
ALTER PLUGGABLE DATABASE open
*
ERROR at line 1:
ORA-65054: Cannot open a pluggable database in the desired mode.
what is going on here worng , my database is not openging
its unlocked using this way, but get locked every time i log off the system. i have to unlock every time when i log in to system. is there any way to do it in one time..
commit;
I am logged in as an administrator but am unable to reload my listener. Is there a way to fix this?
Nevermind! I was using the incorrect command prompt.
Great tutorial, I have Oracle19c , Here are the list on commands, Any suggestions ? Thank you
SQL> alter session set container =orclpdb;
Session altered.
SQL> show con_name;
CON_NAME
------------------------------
ORCLPDB
SQL> select name,open_mode from v$pdbs;
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
ORCLPDB
READ WRITE
SQL> alter user hr identified by hr account unlock;
alter user hr identified by hr account unlock
*
ERROR at line 1:
ORA-01918: user 'HR' does not exist
did you find a solution to this problem?
Logging denied ..plss tell me why
How to unlock Scott user
Didn't worked for me. Getting Error
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
(CONNECTION_ID=RIkX6sb6RAutQHHzD1d8yg==)
Give the service name as orclpdb in sql developer , dont give it in SID and username and password as showed hr / hr , connection name give a new connectin name maybe hr_conn
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-01190: The user is not authorized to execute the requested listener command
Please help me.
@@vasanthakumare2791 Open command prompt through Run as Administrator.
❤❤
Thank you for the love! ❤️ If there's anything specific you'd like to see or if you have any questions, feel free to let me know. Your support is appreciated! 😊
By the way, where do you consider yourself in terms of SQL proficiency: beginner, intermediate, or advanced? I'm interested in knowing more about your SQL journey! 📚🤔
Followed instructions, result, ERROR at line 1: ORA-01918 user 'HR' does not exist.
did you find a solution to this problem?