patternMinor
Oracle 12c SYSTEM user locked out
Viewed 0 times
usersystem12clockedoracleout
Problem
We have a development Oracle 12c database and the SYSTEM user account is locked out for one of the SID's (works fine with another SID). When I try to do a
Any ideas on how to connect to the SID that has the locked SYSTEM account so I can unlock and reset the password?
Thanks.
conn SID / as sysdba it keeps connecting me to another SID that's idle. So I cannot even get to the SID that has the locked account.Any ideas on how to connect to the SID that has the locked SYSTEM account so I can unlock and reset the password?
Thanks.
Solution
Ok, figured it out with the comments from my original question. Steps I used to connect to the correct instance and get the account unlocked and password reset.
-
Connect to the correct SID/instance off the top. Example:
-
I then verified I was in the correct instance:
-
From there I was able to unlock the user and reset their password:
My problem intially was that I was just trying to connect using
Hopefully this will be helpful to other Oracle devs and rookie DBA's (I'm a rookie in this since we have a dev instance for some client work and it rarely gets touched).
-
Connect to the correct SID/instance off the top. Example:
c:\sqlplus SYSTEM/@ --> this can be found in the tnsnames.ora file-
I then verified I was in the correct instance:
SQL>select instance_name, status from v$instance;-
From there I was able to unlock the user and reset their password:
SQL>alter user account UNLOCK;SQL>alter user identified by ;My problem intially was that I was just trying to connect using
sqlplus / as sysdba and it wasn't putting me in the correct instance.Hopefully this will be helpful to other Oracle devs and rookie DBA's (I'm a rookie in this since we have a dev instance for some client work and it rarely gets touched).
Context
StackExchange Database Administrators Q#73411, answer score: 4
Revisions (0)
No revisions yet.