Oracle 19c: HOW TO UNLOCK HR USER in Oracle Database 19c by Manish Sharma
HTML-код
- Опубликовано: 30 ноя 2019
- In this Oracle DBA tutorial, you will learn how to unlock HR user in Oracle Database 19c by Manish Sharma. Unlock the pre-defined HR database and start learning Oracle Database today. www.rebellionrider.com/how-to-...
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: www.rebellionrider.com/how-to-...
Previous Tutorial
► How to Install Oracle 19c: • How To Install Oracle ...
►Master Oracle TNS: • How To Create [TNS Ser...
-------------------------------------------------------------------------
►►►Social Media - Where I sort of Live
/ therebellionrider
/ rebellionrider
/ rebellionrider
/ mannbhardwaj
-------------------------------------------------------------------------
►►►Books I refer to
PL/SQL amzn.to/2QE1jX0
Performance Tuning amzn.to/2sgiAw4
1z0-071 Exam amzn.to/2sgfeJw
Python Programming amzn.to/305UEbh
-------------------------------------------------------------------------
►►►Camera Gears
Favourite Lens 1 amzn.to/2NbUE46
Favourite Lens 2 amzn.to/37SMA03
My New Video Light amzn.to/35FgXFK
Camera Remote [Secrete Weapon] amzn.to/2QH8aPj
Super-Fast inexpensive SD Card amzn.to/2shqhCg
Awesome Vide Mic amzn.to/2QGdliz
On-Camera Mic Worth Every Penny amzn.to/2tIEkBd
Sound Recorder amzn.to/2QZmeTm
Camera- I am using Canon 600d which is not available in the Market Now. But I am soon switching over this camera amzn.to/2R2W3v8
All of the above are affiliate links. Please use them to support the channel
#RebellionRider #OracleDBAwithRebellionRider #OracleDB
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
One of the best tutorial video,
Upload more videos on oracle 19c so that one can become Master like u
Best database teacher ever.. thank you so much you saved my life.
You just made my day
thank you so much for your videos about Oracle database, they've helped me a lot.
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! 😊🌟
Liked & suscribed. Manish you are the man!
wonderful presentation , I look forward to watching all your videos.....
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.
Really thank you Manish . I did it
This was so helpful with my homework! Thank you!!
Great !!! Thanks Manish
you helped me twice in my hard time.. thanks man ❤
Excellent tutorial. Thank you!
Thank you Manish for the detailed walk thru !!
I am glad you like the video. Please do share and like it. Thanks
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.
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, Manish.
Thank you so much.. Your videos are really helpful
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.
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.
Thank you for such valuable knowledge sharing.
thanks bro , your presentation very useful
Thank you very much Manish.
This helped me a lot.
Always a pleasure
Thanks man it really work🙂
amazing thank you so much!
Thanks! You saved my day!
Is it better to use oracle sql developer tool on mac directly or through a virtual machine?
Thank you so much manish :)
That really helped , thank you.
Thank you Manish
Thank you!
Great video, thanks for the explanation.
My pleasure always happy to be of help ☺️
I love you, you're the Best!!
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?
TNS-01190: The user is not authorized to execute the requested listener command
i am facing this error sir..
thank you very much
Thank you very much.
THANK YOU
Love u bro..aftr a sleepless night u came as a saviour ❤️
thank you very much, good explanation!!
Glad it was helpful!
Much helpful...!!!
Thank you so much. Please do share on your social media and with your friends.
Subscribed on the spot :)
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!
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 ?
Thanks
Thank you
Thank u ❤️
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 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?
ORA-12154: TNS:could not resolve the connect identifier specified showing me this error while connecting to hr
Hi Manish , I am getting error in win7 as ORA 12543 , please help on this
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
I get this message ORA-00942: table or view does not exist after trying to execute the statement shown in 4;47
OMG thank you a lot
Always a pleasure. Your appreciation means a lot to me.
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
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.
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.
select name , con_id from v$pdbs;
Sir,
if this statement return on Row then
I am getting no listener error while connecting to tns using net configuration assistance
How to demonstrate two sessions competing for resources as a result of a lack of using a commit or rollback in oracle 19 c
how to configure it in oracle developer?
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.
What do we do now after we have unlocked hr user?
Jow i can create and execute triggers in oracle 21c
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.
Could you provide link to download 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?
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.
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.
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.
Hii...I'm getting g logging denied ..plss tell me why
I am getting error when connecting hr schema error code is ORA-12514
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
sir kindly help me how to unlock scott user in oracle 19c??
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
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
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.
Please make full video playlist of oracle 19 c SQL
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;
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?
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 - ruclips.net/user/shortsbeYcobrCKG0
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
Hi manish its saying as no rows selected what to do ?
Did you find the solution ?
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.
Really nice tutorial. Too bad the last step gave me a ORA-12154
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/
How to unlock Scott user
Pls make the video on Scott user
Thanks for the feedback. Let me see what I can do.
❤❤
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! 📚🤔
%db_hom%
etwork\admin
not able to open this path in explorer
Watch this video to learn how to find db home ruclips.net/video/4EJcbQuaeR0/видео.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
Followed instructions, result, ERROR at line 1: ORA-01918 user 'HR' does not exist.
did you find a solution to this problem?
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.
Not opening
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?
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