Error occurs when running reports using ZENworks Reporting Server with an Oracle database

  • 7007527
  • 10-Jan-2011
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Business Objects Reporting

Situation

Error occurs when running reports using ZENworks Reporting Server with an Oracle database.
ERROR: "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

Resolution

The tnsnames.ora network configuration file requires the full DNS name for the Oracle servicename.