I want to thank you for this video. It explained something that no one else would explain in my hours of searching. It was so frustrating. Thanks so much!!!
Thanks bro! I have watched other videos but you explained exactly what i was looking for. Other people just assumed that we no all this database connection and user thing. But you did not. Thanks! It really helped me and many others.
This is it (when starting with sql dev). Just remember to use the default prefix c## for the common user name. Also take into account that to create a table, insert rows into it, delete rows from it and drop the table, you only need to grant roles, not system privileges. 7:06 a new connection *
But before successfully creating the New connection, I'm having the ORA-12505 error: listener does not currently know of given SID. Please help, it's urgent for my upcoming exam.
Greatly good explain! I wonder, the calm you radiate😊, I was just thinking is not complicated at all, if I could just listen to your voice and see your video 😊👍. Thanks!
That's a great explanation chitu... but at present date 0n 2020 , We need to create a new user in all oracle database which starts with C##username. Where username is any database user name u can give as like system is a admin user.
Thank you so much for your perfect video, I had really bad problem with this oracle, but after watching your video I think I am more comfortable with Oracle Database
@@shivanikumbhar14 Sorry I forget that (it was 3 years before). Earliest date is about 5.2.2021, when I will have enough time for install Oracle DB and reproduce process.
@@shivanikumbhar14 Set speed reproduction of video on 0,75 or slower (0,50) and do everything like he (step by step). First create connection with Oracle system user account, just like he says on begining of video.
i got Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied .all the time when i create user connection, i'm pretty sure my username and password is right, i have oracle xe edition
Followed your example exactly and get the following error: SQL Error: ORA-65096: Invalid Common user or Role name What version of Oracle/SQL Developer are you using? I'm using the Virtual Box Appliance downloaded from their website. Includes Oracle 12.1c and SQL Developer 4.1.0.19
+Mark Curry : I resolved the problem as follows: The first issue I had was, in creating the user, Oracle insisted that I preface the username with "C##" to make it a common user. That was the error ORA-65096 Then in granting privileges as Chitu describes, i received a different error saying I was not able to grant those privileges. I resolved that error as follows: 1. The error message will the line number of the statement, as well as the statement itself, that is causing the errors. 2. IN the Create User window, select the SQL tab that shows the SQL script. 3. Identify the line in the script that is causing the error and comment it out by inserting 2 dashes, --, at the beginning of the line. 4. Click the apply button and you will get another error message giving the line number and offending statement. Repeat steps 1-4 about a dozen times until you no longer get error messages, and then proceed with Chitu's method. Works like a charm! Thanks, Chitu!
@@markcurry3997 I did like you said, but when we commented error lines we automatically cancelled important changes, so i can not login as the new C##user, how to fix that?
THE USERNAMEEEEE!!!!!!!!!!!!! I thought i was supposed to use the username i created when installing oracle 12c. So you're supposed to use "system" instead. This literally took me 5 days before looking up this video.
everyone just download the express version than download the SQL developer . after that create new database connection in which enter the pass when u install the express edition and username will be system.(this is for the new versions)
+Chitu Okoli now about this Services \ (Windows could not start the Oracle ORCL VSS Writer Service service on Local Computer). Error 2 : The system cannot find the file specified.
Failed to process SQL command - Error starting at line : 2 in command - CREATE USER "JFAN" IDENTIFIED BY "ZJFN" Error report - 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. I'm new to this stuff and I don't know what any of this means.
Hello Chitu, I am watching your videos and I can say your explanations are very clear. Could help showing how to create a connection from excel with an oracle database. I have watched many videos but any shows step by step and show how this will work. I am using Oracle developer, Oracle 11g XE db and Excel 2016. Appreciated your help
+Abhishek Kumar Usually I get this error if there is a problem with Oracle Database running. It is hard to explain in a RUclips comment (this is not not a tech support forum), but in brief, you have to make sure that Oracle Database is actually running before you actually start Oracle SQL Developer. Here are the steps you can follow: 1. Follow the steps described in this video: ruclips.net/video/zY1AUhAeFSI/видео.html 2. When you get to the services to enable, first make sure that Oracle SQL Developer is completely closed. Then enable first OracleServiceXE. Wait for it to start running. Then, after it has started running, enable second OracleXETNSListener, in that order. See this image to see which services to enable: snag.gy/vncSf.jpg 3. Wait 60 seconds. This is important, or else you might still have trouble. 4. Start Oracle SQL Developer and try to connect again. I hope that works.
(Status : Failure -Test failed : Listener refued the connection with the following error: ORA-12505 TNS: listener does not currently know of SID given in connect decriptor) what should i do to this error
+Theo Rio Are you sure that Oracle Database is running? Perhaps Oracle Database is not running, and so SQL Developer cannot connect to it. If you're sure that Oracle Database is running, then close SQL Developer completely and then restart it after 30 seconds. I've seen this (or a similar) error when I started SQL Developer before Oracle Database was fully started.
Hi Chitu, I am following same steps as in your video. But When I try to create new user , I am getting below error. Error starting at line 2 in command: CREATE USER abhi IDENTIFIED BY Oracle_1 Error at Command Line:2 Column:13 Error report: SQL Error: ORA-65096: invalid common user or role name Please help.
What is the user name you're trying to use? It might not be acceptable to Oracle. Try a different, simple name. Either one of these two situations might apply: * You're using illegal characters (see docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm); or * You might be trying to name it an existing user name or a reserved Oracle key word (e.g. "system"). However, without knowing what name is giving the error, it's hard to tell.
+latifah mai It might be that you're using an illegal character (such as a space) in the user name or password. To help you, I need to know the exact user name and password that are giving the error, and I also need a screenshot of the error. You can send me this information through chitu.okoli.org/contact/, and I'll respond.
I always get the error "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=XhNXjXvyR3yFbOs1JlwD5w==)" How to fix it?
Hello, please help me to solved this issue i do same steps shown in video but when i create new user(not system user) and click on connect after username and password i am facing an error -Test failed: ORA-01017: invalid username/password; logon denied.
+Akhirah Strong I usually only make tutorials when 1) my students have a problem; 2) it needs a video to really explain the solution well and 2) I can't find any good tutorial on RUclips that helps them out adequately. Other than that, I don't have a master plan for a tutorial series, if that's what you mean. However, if you have a specific request, I'll consider it. That said, you might want to check out Jeff Smith's website (www.thatjeffsmith.com) and RUclips videos (ruclips.net/user/ThatJeffSmithvideos). He's a on the development team of Oracle SQL Developer, has lots of super-useful material already, and is incredibly responsive to questions people ask.
+Chitu Okoli Yeah that's what I meant. You are clear, calm, and concise. If you ever find the time to create a tutorial, there will be many happy beginners.
thanks for the video its very helpful....but i'm having problem in connecting and saving new connection.....bt test always be success.....there is no error shown...how can this be solved????
when I click test button it gives error Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection what shall i do?
when i create new connection using same username and password it copies existing connection data into new one connection..is it possible to create new connection with same username and password with no existing table data??
I never was required to install the Oracle Database after I downloaded the sql developer zip file at this link www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. How am I suppose to setup a system password if the password was never required to be generated after running the sqldeveloper.exe file ? Thanks for your help.
This video is only for the last step. The full steps are: 1. Install Oracle Database (that's when you set the system password) 2. Install SQL Developer 3. Configure the connections (that's what this video is about). Full details can be found at chitu.okoli.org/bios/pro/teach/btm-382/install-oracle-for-btm-382/#how_to_install_oracle
Thanks, but what do I do with a "Test Failed: IO Error: Got minus one from a real call" after installing Oracle Enterprise in addition to Express version when running sql developer?
I've installed Oracle express, could the problem be due to the fact that I have installed the version of SQL developer containing a JDK, meaning I have two JDKs. One for Eclipse and one for SQL developer?
No, generally having 2 or 5 or 10 JDKs is not a problem; they shouldn't interfere with each other. Sorry, I don't know that error, but Google has some answers: www.google.fr/search?q=com.mysql.jdbc.exceptions.jdbc4.CommunicationsException%3A+Communications+link+failure&ie=utf-8&oe=utf-8&client=firefox-b-ab&gfe_rd=cr&ei=hwDdWKPDOtCN8Qez4KiwDg
I tried multiple times but while downloading I am not getting option to add password so unable to establish connection for the same.. Can anyone please help me on this
For the system user, the username is always "system" and the password is the password you created during Oracle installation. For the second user, the username and password are whatever you choose as shown in the video.
There's only one thing you can do: reinstall Oracle Database and remember the password this time (you might need to uninstall it before reinstalling, but I'm not sure).
Thanks for this! Obviously because it's localhost, that database is only accessible using that PC, right? But do you know how I can make it accessible by any PC in the world? That would be great if you can help me answer that question :) In the mean time I'll just search for the answer.
This video is only for the last step. The full steps are: 1. Install Oracle Database (that's when you set the system password) 2. Install SQL Developer 3. Configure the connections (that's what this video is about). Full details can be found at chitu.okoli.org/bios/pro/teach/btm-382/install-oracle-for-btm-382/#how_to_install_oracle
I want to thank you for this video. It explained something that no one else would explain in my hours of searching. It was so frustrating. Thanks so much!!!
After 2 yrs of trying you solved my problem...you re a star!
I've been stuck for hours looking for an answer thank you so much I was finally able to create a connection
Thanks bro! I have watched other videos but you explained exactly what i was looking for. Other people just assumed that we no all this database connection and user thing. But you did not. Thanks! It really helped me and many others.
I actually spent so many hours looking for answers to no avail until I watched your video. Thak you very much!
This is it (when starting with sql dev). Just remember to use the default prefix c## for the common user name.
Also take into account that to create a table, insert rows into it, delete rows from it and drop the table, you only need to grant roles, not system privileges.
7:06 a new connection *
Please create more videos like this!!! I've been going through stacks of videos and this is the simplest explanation yet. Really awesome.
But before successfully creating the New connection, I'm having the ORA-12505 error: listener does not currently know of given SID. Please help, it's urgent for my upcoming exam.
I hit this also. It was my port number.
finally someone on youtube talks about users and all the dynamic tables that are there. Thank you
user create successfully but for log in I have this error:
Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied
Had the same issue, changed username to ALL capital letters and it fixed the problem.
@@M3TA_K Thank you, it worked. It seems like the new version does not change all the letters to capital by itself, which older versions did.
@@M3TA_K YOU ARE A LIFE SAVER! THANK YOU!
@@M3TA_K Thank you so much!! you're my life saviour!
@@M3TA_K LIFE SAVER!
if anyone is having the error ORA-01017 even with all correct credentials, try replacing the username characters by uppercase characters only.
Wish ALL the tutorials on RUclips were this thorough. Thanks. :)
I learning SQL Oracle and PLSQL. Thanks for your help, this video is awesome. Saludos from México.
100 like ... finally i found the right working solution for my ORA-01017 error !!!
Thank you very much 🌺🌺🌺
thanq was stuck on something else but your video proved extremely helpful thanq so much.
Greatly good explain! I wonder, the calm you radiate😊, I was just thinking is not complicated at all, if I could just listen to your voice and see your video 😊👍. Thanks!
I don't know how to thank you for such a helpful video, love the clean connection.
That's a great explanation chitu... but at present date 0n 2020 , We need to create a new user in all oracle database which starts with C##username. Where username is any database user name u can give as like system is a admin user.
Thanks a lot for that comment
Thank you so much for your perfect video, I had really bad problem with this oracle, but after watching your video I think I am more comfortable with Oracle Database
Failure-Test failed:IO Error:The Network adopter could not establish the adopter
Same I got this... Please give us the solution please
@@shivanikumbhar14 Sorry I forget that (it was 3 years before). Earliest date is about 5.2.2021, when I will have enough time for install Oracle DB and reproduce process.
Sir then... Get some solutions on it please because my exams are starting.. And I need oracle too practice
@@shivanikumbhar14 Set speed reproduction of video on 0,75 or slower (0,50) and do everything like he (step by step). First create connection with Oracle system user account, just like he says on begining of video.
@@shivanikumbhar14 first u have to install a oracle database from online..
After viewed all details in video I was resolved problem. Thank you!
i got Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied .all the time when i create user connection, i'm pretty sure my username and password is right, i have oracle xe edition
if you got this just put the user name in CAPITAL
@@mohammadalhaj6681 thank you so much you saved me
Followed your example exactly and get the following error:
SQL Error: ORA-65096: Invalid Common user or Role name
What version of Oracle/SQL Developer are you using? I'm using the Virtual Box Appliance downloaded from their website. Includes Oracle 12.1c and SQL Developer 4.1.0.19
+Mark Curry : I resolved the problem as follows:
The first issue I had was, in creating the user, Oracle insisted that I preface the username with "C##" to make it a common user. That was the error ORA-65096
Then in granting privileges as Chitu describes, i received a different error saying I was not able to grant those privileges. I resolved that error as follows:
1. The error message will the line number of the statement, as well as the statement itself, that is causing the errors.
2. IN the Create User window, select the SQL tab that shows the SQL script.
3. Identify the line in the script that is causing the error and comment it out by inserting 2 dashes, --, at the beginning of the line.
4. Click the apply button and you will get another error message giving the line number and offending statement.
Repeat steps 1-4 about a dozen times until you no longer get error messages, and then proceed with Chitu's method.
Works like a charm! Thanks, Chitu!
+Mark Curry Thanks for posting the solution to your issue! It might help some others.
@@markcurry3997 I did like you said, but when we commented error lines we automatically cancelled important changes, so i can not login as the new C##user, how to fix that?
@@markcurry3997 ,Thanks a lot of this __ help me solve the problem
@@ChituOkoli ,thanks a lot for your tutorial. It's helped me!
You will be mentioned in my night prayers for this video! :)
Thank you so much this helped a lot! I was stuck at how to create a schema from a new user and this video helped me!
Really amazing.. I was stuck on same thing since last 36 hrs. Thanks a lot.
Thank you for this lesson! I was wondering what's going on with users in Oracle, but you helped me to understand
u saved me from never ending frustration thank u
Chitu it is very help for me and my friends tq sm
One of the best tutorial video for SQL Developer connection. Thanks a lot!
How to connect oracle without a server..any virtual connection method available??
thank you so much mate yhis has been wrecking my head for days!!! way better tutorial than my collage notes
THE USERNAMEEEEE!!!!!!!!!!!!! I thought i was supposed to use the username i created when installing oracle 12c. So you're supposed to use "system" instead. This literally took me 5 days before looking up this video.
everyone just download the express version than download the SQL developer . after that create new database connection in which enter the pass when u install the express edition and username will be system.(this is for the new versions)
alter session set "_ORACLE_SCRIPT"=true;
run this if you cannot create a user due to error ORA-65096.
thank you so much
Gettting this error when connecting with user-name 'system':
ORA12543: TNS: destination host unreachable.
Could someone please help !
you need change your laptop
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection. can you fixed it?
U need to set the user name to anonymous
@@rohanpathakpathak3729 Does it really work? As I am getting same error
@@CoolDuderohitsrivastava i am also getting the same error how did you overcome from that error can you plz tell me its urgent
how did you overcome from that error can u tell me plz.
Same error no body care
hello ! please help me for this message (Status : Failure -Test failed : IO Error : The Network Adapter could not establish the connection) ?
+Ndiaye Tahar Most likely, Oracle Database is not running, and so SQL Developer cannot connect to it.
+Chitu Okoli now about this Services \ (Windows could not start the Oracle ORCL VSS Writer Service service on Local Computer).
Error 2 : The system cannot find the file specified.
+Ndiaye Tahar Sorry, I can't help you there. I've never seen that error message before.
+Chitu Okoli ok thanks you
+Ndiaye Tahar I'm getting the same error, have you solved this yet?
Failed to process SQL command
-
Error starting at line : 2 in command -
CREATE USER "JFAN" IDENTIFIED BY "ZJFN"
Error report -
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.
I'm new to this stuff and I don't know what any of this means.
before create user, execute this:
alter session set "_ORACLE_SCRIPT"=true;
why on the botom, i see a red star on ORACLE NOSQL CONNECTIONS? WHAT COULD BE THE ISSUE?
Chitu, this is incredibly helpful! Thanks.
I have done everything correct still getting errors.
STATUS : FAILURE - TEST FAILED: IO ERROR: THE NETWORK ADAPTER COULD NOT ESTABLISH THE CONNECTION.
Are you sure Oracle Database (not SQL Developer) is running? I typically see that error when Oracle is not running for whatever reason.
have you resolved the issue?? if yes..plzz help me
Hello Chitu,
I am watching your videos and I can say your explanations are very clear. Could help showing how to create a connection from excel with an oracle database. I have watched many videos but any shows step by step and show how this will work.
I am using Oracle developer, Oracle 11g XE db and Excel 2016.
Appreciated your help
I am getting IO error.and it says that network adaptor couldnot establish the connection.please reply as sson as possible
+Abhishek Kumar Usually I get this error if there is a problem with Oracle Database running. It is hard to explain in a RUclips comment (this is not not a tech support forum), but in brief, you have to make sure that Oracle Database is actually running before you actually start Oracle SQL Developer. Here are the steps you can follow:
1. Follow the steps described in this video: ruclips.net/video/zY1AUhAeFSI/видео.html
2. When you get to the services to enable, first make sure that Oracle SQL Developer is completely closed. Then enable first OracleServiceXE. Wait for it to start running. Then, after it has started running, enable second OracleXETNSListener, in that order. See this image to see which services to enable: snag.gy/vncSf.jpg
3. Wait 60 seconds. This is important, or else you might still have trouble.
4. Start Oracle SQL Developer and try to connect again.
I hope that works.
(Status : Failure -Test failed : Listener refued the connection with the following error: ORA-12505 TNS: listener does not currently know of SID given in connect decriptor) what should i do to this error
+Theo Rio Are you sure that Oracle Database is running? Perhaps Oracle Database is not running, and so SQL Developer cannot connect to it. If you're sure that Oracle Database is running, then close SQL Developer completely and then restart it after 30 seconds. I've seen this (or a similar) error when I started SQL Developer before Oracle Database was fully started.
+Theo Rio You can also refer to my response to Abhishek Kumar below for more details.
+Chitu Okoli Hi, I'm having the same error. Can you tell us how to run the database? thx
Hello I made a video solving that error: ruclips.net/video/UL2Nh-Cfans/видео.html
Hi Chitu,
I am following same steps as in your video.
But When I try to create new user , I am getting below error.
Error starting at line 2 in command:
CREATE USER abhi IDENTIFIED BY Oracle_1
Error at Command Line:2 Column:13
Error report:
SQL Error: ORA-65096: invalid common user or role name
Please help.
is the issue resolved for you? I am also facing the same issue.
while creating new user,I am getting invalid user or role name error. could you clarify me.
What is the user name you're trying to use? It might not be acceptable to Oracle. Try a different, simple name. Either one of these two situations might apply:
* You're using illegal characters (see docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm); or
* You might be trying to name it an existing user name or a reserved Oracle key word (e.g. "system").
However, without knowing what name is giving the error, it's hard to tell.
try putting 'C##' or c## in front of the username
thank you, this is absolutely what i need
Great tutorial and very helpful, I was able to connect without any issues.
Than you.. Alot.. Like from Sultan of OMAN
evrytime i creat user and put a user name and a password it show me error ??? why please help
+latifah mai It might be that you're using an illegal character (such as a space) in the user name or password. To help you, I need to know the exact user name and password that are giving the error, and I also need a screenshot of the error. You can send me this information through chitu.okoli.org/contact/, and I'll respond.
how can i create form using sql developer?
I don't understand what you mean by a "form" in the context of Oracle SQL Developer.
Its like the form that we create in microsoft access, where the viewer fill in their data. Do we have that such form in sql developer?
you can do that by using ORACLE forms. SQL developer is a tool allowing you to interact with database using SQL.
thank you Chitu, this is fantastic!
(Status : Failure -Test failed : IO Error : The Network Adapter could not establish the connection) what should i do to this error
+LAKHAN BHAGNANI Most likely, Oracle Database is not running, and so SQL Developer cannot connect to it.
best explanation ever
thank you very much ..i have been struggling with this for while now :)
Thank you!! How do you oing it from the cmd using TSNPING
I always get the error "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=XhNXjXvyR3yFbOs1JlwD5w==)" How to fix it?
Thx Dude very good video. I was able to connect without any problem
Hello, please help me to solved this issue
i do same steps shown in video but when i create new user(not system user) and click on connect after username and password i am facing an error -Test failed: ORA-01017: invalid username/password; logon denied.
hi! have you discovered any solutions?
how to find connection name,port,service name
Perfect intro ... thanks dude ...
thanks buddy for help connecting oracle
Are you going to do more tutorials on SQL Developer?
+Akhirah Strong I usually only make tutorials when 1) my students have a problem; 2) it needs a video to really explain the solution well and 2) I can't find any good tutorial on RUclips that helps them out adequately. Other than that, I don't have a master plan for a tutorial series, if that's what you mean. However, if you have a specific request, I'll consider it.
That said, you might want to check out Jeff Smith's website (www.thatjeffsmith.com) and RUclips videos
(ruclips.net/user/ThatJeffSmithvideos). He's a on the development team of Oracle SQL Developer, has lots of super-useful material already, and is incredibly responsive to questions people ask.
+Chitu Okoli Yeah that's what I meant. You are clear, calm, and concise. If you ever find the time to create a tutorial, there will be many happy beginners.
I wasn't asked for a password when downloading. Do you mean the password used to sign into oracle on the web?
Same here,did you find the answer??
thanks for the video its very helpful....but i'm having problem in connecting and saving new connection.....bt test always be success.....there is no error shown...how can this be solved????
when I click test button it gives error
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
what shall i do?
Please read the other comments below. This question has already been answered.
no matter what I am trying, msg with invalid common user or role name is coming and I am not able to create a new user
i couldn't connect, it says username/logon denied :(
when i create new connection using same username and password it copies existing connection data into new one connection..is it possible to create new connection with same username and password with no existing table data??
Yes, exactly: the video shows you how to create a new username. It is the new username that has an empty connection, not just a new connection.
Thanks man! This tutorial really helped me.
i installed oracle sql devoloper 3.2.2 ..but din't ask any password .....what can i enter username and password?
+bhagath reddy Go to 1:30 on the video to see how to create a connection; it should ask you for a password there.
After watching this video i successfully made a connection though i used sys instead of system in Username field
The password you used was your system password?
I never was required to install the Oracle Database after I downloaded the sql developer zip file at this link www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. How am I suppose to setup a system password if the password was never required to be generated after running the sqldeveloper.exe file ? Thanks for your help.
This video is only for the last step. The full steps are:
1. Install Oracle Database (that's when you set the system password)
2. Install SQL Developer
3. Configure the connections (that's what this video is about).
Full details can be found at chitu.okoli.org/bios/pro/teach/btm-382/install-oracle-for-btm-382/#how_to_install_oracle
Thanks, but what do I do with a "Test Failed: IO Error: Got minus one from a real call" after installing Oracle Enterprise in addition to Express version when running sql developer?
Sorry, no idea.
I installed it using the same link and it requires a username and password
Please read my response above to the comment.
Getting the following error:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Anyone have a solution?
That's a MySQL error message. Are you sure you're running Oracle?
I've installed Oracle express, could the problem be due to the fact that I have installed the version of SQL developer containing a JDK, meaning I have two JDKs. One for Eclipse and one for SQL developer?
No, generally having 2 or 5 or 10 JDKs is not a problem; they shouldn't interfere with each other.
Sorry, I don't know that error, but Google has some answers: www.google.fr/search?q=com.mysql.jdbc.exceptions.jdbc4.CommunicationsException%3A+Communications+link+failure&ie=utf-8&oe=utf-8&client=firefox-b-ab&gfe_rd=cr&ei=hwDdWKPDOtCN8Qez4KiwDg
i forget my oracle passward how i can set my new passward kindly help me
Nice tutorial thanks for sharing Chitu
Clean and direct! Thank you!
thank you so much you saved me from a big problem
Very clear, very interesting
I tried multiple times but while downloading I am not getting option to add password so unable to establish connection for the same.. Can anyone please help me on this
Same here what to do now??
STATUS : FAILURE - TEST FAILED: IO ERROR: THE NETWORK ADAPTER COULD NOT ESTABLISH THE CONNECTION..............getting this error
Oracle Database is probably not running. So, Oracle SQL Developer has nothing to connect to.
SO WHATS THE SOLUTION?
you've fixed it yet?
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=Ye3MDYQoRaeBXteymxIHnw==)
Super. very helpful. clearly guided.
Thanks.
the user name and password are the ones of my oracle account?
For the system user, the username is always "system" and the password is the password you created during Oracle installation. For the second user, the username and password are whatever you choose as shown in the video.
what do u do when it didn't ask you to install a username and password?
thank you it works
Phillis Shayi
I'm referring to the Oracle Database (not Oracle SQL Developer) installation. It always asks you for a password for the system user.
I forgot the default system password. How can I change it?
Only one solution: reinstall Oracle and remember the password this time. All existing user accounts will probably be lost.
Amazing tutorial. Thank you !
hI CHITU OKOLI i forgot the password than what to do now how to get back now? please help me with ths
There's only one thing you can do: reinstall Oracle Database and remember the password this time (you might need to uninstall it before reinstalling, but I'm not sure).
thank you for this useful tutorial =)
Thanks a lot, really helpful. Thumbs up!
Its really helpful.. Thank you so much
Tanks man!! Your video help me.
Thanks for this! Obviously because it's localhost, that database is only accessible using that PC, right? But do you know how I can make it accessible by any PC in the world? That would be great if you can help me answer that question :)
In the mean time I'll just search for the answer.
+Kingsleys Tech Channel You might want to look into a cloud database offering from Oracle or Amazon.
It never asked for a password when I was installing SQL dev
This video is only for the last step. The full steps are:
1. Install Oracle Database (that's when you set the system password)
2. Install SQL Developer
3. Configure the connections (that's what this video is about).
Full details can be found at chitu.okoli.org/bios/pro/teach/btm-382/install-oracle-for-btm-382/#how_to_install_oracle
great video.very clear steps.
just what I needed. Thank you!
Thx man, u save my life !!!!!!!
😜😜😜
Not working
Thank you very Much I have been trying connection for whole without success
thank you so much sir 🤗