How to Recover or Change Oracle Sysdba Password

How to recover or change Oracle sysdba password

Have you tried logging into Linux as your installed Oracle user then

sqlplus "/ as sysdba"

When you log in you'll be able to change your password.

alter user sys identified by <new password>;

Good luck :)

Oracle Database 12c - Change SYS Password

That's because you're authenticating as a user belonging to the dba group. Try going to the users groups and remove your user. When you authenticate as sysdba or sysoper, Oracle first validates if your user belongs to the dba group.

How to set sysdba password in Oracle 11G

Log on to your Windows server as a member of the Administrators group or a member of the ORA_DBA group.
Try the below steps

sqlplus /nolog
connect / as sysdba
Once connected, you can change the SYS password to something you know: 
ALTER USER sys IDENTIFIED BY new_password;

Default passwords of Oracle 11g?

It is possible to connect to the database without specifying a password. Once you've done that you can then reset the passwords. I'm assuming that you've installed the database on your machine; if not you'll first need to connect to the machine the database is running on.

1. Ensure your user account is a member of the dba group. How you do this depends on what OS you are running.

2. Enter sqlplus / as sysdba in a Command Prompt/shell/Terminal window as appropriate. This should log you in to the database as SYS.

3. Once you're logged in, you can then enter

   alter user SYS identified by "newpassword";
   

   to reset the SYS password, and similarly for SYSTEM.

(Note: I haven't tried any of this on Oracle 12c; I'm assuming they haven't changed things since Oracle 11g.)

Can you reset/retrieve a username/password used in schema creation of a desktop Oracle database?

Login as SYS (I suppose you are still able to do that) and then issue:

alter user <<schema>> identified by <<new_password>>;

ORA-28001: The password has expired

I have fixed the problem, just need to check:

open_mode from v$database

and then check:

check account_status to get mode information

and then use:

alter user myuser identified by mynewpassword account unlock;

---

Related Topics