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:
Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
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
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 |
Cause |
Solution |
References |