Home » RDBMS Server » Networking and Gateways » Cant open tnsnames.ora file . (windows xp)
icon9.gif  Cant open tnsnames.ora file . [message #493175] Sun, 06 February 2011 06:58 Go to next message
TinaBao
Messages: 5
Registered: February 2011
Junior Member
hi guys,

i need help with set up the connection between oracle developer and database.

i found the file called tnsnames.ora however, i cant open it. i dont know if i need to choose a program to open it or download extension for it.

Thank you very much!!!!!!

...............><.
Re: Cant open tnsnames.ora file . [message #493178 is a reply to message #493175] Sun, 06 February 2011 08:03 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3001
Registered: January 2010
Location: Connecticut, USA
Senior Member
Are you a DBA? If not, ask your DBA. In proper database setup users can read tnsnames but can't edit it. Only DBAs can.

SY.
Re: Cant open tnsnames.ora file . [message #493181 is a reply to message #493175] Sun, 06 February 2011 08:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67488
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try notepad?

Regards
Michel
Re: Cant open tnsnames.ora file . [message #493217 is a reply to message #493178] Sun, 06 February 2011 15:30 Go to previous messageGo to next message
TinaBao
Messages: 5
Registered: February 2011
Junior Member
ye, i think so coz i installed the db in my own pc.
Re: Cant open tnsnames.ora file . [message #493218 is a reply to message #493181] Sun, 06 February 2011 15:32 Go to previous messageGo to next message
TinaBao
Messages: 5
Registered: February 2011
Junior Member
Michel Cadot wrote on Sun, 06 February 2011 08:13
Did you try notepad?

Regards
Michel


i tried notepad, i cant open.
Re: Cant open tnsnames.ora file . [message #493240 is a reply to message #493218] Mon, 07 February 2011 00:49 Go to previous messageGo to next message
Littlefoot
Messages: 21616
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens when you try?

Where is TNSNAMES.ORA file you are talking about located (which directory)?
Re: Cant open tnsnames.ora file . [message #493247 is a reply to message #493218] Mon, 07 February 2011 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 67488
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TinaBao wrote on Sun, 06 February 2011 22:32
Michel Cadot wrote on Sun, 06 February 2011 08:13
Did you try notepad?

Regards
Michel


i tried notepad, i cant open.


And I can.

Don't you think that "I can't" does not help us to know why "you can't". Maybe you didn't power on your PC. Am I right?

Regards
Michel

Re: Cant open tnsnames.ora file . [message #493581 is a reply to message #493247] Tue, 08 February 2011 15:23 Go to previous messageGo to next message
TinaBao
Messages: 5
Registered: February 2011
Junior Member
Michel Cadot wrote on Mon, 07 February 2011 01:22
TinaBao wrote on Sun, 06 February 2011 22:32
Michel Cadot wrote on Sun, 06 February 2011 08:13
Did you try notepad?

Regards
Michel


i tried notepad, i cant open.


And I can.

Don't you think that "I can't" does not help us to know why "you can't". Maybe you didn't power on your PC. Am I right?

Regards
Michel



i cant open with notepad. is that the answer you want.
Re: Cant open tnsnames.ora file . [message #493583 is a reply to message #493240] Tue, 08 February 2011 15:26 Go to previous messageGo to next message
TinaBao
Messages: 5
Registered: February 2011
Junior Member
Littlefoot wrote on Mon, 07 February 2011 00:49
What happens when you try?

Where is TNSNAMES.ORA file you are talking about located (which directory)?


i dont think you know wot to do.
Re: Cant open tnsnames.ora file . [message #493599 is a reply to message #493581] Tue, 08 February 2011 23:39 Go to previous messageGo to next message
Michel Cadot
Messages: 67488
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i cant open with notepad. is that the answer you want.


Quote:
Don't you think that "I can't" does not help us to know why "you can't". Maybe you didn't power on your PC. Am I right?


There are so many reasons you can't, if you don't tell us in which wat you can't we can't help you.

Regards
Michel
Re: Cant open tnsnames.ora file . [message #495330 is a reply to message #493599] Fri, 18 February 2011 03:50 Go to previous messageGo to next message
anyie
Messages: 5
Registered: January 2011
Junior Member
Hi!

Directory - oracle_home\network\admin
oracle_home is the path of the installed software .

Anyie
Re: Cant open tnsnames.ora file . [message #495336 is a reply to message #495330] Fri, 18 February 2011 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 67488
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question
Re: Cant open tnsnames.ora file . [message #495353 is a reply to message #493581] Fri, 18 February 2011 06:27 Go to previous message
flyboy
Messages: 1891
Registered: November 2006
Senior Member
TinaBao wrote on Tue, 08 February 2011 22:23
i cant open with notepad. is that the answer you want.

What about: I ran Notepad editor, chose File - Open from its top menu, navigated to "C:\oracle\mydb\NETWORK\ADMIN" folder, changed the file filter to "All Documents (*.*)", chose "tnsnames.ora" file, clicked on Open button. Then my computer crashed with blue screen of death

Which description of the problem seems more descriptive (so easier to find anything wrong from it) to you?

[Edit: corrected English in the first paragraph]

[Updated on: Fri, 18 February 2011 06:38]

Report message to a moderator

Previous Topic: Connecting 32 bit client on 64 bit server
Next Topic: Connection problem
Goto Forum:
  


Current Time: Sat Oct 31 09:18:21 CDT 2020