validation error

    When I log to dbconsole for my databsase named 'company'  in my dbconsole in oracle 11g
I forgot my username and password.
I could conn / as sysdba through my command prompt.
Is there any way to retrive my username and password in order to access through dbconsole.
the error message is below.
 Host  mathew-b8f381b1

 Oracle Home  C:\app\Mathew\product\11.1.0\db_1
error message

   Validation Error
 ERROR: Invalid username and/or password
 

 
nobleitAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Not really.  Passwords are hashed when stored and there is no 'unhash'.

You can reset your password.

Alter user username identified by new_password;
0
 
nobleitAuthor Commented:
let me make sure  whatever I am going to do is right

set oracle_sid=company

sqlplus / nolog

conn / as sysdba

alter user sys identified by new_password;
"Because I am changing the sys user password"

Is that right..
0
 
sdstuberCommented:
yes,  use ALTER USER SYS  if you want to change SYS password

if you want to change some other user

ALTER USER SOMEOTHERUSER
0
 
slightwv (䄆 Netminder) Commented:
For what it's worth: as long as you connect 'as sysdba' the password doesn't matter and you cannot connect as SYS without connecting 'as sysdba'.
0
 
nobleitAuthor Commented:
As I told this user name and password has to be supplied in dbconsole for the same database when it is prompted..
0
All Courses

From novice to tech pro — start learning today.