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 :)
Make sure you connect to same database instance (XE) and remember that 11G passwords are by default case sensitive.1 person found this helpful
I used select version from V$instance in sqlplus and it returned 126.96.36.199.0.
i can connect by using connect mcgrath /as sysdba
and use my known password. but i cannot connect as mcgrath/password.
i will try you alter suggestion also.
Alter user worked... Many thanks
I dont know how i broke it though
Back to assignments now .. I appreciate the quick response.