Unable to connect as sysdba to the Oracle database

Unable to connect as sysdba to the Oracle database

Problem

Error when trying to connect the Oracle database as sysdba.
Getting ‘ORA-01017: invalid username/password: logon denied’

Solution

Go to E:\app\oracle\product\19.3.0\dbhome_1\network\admin folder

In sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NONE)
#SQLNET.AUTHENTICATION_SERVICES = (NTS)

Change to

SQLNET.AUTHENTICATION_SERVICES = (NTS)
#SQLNET.AUTHENTICATION_SERVICES = (NONE)

Start all services including Oracle.

Opened a cmd prompt and now you should be able to connect as

[oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 10 05:42:10 2024
Version 19.3.0.0.0

successfully Connected.