Upgrade from V8.0 to V9.0 hangs on starting java api process

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Upgrade from V8.0 to V9.0 hangs on starting java api process

Environment

Release: AAMORS99000-9.0-Automic Applications Manager-Oracle - RMS
Component:

Resolution

Detailed Description and Symptoms

During upgrade from V8 to V9 the upgrade hangs on starting java api process. 

java.sql.SQLException: Listener refused the connection with the following error:ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Investigation

It is possible that the SID and Service_Name does not match.  To verify this, either of these methods should work:

log into to SQL*Plus as the SYS user and enter the following command:

SQL> show parameter service

Or 

The following command at the command line will reply with the Services and Instances available on the machine:

lsnrctl status

Solution

Oracle has deprecated the use of the SID and are moving towards using the Service name. In the latest release, of Applications Manager, we ship with the latest version of the JDBC driver which is Oracle compliant.

You should use the full Service name during the installation of Applications Manager and not rely on the Database SID any longer.