Ask the Expert

Can no longer log into database as the sys user

I can no longer log into my database as the sys user. I am getting an ORA-01017 invalid username/password: logon denied error. The password has not changed. I logged in as SYSTEM and reset the password and still get the same error. I am logging in through Enterprise Manager (9i). I also tried through SQL*Plus with the same error. I am not able to perform maintenance because I cannot log in as a sysdba. Why would this happen?

    Requires Free Membership to View

It is possible that your password file is missing or corrupt. Try recreating the password file with the ORADIM utility. Specify the correct SYS password when running this utility.

This was first published in July 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: