This content has been marked as final. Show 5 replies
Passwords can never be recovered ... only changed.
So as SYSDBA ... change the password.
ALTER USER <username> IDENTIFIED BY <new_pwd>;
user6977020 wrote:What is "it" and what does "did not work" mean exactly?
i tried multiple ways as using / as sysdba and it didnot work .
If you want to help us to help you, post full error messages, the least.
i cannot access sql with sysdba besides after reinstalling oracle i cannot find the webshortcut interface of database
i mean by it : database and didnot work means : i cannot access database even to change password as sys.
Please in addition to your own words, post full copy-paste of command line sessions including actual error messages (e.g. cannot access database is not an actual error).
Try from a command window (cmd), assuming Windows platform:
sqlplus / as sysdba
If it says "Connected to idle instance.", try:
Did you just install XE or was it working before and now suddenly it doesn't? (what changed in the latter case?)
Edited by: orafad on Nov 24, 2012 7:52 PM