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

[@akumpawatjr]

I saw 2 - 3 other videos on this topic. Some have made separete videos for all 4 parts. or skipped unlocking HR, SCOTT altogethor. This is the best video as it explains each component properly. Since i am trying to self learn SQL on my own, i had to pause this video at every step and replicate, else you are bound to make mistakes (Bro speaks at the pace of bullet train. I am used to increasing playback speed in most videos, this was a first for me where i had to slow down the speed to keep track) Couple of mistakes i made which i didnt see in the comment section 1. Remember to run the installation as ADMIN 2. follow the exact names, passwords as mentioned in the video for simplicity. Dont be lazy! 3. I had some error in unlocking HR schema. The mistake for me was 2 fold, both due to the path being incorrect. - there was an extra 'human_resources' in the total path. - there were wrong slash in the native file. Changed them to backslash instead to match with the pasted path 4. Password to be used for unlocking SCOTT connection was TIGER. - this is not mentioned in the video description. All other inputs are mentioned and shouldnt have any trouble. For most other queries, there are helpful answers in the other comments as well. P.S - No disrespect on the speed comment. Just trying to be funny. Thanks for the detailed, crisp and accurate video with all links, details in the description. A gem of a video!!! Thanks...

[@techstudio8268]

First of all, sorry for the late reply, it's been 3+ years of my KZbin journey, most of the viewers gave good feedback about my videos, one among the best comments that I received is yours. Thanks for your valuable comments. I am very happy for spending your valuable time for writing the feedback on this video. I will definitely take into consideration all our pros and cons. Regarding voice speed in my video I had to cover all the topics, even small things in that video, if I slow down the voice, then it will take the length of the video, most of the viewers prefer short videos. Just because of that , my voice will be fast in my videos fast. Down the line, I can say one thing, I want to give spoon feeding to my viewers through my videos, that's my main intention of running this channel. Please watch my videos and give your valuable feedback about Pro and cons of my videos 😊🙏 Please subscribe to my channel and also share my videos with your friends 😊

[@imie-nazwisko]

You saved me a month or two, thank you. I would never figure out this incomprehensible esoteric piece of software from a bygone era on my own given how much steps are required to get this thing up and running

[@techstudio8268]

Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@akashkambale3400]

your helped me to unlock hr and scoot i saw many videos in YT no use Thanks from me and my friends side ..

[@techstudio8268]

Thanks bro for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@leogirlgamer3607]

unable to get tables after creating hr db

[@techstudio8268]

Please follow the steps correctly

[@leogirlgamer3607]

followed but getting some modules are not available

[@shettyvighnesh92]

Thank you for the complete end to end steps.

[@techstudio8268]

Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊

[@swagatpritamsahoo5643]

12:44 It showing status: Failure - Test database: ORA-01109: database not open

[@techstudio8268]

Please make sure your oracle service are running

[@rds9815]

Nice one I setup properly by watching your video...thank you

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@ananthkrish1223]

while connecting getting the below error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=82wHoaXsRh6rsQHEelgw1Q==)

[@techstudio8268]

Please make sure that oracle services are running

[@ShashankGowda-xu8pf]

While login to local host, oracle enterprise manager database express it's showing invalid database credentials.. I can't able to login

[@techstudio8268]

Please give credentials in case sensitive

[@HarshitPR6644]

That was helpful, thank you so much. And yes!!, that google drive link for hr scheme is not functional anymore it would be better if you replace it or renew it.

[@techstudio8268]

Ohh..let me check that Google drive link and thanks for your valuable comments please subscribe to my channel and also share my videos with your friends 😊

[@techstudio8268]

I have updated the Google Drive Link, sorry for the inconveninece.

[@mindgamer2728]

Hi Sir, after executing hr_main.sql, & entering parameter 6: localhost:1521/ORCLPDB, I'm getting this as output Error starting at line : 86 File @ C:\Oracle_21c\WINDOWS.X64_213000_db_home\demo\schema\human_resources\hr_main.sql In command - DROP USER hr CASCADE Error report - ORA-01918: user 'HR' does not exist 01918. 00000 - "user '%s' does not exist" *Cause: User does not exist in the system. *Action: Verify the user name is correct. how do i get rid of this.

[@techstudio8268]

Please execute step by step

[@gauravmali6106]

Can not open sqldeveloper after extraction It show warning -could not install some modules

[@techstudio8268]

Just click on yes, it will open

[@gowrishankar7151]

Sir, I'm facing trouble in accessing hr schema , in my case the process is completed upto secession altered then the errors started. The error is as follows: unable to open file hr_cre,hr_popul.. Onson

[@techstudio8268]

Looks like you have not done exactly what I showed in the video

[@NitinBarapatre-c7r]

Thank you it's very useful video. I am facing issue while logging into local host it's not accepting user - system & pass - 1234

[@techstudio8268]

Make sure that oracle services are running or not

[@austechsupport9007]

everything goes smooth until...i get ORA-01109 :database not open ( but i checked everything)though orcl is working fine but unable to connect with hr .rar file without pluggins

[@techstudio8268]

Did you checked the oracle services?

[@mhamidhimmat632]

I have [20801] and [20802] errors in installing Oracle 21c what can I do?

[@techstudio8268]

Let me check the error codes

[@murali3568]

Hello sir Iam facing a problem please help me ragarding While opening SQL developer it showing Warning-could not install some modules... I have tried these steps to resolve the issue by the following.. 1.i have extracted the zip file agian and tried it's been same 2.i have deleted the the SQL developer and re download it but the problem remains same...

[@techstudio8268]

This is weird, You better download latest SQL Developer, That my work out

[@ananthkrish1223]

Status : Failure -Test failed: ORA-01109: database not open The above error reflecting while configuration, could you please help me.

[@techstudio8268]

Give credentials in case sensitive

[@krusty3928]

Sir it is showing error in step 4 of installation of database 21c error:[INS-32922] A database instance with the specified identifier already exists.

[@krusty3928]

Can i change the global databse name and pluggable database name

[@krusty3928]

I changed them and moved forward but now it shows there is no memory in step 5

[@techstudio8268]

If you change the names also, it will give you error at the next point, so I strongly recommend to format the operating system and install freshly

[@techstudio8268]

Please format and install

[@prajwalprajju6420]

I got an error at test phase The error says the network adapter could not establish the connection What should i do

[@prajwalprajju6420]

Hii sir please reply

[@techstudio8268]

Please provide the login details correctly, case sensitive

[@techstudio8268]

Try to give login details correctly and also check the oracle services are perfectly running

[@prajwalprajju6420]

@@techstudio8268 i cant start the services its in automatic mode

[@allantian4352]

sir, If I forget the pluggable database name, how I can find it？

[@techstudio8268]

Please see the video one more time, it's all generic information

[@allantian4352]

@@techstudio8268 I didn't screenshot by the ways =.=

[@faresabushawish6579]

Hello , thanks for the video but i have a problem Sp2-0310 : unable to open file : "C:\Oracle\WINDOWS.X64_213000_db_home\demo\schema\human_resources/human_resources/hr_cre.sql"

[@faresabushawish6579]

I found the solution .. just make sure to put the right path .. I feel stupid

[@techstudio8268]

Ok

[@jalalgazanfarov3766]

What is the difference between Express edition and Enterprise edition?

[@techstudio8268]

In simple language, enterprise edition is full software, your pc resources are maximum utilised Express edition is simple for practice the SQL queries and very less usage of pc resources

[@jalalgazanfarov3766]

@@techstudio8268 thank you

[@VenkatNaidu-m8c]

Hi, i followed all the process as mentioned in the video..able to login & also able to access all tables you showed us. . but next day when i logging in it gives an error: "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=N6rhgk4UTX6yIfiSxpewyg==)" Can you please help me. Thanks in advance !

[@techstudio8268]

Looks like port number is getting clashes, oracle port is clashing with some other software, please check and try to change the port number for that software not for oracle and restart

[@umasai5653]

Thank you so mich it helped me a lot❤

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@SushanthSinu]

the sign up the url link is not takeing username and password which is showing Invalid Container Name

[@techstudio8268]

You need to switch the container

[@IqGAMMER0]

I have followed each and every step and successfully Installed. Thank You. I have run the command to see the tables in hr and scott databases. I don't see any tables in any of these databases. Can you help?

[@techstudio8268]

Please follow the steps I showed in the video, you need to execute the commands is system user

[@459hema8]

Configuration assistant 'oracke database configuration assistant' i got this error while install product. Please provide the solution for this

[@techstudio8268]

Looks like your pc hardware issue or your operating system might got corrupted Please reinstall operating system

[@rehu2810]

I followed your instructions but still got ORA-12514 error .It says listener doesn’t know of service request. Please guide , how to fix this and connect to Scott and HR . Thank you !

[@satyanarayanamunipalli109]

Sir at 13:21 you started using Human_resources zip file. How to download Huma_resources. Kindly provide link to download Human_resources for unlock HR Schema. Except this I have loaded backend ORACLE 21C and front end SQLDEVELOPPER.

[@techstudio8268]

It is zip file, just download and follow the video and implement as it is

[@leelakasireddy4320]

Hi, Getting invalid username/ password error while creating HR DB connection, any suggestion pls?

[@techstudio8268]

Please give credentials in case sensitive

[@VibeTribe786]

Btw why we need to add HR seperately, its already there, right. We can found that schema in OTHER USERS btw i am talking about 19c. anyone plz clarify.

[@techstudio8268]

You are correct, it will be there but you need to unlock that in any version

[@manishnayak930]

Is all this process for installation of Oracle is can applicable on windows 10

[@techstudio8268]

Yes please

[@satyanarayanamunipalli109]

Sri Srinivas Garu , Is the Oracle 21c software downloaded from the official website of ORACLE Company is trial run software or Complete version ? Any time limit is fixed by Oracle Company for this trial version ? If so how many months it will work. If the above is a trial run software. How to get an official full version of Oracle 21c ?

[@techstudio8268]

Hi, this is not a trial version This is a complete software As long as you are not using for commercial purposes , you are free to use with out licence

[@divyamahesh9032]

Thank you , it helped me.

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@alqshamaqsood63]

Sir it showing error (Failure - Test failed: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service req...) Sir help me to solve this problem the pswrd which uh entered are all same the process nd all i just copied it from uh... But still it's suckz

[@techstudio8268]

First please check oracle services are running or not Secondly give the credentials correctly, credentials are case sensitive

[@youtubechanel-l1q]

bro you have to write service name like this: orcl.bbrouter

[@SushanthSinu]

when sqlplus entered userid and password its says ORA-01017: invalid username/password; logon denied

[@techstudio8268]

Please follow the steps as shown in the video then only your installation will be completed

[@ArunkumarMTamil]

I am facing this problem Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=/OG/3iYrR7COGK2ZBrpOoQ==)

[@shaiksameer2776]

check the listener is running or not

[@techstudio8268]

Please make sure that oracle services are running

[@skshameer7581]

I followed each and every step correctly after test it is getting failure i am unable to connect

[@techstudio8268]

Please give credentials in case sensitive

[@skshameer7581]

@@techstudio8268 can you give your mail id or insta id to contact you

[@skshameer7581]

@@techstudio8268 can you give your insta id to contact you

[@nagasuma8431]

I'm getting this error at the time of test ..Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=lRXwo1rYRcu9ViKZp9sisA==)

[@techstudio8268]

Please make sure oracle services are running

[@nagasuma8431]

They are running only but I'm still getting the same error

[@youtubechanel-l1q]

bro you have to write service name like this: orcl.bbrouter

[@sahilyakalaspur]

sir User HR not exist I m getting help me to solve this

[@techstudio8268]

I request you to follow the steps once again 🙏

[@kalpeshshindet_3317]

Download link for Oracle SQL Developer :: is not working please need help

[@techstudio8268]

Let me check from my side

[@VibeTribe786]

Can i do the same for Oracle 19c database for installing HR user

[@techstudio8268]

Paths you need to change

[@ph9551]

why do we need to unlock HR, Scott? Is that necessary?

[@techstudio8268]

This is for practice purpose

[@jayasri9900]

I'm getting so many errors while connecting to hr schema Can you please help me please

[@techstudio8268]

Please kindly follow the steps that I shown in the video

[@jayasri9900]

Followed as it is.. But getting error after giving last parameter

[@jayasri9900]

If I run that select * from tab i am not getting those rows

[@ChandraSekhar-ki3iz]

🙏Very👏useful👏👏Pl make video on install oracle 21c🙏on ubuntu 🙏

[@techstudio8268]

Sure I will try, by the way thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@diptigandhamwar877]

My setup. exe not shown plz help

[@techstudio8268]

Please download from the Google drive link

[@surendertayal1195]

Thankyou so much sir 🙏❤😊

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@bbaek2717]

[INS-35180] Unable to check for available memory. help me

[@techstudio8268]

Let me check from my end about the error

[@techstudio8268]

Let me check that

[@techstudio8268]

It's an error regarding available memory on your system, so please check the RAM and increase it.

[@souvikghosh8716]

Thank you Sir for this Video where you had covered how to unlock HR & SCOTT schema, Yesterday i had installed based on the steps in your video but today when i opened SQL developer i dont see SCOTT and i am unable to use HR schema also, it is give below error IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=knGKtLRbSB6ttgmaF+ju1Q==) Vendor code 17002 could you please be kind to help how to sort out

[@techstudio8268]

Please make sure the credentials are case sensitive

[@basamsuresh7705]

HR SCHEMA ZIP FILE IS NOT DOWNLOAD

[@techstudio8268]

Seems to be working please check and confirm

[@techuniverse_Official]

hr schema link not working pls give me hr main.sql file

[@techstudio8268]

I have updated the Google drive link, sorry for the inconvenience

[@pugalanbu720]

Thanks for this video.

[@techstudio8268]

You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊

[@chadanaballa9500]

Thank u very much..

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@achrafouahab669]

thank you very much

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@satishboddula4942]

For scott password TIGER in caps

[@techstudio8268]

Yes please

[@akumpawatjr]

I had this same doubt. Thanks for clarifying

[@HOLYxASH_YT]

THANK YOU

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@ftz3626]

Thank you 🫡🫡🫡🫡🫡

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@manishnayak930]

Plz reply

[@techstudio8268]

Yes please

[@andreseydel7282]

"promo sm" 😏

[@techstudio8268]

What it means 😕

[@arpartos591]

@TechStudio82--Thanks

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@i_m_the_hotstar]

Thank you so much sir ❤❤🎉🎉

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@UmerHashmi-ld5wx]

I am unable to get default tables after giving the command

[@techstudio8268]

Please follow the steps as shown in the video