How to install SQL Developer on Windows 10 | Create Database connection using SQL Developer Tutorial
Вставка
- Опубліковано 12 бер 2022
- In this video section we will discuss how to install SQL Developer on windows 10.
We will also discuss how to create database connection with Oracle SQL. Download SQL Developer is done in easy steps.
Things discussed in this video:
How to install oracle SQL developer on windows 10
How to create Database connection using SQL Developer
How to unlock HR schema in oracle 11g
First you need to install Oracle SQL Developer then for installing SQL developer extract the file and open the sqldeveloper folder then run the application.
Commands to unlock hr user in oracle 11g
1) alter user hr account unlock;
2) alter user hr identified by hr;
#SQLDeveloper #download #windows10 #OracleSQLDeveloper #tutorial - Наука та технологія
I hope everyone loved this video while they are working with SQL developer. Thanks!
You're welcome!
I'm facing error while connecting ORA-01017 INVALID USERNAME/PASSWORD, Can you advise in cmd password is working but Sql developer notworking
@@bommanagayathri82 Same problem here...Is that your query resolved
one of the best video on sql developer in windows 10
You sir owned my subscription! Thank you!
I swear on my life working on a oracle sql project u saved my life. Love you bro
Glad I could help
Thank you!it helped me👍
Simple installation with the complete guide & to unlock HR user
Thanks bro very very helpful
Thank you for the video on unlock hr database in oracle database
This is the best video on how to install sql developer on linux . Thank you man you are awesome
Thank you so much, you saved the day🤗
Thank you so much sir.
Thanks!
useful
thank you sir, its very helpful for me to install and create table
Thank You HK for such a positive response
Very nice ❤️👍🏻
Very useful
3:26 Test failed: IO Error: The network adaptor could not establish the connection...
Please help
Facing same issue
Me also same issue please help
same brother
could you tell me how can I get solution of this problem
Nice
Existing table mai archive hota hai ya nahi kaise dekhate hai...
can we not only use sys as sysdba? is it necessary to unlock hr and use it? For some reason, the hr one won't connect saying something about wrong password. I followed the video.
Hey Ayma,
You can follow along this video to unlock HR user as this HR user contain the dummy schema for the learning of Oracle SQL
Link: ua-cam.com/video/nBbeMWyLWxM/v-deo.html
Its very imp plz reply
getting failure while connecting sql developer. Run SQL command line is connected but failure to connect sql. please assist
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=aR3CNaMBTp6c3qxXNQPUoQ==)
Can i know whether the problem is resolved
If we have username is hr, password is hr and SID is ORCL then how to connect and their is need to download oracle 21c express for Oracle SQL developer and my oracle sql developer shows load tns file no tns entries found in user plz help me
Hey Rutuja,
First of all thanks for watching this video, this video is made in reference to unlock the HR user in Oracle 11g express edition.
The steps are little different for oracle 21c express edition, although remember one thing sql developer can be used with any version of Oracle database.
And for sure HR user steps are different in other version of databases.
@@REGexSoftware plz make video on this for Oracle 21 express edition
@@REGexSoftware I did what you shown in video but it isn't connected plz tell me how i delete this hr user which i try to connect and how i connect it in oracle 21 express edition
After doing those steps still its showing user name is invalid what to do
Sir,I did same as you say but after opening SQL developer it shows warning that could not install some modules
That might be the issue because of Java Jdk or try running it as an administrator
@@REGexSoftware I did it it shows the same warning
@@parasunirmala2398 Have you checked the Java installation & also whether the path is set or not ? Try to run the database through administrator user
@@REGexSoftware database connected
Please show how you set the user name.
When creating account for oracle it takes user name as EMAIL address only. All the videos on UA-cam just showing how to make connections but not showing how to get those credentials which we have to use for making the connection.
Installation is not the most difficult thing. Sir please help me with making the connection
Hey Akshay, first of all make the connection with sys user as it behave like admin and put the password that you have provided at time of installation.
Apart from this you can follow along with the video to make hr user connection with the password as hr as mentioned in the vidoe section
Link : ua-cam.com/video/nBbeMWyLWxM/v-deo.html
sir please help me
I am not getting connection
Can you advise how to connect new db connection
Hey you can follow the steps as mentioned in this video: ua-cam.com/video/nBbeMWyLWxM/v-deo.html
Do we need to install Oracle 11g first ???
Hey Muzamil,
Yes you need to have Oracle installed otherwise how you will make a connection with the same.
How to create another user account and password
i did the steps but there is no TNS file . what to do?
Hey Yagami,
Have you install oracle database before installing sql developer?
If yes, then check the location where you have done the installation of database, sql developer only provides you the connection with your database that you have installed in your local base machine
@@REGexSoftware hi, can you tell me what all things to download for sql developer to work. or if possible can your share the link with me as it is very confusing for me. That would be a great help if you do!!
Insufficient privileges error bro
Hey Dinesh,
Try to execute the commands only with sys user.
And while making the hr user connection make hr as username & password
Sir please
What about the password in 3.11
Hey Laila,
Password is the same as you set for the user while you unlock them
Dear brother,I have created database same as you shown in the video,but once give a command like select * from employees or customers,I am getting error
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 1 Column: 15
please help me on the same
Hey Nagesh,
You can follow along this video to unlock HR user as this HR user contain the dummy schema for the learning of Oracle SQL
Link: ua-cam.com/video/nBbeMWyLWxM/v-deo.html
@@REGexSoftware Thanks for reply
user name and password Not coreect for connection of db
Hey, kindly try to unlock the user as per the given video in this link : ua-cam.com/video/nBbeMWyLWxM/v-deo.html
I don't know when we set the password???
when we used alter user hr identified by hr; using the same command we did the same
Hope now you understand
What about password brother
If you have unlocked the HR user using the same approach as mentioned in the video then the password will be the hr only.
I hope it works for you now!
pwd plz
If you have followed the same steps hr is the password for the hr user
@@REGexSoftware status failure the network adaptor could not establish the connection.
Same issue please help me
Password
Ok