Post reply

Connectivity of Oracle Server from Windows XP and Linux?

  • April 18, 2011 at 4:51 am

    #234917

    Hello All

    We have Oracle installed on Server.

    There are 2 OS running in the 2 network lines namely XP,and Linux.

    Is it possible to access Oracle form both the OS ?

    If yes how?

    If No ? Anyhow, how to achieve this?

  • April 23, 2011 at 1:27 pm

    #1315173

    Could you please clarify or reword you question?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • April 23, 2011 at 1:38 pm

    #1315176

    You might want to ask your question in a dedicated Oracle forum...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • April 29, 2011 at 1:27 pm

    #1317940

    sherwincurt (4/18/2011)

    Hello All

    We have Oracle installed on Server.

    There are 2 OS running in the 2 network lines namely XP,and Linux.

    Is it possible to access Oracle form both the OS ?

    If yes how?

    If No ? Anyhow, how to achieve this?

    Yes. No problem at all. Oracle RDBMS doesn't care where are clients running or which operating system are they using.

    1- Install Oracle client in each "client" machine.

    2- In each "client" machine add a TNSNAMES entry to tnsnames.ora file located under ORACLE_HOME/network/admin

    3- Test client-to-host connectivity using "ping"

    4- Test client-to-OracleInstance connectivity using "tnsping" pointing to desired tnsnames entry

    5- Connect using sqlplus or whatever front-end application by pointing to desired tnsnames entry.

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 4 posts - 1 through 3 (of 3 total)

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