Connectivity of Oracle Server from Windows XP and Linux?

Question

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?

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

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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.