Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Hi everyone, I installed oracle 11g Database server in windows 2003 server. I changed the password. It works very well when I start at first. After restarting, the password is not at all working. Please do guide me to settle the issue.

Thanks a lot in advance.

Regards, H. Noordeen

share|improve this question

migrated from stackoverflow.com Jan 3 at 10:26

This question came from our site for professional and enthusiast programmers.

1  
Please be aware that in Oracle 11G passwords are case sensitive. –  Rene Jan 3 at 9:40
    
Yes but only if you enable it by Oracle Parameter sec_case_sensitive_logon –  Wernfried Jan 3 at 10:04
    
"Rolls back" or "not at all working"? Which is it? –  kubanczyk Feb 3 at 6:59

1 Answer 1

If you have used special character like "@" in your password, then try to log in by providing your password within double quotes

e.g. -

c:> SQLPLUS username/"pass@word"@database

Then you can set new password using

alter user <username> identified by <new_password>;

You can change using this command through Admin log in as well.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.