4 Replies Latest reply on Jun 16, 2014 1:14 PM by Alvaro Soares

    ORA-12519: TNS:no appropriate service handler found error

    Alvaro Soares

      Hi Gurus,


              I having a environment with Financial Management and FDM at same server and i'm having the following error when I try to deploy an HFM app :


      Error 11; hypadmin; 06/12/2014 12:01:54; HfmADOConnection.cpp; Line 591; <?xml version="1.0"?>

      <EStr><Ref>{C8D1FE60-7743-465B-ACA1-509C59EC4A75}</Ref><AppName/><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147467259</Num><Type>1</Type><DTime>6/12/2014 12:01:54 PM</DTime><Svr>RJ1-2K8-BI-P06</Svr><File>HfmADOConnection.cpp</File><Line>591</Line><Ver></Ver><DStr>ORA-12519: TNS:no appropriate service handler found</DStr></ESec></EStr>.


             I know the issue is related to TNSNAMES.ORA and I have Oracle Client 32 and 64 bits installed. My TNS_ADMIN variable is set to  D:\Oracle\Middleware\dbclient32\network\admin;D:\Oracle\Middleware\user_projects\config\dbclient  and my PATH variable is set to D:\Oracle\Middleware\dbclient64\BIN;D:\Oracle\Middleware\dbclient32\bin;%PATH%


            Also, I have ORACLE_SID set as environment variable but still having the error above.


            Does some knows how should be set the environment databases in order to get the connection correctly ?



      Thanks in advance