Error: "ORA-28000: The Account Is Locked" After Changing The Data Warehouse Schema (by Default, STARUSER) Password (Doc ID 2399969.1)

Last updated on JULY 17, 2023

Applies to:

Symptoms

Using Primavera Data Warehouse, when attempting to execute an ETL after changing the Data Warehouse Schema password, the following error occurs:

ERROR
-----------------------
TIMESTAMP [main] INFO ETL.Message - Connecting to database...
TIMESTAMP [main] WARN ETL.Message - Exception creating connection (1017, java.sql.SQLException: ORA-01017: invalid username/password; logon denied)
TIMESTAMP [main] INFO ETL.Message - Waiting for 10 seconds and make 10 more attempts to connect
TIMESTAMP [main] INFO ETL.Message - Done sleeping, about to retry connecting

TIMESTAMP [main] INFO ETL.Message - Connecting to database...
TIMESTAMP [main] WARN ETL.Message - Exception creating connection (1017, java.sql.SQLException: ORA-01017: invalid username/password; logon denied)
TIMESTAMP [main] INFO ETL.Message - Waiting for 10 seconds and make 10 more attempts to connect
TIMESTAMP [main] INFO ETL.Message - Done sleeping, about to retry connecting

TIMESTAMP [main] INFO ETL.Message - Connecting to database...
TIMESTAMP [main] WARN ETL.Message - Exception creating connection (28000, java.sql.SQLException: ORA-28000: the account is locked)
TIMESTAMP [main] INFO ETL.Message - Waiting for 10 seconds and make 10 more attempts to connect
TIMESTAMP [main] INFO ETL.Message - Done sleeping, about to retry connecting

TIMESTAMP [main] INFO ETL.Message - Connecting to database...
TIMESTAMP [main] WARN ETL.Message - Exception creating connection (28000, java.sql.SQLException: ORA-28000: the account is locked)
TIMESTAMP [main] INFO ETL.Message - Waiting for 10 seconds and make 10 more attempts to connect
TIMESTAMP [main] INFO ETL.Message - Done sleeping, about to retry connecting

TIMESTAMP [main] INFO ETL.Message - Connecting to database...
TIMESTAMP [main] WARN ETL.Message - Exception creating connection (28000, java.sql.SQLException: ORA-28000: the account is locked)



Using Primavera Analytics hosted within OBIEE, attempting to load a dashboard or analysis results in the following error:

ERROR
-----------------------
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 28000, message: ORA-28000: the account is locked at OCI call OCISessionBegin. (HY000)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Adjust the Data Warehouse schema password within the Oracle DB.
2. Attempt to execute a Data Warehouse ETL
3. Note the error which occurs
4. Login to OBIEE configured for Primavera Analytics
5. Attempt to execute a dashboard or anlaysis
6. Note the error which occurs.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.