General MySQL Oracle SQL Server

Reset Lost SYSTEM Password in Oracle

Q

What To Do If DBA Lost the SYSTEM Password in Oracle?

✍: FYIcenter.com

A

If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to gain access to the database. The tutorial exercise below shows you how:

(Terminal server to the Oracle server machine)
(Start SQL*Plus)
SQL>CONNECT / AS SYSDBA
Connected.

SQL> ALTER USER SYSTEM IDENTIFIED BY ssap_iyf;
User altered.

Notice that the (/) in the CONNECT command tells SQL*Plus to use the current user on local operating system as the connection authentication method.

 

⇒ Types of Commands Executed in SQL*Plus in Oracle

⇐ Error: Could not Resolve the Connect Identifier in Oracle

⇑ Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-08-13, 5108🔥, 0💬

General MySQL Oracle SQL Server