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, 5402🔥, 0💬
Popular Posts:
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...