Create new connection with new user in Oracle SQL Developer
HTML-код
- Опубликовано: 8 сен 2024
- This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
I've been stuck for hours looking for an answer thank you so much I was finally able to create a connection
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!!!
I actually spent so many hours looking for answers to no avail until I watched your video. Thak you very much!
After 2 yrs of trying you solved my problem...you re a star!
if anyone is having the error ORA-01017 even with all correct credentials, try replacing the username characters by uppercase characters only.
Please create more videos like this!!! I've been going through stacks of videos and this is the simplest explanation yet. Really awesome.
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.
Thanks a lot for that comment
After viewed all details in video I was resolved problem. Thank you!
finally someone on youtube talks about users and all the dynamic tables that are there. Thank you
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.
thanq was stuck on something else but your video proved extremely helpful thanq 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.
Chitu it is very help for me and my friends tq sm
I don't know how to thank you for such a helpful video, love the clean connection.
100 like ... finally i found the right working solution for my ORA-01017 error !!!
Thank you very much 🌺🌺🌺
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.
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!
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
You will be mentioned in my night prayers for this video! :)
u saved me from never ending frustration thank u
Thank you for this lesson! I was wondering what's going on with users in Oracle, but you helped me to understand
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.
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.
Great tutorial and very helpful, I was able to connect without any issues.
One of the best tutorial video for SQL Developer connection. Thanks a lot!
Nice tutorial thanks for sharing Chitu
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..
thank you so much mate yhis has been wrecking my head for days!!! way better tutorial than my collage notes
Very clear, very interesting
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
best explanation ever
Chitu, this is incredibly helpful! Thanks.
Than you.. Alot.. Like from Sultan of OMAN
Perfect intro ... thanks dude ...
thank you Chitu, this is fantastic!
thank you, this is absolutely what i need
Thx Dude very good video. I was able to connect without any problem
Super. very helpful. clearly guided.
Thanks.
Thank you sir
thanks buddy for help connecting oracle
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!
thank you for this useful tutorial =)
thank you very much ..i have been struggling with this for while now :)
very informative and awesome, thank you
Thank you very Much I have been trying connection for whole without success
thank you so much sir 🤗
Its really helpful.. Thank you so much
Thanks. It works
thank you so much you saved me from a big problem
this video very helpful Thank you
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?
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)
Amazing tutorial. Thank you !
Thanks a lot, really helpful. Thumbs up!
How to connect oracle without a server..any virtual connection method available??
Thanks a lot, helped me out.
Thanks man! This tutorial really helped me.
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.
jigari xar dzma
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
Clean and direct! Thank you!
Thank you sir!
thankyou for the tutorial :)
Tanks man!! Your video help me.
why on the botom, i see a red star on ORACLE NOSQL CONNECTIONS? WHAT COULD BE THE ISSUE?
Getting error : Faliure - Test failed : IO Error : The Network Adapter could not establish the connection.. Please help let me know what to do
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;
Thank you very much!!!
excellent tutorial, greetings
Thank you very much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks a lot. It helped. Hope you buy a better mic for your future videos sir!
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.
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
Thx man, u save my life !!!!!!!
😜😜😜
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????
Thank you so very much
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.
Thank you!! How do you oing it from the cmd using TSNPING
just what I needed. Thank you!
thanks bro
thanks a lot
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
Thanks man .. really amazing
Thank you soo muchh brooo
how to find connection name,port,service name
Nice job
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.
Great HELP
(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
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
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
Thank u Sir 🤗
Thank you! :)
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?
I just download a zip file and I unzipped it.i did not get any option to enter password and username.Please Help
sujit gupta The login information comes from the Oracle Database that you are connecting to, not from Oracle SQL Developer itself. So, you must first install Oracle Database. During the Oracle Database installation procedure, you will be asked to enter a password for the default user account, whose login ID is "system".
Sir Please please give me a link to download Oracle database..
sujit gupta All instructions and links are available here: chitu.okoli.org/bios/pro/teach/btm-382/install-oracle-for-btm-382/.
Please note that you won't have access to the password-protected links for my students, but just follow the public links for Oracle. You will need to create a free Oracle account to download their software.