Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Alvaro SoaresJun 12 2014 — edited Jun 16 2014

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

This post has been answered by Jjun.Tan on Jun 12 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2014
Added on Jun 12 2014
4 comments
2,612 views