This content has been marked as final. Show 5 replies
984629 wrote:Can you post an exact version number - the value returned from V$VERSION, assuming you have access?
I am a part time student / full time systems admin. Ive been working on an oracle assignment using application express and sql plus, verison 11g express.
Everything was going perfect until this evening when i tried to login as myself (user mcgrath)and i got the message ORA-01017 invalid username and password.
This account was perfect. I can login to application express with no problem with the same username. I even changed my password in applicatiion express and retried sql plus.
As i started to work on security i created a new workspace (user college) so i can work on grants and revokes. I can login to sql plus with this account no problem. somewhere along the way i must have blocked myself.
when i select username,account_status from dba_users it says user mcgrath is open.
You can log in using Apex but not SQL*PLUS even after changing the password.
Apex users/passwords mirror those in Oracle but do not duplicate them. Changing an Apex password through Apex should have no effect. If you have access to an Apex user with DBA privilege you can change the Oracle password of another account using the SQL tool.
Also, 11g database schema passwords are case senstitive.
If you have access to a DBA account log into it in SQL*PLUS and use it to change the password using ALTER USER whatever IDENTIFIED BY new_password. If you are not security-consious make the password for the name name in Apex and Oracle be the same so you don't have to remember 2 different passwords :)