Linked Server location?

  • I have inherited a SQL Server that makes a call to a Linked Server called "TABLEAU". The linked server is working fine, and using the Oracle OLE DB provider (OraOLEDB.Oracle). The only problem is I'm having trouble figuring out where this server actually is. When I "ping TABLEAU" from the SQL Server VM command prompt, it resolves to TABLEAU.mycompany.com, which is where our actual Tableau server resides. I find it really difficult to believe that the folks running our Tableau server are running an Oracle DB server on the same box! Does anyone know how I can figure out what this "TABLEAU" linked server resolves to? I looked at the C:\Windows\System32\drivers\etc\hosts file but that was just all comments. Also, if this server was in there, I would think it would have pinged a different IP address than the actual Tableau server. Is there some kind of equivalent hosts file for the OraOLEDB.Oracle provider or something?

  • on the server itself (or through xp_cmdshell on that sql instance) execute

    tnsping tableau

    if the server is names like that you will get an output with the ip/hostname of the server the oracle instance is located on.

    if tnsping is not found you will need to determine where is the oracle home on that server - this can be done through registry under key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

    with that you can go to its home, directory network\admin

    file tnsnames.ora will contain entries for the oracle server defined on your linked server.

    It is also possible that the linked server has the servername on it.

  • Heh... call the folks that are on the infrastructure team.  They'll know.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Thanks frederico_fonseca!!!  Yup, it was in the tnsnames.ora file.  Really appreciate the help

  • Jeff Moden wrote:

    Heh... call the folks that are on the infrastructure team.  They'll know.

    Ha!  Yeah, that was going to be my last resort.  Since I recently inherited this server, I didn't want to go calling the infrastructure team unless absolutely necessary.  No need to make it so obvious that I'm a newb in this environment...  🙂   Luckily, frederico's answer above did the trick!

     

  • pkarandi wrote:

    Jeff Moden wrote:

    Heh... call the folks that are on the infrastructure team.  They'll know.

    Ha!  Yeah, that was going to be my last resort.  Since I recently inherited this server, I didn't want to go calling the infrastructure team unless absolutely necessary.  No need to make it so obvious that I'm a newb in this environment...  🙂   Luckily, frederico's answer above did the trick!

    I know what you mean.  And seeing the file name of tnsnames.ora brought back no pleasant memories for me. 😉  It's probably just because I cut my teeth on SQL Server and so, except for certain thing like how they did real BEFORE triggers, I had little love for Oracle.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • This was removed by the editor as SPAM

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

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