Home » SQL & PL/SQL » SQL & PL/SQL » test failed: ORA-01017 invalid username / password access denied
test failed: ORA-01017 invalid username / password access denied [message #679212] Sun, 16 February 2020 11:00 Go to next message
syed.javid.ali.ali@gmail.
Messages: 10
Registered: February 2020
Junior Member
Iam trying to connect to a database from sql developer tool. but it is showing error like as below.

"test failed: ORA-01017 invalid username / password access denied".
Can anyone help me on this
Re: test failed: ORA-01017 invalid username / password access denied [message #679216 is a reply to message #679212] Sun, 16 February 2020 11:30 Go to previous messageGo to next message
John Watson
Messages: 8323
Registered: January 2010
Location: Global Village
Senior Member
That is not an error, it is success. An ora-01017 means that SQL*Dev got all the way through to establishing a session against the database. The logon failure is because to complete the test it presents some default credentials that do not exist on your database.
Re: test failed: ORA-01017 invalid username / password access denied [message #679217 is a reply to message #679212] Sun, 16 February 2020 11:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67303
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
-01017 invalid username / password access denied

As it says...

Re: test failed: ORA-01017 invalid username / password access denied [message #679218 is a reply to message #679217] Sun, 16 February 2020 13:24 Go to previous messageGo to next message
syed.javid.ali.ali@gmail.
Messages: 10
Registered: February 2020
Junior Member
if i forgot username or password where do i go and check..is there any option to check
Re: test failed: ORA-01017 invalid username / password access denied [message #679219 is a reply to message #679218] Sun, 16 February 2020 14:14 Go to previous messageGo to next message
Michel Cadot
Messages: 67303
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You need to be able to connect anyway to know the user names.
You can't check the password but trying to connect.

Re: test failed: ORA-01017 invalid username / password access denied [message #679221 is a reply to message #679218] Sun, 16 February 2020 14:56 Go to previous message
EdStevens
Messages: 1233
Registered: September 2013
Senior Member
syed.javid.ali.ali@gmail. wrote on Sun, 16 February 2020 13:24
if i forgot username or password where do i go and check..is there any option to check
Did you create the database? And didn't think it important to make a note of any usernames and passwords that were created or configured in the process?

Get a command line on the server running the database, connected to that server as the owner of the Oracle installation, or any other member of the OS group 'dba'.
At that command line, enter 'sqlplus / as sysdba'. That will connect you to the database. Then, at the SQL prompt, enter:

select username from dba_users order by username;

That will give you all of the usernames available. There is no way to retrieve the password. If there were, it wouldn't be very secure, would it?

Looking at your recent posting history (how to install SQL Dev? How to connect from SQL Dev to a database? Now this) Perhaps it would be helpful if you explained what you've been doing, what was your starting point, where you are now, and a bit about your technical background that prepared you for this exercise.
Previous Topic: ORA-02085 database link AZZRE.CG44.FR connects to GZWR2.ZZ44.FR
Next Topic: AS_XLSX. how to set worksheet name
Goto Forum:
  


Current Time: Thu Aug 13 13:18:43 CDT 2020