OraFAQ Forum: Enterprise Manager » Error parsing the tnsnames.ora file

Home » RDBMS Server » Enterprise Manager » Error parsing the tnsnames.ora file

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

Error parsing the tnsnames.ora file [message #68771]

Wed, 08 September 2004 01:03

Shakeel
Messages: 8
Registered: July 2003

Junior Member

Hi.
I have installed Oracle9i client on my laptop, alongwith OEM. I have a machine on my network which I am using as a database server machine.
I choose to run it as stand alone.
Now when I run OEM, I get the following message:

Failed to parse tnsnames.ora file
oracle.net.config.ServiceAliasException: 10

I click ok, and OEM asks me to "Add Databases to Tree".
I tell it to use my local tnsnames.ora file which contains the correct entries for all the instances running on the server. But nothing happens.

What is the problem here?

Thank you.

Shakeel.
:)

Report message to a moderator

Re: Error parsing the tnsnames.ora file [message #68825 is a reply to message #68771]

Wed, 27 October 2004 04:53

Joseph
Messages: 30
Registered: June 2002

Member

I have exactly thesame problem as you described.But I have not found the solution yet.

Report message to a moderator

Re: Error parsing the tnsnames.ora file [message #68837 is a reply to message #68771]

Sat, 06 November 2004 07:58

Eric Ash
Messages: 1
Registered: November 2004

Junior Member

I have had a similar issue where Top Sessions will not work correctly, even though I can see a database on the OEM tree. There was an issue with my tnsnames.ora file. The answer in my case, was to place a "space" before every entry in the file. Yes, lame but it worked for me.

Report message to a moderator

Re: Error parsing the tnsnames.ora file [message #68855 is a reply to message #68771]

Thu, 02 December 2004 00:24

anonimous
Messages: 2
Registered: October 2002

Junior Member

keep only required entries in tnsnames.ora. This worked for me.

Report message to a moderator

Re: Error parsing the tnsnames.ora file [message #68897 is a reply to message #68771]

Wed, 19 January 2005 15:14

Snehasis Palit
Messages: 1
Registered: January 2005

Junior Member

Please retain only SID for which you want to correct and it works.

Report message to a moderator

Re: Error parsing the tnsnames.ora file [message #109269 is a reply to message #68771]

Wed, 23 February 2005 03:20

Arthur Kirchner
Messages: 1
Registered: February 2005

Junior Member

Hello,

I solved the problem after I found out, that there was
white space previous to one entry, e.g.
___DEMOIMMO =
(DESCRIPTION =
instead of

DEMOIMMO =
(DESCRIPTION =

after a listener-restart, everything woked out fine.

Report message to a moderator

Re: Failed to parse tnsnames.ora file [message #200845 is a reply to message #68771]

Wed, 01 November 2006 10:10

blazingrock4u
Messages: 30
Registered: March 2006
Location: India

Member

Hello every1.

Below was the error that had been a pain in my neck for quite some time. Mad

"Failed to parse tnsnames.ora file
oracle.net.config.ServicesAliasException: 10"

This error appears whenever I try to connect to remote databases (9.2.0.6) using OEM Stand Alone (9.2.0.1)

Finally I stopped the listener on my Workstation (because my workstation has couple of play-databases).

Moved all the ".ora" files from ORACLE_HOME/network/admin/ directory to some bkp directory.

Recreated the Listener.ora and Tnsnames.ora using Net Configuration Assistant.

And viola!!! It worked. Cool

Report message to a moderator

Re: Failed to parse tnsnames.ora file [message #411611 is a reply to message #200845]

Mon, 06 July 2009 00:57

daphne.chang
Messages: 1
Registered: July 2009
Location: Taiwan

Junior Member

hi

i solve the problem .
in my case , there is some invalid connect string in tnsname.ora. si , i edit the tnsname.ora file which delete those words . and open oem to add database name to tree . it works

Thanks

Daphne

Report message to a moderator

Re: Failed to parse tnsnames.ora file [message #411663 is a reply to message #411611]

Mon, 06 July 2009 05:02

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Great to know that.

Thanks for the feedback.

Babu

Report message to a moderator

Previous Topic:	Delete a threshold value
Next Topic:	Configuring Notification Alerts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 02:28:09 CST 2024