How to Unlock HR User in Oracle Database 11g Express Edition Software | Install HR Schema in 11g

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 unlock hr user in oracle database 11g express edition software before forwarding there are some prerequisites the first thing your pc must have installed with the oracle database 11g 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 11g 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 11g express edition software so let's get started on how to unlock hr schema in oracle database 11g express edition software 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 11g express edition software installation you might have specified database passwords for sys and system database accounts whatever the password that you have entered you need to specify that password over here at the time of installation i have given the password as admin so i am giving as admin and the connection type let it be the basic let it be the default connection hostname localhostport1521 sid xc click on test connection you can see the status success click on connect we have successfully configured system admin connection here you can see system admin connection worksheet you have successfully connected to the system admin now we are going to unlock hr user account in oracle database 11g express edition software let's execute the sql statement for unlocking the hr user alter user hr identified by hr account unlock we are going to execute this sql statement for unlocking the hr user make sure that you are in the system admin connection worksheet now run the statement click on this on the screen you can see the screen output user hr altered let's query in the database by executing select star from all users execute here you can see hr account so far we have successfully unlocked the hr user in oracle database 11g express edition now we are going to create a database connection for this hr account go to the connections click on the new connection this plus icon you can see a pop-up window for new select database connection you can see the existing connections we need to specify the name for this new hr connection i am going to give as hr whatever the name you would like to specify you can give you need the you need to give the credentials for hr username is hr and password is also hr and this enable the save password and let it be the default connections host name localhost port 1521 and sid xc click on test connection here you can see the status as success let's connect here you can see we have successfully created database connection for hr account on on the screen you can see hr worksheet now let's query the hr database select start from tab run the statement on the screen you can see the query result you can see the list of tables in the hr database these are all the tables that are present in the hr database let's query one of the tables employees select start from employees run the statement you can see the query result you can see the data present in the employees table in this way we can unlock hr user in oracle database 11g express edition software 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: 5,319

Keywords: How to Unlock HR User in Oracle Database 11g Express Edition Software, Unlock HR Schema, Unlock HR User, How to Install HR User in Oracle Database 11g Express Edition Software, Install HR Schema, Install HR User, Unlock HR Schema in Oracle 11g Express Edition, Unlock HR Schema in Oracle 11g, Unlock HR User in Oracle 11g Express Edition, Unlock HR User in Oracle 11g, Install HR Schema in Oracle 11g Express Edition, Install HR Schema in Oracle 11g, Install HR User in Oracle 11g

Id: dXFi4H9U_qk

Length: 5min 20sec (320 seconds)

Published: Wed Mar 16 2022