OraFAQ Forum: Networking and Gateways » Cant open tnsnames.ora file .

Home » RDBMS Server » Networking and Gateways » Cant open tnsnames.ora file . (windows xp)

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

Cant open tnsnames.ora file . [message #493175]

Sun, 06 February 2011 06:58

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!!!!!!

...............><.

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493178 is a reply to message #493175]

Sun, 06 February 2011 08:03

Solomon Yakobson
Messages: 3303
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.

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493181 is a reply to message #493175]

Sun, 06 February 2011 08:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you try notepad?

Regards
Michel

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493217 is a reply to message #493178]

Sun, 06 February 2011 15:30

TinaBao
Messages: 5
Registered: February 2011

Junior Member

ye, i think so coz i installed the db in my own pc.

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493218 is a reply to message #493181]

Sun, 06 February 2011 15:32

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.

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493240 is a reply to message #493218]

Mon, 07 February 2011 00:49

Littlefoot
Messages: 21823
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)?

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493247 is a reply to message #493218]

Mon, 07 February 2011 01:22

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493581 is a reply to message #493247]

Tue, 08 February 2011 15:23

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.

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493583 is a reply to message #493240]

Tue, 08 February 2011 15:26

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.

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #493599 is a reply to message #493581]

Tue, 08 February 2011 23:39

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #495330 is a reply to message #493599]

Fri, 18 February 2011 03:50

anyie
Messages: 5
Registered: January 2011

Junior Member

Hi!

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

Anyie

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #495336 is a reply to message #495330]

Fri, 18 February 2011 04:31

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Report message to a moderator

Re: Cant open tnsnames.ora file . [message #495353 is a reply to message #493581]

Fri, 18 February 2011 06:27

flyboy
Messages: 1903
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 21:09:26 CST 2025