Adgendbc Fails With Database Connection Failure
(Doc ID 1302708.1)
Last updated on SEPTEMBER 01, 2024
Applies to:
Oracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Goal
How to overcome the following error when running Autoconfig following the movement of the database to a separate server?
....\admin\install\adgendbc.cmd
script returned:
****************************************************
ECHO is off.
ECHO is off.
adgendbc.cmd started at 08/03/2011 11:45
ECHO is off.
ECHO is off.
Enter the APPS Username/Password:
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Mar 8 11:45:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value : MASTER
Level Name: SITE
INFO : Updated/created profile option value.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
1 file(s) copied.
1 file(s) copied.
Unique constraint error (00001) is OK if key already exists
Creating the DBC file...
Enter username/password: java.sql.SQLRecoverableException: No more data to read from socket raised validating GUEST_USER_PWD
java.sql.SQLRecoverableException: No more data to read from socket raised getting GUEST_USER_PWD - ignoring
java.sql.SQLRecoverableException: No more data to read from socket- Database error performing ADD
ADD call failed with exit code 1
Updating Server Security Authentication
Enter username/password: java.sql.SQLException: 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.cmd exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.fnd.security.AdminAppServer.validateGuestUserPwd(AdminAppServer.java:2075)
at oracle.apps.fnd.security.AdminAppServer.setGuestUserPwdInDB(AdminAppServer.java:1943)
at oracle.apps.fnd.security.AdminAppServer.addServer(AdminAppServer.java:908)
at oracle.apps.fnd.security.AdminAppServer.execute(AdminAppServer.java:605)
at oracle.apps.fnd.security.AdminAppServer.main(AdminAppServer.java:2641)
Unable to update GUEST_USER_PWD in database to GUEST/ORACLE - java.sql.SQLRecoverableException: No more data to read from socket
script returned:
****************************************************
ECHO is off.
ECHO is off.
adgendbc.cmd started at 08/03/2011 11:45
ECHO is off.
ECHO is off.
Enter the APPS Username/Password:
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Mar 8 11:45:31 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value : MASTER
Level Name: SITE
INFO : Updated/created profile option value.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
1 file(s) copied.
1 file(s) copied.
Unique constraint error (00001) is OK if key already exists
Creating the DBC file...
Enter username/password: java.sql.SQLRecoverableException: No more data to read from socket raised validating GUEST_USER_PWD
java.sql.SQLRecoverableException: No more data to read from socket raised getting GUEST_USER_PWD - ignoring
java.sql.SQLRecoverableException: No more data to read from socket- Database error performing ADD
ADD call failed with exit code 1
Updating Server Security Authentication
Enter username/password: java.sql.SQLException: 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.cmd exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.fnd.security.AdminAppServer.validateGuestUserPwd(AdminAppServer.java:2075)
at oracle.apps.fnd.security.AdminAppServer.setGuestUserPwdInDB(AdminAppServer.java:1943)
at oracle.apps.fnd.security.AdminAppServer.addServer(AdminAppServer.java:908)
at oracle.apps.fnd.security.AdminAppServer.execute(AdminAppServer.java:605)
at oracle.apps.fnd.security.AdminAppServer.main(AdminAppServer.java:2641)
Unable to update GUEST_USER_PWD in database to GUEST/ORACLE - java.sql.SQLRecoverableException: No more data to read from socket
Solution
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
Goal |
Solution |
References |