Home » RDBMS Server » Server Administration » SYS Account locked (Oracle 18c Windows 10)
SYS Account locked [message #683992] Tue, 16 March 2021 11:10 Go to next message
grh_oracle
Messages: 1
Registered: March 2021
Junior Member
I am unable to connect as sysdba as my sys account is locked.

C:\WINDOWS\system32>sqlplus/nolog

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 16 11:07:18 2021
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-28000: The account is locked.


I also tried the following;

C:\WINDOWS\system32>sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 16 10:50:58 2021
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied



My user ID is also included as an ORA_DBA;

GROUP INFORMATION
-----------------

Group Name Type SID Attributes
====================================
================
======================================== ===============================================================
Mandatory Label\High Mandatory Level Label S-1-16-12288
Everyone Well-known group S-1-1-0 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\docker-users Alias S-1-5-21-2520138108-4042964225-1434394849-1080 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\mqbrkrs Alias S-1-5-21-2520138108-4042964225-1434394849-1003 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\ORA_ASMDBA Alias S-1-5-21-2520138108-4042964225-1434394849-1020 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\ORA_DBA Alias S-1-5-21-2520138108-4042964225-1434394849-1001 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\ORA_OraDB18Home1_SYSBACKUP Alias S-1-5-21-2520138108-4042964225-1434394849-1017 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\ORA_OraDB18Home1_SYSDG Alias S-1-5-21-2520138108-4042964225-1434394849-1018 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\ORA_OraDB18Home1_SYSKM Alias S-1-5-21-2520138108-4042964225-1434394849-1019 Mandatory group, Enabled by default, Enabled group
LAPTOP-N4HBLCII\mqm Alias S-1-5-21-2520138108-4042964225-1434394849-1004 Mandatory group, Enabled by default, Enabled group
BUILTIN\Administrators Alias S-1-5-32-544 Mandatory group, Enabled by default, Enabled group, Group owner
BUILTIN\Users Alias S-1-5-32-545 Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\INTERACTIVE Well-known group S-1-5-4 Mandatory group, Enabled by default, Enabled group
CONSOLE LOGON Well-known group S-1-2-1 Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\Authenticated Users Well-known group S-1-5-11 Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\This Organization Well-known group S-1-5-15 Mandatory group, Enabled by default, Enabled group
LOCAL Well-known group S-1-2-0 Mandatory group, Enabled by default, Enabled group
NT AUTHORITY\Cloud Account Authentication Well-known group S-1-5-64-36 Mandatory group, Enabled by default, Enabled group

Would appreciate some help
Re: SYS Account locked [message #683993 is a reply to message #683992] Tue, 16 March 2021 12:30 Go to previous message
Michel Cadot
Messages: 67844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Be sure your sqlnet.ora file contains the following line:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Previous Topic: Transactions are failing due to insufficient space in the undo tablespace
Next Topic: audit use of dynamic sql
Goto Forum:
  


Current Time: Mon May 10 14:14:57 CDT 2021