How do I configure the Oracle database user lockout threshold?
Purpose
As a security precaution, you can configure the number of consecutive Oracle database user login failures that are tolerated before the user account is locked.
Note: In a redundant deployment, you perform the procedure on the primary database station. After you perform the procedure, the primary database automatically copies the configuration change to the standby database.
The configuration change that you make in this procedure is not affected by a subsequent database upgrade.
Steps
1
Log in to the main database station as the Oracle management user or the NSP admin user.
Note: The Oracle management user name is specified during database installation; the default is ‘oracle’.
2
Open a console window.
3
Enter the following:
Note: If you are logged in as the NSP admin user, you must use sudo to run the command in this step as shown in the following: