'Verifying LAAM_DATABASE_INSTANCES for existing seed...ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows' Error While Installing Preventive Controls Governor (PCG) (Doc ID 1472001.1)

Last updated on FEBRUARY 03, 2016

Applies to:

Oracle Preventive Controls Governor - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

Upgrading Prod from PCG 7.3.2 to 7.3.3 using 7.3.3 install files shows following error in the DB logs.


Error
----------

UTL_DIR not set in gv$parameter !!
LA_BR_CONFIGURATIONS already has data...
It is NOT a Lite installation..
Verifying LAAM_MACHINES for existing seed...
Machine name already exists in LAAM_MACHINES.
Verifying LAAM_DATABASE_INSTANCES for existing seed...
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 110

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