How to Unlock HR User in Oracle Database 21c Express Edition | Install HR Schema | Unlock HR User

hello friends my name is srinivas and welcome to my channel techstudio 82. you can also visit our website www.techstudio82.com please subscribe to my channel and also don't forget to press bell icon for latest updates in this video i will show you how to install hr schema in oracle database 21c express edition software before forwarding there are some prerequisites the first thing your pc must have installed with the oracle database 21c express edition software and secondly make sure that you have downloaded oracle sql developer software which is a standalone software we are going to make use of this sql developer for unlocking hr schema if you want to know how to do a complete setup of oracle database 21c express edition software on windows operating system i have prepared a video on this please have a look at it in the below description i have provided that link please watch that video for complete setup of oracle database 21cx space edition so let's get started on how to unlock hr schema in oracle database 21cx space edition as i already said you should download sql developer i have downloaded my sql developer software double click on this here you can see sql developer icon application icon this is a standalone software we do not need to install this software to every time we need to open this application so open this application sql developer double click on this icon on the screen you can see oracle sql developer is loading this is the oracle sql developer welcome page before unlocking hr schema we need to connect to the system admin for this we need to create a new connection we need to manually create connection in order to create a connection go here click on this new connection plus icon on the screen you can see a pop-up window new select database connection first we need to configure system connection so we need to give the name as whatever the name you would like to give but i am giving system admin and username is system in small letters at the time of oracle database 21c express edition installation you might have specified the database password for system admin and pdb admin account whatever the password that you have entered over there you need to specify that password here i have specified my password at the time of installation as admin so i am giving as admin it's always better to save password coming to the connection details hostname is localhost port is 1521 but for the service name we need to give xcpdb1 at the last step of oracle database 21cx presentation installation you might have seen this last screen which has the connection information you can see this pluggable database localhost port number is 1521 and the service name is xcpdb1 which we need to specify over here x e p db1 click on text connection here you can see the status as success click on connect on the screen you can see we have successfully connected to the system admin you can see a worksheet over here now let's unlock hr user actually the fact is in oracle 21c express edition we need to manually install hr schema so in the below description i have provided a link for to download the hr schema related file just click on that link you can able to download that file on the screen you can see in my downloads folder this file this zip file this is all about hr schema just right click and extract the file the file got extracted double click and copy this and we need to paste in the c drive location c apps double click on apps double click on this folder and double click on the product folder 21c and double click on the db home xc here you can see demo folder double click on this here you can see the schema folder double click on this here we need to paste this folder right click and paste open this human resources folder you can see multiple sql files all these are related to the hr schema so we are going to execute one by one with the help of sql develop first we are going to execute this hr underscore main this is the first file to be executed for this you need to copy this path click on this path right click copy and we need to paste in the sql developer please make sure that we are connected to the system user go back to the human resource folder the first sql file that we need to execute is hr underscore main this we need to copy open the sql developer and give the hr underscore main dot sql in order to execute the sql statement we need to specify at symbol space at the starting of this line now we are going to run this statement click on this run statement on the screen you can see a pop-up window we need to enter variables that is enter value for 1 which is specify password for hr as parameter 1. i am giving hr as password click on ok we need to enter value for 2 here we need to specify default tablespace for hr as parameter 2. so i am providing as users click on ok we need to specify temporary table space for hr as parameter 3. for this i am giving as temp temp click on ok we need to specify password for cis as parameter 4 at the time of installation we have provided sys system and pdb admin password as admin in small case so the same i am going to provide over here admin in small case click on ok you need to specify log path as parameter 5. i am providing dollar oracle underscore home demo schema log just click on ok and we need to specify connection string as parameter six we need to enter value for six i'm giving value as localhost 1521 xcp db1 this is the plugable database so we need to specify this connection string click on ok you can see the log over here so far we have successfully created hr user now we need to create a new connection for this hr user click on this plus icon new connection give the name as whatever the name you would like to give i'm giving as hr and username as hr in small case and password as hr in small case and this for connection details i need to provide the service name as xcpdb1 which is a pluggable database click on the test connection you can see the status as success and click on connect we have successfully connected to the hr user just querying the hr database select star from tab you can see in this user there are no tables now we are going to dump the tables rows etc all related to the hr schema let's go back to the hr schema folder here you can see this sql files now i am going to execute some of these files not all the files some of these files i have created once notepad and i have created this sql files and i am going to execute one by one i am going to execute the second file which creates table sequences and constraints okay copy this paste it in the paste it in the sql developer make sure that you are in the hr schema and click on this run statement on the screen you can see the log it created tables indexes and views go back to the notepad and copy the third sql file which populate the tables copy and paste it in the sql developer click on run statement you can see it populated the rows it inserted the rows and finally it committed once again open the notepad copy this fourth sql file it will create indexes copy and paste in the sql developer run the statement on the lock you can see it created indexes and finally it committed let's go back to the notepad let's execute this fifth sql file which creates procedural objects copy this and paste it in the sql developer click on this run statement on the screen you can see it created procedures triggers successfully and also committed let's go back to the notepad now we are going to execute the sixth sql file which add comments to tables and columns copy this and paste it in the sql developer and run this statement in the log you can see the comments got created let's go back to the notepad we are going to execute this final sql file this will gather schema statistics copy this final sql file and paste it in the sql developer click on run statement here you can see pl sql procedure successfully completed so far we have executed sql scripts that are related to the hr schema and dumped the data now let's query the hr database select star from tab run statement here you can see the tables on the screen you can see the tables let's query one of the table employees select star from employees run the statement on the screen you can see the data over here for your convenience i have given all these sql statements in the below description part please check the below description so that you can execute all the sql statement one one after the other in this way we install hr schema in oracle database 21c express edition that's it thanks for watching if you like my video please subscribe to my channel and also don't forget to press bell icon for latest updates please like and also share my videos with your friends and drop a comment your comments are highly valuable thank you

Channel: TechStudio82

Views: 26,225

Keywords: How to Unlock HR Schema in Oracle Database 21c Express Edition, Unlock HR Schema, Install HR Schema in Oracle Database 21c Express Edition, Install HR Schema, How to Install HR Schema in Oracle Database 21c Express Edition, How to Unlock HR User in Oracle Database 21c Express Edition, Unlock HR User, Install HR User in Oracle Database 21c Express Edition

Id: IalqQN09OaA

Length: 9min 51sec (591 seconds)

Published: Tue Mar 15 2022