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