Hi, I need some help, look I changed the passwords for the users SYSTEM, SYS and ADMIN, and now I forgot them, so I can't do anything as administrator of the DB.... I know this sounds creepy but my mind had a little lose of data If anyone knows how to recover those passwords or how to make new ones please tell me.

Thanks

you do not state your version.

However, make a new passwordfile would work.


otherwise, connect at command-line of the host through telnet or at the terminal (not through a client) and use:

sqlplus anyuser/password@sid

SQL*Plus: Release 9.2.0.2.0 - Production on Thu Jul 10 10:50:14 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning and OLAP options
JServer Release 9.2.0.2.0 - Production

sid:username> connect / as sysdba
Connected.
sid:username> show user
USER is "SYS"