Forum Stats

  • 3,824,920 Users
  • 2,260,440 Discussions
  • 7,896,347 Comments

Discussions

i forgot database username and password ,how can i open it

Answers

  • User_C5K5U
    User_C5K5U Member Posts: 2 Green Ribbon

    i forgot database username and password ,how can i open it

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,816 Red Diamond

    Database and o/s versions?

    Basic answer: use a privileged o/s user (typically oracle on Linux), set the ORACLE_SID and ORACLE_HOME environment variables to the applicable values, and then use command sqlplus "/ as sysdba" to gain full system/dba access to the database.

    If a CDB with PDBs, select the applicable PDB.

    Reset password for the user with the ALTER USER command,