OraFAQ Forum: Server Administration » Accessing a Server from Unix

Home » RDBMS Server » Server Administration » Accessing a Server from Unix

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Accessing a Server from Unix [message #58122]

Sat, 02 August 2003 23:20

Raghavendra.K.Balgi
Messages: 1
Registered: August 2003

Junior Member

I have installed a Oracle Server on my Windows 2k and confugured it well. I'am able to use the same from my local machine and also from other windows Machines.

But my organisation has a solaris server. I need to find a way to access the windows server from that solaris machine. I tried supply all the necessary details (ip number,port) etc..but it still says that TNS entry not found. When I checked the ORACLE_HOME it pointed to one on the solaris machine..and I guess it tried to access the TNS names.ora from there. I think knowing the address/port/servivename/sid of the server(windows) should be enough to make a database connection..and simply doesnt make sense adding an entry in tnsnsames.ora file on the solaris machine.Please help.

Report message to a moderator

Re: Accessing a Server from Unix [message #58123 is a reply to message #58122]

Sun, 03 August 2003 16:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

from solaris machine you are trying to connect to a windows machine.
right?
then oracle installation in solaris machines ORACLE_HOME/network/admin/tnsnames.ora should have the tns entries to connect to the database in windows machine.

Report message to a moderator

Re: Accessing a Server from Unix [message #58132 is a reply to message #58123]

Mon, 04 August 2003 06:52

Yasuhiro Ikeda
Messages: 4
Registered: June 2003

Junior Member

Raghavendra,

You should comment out as follows:

-- sqlnet.ora --
SQLNET.AUTHENTICATION_SERVICES = (NTS)
--

Thanks,
Yasuhiro

Report message to a moderator

Previous Topic:	invalid username/password
Next Topic:	system error message 4 while exporting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:41:36 CDT 2024