Invalid User Name (ORA-01017) [message #673504] |
Wed, 21 November 2018 12:14 |
|
Raul_Rodriguez
Messages: 6 Registered: November 2018
|
Junior Member |
|
|
Hello, I have created a new user while logged in as SYSTEM. This is a new installation and this my first try at creating a user. I followed the instructions from this link: "oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/appdev/sqldev/sqldev_adv/sqldev_adv_otn"
I have assigned the following privileges as suggested on the guide:
CREATE PROCEDURE;CREATE SEQUENCE;CREATE SESSION;CREATE TABLE;CREATE TRIGGER;CREATE TYPE;CREATE VIEW;UNLIMITED TABLESPACE.
The user shows up (after creating it on the "Other Users" Tree), but when I create the new connection using this newly created id, I get the error:
Invalid User Name (ORA-01017); I have reset the password a few times but it doesn't work.
Based on the instructions I don't see what am I doing wrong.
Please help
Note: the forum won't allow me to post a link yet, this is my first posting.
Thanks,
RR
|
|
|
|
Re: Invalid User Name (ORA-01017) [message #673506 is a reply to message #673505] |
Wed, 21 November 2018 14:30 |
|
Raul_Rodriguez
Messages: 6 Registered: November 2018
|
Junior Member |
|
|
Your post takes me to an invalid link... Let see if I can show the link nowhttps://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/appdev/sqldev/sqldev_adv/sqldev_adv_otn.htm
Now, while I am an Intermediate user in the field, I know that in order to make sure my password is correct, I create a simple text file, which I use as a pivot to copy and paste my password in both boxes(Pwd and Confirm). This ensures I know what my password is. Anyhow, I also tried creating a second user name, but the results are the same...
I know is not a user id pwd issue, there has to be something else, as I mentioned the user ID I am using to create this new user is SYSTEM, must of the applications I use require an ADMIN ID, identified as Admin...
Is there anything else that anyone can contribute?
Thanks,
RR
|
|
|
|
|
Re: Invalid User Name (ORA-01017) [message #673510 is a reply to message #673509] |
Wed, 21 November 2018 15:27 |
|
Raul_Rodriguez
Messages: 6 Registered: November 2018
|
Junior Member |
|
|
In order to save us the time of me retyping and make this post unreadable I have placed the shortcut to the Oracle Guide. In there it has depiction of the steps, which is exactly what I have done. However, in order to make sure you don't think I am not following instructions I will describe what I see on my screen. I have a window named Edit User which is obtained by right clicking on the "test" user name, in the tab System Privileges, I see check marks on the boxes I listed before (create sequence, create session, etc.) these check marks are under the column labeled Granted just like in the depiction presented in the Guide. Funny thing is: the password is test and the user is test, I know this is done to make it as simple as possible and I could not agree more with the approach. I also know how to use the Code tags, however, no code is necessary when using the interface (Checking the boxes)
Is there anything else I may try or that could be creating the issue.
RR
|
|
|
|
|
|
Re: Invalid User Name (ORA-01017) [message #673525 is a reply to message #673523] |
Thu, 22 November 2018 08:37 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
The point Michel was making before is that you've made the username case sensitive.
In oracle by default all object names (including user names) are translated to upper case and stored in the data dictionary in that form. No matter how you write it in code.
The exception to that rule is if you wrap the object name in double quotes when you create the object.
In that case it is stored in the data dictionary in whatever case it was entered in.
Then to refer to the object you need to write the name in the same case every time and wrap it in double quotes:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
SQL> create user "test" identified by test;
User created.
SQL> grant connect to test;
grant connect to test
*
ERROR at line 1:
ORA-01917: user or role 'TEST' does not exist
SQL> grant connect to "test";
Grant succeeded.
SQL> connect test/test;
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> connect "test"/test
Connected.
SQL>
You can tell that's what has happened here since in your screenshot of usernames test is in lower case.
I suggest you drop the user and recreate it so it isn't case sensitive.
|
|
|
|
|
Re: Invalid User Name (ORA-01017) [message #673528 is a reply to message #673522] |
Thu, 22 November 2018 09:49 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Apart creating your user with a lower case name, there is another thing you must never do:
Quote:Last thing I used... '#The following line allows the creation of users without the C## prefix in Oracle SQL Developer
alter session set "_ORACLE_SCRIPT"=true; This implies that you are working in the root container of a multitenant database. No, no, no! You should be working in a pluggable container, not the root container. The tutorial you are following is not intended to run against a 12.x database, but against an 11.x database. Back in release 11, multitenant did not exist.
|
|
|
|
|
Re: Invalid User Name (ORA-01017) [message #673542 is a reply to message #673533] |
Fri, 23 November 2018 02:47 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
Raul_Rodriguez wrote on Thu, 22 November 2018 17:55I followed the Oracle provided instructions were they showed everything in lower case, that was my biggest mistake.
I understand and appreciate everyone's input, I have dropped the user and re-created it in all CAPS.
Don't use double-quotes (") then you don't have to worry about case with Oracle objects.
|
|
|
Re: Invalid User Name (ORA-01017) [message #673548 is a reply to message #673533] |
Fri, 23 November 2018 07:05 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
Raul_Rodriguez wrote on Thu, 22 November 2018 11:55I followed the Oracle provided instructions were they showed everything in lower case, that was my biggest mistake.
I understand and appreciate everyone's input, I have dropped the user and re-created it in all CAPS . By the way @BlackSwan I was not ignoring your suggestion; the explanation provided by @cookiemonster is very clear and I have now successfully created a new connection.
Thank you again
RR
The "Oracle provided instructions" (whatever and wherever they are, since you didn't bother to cite them) may have shown in lower case, but I'm as certain as I can be (without being able to see the un-cited source) that they did not wrap it in double quotes.
SQL> select username from dba_users
2 where upper(username) like 'FUB%'
3 order by username
4 ;
no rows selected
SQL> create user fubar identified by fubar;
User created.
SQL> select username from dba_users
2 where upper(username) like 'FUB%'
3 order by username
4 ;
USERNAME
------------------------------
FUBAR
1 row selected.
SQL> create user "fubar" identified by fubar;
User created.
SQL> select username from dba_users
2 where upper(username) like 'FUB%'
3 order by username
4 ;
USERNAME
------------------------------
FUBAR
fubar
2 rows selected.
SQL> create user "FUBAR" identified by fubar;
create user "FUBAR" identified by fubar
*
ERROR at line 1:
ORA-01920: user name 'FUBAR' conflicts with another user or role name
SQL> select username from dba_users
2 where upper(username) like 'FUB%'
3 order by username
4 ;
USERNAME
------------------------------
FUBAR
fubar
2 rows selected.
SQL> spo off
|
|
|