1 Reply Latest reply: Mar 20, 2012 5:37 PM by Hussein Sawwan-Oracle RSS

    Demantra Silent Installer Issue

      Hi all,

      We are on Demantra 7.3.1, Oracle 11g and we have the following problem:

      When trying to launch from Collaborator Workbench any of the applications from the Planning Application tab (ie: Member Management, Business Modeler..) it results in the following error:

      "Can't connect to database ora - 12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA".

      I investigated and found that from 11g onwards, the way of using the Hostname adapter has changed.Refer ID 556996.1

      The TNSNAMES.ora file has the following entry

      patvcpdb01.am.abc-solutions.com= (DESCRIPTION=

      Any input will be helpful.

      Thank You
        • 1. Re: Demantra Silent Installer Issue
          Hussein Sawwan-Oracle
          Please see these docs.

          Common issues or problems encountered when running the Oracle Demantra Installation [ID 430913.1]
          Starting Demantra Applications. Hardware. Upgrade. Clone. Performance. System. Compatibility. Java. Engine. Integration [ID 1372253.1]
          Demantra Engine on Linux has ORA-12154: TNS:could not resolve the connect identifier error [ID 1323534.1]
          Oracle Demantra Analytical Engine fails with the following Database Error: Oracle error occurred, but error message could not be retrieved from Oracle [ID 452409.1]
          ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA while installing Demantra Patch [ID 1401744.1]