Upgrade to LSH 2.2.3 - Post Install Throws Up ORA-28000: "The Account Is Locked" (Doc ID 2074919.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.2 and later
Information in this document applies to any platform.

Symptoms

LSH 2.2.2 upgraded to 2.2.3.

After applying the post install steps, there are some errors in OWB Log related to adapters deployment, and also in other logs, where it shows some database accounts are locked, although it does not indicate which accounts.

1) Per OWB log
2015/09/02-11:20:29-CDT [27A897A9][CDR_RTREPOS.CDR_RTREPOS] Attempting to create adapter 'class.Oracle Database.11.2.DDLDeployment'
2015/09/02-11:20:29-CDT [27A897A9][CDR_RTREPOS.CDR_RTREPOS] java.sql.SQLException: ORA-28000: the account is locked

2) Per Work Area install log:

Install workarea: INFORMATICA_ADPTR_WA
Error count : 2
Error message :
Exception :User-Defined Exception occured. Rolling back changes.
Adapter Workarea not installed:: NAME : WA_TEXT Header:/* $Header: cdrattxtsrvcs.txt 120.6.12000000.3 2014/05/23 18:06:51 jakrupa noship $*/
...

List of Adapters not Installed successfully:: STARTS
Adapter Workarea not installed:: NAME : INFORMATICA_ADPTR_WA Header:/* $Header: cdrinfadpb.txt 120.2.12000000.14 2014/10/23 18:37:56 jakrupa noship $*/
Adapter Workarea not installed:: NAME : WA_TEXT Header:/* $Header: cdrattxtsrvcs.txt 120.6.12000000.3 2014/05/23 18:06:51 jakrupa noship $*/
Adapter Workarea not installed:: NAME : WA_ORACLE_DATABASE Header:/* $Header: cdratorcldbsrvcb.txt 120.3.12000000.4 2014/05/19 04:09:34 ctankasa noship $*/
Adapter Workarea not installed:: NAME : WA_ORACLE_DATABASE Header:/* $Header: cdratorcldbb.txt 120.7.12000000.8 2014/05/19 04:03:28 ctankasa noship $*/
Adapter Workarea not installed:: NAME : ORACLE CLINICAL GLOBAL METADATA Header:/* $Header: cdratocgmetab.txt 120.2.12000000.2 2014/11/20 17:49:10 ctankasa noship $*/
Adapter Workarea not installed:: NAME : ORACLE CLINICAL LABS Header:/* $Header: cdratoclabb.txt 120.0.12000000.2 2014/11/27 07:35:19 ctankasa noship $*/
Adapter Workarea not installed:: NAME : ORACLE CLINICAL RANDOMIZATION Header:/* $Header: cdratocrandb.txt 120.0.12000000.2 2014/11/20 09:52:17 ctankasa noship $*/
Adapter Workarea not installed:: NAME : ORACLE CLINICAL GENERAL ADAPTER Header:/* $Header: cdratocgenb.txt 120.3.12000000.2 2014/11/20 07:24:08 ctankasa noship $*/
List of Adapters not Installed successfully:: ENDS
DELETE USER GROUPS , ROLES, USERS AND THERE ASSOCITIOATION WITH USER:: STARTS
User ID 1110
ROLE ID = 46501
USER GROUP ID =56601
USER COMPANY ID = 1021



Per  < NOTE 2024350.1> Oracle Life Sciences Data Hub 2.2.3 Release Notes ==> "4.2.1 Run Required Post-Installation Jobs" the steps to apply are as follows:

 

 

Changes

The OWBSYS_AUDIT, OWBSYS and CDR_RTREPOS accounts were NOT locked, that are the common ones where "ORA-28000: the account is locked" is displayed. Some of the CDR_W% accounts were the ones unexpectedly locked.

Cause

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