Trigger Oracle RAC

Document ID : KB000089361
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Trigger Oracle RAC
Resolution:
Detailed Description and Symptoms
There is a known problem with updating the trigger for an Oracle Applications Agent when the database for Oracle Applications is setup to use a RAC login

Errors:

ErrorMsg: AwE-5001 Database Query Error (8/12/10 10:52 AM)

java.sql.SQLException: Io exception: Invalid number format for port number

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3649)


Solution

This issues has been fixed in Applications Manager v 8.0 SP5.

The workaround is to temporarily set the OAE login to a standard Oracle login (non-Apps), click the Update button and following a successful update, revert back to the OAE RAC login.