After awinstall, RMIServer throws Invalid connection string format

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After running awinstall, the RMIServer will not start up and throws an error like:

03:19:50.112 main: .AxRmiServer$1: null ErrorMsg: AwE-5001 Database Query Error (8/10/25 3:19 AM) 
Details: IO Error: Invalid connection string format, a valid format is: "host:port:sid" 
getConnection
     null
03:19:50.113 main: AwE-5001
03:19:50.113 main: SQL Error: 17002
ErrorMsg: AwE-5001 Database Query Error (8/10/25 3:19 AM) 
Details: null
java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "host:port:sid" 
...

Environment

Version: Any
Database setup: OracleRAC is used

Cause

There is an extra carriage return in the OraceRAC descriptor in Options.properties like:

 

Resolution

Steps to resolve:

1. On the server where Applications Manager RMI Server is running, cd to $AW_HOME/web/classes/
2. Open Options.properties
3. Update the OraceRAC= and remove any carriage returns

 

A good indication of this can be seen in the RMI Server log:

03:19:49.998 main: .AxOptions: DriverClassName=oracle.jdbc.driver.OracleDriver
03:19:49.998 main: .AxOptions: OracleRAC=(DESCRIPTION =
03:19:49.999 main: .AxOptions: DatabaseIdleTimeout=30
03:19:49.999 main: .AxConnectionPool: constructor AUTOMIC [database.server.example.com]:[systemname] OracleRAC oracle.jdbc.driver.OracleDriver
03:19:50.55 main: .AxOptions: DriverUrl_10=jdbc:oracle:thin:@{host}:{port}:{sid}
03:19:50.55 main: .AxOptions: OracleRAC=(DESCRIPTION =
03:19:50.55 main: .AxConnectionPool: jdbc:oracle:thin:@(DESCRIPTION =
03:19:50.55 main: .AxOptions: MaxPooledConnections=50

Notice that the .AxConnectionPool: jdbc:oracle:thin:@( line cuts off - this should be the full connection string - in a non-oracleRac system it would look like:

.AxConnectionPool: jdbc:oracle:thin:@//[database.server.example.com]:1521/[schema_name]

and in Oracle RAC would be the full Options.properties setting