My Oracle Support Banner

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

Last updated on MAY 17, 2018

Applies to:

Primavera Analytics - Version 17.7 and later
Primavera Data Warehouse - Version 17.7 and later
Information in this document applies to any platform.

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.

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.