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.
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.
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 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??
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.
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??
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
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
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 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
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, 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.
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?
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.
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!
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 - ua-cam.com/users/shortsbeYcobrCKG0
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..
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-01190: The user is not authorized to execute the requested listener command
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
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
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
lsnrctl reload LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 22-APR-2023 15:02:45 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-01190: The user is not authorized to execute the requested listener command
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'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
I watched lots od tutorials, but none od them helped.
This one not only helped but everything is perfectly explained.
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.
Best database teacher ever.. thank you so much you saved my life.
You just made my day
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, 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! 😊🌟
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
thank you so much for your videos about Oracle database, they've helped me a lot.
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.
Liked & suscribed. Manish you are the man!
Really thank you Manish . I did it
Thank you very much Manish.
This helped me a lot.
Always a pleasure
Thank you Manish for the detailed walk thru !!
I am glad you like the video. Please do share and like it. Thanks
Thank you, Manish.
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.
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?
This was so helpful with my homework! Thank you!!
you helped me twice in my hard time.. thanks man ❤
Great !!! Thanks Manish
Thank you for such valuable knowledge sharing.
Excellent tutorial. Thank you!
Thank you so much.. Your videos are really helpful
Thanks! You saved my day!
That really helped , thank you.
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.
wonderful presentation , I look forward to watching all your videos.....
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.
Thanks man it really work🙂
Much helpful...!!!
Thank you so much. Please do share on your social media and with your friends.
TNS-01190: The user is not authorized to execute the requested listener command
i am facing this error sir..
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.
Thank you so much 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!
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.
amazing thank you so much!
THANK YOU
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.
Please make full video playlist of oracle 19 c SQL
thank you very much, good explanation!!
Glad it was helpful!
Thank you Manish
Great video, thanks for the explanation.
My pleasure always happy to be of help ☺️
Love u bro..aftr a sleepless night u came as a saviour ❤️
I love you, you're the Best!!
how to configure it in oracle developer?
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
Thank you!
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 ?
How to demonstrate two sessions competing for resources as a result of a lack of using a commit or rollback in oracle 19 c
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?
Thank you very much.
thank you very much
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
ORA-12154: TNS:could not resolve the connect identifier specified showing me this error while connecting to hr
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
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 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
Pls make the video on Scott user
Thanks for the feedback. Let me see what I can do.
I am getting no listener error while connecting to tns using net configuration assistance
What do we do now after we have unlocked hr user?
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, 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.
Thank u ❤️
Really nice tutorial. Too bad the last step gave me a ORA-12154
Subscribed on the spot :)
Jow i can create and execute triggers in oracle 21c
sir kindly help me how to unlock scott user in oracle 19c??
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?
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
Could you provide link to download Oracle 19c
Hi manish its saying as no rows selected what to do ?
Did you find the solution ?
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?
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.
Hi Manish , I am getting error in win7 as ORA 12543 , please help on this
i cant find network file does someone know how to locate this file in 19c?
I ve just followed your procedure and it says, ORA-28000: The account is locked.
OMG thank you a lot
Always a pleasure. Your appreciation means a lot to me.
I am getting error when connecting hr schema error code is ORA-12514
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 - ua-cam.com/users/shortsbeYcobrCKG0
Hii...I'm getting g logging denied ..plss tell me why
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;
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.
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.
How to unlock Scott user
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
Logging denied ..plss tell me why
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.
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/
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
%db_hom%
etwork\admin
not able to open this path in explorer
Watch this video to learn how to find db home ua-cam.com/video/4EJcbQuaeR0/v-deo.html
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
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?
lsnrctl reload
LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 22-APR-2023 15:02:45
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-01190: The user is not authorized to execute the requested listener command
Followed instructions, result, ERROR at line 1: ORA-01918 user 'HR' does not exist.
did you find a solution to this problem?