Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Intermittent ORA-01017 and ORA-28000 errors in RAC

user5298988Aug 5 2016 — edited Aug 9 2016

I have a program, HammerDB, driving a load on a series of Oracle RAC servers.

I am running Oracle 12c.

The first 14 users are able to log in fine.  After the 14th user, the 15th fails.  Then the 17th fails, followed by the 19th.  As the number of users is increased, all subsequent users fail to log in.  The error being returned is ORA-01017 or ORA-28000, invalid username/password; login denied or account is locked. 

At this point, any user that logs in to the RAC database gets the same error, including system/manager.  However, when I terminate the driver, all users can log in.  Also, during this time, I can always log in to each specific instance.  See below:

Able to log in to the instance:

[oracle@aps41-50 ~]$ export ORACLE_SID=orarac_4

[oracle@aps41-50 ~]$ unset TWO_TASK

[oracle@aps41-50 ~]$ sqlplus system/manager

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 5 16:11:35 2016

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

Last Successful login time: Fri Aug 05 2016 16:10:50 -05:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

SQL> quit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

[oracle@aps41-50 ~]$

Unable to log in to RAC:

[oracle@aps41-50 ~]$ unset TWO_TASK

[oracle@aps41-50 ~]$ export TWO_TASK=orarac

[oracle@aps41-50 ~]$ sqlplus system/manager

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 5 16:23:35 2016

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

ERROR:

ORA-28000: the account is locked

Enter user-name:

Kill off the driver and it works:

[oracle@aps41-50 ~]$ sqlplus system/manager

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 5 16:24:53 2016

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

Last Successful login time: Fri Aug 05 2016 16:22:49 -05:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

At the point where I get either the account is locked or invalid username/password error, no other user can log in.  This is not unique to system/manager.

So the question is, it's pretty obvious that I'm running out of some kind of resource.  Does anyone know what that resource might be?

Thank you for any help you can provide.

Regards,

BobA

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2016
Added on Aug 5 2016
8 comments
2,870 views