Great explanation video brother. I have been searching for a proper video for about 2 weeks , atlast i found this video and i successfully loaded the HR scheme. thank you bro. Keep Posting knowledge bro. Best wishes.
For those having an error creating a new database connection in SQL Developper(Status failure test io error the network adapter could not established the connection connection ): 0- Make sure you have the right credentials. Normally, a program named SQL Plus should be installed along oracle express 21c. You can open it by pressing windows + type in SQL Plus. It looks like the command line (cmd) when you open it up. There, you can connect to your oracle express database, and it's a great way to know if your credentials are correct. I'm not sure if SQL Developper will tell you that your credentials are wrong, but SQLPlus surely will. 1- Make sure that Oracle RDEBMS kernel Executable is running in task manager (it should take a lot of ram). It runs by default when you open windows, after you installed oracle express. If it's not running, restart your computer. It might fix it, and I have no other way of getting it to boot (tell me if you know please). 2- Open the command line (or windows powershell) and type: lsnrctl start Wait a little for the connexion to happen. It should write a bunch of lines in the commande line saying it worked. If it didn't, again, make sure that oracle RDEBMS kernel Executable is running. 3- It could be a weird firewall settings on your pc. Make sure it can open the port 1521. 4- Please upvote this comment if it helped you and comment to help others. Remember, I'm just trying to help here. Have a nice day :)
This is a great video on starting to use Oracle. The only problem I had is that I don't have an ORACLE_HOME environment variable set. I know how o create it, but 2 questions: 1. What path goes in it, and 2. Is it a user or system variable? Thanks!
I am unable to connect to DB. from sql developer using sys and system .... i am getting as invalid username and pwd . But if I connect with SQL Plus I am able to connect.
Hi! thank for the video it is really well done. All those tables associated to System connection are just sample data you could use for training purpose apart from HR schema?
Before installation getting started. It asked me to remove Oracle 21C .. Once I selected Remove, it started removing the Oracle software components, which took approx 10 mins
Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied this error comes at the time of connecting the hr please give solution
SQL developer is a stand-alone software, so everytime we need to open the software from the download folder, open SQL developer.exe file from the folder
Everything was fine, but after few days I was logout. Now when I try to login I have error (idk if password is wrong or what): the network adapter could not establish the connection vendor code 17002, Please help 😢
Well the screenshot will have web connection details, if I need to generalize, all the connection details are same as shown in video, but I suggest you to take a screenshot as and when required you can refer to that screenshot That's my intention
Hi, Friend when i am making Oracle SQL developer connection, it's validating as: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection (CONNECTION_ID=mMs77G7cT2aCZs77uBjFmw==) Can i have help on this! i have downloaded 22.2 version. Thanks in Advance.
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=mlNxZd9QS7WocXKshYClsg==) Here is the error. Can't figure out what's wrong. Writing all credentials correctly.
@@techstudio8268 if issue is still persisting here is how I fixed it. Open command prompt as admin and enter the following command. "C:\> lsnrctl start." it will show you the localhost. put that value (something like 192.168 something) in place of host. then try.
@@sabeehazam9273 bro I'm facing this problem, but maybe this guy have a listener that doesn't start, I'm not sure but maybe it's because he has windows home edition, I don't know how to solve this problem, I tried to install oracle 21c varius times and the problem was always the listener, I have windows 10 home on my pc, need healing
@@marioantoniosaviano1720 i encountered 2 problems. 1 was solved by running as administrator so make sure to do that. Second was solved by above step. It was a listener problem which got fixed by the "C:\> lsnrctl start." command.
I successfully executed all steps exactly as explained in the video (except that I replaced user "System" with another user name such as "selenium" and also that during the install process, I do not recall specifying password "hr" for "user "HR", but accepted "hr" as password when installing the HR schema. However, when I started executing the SQL script, I kept getting prompts for passwords, etc. which are not mentioned in the video. It may be noted that initially, I made the mistake of running the script with all SQL files without mentioning the ".sql" suffix and later rerun the script including all file names with the ".sql" suffix, and noticed that the same error messages appeared. Can you please help? Thx in advance.
I came here for installation to Learn oracle. Installation everything gone successful even hr schema also executed. But can you explain what the term hrscema mean why we used to execute.
HR schema is not mandatory, this is just for practicing SQL queries, for anyone who is working on a database need to have sample data. Instead of creating tables, inserting data etc.. HR schema is a ready made sample database. That is why I suggested to execute HR SQL script Hope I gave clear information about HR Schema
Hello sir, it's very interesting this tutorial but I don't understand why we need to install human_ressources file and execute sql file within this folder. If someone can explain me beacause I'm a beginner ? Thanks.
Unable to connect after installation got below error An error was encountered performing the requested operation: ORA-01109: database not open 01109. 00000 - "database not open" *Cause: A command was attempted that requires the database to be open. *Action: Open the database and try the command again Vendor code 1109
THIS GUY EXPLAINATION>>>>COLLEGE EXPLAINATION WOW SO EASY TO UNDERSTAND YOU DESERVE MY SUBSCRIBE
Thanks a ton🤗 please share my videos with your friends 😊
I thank you very much. Your channel solves the problem that I have been stuck for many days. Very good. I use the exam. Thank you.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
thankyou sir for guiding so beautifully , Installation completed without any errors.💐💐✌✌😊😊
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Dude you are a genius. Trying to install it for like three days...
Thanks a lot.
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
One of the best and complete video in UA-cam I found so far staring form installation to Configure HR
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Great explanation video brother. I have been searching for a proper video for about 2 weeks , atlast i found this video and i successfully loaded the HR scheme. thank you bro. Keep Posting knowledge bro. Best wishes.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
You are awesome, this video is as easy as Oracle installation can get. Thank you so much!!
Thanks for your wonderful compliment 💞 please subscribe to my channel and also share my videos with your friends 😊
Thank you for explaining all steps in a proper manner!
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
I was struggling for 2 day and your video just saved me. Thanks a ton !!
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
This is one of the best tutorials i have ever come across. Thank you sir for that enormous help.😊🙏🤝
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
thank you veryy much man. Greeting from Azerbaijan❤❤❤
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends ☺️
VERY GOOD AND CLEAR CUT INSTALLATION VIDEO 👌👌
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
Merci beaucoup Monsieur pour votre aide si précieuse, excellente journée.. !
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank You so much for such a simple and elegant explanation
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
For those having an error creating a new database connection in SQL Developper(Status failure test io error the network adapter could not established the connection connection ):
0- Make sure you have the right credentials. Normally, a program named SQL Plus should be installed along oracle express 21c. You can open it by pressing windows + type in SQL Plus. It looks like the command line (cmd) when you open it up. There, you can connect to your oracle express database, and it's a great way to know if your credentials are correct. I'm not sure if SQL Developper will tell you that your credentials are wrong, but SQLPlus surely will.
1- Make sure that Oracle RDEBMS kernel Executable is running in task manager (it should take a lot of ram). It runs by default when you open windows, after you installed oracle express. If it's not running, restart your computer. It might fix it, and I have no other way of getting it to boot (tell me if you know please).
2- Open the command line (or windows powershell) and type: lsnrctl start
Wait a little for the connexion to happen. It should write a bunch of lines in the commande line saying it worked. If it didn't, again, make sure that oracle RDEBMS kernel Executable is running.
3- It could be a weird firewall settings on your pc. Make sure it can open the port 1521.
4- Please upvote this comment if it helped you and comment to help others. Remember, I'm just trying to help here. Have a nice day :)
Good one, but when GUI is user friendly, why do we need to use command mode
BHAIYA AAPNE TO KAMAL HI KAR DIYA
BAHUT BAHUT DHANYAVAD AAPKA
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thankyou so much Brother finally i connected to my database from java application
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks for this video and step-by-step process, I have installed and connected successfully.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much. I've been struggling for long time.
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
Дай Бог тебе здоровья милый человек, всё четко и грамотно,с 1 раза получилось, удачи бро
Sorry can't understand this language
@@techstudio8268 I translate from Russian, God grant you good health, dear man, everything is clear and competent, it turned out 1 time, good luck bro
this video is amazing... very informative video in whole youtube..
Thanks a lot for your comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
This is the best learning video to install Oracle21c.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you sir.you video helped me a lot.wish u all the best for your channel.
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you indeed you are life saver.
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
Thanks a lot for this clear installation guide, it was helpful.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
I can use it because of your video. thank you very much. 🥰
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Hi Bro. Very clear and good explanation. useful info. tanq.
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends ☺️
Thank you very much. Done at one go
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you bro 😊, this video is very helpful for me .
Thanks for your valuable comments 😘 please subscribe to my channel and also share my videos with your friends 😊
Ver y clearly explained. Was very helpful.
Thanks for your valuable feedback ☺️ please subscribe to my channel and also share my videos with your friends 😊
thank you very much!!! you save me :)
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
thank you sir this tutorial is so helpful .😘😗
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
Thank u for clear explanation! :)
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
This is a great video on starting to use Oracle. The only problem I had is that I don't have an ORACLE_HOME environment variable set. I know how o create it, but 2 questions: 1. What path goes in it, and 2. Is it a user or system variable? Thanks!
At the time of installation, wizard will give some steps, In that you might have given the path, hope you might have remembered the path
i saw ur vedio and done step by step
Thanks 😊 please subscribe to my channel and also share my videos with your friends 😊
Thank you bro. You actually helped me.
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
😊Thank you. This video is very helpful for me...
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
This video is such a great help!
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
I have successfully installed Oracle DB 21c EX thanx man✌
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@@techstudio8268 already subscribed✌
Bhai maine set up kar liye but jaise hi oracle connection add karta hoon toh test failure aa raha hai bro help me
Worked for me. Thank You !
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you for this. It really helped😇
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thank you, this video is very helpful for me
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
thnks... worked for me w/o any issue.
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
thank you very much this was very helpfull
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Excellent!!!!
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
Many thanks from Palestine 🇵🇸❤️🌹
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
finally a great explaination.
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks 👍
Very helpful video ...thanks a lot
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank You , it's working for me.
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much! You saved me!!
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks for sharing. I have successfully Done the setup.
Sounds great 👍 please subscribe to my channel and also share my videos with your friends 😊
❤❤❤❤❤❤ you are the best bro!!!
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
THANK YOU VERY MUCH ITS 100% WORK
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thanks so much for this video.
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
thanks man ! helped a lot !
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Yeppp thank you so much
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
Thank you Thank you Thank you so much sir.
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
thank you very much. you helped me a lot
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
perfectly taught..!
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
wowww delicious knowledge
Thanks for your wonderful comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
Status : Failure -Test failed: IO Error: Got minus one from a read call, connect lapse 61011 ms., Authentication lapse 0 ms.
Please make sure all the settings are perfectly given
Excellent Work, Keep it up
Thanks 😊 please subscribe to my channel and also share my videos with your friends 😊
Thank you so much
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
thanks alot for helping me ❤
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Nice work Tech!
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
I am unable to connect to DB. from sql developer using sys and system .... i am getting as invalid username and pwd . But if I connect with SQL Plus I am able to connect.
Credentials are case sensitive, please try
Thankyou so much Brother
You are most welcome bro 😊 please subscribe to my channel and also share my videos with your friends 😊
Hi! thank for the video it is really well done. All those tables associated to System connection are just sample data you could use for training purpose apart from HR schema?
Yes, thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
Before installation getting started. It asked me to remove Oracle 21C .. Once I selected Remove, it started removing the Oracle software components, which took approx 10 mins
That indicates that already 21c is already installed on your machine
Bro i am getting an status: failure - test failed while clicking test.... I have entered the details correctly....
Please make sure that services are running and also give credentials in case sensitive
Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied
this error comes at the time of connecting the hr please give solution
Please give the credentials in lower or upper case
Excellent Tut.... sir/....
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
thanks this helped a lot.
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Why it is rolling back for the installation time😔many times I tried to install...and every time it like this on rolling back
Really very weird, not sure why that is happening
@@techstudio8268 I don't know plz tell me
Thank you so much..🔥🔥
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thanks alot sir!!!
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
Too Good
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Link sql dov and hr errors
Thank you so much!
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Thank you sir ❤❤
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Sir once we closed the tab how to open the front end oracle SQL developer again?
SQL developer is a stand-alone software, so everytime we need to open the software from the download folder, open SQL developer.exe file from the folder
But i downloaded windows 64 bit with jdk 11 included...process is same or different for both..
Yes it is same
@@techstudio8268 okay sir tq for the information 👍
I think its time to start online teaching ❣️
we will support you..
Thanks for your support 💕 i will plan accordingly 😊
Thanks Guru 🙏
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
Hi sir im already downloaded sql developer but when the network adapter could not establish the connection....
How can I solve this ???
Ya it is almost same, but please give credentials in case sensitive
@@techstudio8268 okay sir 👍
@@techstudio8268 sir I give credentials in case sensitive but still it was showing same error
Everything was fine, but after few days I was logout. Now when I try to login I have error (idk if password is wrong or what): the network adapter could not establish the connection vendor code 17002, Please help 😢
First check whether oracle services are running or not
Secondly, either you are not giving login credentials correctly
Credentials are case sensitive
Thanku sir 🙏🏻
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
what should I do if I forgot to take a screen shot when I was installed oracl 21 ?
Well the screenshot will have web connection details, if I need to generalize, all the connection details are same as shown in video, but I suggest you to take a screenshot as and when required you can refer to that screenshot
That's my intention
Hi, Friend when i am making Oracle SQL developer connection, it's validating as: Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
(CONNECTION_ID=mMs77G7cT2aCZs77uBjFmw==)
Can i have help on this! i have downloaded 22.2 version.
Thanks in Advance.
looks like port 1521 is already in use , give all the connection details correctly and try one more time, hope that should work
Hi were you able to solve the error
Can I perform cold RMAN backup on windows OS
Sorry, I am not getting what you are trying to ask
Bro you ROCK
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=mlNxZd9QS7WocXKshYClsg==)
Here is the error. Can't figure out what's wrong. Writing all credentials correctly.
Please give the credentials in case sensitive
@@techstudio8268 if issue is still persisting here is how I fixed it. Open command prompt as admin and enter the following command. "C:\> lsnrctl start." it will show you the localhost. put that value (something like 192.168 something) in place of host. then try.
@@sabeehazam9273 bro I'm facing this problem, but maybe this guy have a listener that doesn't start, I'm not sure but maybe it's because he has windows home edition, I don't know how to solve this problem, I tried to install oracle 21c varius times and the problem was always the listener, I have windows 10 home on my pc, need healing
@@marioantoniosaviano1720 i encountered 2 problems. 1 was solved by running as administrator so make sure to do that. Second was solved by above step. It was a listener problem which got fixed by the "C:\> lsnrctl start." command.
thanks brother
thanks a lot .............................
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
I successfully executed all steps exactly as explained in the video (except that I replaced user "System" with another user name such as "selenium" and also that during the install process, I do not recall specifying password "hr" for "user "HR", but accepted "hr" as password when installing the HR schema. However, when I started executing the SQL script, I kept getting prompts for passwords, etc. which are not mentioned in the video. It may be noted that initially, I made the mistake of running the script with all SQL files without mentioning the ".sql" suffix and later rerun the script including all file names with the ".sql" suffix, and noticed that the same error messages appeared. Can you please help? Thx in advance.
Firstly give credentials in case sensitive
Next, you can run that .SQL script as many times as you can
After execution check the hr scema
If choose default location there is a message shows: The provided destination folder has invalid character. Verify and try again
Please avoid special characters and proceed with installation
I came here for installation to Learn oracle. Installation everything gone successful even hr schema also executed. But can you explain what the term hrscema mean why we used to execute.
HR schema is not mandatory, this is just for practicing SQL queries, for anyone who is working on a database need to have sample data. Instead of creating tables, inserting data etc.. HR schema is a ready made sample database. That is why I suggested to execute HR SQL script
Hope I gave clear information about HR Schema
Hello sir, it's very interesting this tutorial but I don't understand why we need to install human_ressources file and execute sql file within this folder. If someone can explain me beacause I'm a beginner ? Thanks.
HR is a schema, which is very helpful for practice purpose especially for beginners, that's why we install or unlock hr schema
While making new connection when I click on test there is an listner error ORA-12514 what to do?
Please give the parameters correctly
@@techstudio8268 I have entered correct username, password, service but still getting same error
Did you solve this problem? Can you help me? i have the same
@@techstudio8268 I give all parameters correctly, and have the same problem, can you help?
Any update regarding the error I am unable to get the solution.
Unable to connect after installation got below error
An error was encountered performing the requested operation:
ORA-01109: database not open
01109. 00000 - "database not open"
*Cause: A command was attempted that requires the database to be open.
*Action: Open the database and try the command again
Vendor code 1109
Did you installed/connected with adminstrator user?
i forgot to take a screenshot of service name what should i do
Service name is XEPDB1
Showing error when I enter this service name
Can we delete the zip files after extracting them?
Yes, you can.. there will be no problem