TNS-12533: TNS:illegal ADDRESS parameters I kept receiving this error recently but until today, never bothered to investigate it. To get around it, I would just comment out the bottom half (where the problem was) of the tnsnames file.

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 = 
  (DESCRIPTION = 
    (ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = localhost)
      (PORT = 1521)
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = TESTING)
    )
  )

It's probably difficult to see...maybe a picture would do better.



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.

Labels: debug, ORA-12533

  ¶ 2/02/2010 09:16:00 AM