My Oracle Support Banner

ORA-01422: exact fetch returns more than requested number of rows when Trying to Install ORDS 19.1 (Doc ID 2729073.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle REST Data Services - Version 19.1 to 19.1
Information in this document applies to any platform.

Symptoms

Note:Values and PATH location for various variables such as below has been used for Demonstration Purpose only.

  

---------------------
ORDS 19.1
Database 12.2.0.1.0
Solaris SPARC 11.3 64-bit

Problem
-----------
While installing ORDS, I get the following error:

/u01/app/oracle/product/12.2.0.1/dbhome/jdk/bin/java -jar ords.war install advanced

[...]

Installing Oracle REST Data Services version 19.1.0.r0921545
... Log file written to /export/home/oracle/ords_install_core_2020-11-16_134440_00837.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
Nov 16, 2020 1:44:48 PM oracle.dbtools.installer.InstallerBase processNonCDB
SEVERE: Error executing script: ords_grant_privs.sql Error: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 61

Refer to log file /export/home/oracle/ords_install_core_2020-11-16_134440_00837.log for details

Log file:

ERROR
-----------
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 61
01422. 00000 -  "exact fetch returns more than requested number of rows"
*Cause:    The number specified in exact fetch is less than the rows returned.
*Action:   Rewrite the query or change number of rows requested

Changes

 Trying to install ORDS 19.1.

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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