How to Unlock HR User in Oracle Database 21c Express Edition | Install HR Schema | Unlock HR User
Vložit
- čas přidán 5. 09. 2024
- Hello Friends,
Please follow/ Execute the below steps as shown in the Video
=============================================================
**************** Website to be launched Soon *************************
=============================================================
Watch complete Setup Video for Oracle Database 21c Express Edition Software on Windows Operating System
=============================================================
Video Link : • How to install Oracle ...
Download link for Oracle 21c Express Edition
--------------------------------------------------------------------------------
Option 1::
-----------------
www.oracle.com...
Option 2 ::
----------------
drive.google.c...
Download link for Oracle SQL Developer ::
--------------------------------------------------------------------------------
Option 1::
-----------------
www.oracle.com...
Option 2 ::
----------------
drive.google.c...
---------------------------------------------------------------------------
Unlock/ Install HR Schema SQL Commands ::
---------------------------------------------------------------------------
Firstly, Download HR Schema ZIP File from below link,
drive.google.c...
Later, extract the ZIP file and Place this folder as shown in video.
First SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql
Parameter 1 ::
----------------------
hr
Parameter 2 ::
----------------------
users
Parameter 3 ::
----------------------
temp
Parameter 4 :: { Only this will change}
----------------------
admin
Parameter 5 ::
----------------------
$ORACLE_HOME/demo/schema/log
Parameter 6 ::
----------------------
localhost:1521/XEPDB1
------------------------------------------------------------------------------
Except Parameter 4, all are CONSTANT Values, there won't be any changes
------------------------------------------------------------------------------
Second SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_cre.sql
Third SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_popul.sql
Fourth SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_idx.sql
Fifth SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_code.sql
Sixth SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_comnt.sql
Final SQL File to be Executed ::
----------------------------------
@ C:\app\guru1\product\21c\dbhomeXE\demo\schema\human_resources\hr_analz.sql
===================================================
Thanks,
Please Subscribe, Share, Like and Comment on this Video.
after lot of struggle finaly i found the best video to solve my problems thank you so much
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
Man u have no clue how much it helped me. Big shout out to this man for spreading knowledge.
Thanks for your wonderful comments 😘 please subscribe to my channel and also share my videos with your friends 😊
Hello Tech Studio, Thank you so much for explaining all steps for configuring HR schema. You saved a lot of time.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks! It's well organized, and you explained it well. You helped me save hours in setting up the HR. This is the best tutorial video I watched today.
Thanks for your honest comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Dear Mr.Srinivas, Thnk you very much. Very effective lecture as well as demonstration. I fully followed and successfully downloaded all as you described here. I will come back to you after few days for more. Thanks again.
Thanks for your wonderful comments, I am very happy to hear this comments, please subscribe to my channel and also share my videos with your friends 😊
@@techstudio8268 Thanks for quick reply , I have already done subscribed and going through videos related to 21C videos.
Thanks, it was very helpful. I would like to add that instead of running all the SQL except hr_main.sql separately, we can edit the hr_main.sql file and replace the path of index, table etc creation with the path where all these is available then it will automatically gets executed once you run hr_main.sql
Yes, I agree with you, but i did this video for beginners too, so that I can give spoon feeding. Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much for this video, I have been struggling to connect HR schema in SQL developer for the last 2 months
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Excellent Guide. Thanks a lot it was very helpful me to connect HR schema.
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot. changing connection settings to XEPDB1 solved my issue.
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
You just saved my day sir. Thank you so much. Hates off to your effort
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks for your support, this video was the only one that helped me, you saved my life ;)
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you for taking the time to share your knowledge, greetings from a new subscriber!
Thanks for your valuable wishes and comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much for yout explanation, believe me it help me a lot.
Greetings from Brazil.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks Man. The only thing i wanna add is, the directory to execute:
If the Oracle is installed in another folder then you can copy that directory instead, like mine is: D:\Oracle\Oracle_Main\dbhomeXE\demo\schema\human_resources
Yes, thanks for the add on. Please subscribe to my channel and also share my videos with your friends 😊
So clear teaching! thank you so much!
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
It took mw 2 days to find the right video. So many others made it look complicated and it didn't work in my system.
Thanks 😊
you are a life saver, thank you so much for you effort, god bless you!!
Thanks for your valuable comments 👍 please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot for these instructions. Straight to the point, and it works just as described. One question, some of the scripts that we didn't execute, what are they related to? Will it be required to execute them at some point or we can simply ignore them?
Hr main.sql is the main file, this file executes all the other .SQL files
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
clear explanation thanks for the video really helpful for beginners :)
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
clear explanation. thanks a lot for this really excellent video.
Thanks for your booster comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
This video has helped a lot..thank you so very much
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you for your useful video. appreciate your efforts. Thanks . :)
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
You made my day bro. Quality content :)
Thanks bro 🙏 for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Works perfectly, thank you very much sir!
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends ☺️
Very nice tutorial. Thank you so much!!
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much! It was very helpful
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Very helpful, Thank you so much!!
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thanks. Very useful and helped me a lot.
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@@techstudio8268 sure. What about other files like hr_dn_c, hr_dn_d, hr_drop, HR_UnLock_Account etc.
It is really great! Tank you for your efforts :)
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
Thanks you so much, your video helped me a lot
Thanks for your valuable comments 👍 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much bro, it helps a lot👍
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends:)
Hello , I forgot to take the screenshot of my plugable database name and I'm struggling to get it back. Can you please guide me on this
Service name is XEPDB1
Excelente video! Funcionó de maravilla! Felicidades :)
Thanks for your booster comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot! You help me very much)
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot you really helps me!
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
thanks, It was very helpful
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
Thank you so much sir🙏
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
bro you are awesome. Thank you so much!!!
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Great help! Thanks a lot!
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
thank you so much, its very helpful and easy understand. Subscribed same...)
Thanks 🙏
thanks for your contribution!!
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
thank you , you really really helped me .
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@@techstudio8268 done
Thanks for your video :) .
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
This was extremely helpful
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
What Type of Connection do you choose for (user) System: Basic or TNS?
Basic
Thank you so much!!
You are welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you for this video
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you very much !
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you very much
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
I faced with problem in "specify log path as parameter". what should be written?
Your installation drive is C drive or any other drives, in that case you need to specify drive name
Thank you so much 💜
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends
I am not able to access the drive for hr schema
Please login with any of your Gmail account and then download
Thanks a lot 😊
You are most welcome 🤗
Thank you ☺️
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
Thank you !
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot..
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
i am having an error when i click on test
status: failure -test failed: ORA: invalid username/password; logon denied
Please make sure you are entering password correctly. Case sensitive
Thank you
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks you bro
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
thanks :)
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Great knowledge sharing.I appreciate.I could unlock hr@ORCLPDB1 in oracle 21c xe on Rocky Linux 86 using scripts
Good to hear that ☺️ please subscribe to my channel and also share my videos with your friends 😊
Thanks
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you GURU ... You are a good man !
Thanks for your wonderful comments 😘 please subscribe to my channel and also share my videos with your friends 😊
It's helpful
Thanks 👍 please subscribe to my channel and also share my videos with your friends 😊
I am facing the issue while importing the HR schema after the parameter given in sql developer
can you please assist me on that...
Please follow the steps as shown in the video, password case sensitive
I was able to download and install hr schema successfully. can you be specific about the areas you are facing issues with?
@@charlieherrs hello charlie. i have an issue. after the 6th parameter, it shows that it coulnt create a spool and " User does not exist in the system. Verify the user name is correct." i hope you can help
THANK YOU BRO
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
cannot find the app folder in c drive to copy contents of hr schema zip file
If not in C Drive, check where you installed oracle software and then paste HR schema folder in that drive
I got an error while execute on trigger file like cannot create triggers on objects owned by sys... How to resolve this bro..?
Okk.. could you please let me know the SQL Script file name.
@@techstudio8268 8:24... Hr_code file...
error :SP2-0332: Cannot create spool file.
how to fix this error please guide
You are executing wrong.sql file
it shows there is no user by "hr name" after running the last parameter
please help
I suggest you to please uninstall and reinstall the software and follow the steps as shown in the video
@@techstudio8268 thankyou. Its running successfully now. You saved my day.
I'm getting lots of errors. For importing HR schema could you please give your contact to solve this.. Number of times I'm tired but not working..
Please download the hr schema folder and I request you to follow the steps as shown in the video, if you still face issue, please provide your contact number
Hello bro, am not having demo folder in my dbhomexe folder can u give a=me a solution ??
Then you need to download and install the oracle 21c xe software on your machine, you can find download link in my videos
But why did we only execute 7 files? What about the others?
Well it's a big story
The network adaptor could not established connection
Please give the credentials correctly, and it is case sensitive
i am facing the issue of network adapter.How can i resolve it?
You are not giving the credentials correctly, case sensitive
i am having problems with the hr_analz.sql file. The console says that the set tab off is obsolete. What could i do to fix it?
Weird...let me check
sir plz help me i am not able to download its showing rar file what to do ahead?
You need to download winrar software in your machine and then download and later extract that rar file and install the software
Why my human resources doesn't have hr main?
Hr main has all the other sql scripts
Error report -
SP2-0310: Unable to open file: "C:\app\Jagannath\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql"
gettting this error brother
Please place the hr download folder in that place and then try
@@techstudio8268 same errror brother
@@techstudio8268 please help me
@@techstudio8268 ERROR at line 1: ORA-01917: user or role 'HR' does not exist ERROR: ORA-01017: invalid username/password; logon denied
I m unable to download hr schema from the below link
Ohh..ok, but this Google drive link is working, please try one more time
Hi i am unable to create hr schema, i followed all steps but got error as hr user does not exists, trying for past 2 days, request you to help me
No worries, please try to execute the HR script in System user
Keenly observe the results of HR script at the time of execution
If you get any errors just let me know
@@techstudio8268 hi
tried to re-install both oracle_21c and sql developer and tried the hr script got below error.
SP2-0332: Cannot create spool file.
Error starting at line : 86 File @ C:\oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_main.sql
In command -
DROP USER hr CASCADE
Error report -
ORA-01918: user 'HR' does not exist
01918. 00000 - "user '%s' does not exist"
*Cause: User does not exist in the system.
*Action: Verify the user name is correct.
Any help is appriciated
@@techstudio8268 hi I have figured it out about to create hr db. Thank you for the guidance and informative videos
@@g.nikhilkumar3 how did u do that? i have same problem
@@krisuu4106 hi krisuu i performed the he connection as it is but while connecting to database select service name and enter the service and connect to it and try the hr code
what we must do if we got unsuccessful connect with this error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=Ho+S7yfTS2iXZ0expYa5VQ==)
Please make sure services are running
Listener refused the connection with the following error:
So what's the error?
How to directly login to sql plus shell?
Click on start menu from operating system and then go to oracle folder, there you can find sqlplus terminal, just click on that
@@techstudio8268 yes, but when i try to login to hr, it shows error
Same problem
How to open this hr schema in sql plus
First you need to unlock hr schema
I unlocked that with the help of your tutorial but it is not logging in sql plus
WILL I NEED TO REPEAT THESE STEPS EACH TIME I WILL NEED TO USE THE HR SCHEMA?
Yes please
I didnt understand anything
Please try to follow the steps that are shown in the video
Thanks Thanks
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot 😊
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thank you!!!
You are welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
thank you
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
thanks
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends ☺️
Thank You!
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊