Skip navigation
Contact Us
6048 Views 6 Replies Latest reply: Apr 13, 2014 7:08 AM by Anil Kumar Borru RSS
krish k Apprentice 124 posts since
Aug 5, 2011
Currently Being Moderated

Aug 31, 2012 8:34 AM

ORA-12154: TNS:could not resolve the connect identifier specified






RR_4036    Error connecting to database [

Database driver error...

Function Name : Logon

ORA-12154: TNS:could not resolve the connect identifier specified

Database driver error...

Function Name : Connect

Database Error: Failed to connect to database using user [apps] and connection string [oltp].].



Whenever I am trying to run the workflow I got above error.



I am able to ping the tnslistner and server ip sucessfulluy from local client.Where is the issue how can i resolve this issue Please help me out anybody.

  • vasu bhattiprolu Apprentice 83 posts since
    Apr 22, 2012

    Hi Krish,



    Go to following path : oracle/product/network/admin


    Please verify following things:



    1)Make sure that TNSNAMES is listed as  one of the values of the names.directory_path parameter

    in the sqlnet.ora Oracle Net profile.


    2)Verify that a tnsnames.ora file exists and is in the proper directory and is accessible.


    3)Check that the net service name used as the connect identifier exists in the tnsnames.ora file.


    4)Make sure there are no syntax errors anywhere in the tnsnames.ora file.


    5)Look for unmatched parentheses or stray characters.Errors in a tnsnames.ora file may make it  unusable.


    Please find attached files for reference.






  • Dinesh K Newbie 10 posts since
    Apr 10, 2012

    May be the issue is with your Integration Service. Do check the Connect String Given under the Repository setting.

    If the Issue is with the user, then try giving Admin privileges to that user given under Repository setting and then use the same user to setup Integration Service.

  • DIWAKAR KUMAR Novice 52 posts since
    Jun 24, 2012

    Hi Krish,


    Your cause may be the following:


    RR_4036Error connecting to database <database name>.

    Cause:The Integration Service failed to connect to the database. You may have logged in incorrectly.

    Action:Enter the correct login information. user names and passwords may be case-sensitive.


    Follow the above mentioned steps and please inform me whether you are able to solve this problem or not.





  • Jeet Singh Newbie 3 posts since
    Apr 7, 2014

    hi everyone ,


    i tried eveverything specified above but no solution works.

    i faced this problem in Powercenter express ,  i. am able to add source in mapping but mapping fails

    on running.


    Any help is appreciated.



    Thanks for any support

More Like This

  • Retrieving data ...

Bookmarked By (0)