Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

getting DBD::Oracle::st execute failed: ORA-01422: exact fetch returns more than requested number of

Hi,

I was applying the DBRU patch 32524155 on a standalone Oracle 18C database server which is running on RHEL 7. The "opatch apply" was successful. But when I try to run the "datapatch -verbose" , I am getting the following error :


DBD::Oracle::st execute failed: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "SYS.DBMS_SQLPATCH", line 567

ORA-06512: at line 21 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE

rec dba_registry_sqlpatch%ROWTYPE;

BEGIN

rec.patch_id := :patch_id;

rec.patch_uid := :patch_uid;

rec.patch_type := :patch_type;

rec.action := :action;

rec.description := :description;

rec.flags := :flags;

rec.patch_descriptor := :patch_descriptor;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center