Today I had enough.
I removed all but the top most entry, saved the file and did a tnsping <first_entry>.
OK (40 msec)
I added in the second entry, tnsping <second_entry>
OK (210 msec)
I added in the third entry
TNS-12533: TNS:illegal ADDRESS parameters
Removed it.
Success.
WTF?
TESTING =It's probably difficult to see...maybe a picture would do better.
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = localhost)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME = TESTING)
)
)
How about now?
Still don't see it?
I almost gave up as well.
This should help.
A freaking space? Really? 8+ years and this is the very first time I am seeing this...seems strange I haven't encountered this before.
23 comments:
Welcome to the club :)
it is common error.
when save into unix machine after edit the file in windows with DOS format.
please remember save it as unix format.
Don't you know you should be using the 'netmgr' utility to create these. What are this fancy CLI tools you are using :)
Shouldn't you be torturing @purlygirl tonight instead of me?
okay, I'll stop torturing you and reading your blog *sniff*
Thanks a lot. I got the same error from today morning and didnt have a clue what could be wrong as the same tns file worked for my previous builds. It is working after I remove the space.
Great post, helped me fix the error. I was sent a TNS names entry and wasn't able to connect even though the instance was on the same server as another production system that I was able to connect to and it was from the same TNS file. I saved the file in UNIX format and then resaved as Windows and it worked. Something so simple yet so frustrating.
Glad it helped...who knew it could be something so tiny as a space?
chet
Thanks Google and thanks to you fantastic eye !!!
Thanks a lotttt, it worked for me as well...Wasted one whole day in fixing it, but he entry looked fine...and now I realize wat was going
Great post! Thanks.
This just got me as well! for me it was the entry that proceeded after the TNS which I was getting the fail on. Thanks for the great blog.
I too faced a similar rouge space causing said error. Your article saved a several minutes (dare I say hours) troubleshooting the same.
Appreciate you taking the time to post so that people like me can save themselves.
Thanks.
Rohit N.
I am having this error now.
I am going to try solve it using this hint.
And if this is the problem i am going to cut my tongue after...
I am curring battleing with this error.
I will try to solve it using this hint and if this is the case i am going to cut my tongue after...
At last i got i to work
Thanks !
THANK YOU SO MUCH!!!! you are officially my hero for the day
Your Post Saved me!
It was not a space in my case, rather a tab at the end of one of the lines... Gives the same issue
Darned missing ')' at the end of the block got me - was hard to see until I found your blog entry. Thanks!!
Thank you for your Post.It helped me with the issue I have been having
Thanks to this post even in 2016 we are being saved !!!
thanks you just saved me too, those pesky spaces ;)
last bracket was missing and getting the same error
test.world =
(DESCRIPTION =
(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)
(Host=server1vip)(Port=1523)))
(CONNECT_DATA=(SID=test))
====>>>)
Post a Comment