How to install Oracle Database 21c Express Edition on Windows| Download, SQL Developer Configure HR

preview_player
Показать описание
Hello Friends,

Please check the below information,

Download link for Oracle 21c Express Edition
--------------------------------------------------------------------------------
Option 1::
-----------------

Option 2 ::
----------------

Download link for Oracle SQL Developer ::
--------------------------------------------------------------------------------
Option 1::
-----------------

Option 2 ::
----------------

---------------------------------------------------------------------------
Unlock/ Install HR Schema SQL Commands ::
---------------------------------------------------------------------------

Firstly, Download HR Schema ZIP File from below link,

Later, extract the ZIP file and Place this folder as shown in video.

First SQL File to be Executed ::
----------------------------------

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 ::
----------------------------------

Third SQL File to be Executed ::
----------------------------------

Fourth SQL File to be Executed ::
----------------------------------

Fifth SQL File to be Executed ::
----------------------------------

Sixth SQL File to be Executed ::
----------------------------------

Final SQL File to be Executed ::
----------------------------------

===================================================

Thanks,

Please Subscribe, Share, Like and Comment on this Video.
Рекомендации по теме
Комментарии
Автор

THIS GUY EXPLAINATION>>>>COLLEGE EXPLAINATION WOW SO EASY TO UNDERSTAND YOU DESERVE MY SUBSCRIBE

gunnerparth
Автор

thankyou sir for guiding so beautifully, Installation completed without any errors.💐💐✌✌😊😊

ashishnirmal
Автор

For those having an error creating a new database connection in SQL Developper(Status failure test io error the network adapter could not established the connection connection ):

0- Make sure you have the right credentials. Normally, a program named SQL Plus should be installed along oracle express 21c. You can open it by pressing windows + type in SQL Plus. It looks like the command line (cmd) when you open it up. There, you can connect to your oracle express database, and it's a great way to know if your credentials are correct. I'm not sure if SQL Developper will tell you that your credentials are wrong, but SQLPlus surely will.

1- Make sure that Oracle RDEBMS kernel Executable is running in task manager (it should take a lot of ram). It runs by default when you open windows, after you installed oracle express. If it's not running, restart your computer. It might fix it, and I have no other way of getting it to boot (tell me if you know please).

2- Open the command line (or windows powershell) and type: lsnrctl start
Wait a little for the connexion to happen. It should write a bunch of lines in the commande line saying it worked. If it didn't, again, make sure that oracle RDEBMS kernel Executable is running.

3- It could be a weird firewall settings on your pc. Make sure it can open the port 1521.

4- Please upvote this comment if it helped you and comment to help others. Remember, I'm just trying to help here. Have a nice day :)

diceblock
Автор

Great explanation video brother. I have been searching for a proper video for about 2 weeks, atlast i found this video and i successfully loaded the HR scheme. thank you bro. Keep Posting knowledge bro. Best wishes.

ntccgno
Автор

One of the best and complete video in YouTube I found so far staring form installation to Configure HR

saugatasarkar
Автор

Dude you are a genius. Trying to install it for like three days...
Thanks a lot.

mojadhere
Автор

This is one of the best tutorials i have ever come across. Thank you sir for that enormous help.😊🙏🤝

kingteller
Автор

I was struggling for 2 day and your video just saved me. Thanks a ton !!

teynee_
Автор

You are awesome, this video is as easy as Oracle installation can get. Thank you so much!!

BVar-xgvb
Автор

Дай Бог тебе здоровья милый человек, всё четко и грамотно, с 1 раза получилось, удачи бро

iqnxkxy
Автор

I thank you very much. Your channel solves the problem that I have been stuck for many days. Very good. I use the exam. Thank you.

feeldown
Автор

VERY GOOD AND CLEAR CUT INSTALLATION VIDEO 👌👌

HritikRanjan-mrpq
Автор

Thank you for explaining all steps in a proper manner!

shreyabhagole
Автор

Thanks for this video and step-by-step process, I have installed and connected successfully.

vinothkumarr
Автор

This is the best learning video to install Oracle21c.

sadiqurrahman
Автор

Thankyou so much Brother finally i connected to my database from java application

shaikkhizar
Автор

thank you veryy much man. Greeting from Azerbaijan❤❤❤

shadowmasked
Автор

Merci beaucoup Monsieur pour votre aide si précieuse, excellente journée.. !

berbarmoumen
Автор

this video is amazing... very informative video in whole youtube..

insidehead
Автор

Thank You so much for such a simple and elegant explanation

Vishal-gnfn