ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 

Cause

This is caused by Defect DE60196

Environment

Clarity 16.0 and releases supporting Jaspersoft 7.8

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

 

 

Attachments