Home » RDBMS Server » Networking and Gateways » parsing tnsnames.ora
parsing tnsnames.ora [message #397919] Tue, 14 April 2009 09:49 Go to next message
abuzayd
Messages: 15
Registered: September 2008
Location: this world
Junior Member
Hi,
I'm trying to connect two computers (the oracle client - on windows vista) and the oracle database (windows XP) but have been facing some difficulties.
Then a senior colleague advised i change the hostname in the tnsnames.ora file to the IP address of the 'server'.
I did that and then tried connecting in SQL*PLUS using the following

Quote:
system/dudu@dbase1


but it keeps telling me something like

Quote:
cannot parse tnsnames.ora file


Please any idea on how to get them connected so i can actually query the database.

P.S. I'm (so to say) a beginner. please help

Report message to a moderator

Re: parsing tnsnames.ora [message #397921 is a reply to message #397919] Tue, 14 April 2009 09:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Fix your tnsnames.ora file.

Regards
Michel

Report message to a moderator

Re: parsing tnsnames.ora [message #397922 is a reply to message #397919] Tue, 14 April 2009 09:53 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

Grab a copy of tnsnames.ora from a client that is working OK

Report message to a moderator

Previous Topic: Access control
Next Topic: ORA-28500 Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 04 17:17:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.