The following error messages are observed in event_log:
08/14/07 23:00 Error: 15033 - Failed to execute SQL on table : ORA-28003: password verification for the specified password failed. [sp_opst/19654]
08/14/07 23:00 Notice: Oracle error: ORA-28003: password verification for the specified password failed. rowid:N/A [sp_opst/19654]
08/14/07 23:00 Notice: ORA-28003: password verification for the specified password failed. [sp_opst(osp)/19654]
08/14/07 23:00 Error: OCI Error: ORA-28003: password verification for the specified password failed. [sp_opst/19654]
OR
The ora_setup fails with ORA-28003 as below:
Would you like to create a new SharePlex user ? [y] : y
Enter username for new user [SPLEX/SPLEX] : USERNAME
Enter password for new user :
Re-enter password for new user : PASSWORD
SQL> CREATE USER USERNAME IDENTIFIED BY PASSWORD
OCIStmtExecute: Oracle error ORA-28003: password verification for the specified password failed
ORA-20003: Password should contain at least one \
digit, one character and one punctuation
The password security policy is causing issues with Post or ora_setup.
First, one can try to create the user with the password as attempted by using a SQL*Plus session as:
SQL> CREATE USER USERNAME IDENTIFIED BY PASSWORD
If that fails, then the problem has to do with the password policy in force at customer site. The workaround is to either relax the password policy or to use a password so as to conform to the password policy of the company. Once that is done, the ora_setup can be re-run and it should succeed. Also, once it succeeds, then there should be no issues with Post. If the SQL*Plus session succeeded, then the issue needs to be investigated further.
Here is the description of Oracle error:
$ oerr ora 28003
28003, 00000, "password verification for the specified password failed"
// *Cause: The new password did not meet the necessary complexity
// specifications and the password_verify_function failed
// *Action: Enter a different password. Contact the DBA to know the rules for
// choosing the new password
//
