Q

"Invalid username/password" error

I have installed Oracle 9.2 on Windows 2003 Server. I created a single database, and I am having a problem with the 'SYSTEM' and 'SYS' user password. At the time of installation I changed the password and then tried to connect with SQL. It worked fine but after a while it didn't and I got an error.

I have installed Oracle 9.2 on Windows 2003 Server. I created a single database, and I am having a problem with the 'SYSTEM' and 'SYS' user password. At the time of installation I changed the password and then tried to connect with SQL. It worked fine but after a while it didn't and I got the following error:
ORA-01017: invalid username/password; logon denied
While in EMC when I try to connect as sysdba I do connect. Then I usually change the password so both users connect, but again after some time they don't and I have the same problem. Other users connect successfully. Please help.
Oracle does not just change the password on its own. If you were able to connect successfully with a userid/password combination and later that same userid/password combination receives the ORA-1017 error, then that combination is no longer correct. This means that someone has changed the password on you.
This was first published in November 2005

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close