OraFAQ Forum

Today's Messages (on) | Unanswered Messages (off)

Forum: Security

Re: Unlocking Oracle 9i SYS user [message #689806 is a reply to message #266182]

Fri, 26 April 2024 09:06

dom606_user
Messages: 1
Registered: April 2024

Junior Member

Hi!

Unfortunately, my user "sys" is locked. Maybe you know the solution?

SQL> select account_status from dba_users where username = 'SYS';

ACCOUNT_STATUS
--------------------------------
LOCKED

conn as sysdba
Enter user-name: sys/manager@XE as sysdba
ERROR:
ORA-28000: The account is locked.

BR

Report message to a moderator

Re: Unlocking Oracle 9i SYS user [message #689808 is a reply to message #689806]

Fri, 26 April 2024 12:39

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

User SYS is NEVER locked even if it is in status LOCKED.

What is your Oracle version?

[Updated on: Fri, 26 April 2024 12:44]

Report message to a moderator

Current Time: Fri Apr 26 21:59:12 CDT 2024