How to change lost password or oracle sys account
book
Article ID: 196063
calendar_today
Updated On:
Products
Data Loss Prevention Endpoint Prevent
Issue/Introduction
Unable to run oracle_create_user.sql due to the sys accounts password is unknown
Environment
Release : oracle 12c, oracle 19c
Component : Windows
Resolution
- Edit the sqlnet.ora located at %ORACLE_HOME%\network\admin\

- change the sqlnet.authentication_services = (NTS)
- add the logged in user to the local group ora_dba

- launch command prompt
- run command sqlplus /nolog
- run command conn / as sysdba;
- alter user sys identified by [new password];

Feedback
thumb_up
Yes
thumb_down
No