Post reply

Connection to oracle 11g

  • February 1, 2012 at 10:11 am

    #254607

    Hi All,

    When I trying to connect the oracle 11g from SSIS package

    It shows error like below

    ORA-12154:TNS:Could not reslove service name

    How to fix this problem

    Thanks

  • February 1, 2012 at 10:28 am

    #1441325

    Do you have oracle clients on your machine to connect to oracle database like SQL PLUS or any other?

  • February 1, 2012 at 12:37 pm

    #1441387

    Thanks for your replay

    I have oracle client on my machine

  • February 2, 2012 at 12:25 am

    #1441563

    sqlserver8650 (2/1/2012)

    Thanks for your replay

    I have oracle client on my machine

    And did you configure the TNS names.

    There should be a TNSNAMES.ORA file somewhere in your Oracle folder that contains all the connection info for the service names.

    Example:

    myTNSName = (DESCRIPTION=

    (ADDRESS=(PROTOCOL=tcp)(HOST=myServerName)(PORT=1526))

    (CONNECT_DATA=(SID=myTNSName))

    )

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 2, 2012 at 11:44 am

    #1441993

    sqlserver8650 (2/1/2012)

    Thanks for your replay

    I have oracle client on my machine

    Out of curiosity, were you able to connect to that oracle database using those SQL Client tools such as SQL PLUS.

    I wonder what else you are missing... because, I use microsoft OLEDB provider for oracle and I provide only Server name, user name, password. Thats it. Every thing works.

  • February 2, 2012 at 2:13 pm

    #1442081

    AluburaJ (2/2/2012)

    sqlserver8650 (2/1/2012)

    Thanks for your replay

    I have oracle client on my machine

    Out of curiosity, were you able to connect to that oracle database using those SQL Client tools such as SQL PLUS.

    I wonder what else you are missing... because, I use microsoft OLEDB provider for oracle and I provide only Server name, user name, password. Thats it. Every thing works.

    But you probably installed and configured the Oracle client, right?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 3, 2012 at 1:03 pm

    #1442614

    Yes.

  • February 3, 2012 at 1:04 pm

    #1442615

    Koen Verbeeck (2/2/2012)

    AluburaJ (2/2/2012)

    sqlserver8650 (2/1/2012)

    Thanks for your replay

    I have oracle client on my machine

    Out of curiosity, were you able to connect to that oracle database using those SQL Client tools such as SQL PLUS.

    I wonder what else you are missing... because, I use microsoft OLEDB provider for oracle and I provide only Server name, user name, password. Thats it. Every thing works.

    But you probably installed and configured the Oracle client, right?

    YES.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply