Install TIBCO JasperReports® Server on Oracle Service with Oracle Advanced Security enabled

Requirement

There are some uncommon usecases, when users need to install TIBCO JasperReports^® Server on Oracle Service with Oracle Advanced Security Enabled.

Solution

Install JasperReports^® Server on such environment is not a common usecase, so some addtional changes should be done before installation.

First, User needs to set serviceName instead of SID in default_master.properties. The result will be like:

serviceName=Name

After this, User need to open /buildomatic/conf_source/db/oracle/db.template.properties and append OAS properties in the end of the following lines for connection to Oracle:

admin.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}${AdditionalAdminProperties}
js.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}
sugarcrm.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};CatalogOptions=0;${dbSidOrServiceNameProp}
foodmart.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};CatalogOptions=0;${dbSidOrServiceNameProp}

So the result will be like the following:

admin.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp}${AdditionalAdminProperties};DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256
js.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};${dbSidOrServiceNameProp};DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256
sugarcrm.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};CatalogOptions=0;${dbSidOrServiceNameProp};DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256
foodmart.jdbcUrl=jdbc:tibcosoftware:oracle://${dbHost}:${dbPort};CatalogOptions=0;${dbSidOrServiceNameProp};DataIntegrityLevel=accepted;EncryptionLevel=accepted;EncryptionType=AES256

After all these changes User can install JasperReports Server on Oracle Service with Oracle Advanced Security enabled.

References

• OAS Specification
• Connect to Oracle Service

ref - akovach 01771283