How to install Oracle Database 21c Express Edition on Windows| Download, SQL Developer Configure HR

  Рет қаралды 160,584

TechStudio82

TechStudio82

Күн бұрын

Пікірлер: 697
@gunnerparth1158
@gunnerparth1158 6 ай бұрын
THIS GUY EXPLAINATION>>>>COLLEGE EXPLAINATION WOW SO EASY TO UNDERSTAND YOU DESERVE MY SUBSCRIBE
@techstudio8268
@techstudio8268 6 ай бұрын
Thanks a ton🤗 please share my videos with your friends 😊
@diceblock
@diceblock 2 жыл бұрын
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 :)
@techstudio8268
@techstudio8268 2 жыл бұрын
Good one, but when GUI is user friendly, why do we need to use command mode
@mojadhere7592
@mojadhere7592 Ай бұрын
Dude you are a genius. Trying to install it for like three days... Thanks a lot.
@techstudio8268
@techstudio8268 Ай бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@ashishnirmal5734
@ashishnirmal5734 2 жыл бұрын
thankyou sir for guiding so beautifully , Installation completed without any errors.💐💐✌✌😊😊
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@feeldown4471
@feeldown4471 Ай бұрын
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.
@techstudio8268
@techstudio8268 Ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@saugatasarkar3787
@saugatasarkar3787 2 жыл бұрын
One of the best and complete video in KZbin I found so far staring form installation to Configure HR
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@SurendarR-i8k
@SurendarR-i8k 11 ай бұрын
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.
@techstudio8268
@techstudio8268 11 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@kingteller2024
@kingteller2024 Жыл бұрын
This is one of the best tutorials i have ever come across. Thank you sir for that enormous help.😊🙏🤝
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
@betterthanamasterofone
@betterthanamasterofone 8 ай бұрын
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!
@techstudio8268
@techstudio8268 8 ай бұрын
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
@teynee_
@teynee_ 2 жыл бұрын
I was struggling for 2 day and your video just saved me. Thanks a ton !!
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@shreyabhagole2651
@shreyabhagole2651 4 ай бұрын
Thank you for explaining all steps in a proper manner!
@techstudio8268
@techstudio8268 4 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@BVar-xg3vb
@BVar-xg3vb 7 ай бұрын
You are awesome, this video is as easy as Oracle installation can get. Thank you so much!!
@techstudio8268
@techstudio8268 7 ай бұрын
Thanks for your wonderful compliment 💞 please subscribe to my channel and also share my videos with your friends 😊
@vinothkumarr2961
@vinothkumarr2961 2 жыл бұрын
Thanks for this video and step-by-step process, I have installed and connected successfully.
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@Vishal-gn2fn
@Vishal-gn2fn Жыл бұрын
Thank You so much for such a simple and elegant explanation
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
@HritikRanjan-mr5pq
@HritikRanjan-mr5pq Жыл бұрын
VERY GOOD AND CLEAR CUT INSTALLATION VIDEO 👌👌
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
@try_gettechnical
@try_gettechnical 2 жыл бұрын
BHAIYA AAPNE TO KAMAL HI KAR DIYA BAHUT BAHUT DHANYAVAD AAPKA
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
@shadowmasked7188
@shadowmasked7188 Жыл бұрын
thank you veryy much man. Greeting from Azerbaijan❤❤❤
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends ☺️
@berbarmoumen1847
@berbarmoumen1847 Жыл бұрын
Merci beaucoup Monsieur pour votre aide si précieuse, excellente journée.. !
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
@sadiqurrahman2
@sadiqurrahman2 Жыл бұрын
This is the best learning video to install Oracle21c.
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@enggaabow3801
@enggaabow3801 Жыл бұрын
Thank you indeed you are life saver.
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
@shaikkhizar8133
@shaikkhizar8133 5 ай бұрын
Thankyou so much Brother finally i connected to my database from java application
@techstudio8268
@techstudio8268 5 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@sugendransugi5218
@sugendransugi5218 Жыл бұрын
Thank you so much. I've been struggling for long time.
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
@insidehead
@insidehead Жыл бұрын
this video is amazing... very informative video in whole youtube..
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks a lot for your comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
@МаксимЖмыхов-ъ7и
@МаксимЖмыхов-ъ7и 3 ай бұрын
Дай Бог тебе здоровья милый человек, всё четко и грамотно,с 1 раза получилось, удачи бро
@techstudio8268
@techstudio8268 3 ай бұрын
Sorry can't understand this language
@МаксимЖмыхов-ъ7и
@МаксимЖмыхов-ъ7и 3 ай бұрын
@@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
@youssefrigale
@youssefrigale 5 ай бұрын
Status : Failure -Test failed: IO Error: Got minus one from a read call, connect lapse 61011 ms., Authentication lapse 0 ms.
@techstudio8268
@techstudio8268 5 ай бұрын
Please make sure all the settings are perfectly given
@cartoonlegend18
@cartoonlegend18 2 жыл бұрын
Thank you sir.you video helped me a lot.wish u all the best for your channel.
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@ChandranChandru-q6e
@ChandranChandru-q6e 8 күн бұрын
Bruh i have error at hr schema rub as unable to open file
@techstudio8268
@techstudio8268 6 күн бұрын
Please share the error details
@rossvazgo3248
@rossvazgo3248 Жыл бұрын
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?
@techstudio8268
@techstudio8268 Жыл бұрын
Yes, thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
@chsilpa8761
@chsilpa8761 Жыл бұрын
Why it is rolling back for the installation time😔many times I tried to install...and every time it like this on rolling back
@techstudio8268
@techstudio8268 Жыл бұрын
Really very weird, not sure why that is happening
@chsilpa8761
@chsilpa8761 Жыл бұрын
@@techstudio8268 I don't know plz tell me
@suchanyajaichun6293
@suchanyajaichun6293 2 жыл бұрын
I can use it because of your video. thank you very much. 🥰
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@Vendhya_2022_Humsafar
@Vendhya_2022_Humsafar 21 күн бұрын
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
@techstudio8268
@techstudio8268 21 күн бұрын
That indicates that already 21c is already installed on your machine
@Tony-ee3nm
@Tony-ee3nm 7 ай бұрын
Thanks a lot for this clear installation guide, it was helpful.
@techstudio8268
@techstudio8268 6 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@ramk8010
@ramk8010 7 ай бұрын
Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied this error comes at the time of connecting the hr please give solution
@techstudio8268
@techstudio8268 7 ай бұрын
Please give the credentials in lower or upper case
@rakshithmakam575
@rakshithmakam575 Жыл бұрын
Sir once we closed the tab how to open the front end oracle SQL developer again?
@techstudio8268
@techstudio8268 Жыл бұрын
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
@ramanavenkat4588
@ramanavenkat4588 6 ай бұрын
i saw ur vedio and done step by step
@techstudio8268
@techstudio8268 6 ай бұрын
Thanks 😊 please subscribe to my channel and also share my videos with your friends 😊
@gireeshkumarhanumara
@gireeshkumarhanumara 2 жыл бұрын
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.
@techstudio8268
@techstudio8268 2 жыл бұрын
looks like port 1521 is already in use , give all the connection details correctly and try one more time, hope that should work
@sakshikhose2792
@sakshikhose2792 2 жыл бұрын
Hi were you able to solve the error
@Tt-wm1ze
@Tt-wm1ze Жыл бұрын
Hi Thanks for the tutorial, Iam getting this message Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID===)
@techstudio8268
@techstudio8268 Жыл бұрын
Please provide the login credentials in case sensitive
@arunraj7965
@arunraj7965 4 ай бұрын
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.
@techstudio8268
@techstudio8268 4 ай бұрын
Credentials are case sensitive, please try
@NandanMeher
@NandanMeher 10 ай бұрын
Thank you very much. Done at one go
@techstudio8268
@techstudio8268 10 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@GreenwayCarriers
@GreenwayCarriers Жыл бұрын
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
@techstudio8268 Жыл бұрын
Please give the credentials in case sensitive
@sabeehazam9273
@sabeehazam9273 Жыл бұрын
@@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.
@marioantoniosaviano1720
@marioantoniosaviano1720 Жыл бұрын
@@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
@sabeehazam9273
@sabeehazam9273 Жыл бұрын
@@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.
@JaiPrakash-bl8mw
@JaiPrakash-bl8mw Ай бұрын
Bro i am getting an status: failure - test failed while clicking test.... I have entered the details correctly....
@techstudio8268
@techstudio8268 Ай бұрын
Please make sure that services are running and also give credentials in case sensitive
@babu-hg4ub
@babu-hg4ub Жыл бұрын
Hi sir im already downloaded sql developer but when the network adapter could not establish the connection.... How can I solve this ???
@techstudio8268
@techstudio8268 Жыл бұрын
Ya it is almost same, but please give credentials in case sensitive
@babu-hg4ub
@babu-hg4ub Жыл бұрын
@@techstudio8268 okay sir 👍
@babu-hg4ub
@babu-hg4ub Жыл бұрын
@@techstudio8268 sir I give credentials in case sensitive but still it was showing same error
@MotoExploring
@MotoExploring 2 жыл бұрын
Worked for me. Thank You !
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
@monikadominczyk9432
@monikadominczyk9432 9 ай бұрын
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 😢
@techstudio8268
@techstudio8268 9 ай бұрын
First check whether oracle services are running or not Secondly, either you are not giving login credentials correctly Credentials are case sensitive
@babu-hg4ub
@babu-hg4ub Жыл бұрын
But i downloaded windows 64 bit with jdk 11 included...process is same or different for both..
@techstudio8268
@techstudio8268 Жыл бұрын
Yes it is same
@babu-hg4ub
@babu-hg4ub Жыл бұрын
@@techstudio8268 okay sir tq for the information 👍
@Dark_Vader01
@Dark_Vader01 7 күн бұрын
How much total time it takes to complete to 100% ? Mine is stuck at 7% !
@techstudio8268
@techstudio8268 6 күн бұрын
Looks like you have hardware issues
@jowanmohsen8076
@jowanmohsen8076 3 сағат бұрын
@@techstudio8268 same how do i fix it ?
@saturo_sukuno
@saturo_sukuno 11 ай бұрын
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.
@techstudio8268
@techstudio8268 11 ай бұрын
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
@mahomedcissokho455
@mahomedcissokho455 2 жыл бұрын
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.
@techstudio8268
@techstudio8268 2 жыл бұрын
HR is a schema, which is very helpful for practice purpose especially for beginners, that's why we install or unlock hr schema
@sirishireesha6474
@sirishireesha6474 Жыл бұрын
i forgot to take a screenshot of service name what should i do
@techstudio8268
@techstudio8268 Жыл бұрын
Service name is XEPDB1
@E_Navya
@E_Navya Жыл бұрын
Showing error when I enter this service name
@kathleenyap8975
@kathleenyap8975 Жыл бұрын
This video is such a great help!
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊
@vinayakajoshi7573
@vinayakajoshi7573 4 ай бұрын
Thanks for sharing. I have successfully Done the setup.
@techstudio8268
@techstudio8268 4 ай бұрын
Sounds great 👍 please subscribe to my channel and also share my videos with your friends 😊
@pinesmovies3081
@pinesmovies3081 9 ай бұрын
Excellent!!!!
@techstudio8268
@techstudio8268 9 ай бұрын
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
@emanmustafa3574
@emanmustafa3574 11 ай бұрын
what should I do if I forgot to take a screen shot when I was installed oracl 21 ?
@techstudio8268
@techstudio8268 11 ай бұрын
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
@sumanthReddy-r2d
@sumanthReddy-r2d 7 ай бұрын
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
@techstudio8268
@techstudio8268 7 ай бұрын
Did you installed/connected with adminstrator user?
@vinay_gudiya9250
@vinay_gudiya9250 Жыл бұрын
Not able to connect new/select database connection and getting error Status : Failure - test failed : listener refused the connection with the following error : ORA - 12514 After installation Oracle database 21c Express Edition not getting installed successfully screen for pliggable database and localhost ID for taking screenshot. Please help and appreciated if you respond to my query.
@techstudio8268
@techstudio8268 Жыл бұрын
Firstly, check whether you are providing the credentials correctly or not, credentials are case sensitive Secondly, please make sure the oracle services are running or not If still if you face any issues, please let me know
@vinay_gudiya9250
@vinay_gudiya9250 Жыл бұрын
@@techstudio8268 Tried mentioned resolution that you shared but not resolved my issue. Requesting for your help.
@nitish5152
@nitish5152 8 ай бұрын
​@@techstudio8268I tried,but still showing same error
@med-amine7903
@med-amine7903 11 ай бұрын
finally a great explaination.
@techstudio8268
@techstudio8268 11 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@techstudio8268
@techstudio8268 Ай бұрын
Thanks 👍
@adityajaiswal7978
@adityajaiswal7978 Жыл бұрын
I have successfully installed Oracle DB 21c EX thanx man✌
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@adityajaiswal7978
@adityajaiswal7978 Жыл бұрын
@@techstudio8268 already subscribed✌
@Abhishek9o
@Abhishek9o Жыл бұрын
Bhai maine set up kar liye but jaise hi oracle connection add karta hoon toh test failure aa raha hai bro help me
@karrisateesh7938
@karrisateesh7938 2 жыл бұрын
Hi Bro. Very clear and good explanation. useful info. tanq.
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks for your comments 🙏 please subscribe to my channel and also share my videos with your friends ☺️
@melvinalejandrocustodiorom5359
@melvinalejandrocustodiorom5359 2 жыл бұрын
thank you very much!!! you save me :)
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@sumitbhadola
@sumitbhadola 2 ай бұрын
Those who are getting error while pasting the command make sure to change the guru1 with your folder name. @ C:\app\amitb\product\21c\dbhomeXE\demo\schema\human_resources\hr_cre.sql @ C:\app\amitb\product\21c\dbhomeXE\demo\schema\human_resources\hr_popul.sql @ C:\app\amitb\product\21c\dbhomeXE\demo\schema\human_resources\hr_idx.sql @ C:\app\amitb\product\21c\dbhomeXE\demo\schema\human_resources\hr_code.sql @ C:\app\amitb\product\21c\dbhomeXE\demo\schema\human_resources\hr_comnt.sql @ C:\app\amitb\product\21c\dbhomeXE\demo\schema\human_resources\hr_analz.sql
@techstudio8268
@techstudio8268 2 ай бұрын
🙏
@sowjanyasathuluri9162
@sowjanyasathuluri9162 11 ай бұрын
Hi..Even i got the same error, Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=v5mtxcUaSsKK+5N5YF9s1A==) Could you please advisw
@techstudio8268
@techstudio8268 11 ай бұрын
Please give the login credentials correctly and ensure that the oracle services are running
@sowjanyasathuluri9162
@sowjanyasathuluri9162 11 ай бұрын
thanks, my issue got resolved by giving ip address
@saiprasadkashid570
@saiprasadkashid570 2 жыл бұрын
While making new connection when I click on test there is an listner error ORA-12514 what to do?
@techstudio8268
@techstudio8268 2 жыл бұрын
Please give the parameters correctly
@saiprasadkashid570
@saiprasadkashid570 2 жыл бұрын
@@techstudio8268 I have entered correct username, password, service but still getting same error
@Ser-f4g
@Ser-f4g Жыл бұрын
Did you solve this problem? Can you help me? i have the same
@Ser-f4g
@Ser-f4g Жыл бұрын
@@techstudio8268 I give all parameters correctly, and have the same problem, can you help?
@abinashsahu5907
@abinashsahu5907 Жыл бұрын
Any update regarding the error I am unable to get the solution.
@mohdusman5607
@mohdusman5607 Жыл бұрын
Thank you bro 😊, this video is very helpful for me .
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks for your valuable comments 😘 please subscribe to my channel and also share my videos with your friends 😊
@chaitanyareddy5567
@chaitanyareddy5567 10 ай бұрын
Ver y clearly explained. Was very helpful.
@techstudio8268
@techstudio8268 10 ай бұрын
Thanks for your valuable feedback ☺️ please subscribe to my channel and also share my videos with your friends 😊
@UmidjonNormatsvsvidbxksbs
@UmidjonNormatsvsvidbxksbs Жыл бұрын
Thank u for clear explanation! :)
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@vikoxplayer
@vikoxplayer Жыл бұрын
Thank you bro. You actually helped me.
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@rohidasdevdhe8562
@rohidasdevdhe8562 Жыл бұрын
Can I perform cold RMAN backup on windows OS
@techstudio8268
@techstudio8268 Жыл бұрын
Sorry, I am not getting what you are trying to ask
@Rashidali-cx5mc
@Rashidali-cx5mc Жыл бұрын
thank you sir this tutorial is so helpful .😘😗
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊
@ahmedkaleem5504
@ahmedkaleem5504 2 жыл бұрын
Hello Sir, Thanks for this great video. It helped me a lot. I have a question. Can we host application based on 21c XE on google cloud? Thanks again.
@techstudio8268
@techstudio8268 2 жыл бұрын
Well I am not sure of that, sorry
@aneeshkumara.s.8209
@aneeshkumara.s.8209 2 жыл бұрын
Thank You , it's working for me.
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@ranjeshsingh5933
@ranjeshsingh5933 3 ай бұрын
If choose default location there is a message shows: The provided destination folder has invalid character. Verify and try again
@techstudio8268
@techstudio8268 3 ай бұрын
Please avoid special characters and proceed with installation
@shubhangigangurde8181
@shubhangigangurde8181 Жыл бұрын
Thank you for this. It really helped😇
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@temirtaragay8932
@temirtaragay8932 Жыл бұрын
It has been three months since I started trying to connect to database but none of the videos helped including this one. Unfortunately. It gives some errors while testing connection to DB. I have tried to resolve this issue by following other videos still could not solve it. I installed Windows 10 and reinstalled it. I tried it on Windows 7. I was able to Oracle DB developer VM and log on to database but I could not create users in that database. Searching the internet during 3 months several hours per week did not bring any positive results. Why does it have to so difficult?
@techstudio8268
@techstudio8268 Жыл бұрын
I can understand your situation, some times a small mistakes will make our life hell. Ok, let's get into your issue In your case, I strongly recommend you to format your operating system and re install operating system,fresh copy , it can be either windows 11 or 10 Secondly, install the minimum pre requisite softwares on your machine Thirdly, install oracle 11g software Why do I recommend this for you is, It is a light weight software and does not take much of your system hardware resources and more over, for practicing SQL queries this is the best software Lastly install SQL developer software, which is a stand-alone software and then unlock HR and SCOTT users from the system admin If still the issue persists, get back to me Still I can help you Lastly, please don't loose your patience 🙏
@nehamajumdar1810
@nehamajumdar1810 2 ай бұрын
I forgot to take the screenshot of plugging host how to get it now that link please reply 🙏🙏
@techstudio8268
@techstudio8268 2 ай бұрын
No problem, that is generic information and the details will be almost same as shown in the video
@nehamajumdar1810
@nehamajumdar1810 2 ай бұрын
@@techstudio8268okk l will try and let you know
@littleprincess250
@littleprincess250 2 жыл бұрын
Yeppp thank you so much
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
@satyasaibhagavatula7559
@satyasaibhagavatula7559 20 күн бұрын
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.
@techstudio8268
@techstudio8268 17 күн бұрын
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
@PranavParab28
@PranavParab28 2 жыл бұрын
thnks... worked for me w/o any issue.
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@nawazrockstar5836
@nawazrockstar5836 7 ай бұрын
Getting an error while configuring oracle components. Check the logs at C:\...... And try again
@techstudio8268
@techstudio8268 7 ай бұрын
Check the hardware requirements and also space in c drive
@keilebdrums
@keilebdrums 2 жыл бұрын
Thank you so much! You saved me!!
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@mahbuburrahmanopu5634
@mahbuburrahmanopu5634 Жыл бұрын
❤❤❤❤❤❤ you are the best bro!!!
@techstudio8268
@techstudio8268 Жыл бұрын
Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊
@arbajkhureshi8229
@arbajkhureshi8229 2 жыл бұрын
Thank you, this video is very helpful for me
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@enggaabow3801
@enggaabow3801 Жыл бұрын
Second question is: when i click the link of sql developer download I can’t see the download box i see only software licenses agreement.
@techstudio8268
@techstudio8268 Жыл бұрын
Ohh.. weird, let me check
@sagarpatel3204
@sagarpatel3204 9 ай бұрын
THANK YOU VERY MUCH ITS 100% WORK
@techstudio8268
@techstudio8268 9 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@automationcombine
@automationcombine Жыл бұрын
please give a separate video for ODBC 32 Bit connection to oracle database
@techstudio8268
@techstudio8268 Жыл бұрын
I will try
@unluckyman2759
@unluckyman2759 Жыл бұрын
I didn't find the connect button after I tested
@techstudio8268
@techstudio8268 Жыл бұрын
You mean connect button in SQL developer??
@tulumzyber7939
@tulumzyber7939 2 жыл бұрын
Can we delete the zip files after extracting them?
@techstudio8268
@techstudio8268 2 жыл бұрын
Yes, you can.. there will be no problem
@sandrevamsi2954
@sandrevamsi2954 2 жыл бұрын
I think its time to start online teaching ❣️ we will support you..
@techstudio8268
@techstudio8268 2 жыл бұрын
Thanks for your support 💕 i will plan accordingly 😊
@JoniPriya
@JoniPriya 25 күн бұрын
Sir please make vedios on Oracle 23c complete installation and connect with sql developer new version as same as this 21c please
@techstudio8268
@techstudio8268 25 күн бұрын
Very soon you will get that video
@nihadawad7340
@nihadawad7340 Жыл бұрын
Many thanks from Palestine 🇵🇸❤️🌹
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@yasminshaikhmujawar338
@yasminshaikhmujawar338 Жыл бұрын
😊Thank you. This video is very helpful for me...
@techstudio8268
@techstudio8268 Жыл бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@aayushbisht4307
@aayushbisht4307 2 жыл бұрын
thanks man ! helped a lot !
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@Saikiran_1718
@Saikiran_1718 Жыл бұрын
For me Employees details table not showing remaining tables all are coming 🙄🤔 what is the reason ?
@techstudio8268
@techstudio8268 Жыл бұрын
Looks like you are executing script worgly, please try one more time
@akashbansode2987
@akashbansode2987 7 ай бұрын
perfectly taught..!
@techstudio8268
@techstudio8268 7 ай бұрын
Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊
@रामप्रकाशरासवानी
@रामप्रकाशरासवानी 2 жыл бұрын
Thank you Thank you Thank you so much sir.
@techstudio8268
@techstudio8268 2 жыл бұрын
You are most welcome 🙏 please subscribe to my channel and also share my videos with your friends 😊
@ayan7126
@ayan7126 11 ай бұрын
thank you very much this was very helpfull
@techstudio8268
@techstudio8268 11 ай бұрын
You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊
@agrima6819
@agrima6819 Жыл бұрын
I'm getting this error "Oracle Database Installation Completed with Errors. The wizard was interrupted before oracle database 21c express edition could be completely installed. Your system has not been modified. To Complete installation at another time, please run setup again." I tried running it again but getting same error all the time.
@techstudio8268
@techstudio8268 Жыл бұрын
Please uninstall and reboot the machine and then install one more time
@devixun
@devixun Жыл бұрын
Install "setup" rather than installing wizard first
@nimmalapudilakshminarayana1571
@nimmalapudilakshminarayana1571 Жыл бұрын
Oracle Database 21c Express Edition BDS OracleConfigDig DatabaseConfigFailed Msg) An error occurred while configuring Oracle XE database. Check the logs at Clapp imal product\21c\cfgtoollogs\dbca and try again.
@techstudio8268
@techstudio8268 Жыл бұрын
Please reinstall the software and restart your machine and again install the software
@insidehead
@insidehead Жыл бұрын
GETTING THIS ERROR: ORA-65096: invalid common user or role name 65096. 00000 - "invalid common user or role name" *Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must consist only of ASCII characters, and must contain the prefix specified in common_user_prefix parameter. *Action: Specify a valid common user or role name.
@techstudio8268
@techstudio8268 Жыл бұрын
Please follow the video carefully and execute the commands
@insidehead
@insidehead Жыл бұрын
@@techstudio8268 hi thanx for d reply.. i did all the things.. unfortunately its showing the same error tried several times.
@javierandresmendozarocha978
@javierandresmendozarocha978 7 ай бұрын
I finished installing SQL Developer after Oracle Dabatase Express Edition (I created an account), the listener is running. When I put the information after the installation (localhost, port and xepdb1) in a new connection and test it, it throws an error: The Network Adapter could not establish the connection. I'm literally using the info the setup.exe showed me at the end.
@techstudio8268
@techstudio8268 7 ай бұрын
Check whether oracle services are running or not in command prompt mode
@bhanumeesala5798
@bhanumeesala5798 6 ай бұрын
@@techstudio8268 how to check?... can you explain clearly
@gbenrodamola7936
@gbenrodamola7936 Жыл бұрын
Thanks, so insightful . May I ask, how do I run the hr. query on the sqlplus terminal. I tried using the HR(username) to log in but not connected.
@techstudio8268
@techstudio8268 Жыл бұрын
You need to connect to pluggable database, you can check my video, how to unlock HR user in oracle 21c, you will get step by step
@aditya-qd9rg
@aditya-qd9rg Жыл бұрын
how to connect to hr
Кәсіпқой бокс | Жәнібек Әлімханұлы - Андрей Михайлович
48:57
This mother's baby is too unreliable.
00:13
FUNNY XIAOTING 666
Рет қаралды 22 МЛН
How To Get Married:   #short
00:22
Jin and Hattie
Рет қаралды 27 МЛН
How to install MongoDB 6 on Windows 10/ Windows 11
13:32
ProgrammingKnowledge
Рет қаралды 461 М.
Кәсіпқой бокс | Жәнібек Әлімханұлы - Андрей Михайлович
48:57