HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Oracle 12c SYSTEM user locked out

Submitted by: @import:stackexchange-dba··
0
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 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:

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.