OHMPI 3.0 Run-initial-bulk-loader Prompts For DB Password And Locks Account (ORA-1017) (Doc ID 2079081.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Master Person Index - Version 3.0 and later
Information in this document applies to any platform.

Goal

OHMPI 3.0 against DB 11g R2.

All tables are created in 11gR2 database with SEC_CASE_SENSITIVE_LOGON=TRUE

When running the bat file it prompts for a database password.
The CORRECT password is entered, and it doesn't take it (The password does work OK in other tools).

It will prompt again for the password until eventually locks the Oracle account.

Executing the initial load: ./run-loader.sh

Nov 13, 2015 4:34:24 AM net.java.hulp.i18n.Logger severe
SEVERE: Fri Nov 13 04:34:24 PST 2015 - Progress: ORA-01017: invalid username/password; logon denied
Exception in thread "main" java.lang.ExceptionInInitializerError
Caused by: java.lang.NullPointerException
     at com.sun.mdm.index.loader.util.Logger.progressDB(Logger.java:378)
     at com.sun.mdm.index.loader.util.Logger.severe(Logger.java:156)

 

STEPS TO REPRODUCE
1. Change SEC_CASE_SENSITIVE_LOGON parameter to ‘TRUE’
3. Change project’s database user password to something with upper and lower case.
4. Execute the initial load: ./ run-loader.sh
The error is displayed as:

Nov 13, 2015 4:34:24 AM net.java.hulp.i18n.Logger severe
SEVERE: Fri Nov 13 04:34:24 PST 2015 - Progress: ORA-01017: invalid username/password; logon denied
Exception in thread "main" java.lang.ExceptionInInitializerError
...

5. Test via sqlplus. It fails now with the same error:

ERROR: ORA-01017: invalid username/password; logon denied

Solution

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