Installation/upgrade of Jasper Server 7.8 using an Oracle (RAC) cluster fails with ORA-12504
search cancel

Installation/upgrade of Jasper Server 7.8 using an Oracle (RAC) cluster fails with ORA-12504

book

Article ID: 211189

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Installation/Upgrade of Jasper Server 7.8 using an Oracle (RAC) Cluster Fails with the below error.

C:\Temp\install.xml:490: The following error occurred while executing this line:
C:\Temp\install.xml:1113: Unable to get Jasper Database version 
  ERROR: The following error occurred while executing this line:
C:\Temp\install.xml:1324: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA 

Environment

Clarity 16.0 and any releases supporting Jaspersoft 7.8

Cause

This is caused by defect DE60196. 

Resolution

Use the below workaround to address the issue.

  1. Navigate to the directory where you've extracted clarity_jaspersoft_7.8.0_6.4.0.35.zip.
  2. Edit install.xml file and modify "oConnectionType" from "SERVICENAME" to "SERVICE_NAME" on line 937

    Before


    After

  3. Edit file setup.xml under buildomatic/bin folder. Modify "dbSidOrServiceNameProp" from "ServiceName=${serviceName}" to "SERVICE_NAME=${serviceName}" on Line 914


Before


After

Additional Information

 

 

Powered by Wolken Software