Home » RDBMS Server » Security » forget sys and system password
forget sys and system password [message #158222] Thu, 09 February 2006 04:27 Go to next message
Messages: 155
Registered: May 2005
Location: Giza
Senior Member
dear all
i'd like to ask
if i forgot sys and system password could i get it again or login to database anyway

there was file
orapwd file=$HOME/ADMIN/PFILE/orapw$ORACLE_SID
but in oracle 10g i didn't found it is it changed

if any one know where to find this file or how to slove this problem plz replay
Re: forget sys and system password [message #158491 is a reply to message #158222] Sun, 12 February 2006 01:44 Go to previous message
Frank Naude
Messages: 4575
Registered: April 1998
Senior Member
Use the "orapwd" utility to create a new password file with a new SYS password.

$ orapwd
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n>

    file - name of password file (mand),
    password - password for SYS (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
    force - whether to overwrite existing file (opt),
  There are no spaces around the equal-to (=) character.
Previous Topic: OS_ROLES and SYSTEM users
Next Topic: Oracle DBMS – Critical Access Control Bypass in Login Bug
Goto Forum:

Current Time: Tue Oct 03 08:38:10 CDT 2023