Collections:
Reset Lost SYSTEM Password in Oracle
What To Do If DBA Lost the SYSTEM Password in Oracle?
✍: FYIcenter.com
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
2020-08-13, 1652🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...