Home » RDBMS Server » Enterprise Manager » Error parsing the tnsnames.ora file
Error parsing the tnsnames.ora file [message #68771] Wed, 08 September 2004 01:03 Go to next message
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.
:)
Re: Error parsing the tnsnames.ora file [message #68825 is a reply to message #68771] Wed, 27 October 2004 04:53 Go to previous messageGo to next message
Joseph
Messages: 30
Registered: June 2002
Member
I have exactly thesame problem as you described.But I have not found the solution yet.
Re: Error parsing the tnsnames.ora file [message #68837 is a reply to message #68771] Sat, 06 November 2004 07:58 Go to previous messageGo to next message
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.
Re: Error parsing the tnsnames.ora file [message #68855 is a reply to message #68771] Thu, 02 December 2004 00:24 Go to previous messageGo to next message
anonimous
Messages: 2
Registered: October 2002
Junior Member
keep only required entries in tnsnames.ora. This worked for me.
Re: Error parsing the tnsnames.ora file [message #68897 is a reply to message #68771] Wed, 19 January 2005 15:14 Go to previous messageGo to next message
Snehasis Palit
Messages: 1
Registered: January 2005
Junior Member
Please retain only SID for which you want to correct and it works.
Re: Error parsing the tnsnames.ora file [message #109269 is a reply to message #68771] Wed, 23 February 2005 03:20 Go to previous messageGo to next message
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.
Re: Failed to parse tnsnames.ora file [message #200845 is a reply to message #68771] Wed, 01 November 2006 10:10 Go to previous messageGo to next message
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
Re: Failed to parse tnsnames.ora file [message #411611 is a reply to message #200845] Mon, 06 July 2009 00:57 Go to previous messageGo to next message
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
Re: Failed to parse tnsnames.ora file [message #411663 is a reply to message #411611] Mon, 06 July 2009 05:02 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Great to know that.

Thanks for the feedback.

Babu
Previous Topic: Delete a threshold value
Next Topic: Configuring Notification Alerts
Goto Forum:
  


Current Time: Thu Mar 28 08:39:16 CDT 2024