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