0 Replies Latest reply: May 3, 2012 9:24 AM by SenthilMuthuKumar RSS

    Error while launcing Planning applications from colloborator Workbench

    SenthilMuthuKumar
      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

      I am using a WIN 7 - 64 bit Machine , So I have installed 32-bit client too on my machine .

      The tnsnames.ora ( under 32 bit client)*_

      *# tnsnames.ora Network Configuration File: C:\Oracle\Client32bit\product\11.2.0\clienthome\network\admin\tnsnames.ora*_
      *# Generated by Oracle configuration tools.*

      ORCL =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = GAEA-20)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SID = ORCL)
      )
      )




      Listener.ora file is under the database home

      *# listener.ora Network Configuration File: C:\Oracle\database64bit\product*

      \11.2.0\dbhome_1\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\Oracle\database64bit\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\database64bit\product\11.2.0\dbhome_1\bin

      \oraclr11.dll")
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = GAEA-20)(PORT = 1521))
      )
      )



      ADR_BASE_LISTENER = C:\Oracle\database64bit

      DEFAULT_SERVICE_listener_name= GAEA-20

      ___________________________________________________________________________________________________________________________________

      Edited by: SenthilMuthuKumar on 03-May-2012 06:43