Connectivity of Oracle Server from Windows XP and Linux?

• sherwincurt

  SSC Enthusiast

  Points: 192

  More actions

  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?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  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/

• LutzM

  SSC Guru

  Points: 107049

  More actions

  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]

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  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.