Knowledge Base

There is an error in your TNS string

ORA-12533: TNS:illegal ADDRESS parameters

There was an error or unknown parameter entered in the ADDRESS part of a tnsnames entry.
eg:

ERROR.EU.DBMOTIVE.COM =  
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PROT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ERROR.EU.DBMOTIVE.COM)
    )
  )

In the previous example, we incorrectly spelled PROT instead of PORT.

A tnsping of the entry will result in the error.

C:\>tnsping error

TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production
Copyright (c) 1997 Oracle Corporation.  All rights reserved.
Used parameter files:c:\oracle\ora920\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PROT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ERROR.EU.DBMOTIVE.COM)))
TNS-12533: TNS:illegal ADDRESS parameters

In order to solve this problem, you will have to look at the configuration of your tnsnames, oracle names or oid entries.
Probably there is a spelling mistake, or an incorrect configuration of the entry.

Be aware of the fact that Oracle is sensitive on how your entry is formatted, including the correct usage of white spaces.

  • John damte

    Gracias estaba escribiendo mal la direccion ADDRESS puse ADRESS jejej

Oracle Gold Partner DbMotive is an Oracle Gold Partner