search cancel

Trigger Oracle RAC

book

Article ID: 89361

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Trigger Oracle RAC

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

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.