4 Replies Latest reply: Jun 16, 2014 8:14 AM by Alvaro Soares RSS

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

    Alvaro Soares

      Hi Gurus,

       

              I having a 11.1.2.3.500.4435 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>11.1.2.3.500.4435</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