Adgendbc.sh fails during Autoconfig: "ORA-01422: exact fetch returns more than requested number of rows, ORA-06512: at APPS.FND_APP_SEVER_PKG" (Doc ID 356397.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

From the "adconfig.log":

. . .

SQL*Plus: Release 8.0.6.0.0 - Production on Tue Jan 31 11:08:14 2006
   
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
   
Connected.
   
Params=fnd_jdbc_stmt_cache_free_mem=TRUE
fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=false
fnd_jdbc_plsql_reset=false
   
Unique constraint error (00001) is OK if key already exists
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 106
ORA-06512: at line 1 - Database error modifying the server
   
ADD call failed with exit code 1

[...]

Updating parameters:  fnd_jdbc_context_check=false fnd_jdbc_plsql_reset=false
DBC argument specified, ignoring SECURE_PATH
DBC generation failed with exit code 1
   
Updating Server Security Authentication
java.sql.SQLException: Io exception: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
   
[AutoConfig Error Report]
   
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: <$COMMON_TOP>/admin/install/<SID>_<HOSTNAME>
          adgendbc.sh             INSTE8_SETUP       1
   
AutoConfig is exiting with status 1

...

Cause

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