|
|
|
|
|
Re: test failed: ORA-01017 invalid username / password access denied [message #679221 is a reply to message #679218] |
Sun, 16 February 2020 14:56 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
syed.javid.ali.ali@gmail. wrote on Sun, 16 February 2020 13:24if 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.
|
|
|