search cancel

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

book

Article ID: 88927

calendar_today

Updated On:

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.