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

Video Description

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 : https://youtu.be/uoxd5oloEQY Download link for Oracle 21c Enterprise Edition -------------------------------------------------------------------------------- https://drive.google.com/file/d/1Iw03RSL54t61m39qpfsbWVrpd6kGxmQ_/view?usp=sharing 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/1VqTTmIJds-N1tlWwqeKrtj-5fguV5TAH/view?usp=share_link 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.