Connections generate intermittent "user account locked" on one node (two node RAC) or ORA-1017 or ORA-1033 with SQL*Plus to one node

(Doc ID 2337002.1)

Last updated on DECEMBER 27, 2017

Applies to:

Oracle Net Services - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Connections are intermittently working.
Work for all connections and then suddenly end with "account locked"
Local connection to the same DB does not show this user account is locked and access works.

Sometimes the connection may fail with ORA-1033 but the Database is mounted and open.

Listener services may show "additional" services or handlers

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms