Oracle Database 21c Installation - Enterprise Edition - Connect with SQL Developer-Unlock HR, Scott

Please follow/ Execute the below steps as shown in the Video

Watch complete Setup Video for Oracle Database 21c Enterprise Edition Software on Windows Operating System
=============================================================

Video Link :    • How to install Oracle Database 21c Ex...  


Download link for Oracle 21c Enterprise Edition
--------------------------------------------------------------------------------

https://drive.google.com/file/d/1Iw03...


Download link for Oracle SQL Developer ::
--------------------------------------------------------------------------------
https://drive.google.com/file/d/1zqVC...

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

Firstly, Download HR Schema ZIP File from below link,

https://drive.google.com/file/d/1VqTT...

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

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

C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_main.sql

Parameter 1 ::
----------------------
hr

Parameter 2 ::
----------------------
users

Parameter 3 ::
----------------------
temp

Parameter 4 :: { Only this will change - at the time of Installation, you might have password for sys,sysdba, system, that Password should be given}
----------------------
1234

Parameter 5 ::
----------------------
$ORACLE_HOME/demo/schema/log

Parameter 6 ::
----------------------
localhost:1521/ORCLPDB

------------------------------------------------------------------------------
Except Parameter 4, all are CONSTANT Values, there won't be any changes
------------------------------------------------------------------------------

Second SQL File to be Executed ::
----------------------------------
@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_cre.sql


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

@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_popul.sql


Fourth SQL File to be Executed ::
----------------------------------
@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_idx.sql


Fifth SQL File to be Executed ::
----------------------------------
@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_code.sql


Sixth SQL File to be Executed ::
----------------------------------
@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_comnt.sql


Final SQL File to be Executed ::
----------------------------------
@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_analz.sql

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

---------------------------------------------------------------------------
Unlock Scott User/Schema SQL Commands ::
---------------------------------------------------------------------------


Execute the below SQL Statement ::
==================================

@ C:\Oracle_21c\WINDOWS.X64_213000_db_home\rdbms\admin\scott.sql


Thanks,

Please Subscribe, Share, Like and Comment on this Video.