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 SEPTEMBER 16, 2022
Applies to:
Oracle REST Data Services - Version 19.1 to 19.1Information in this document applies to any platform.
Symptoms
---------------------
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 |