Error en oracle TNS-12533: TNS:illegal ADDRESS parameters

Categorías:

Cuando ejecuté tnsping , se generaba el mensaje de error del título del post.

 

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
[oracle@piscis: ICEPRD [/u01/app/oracle/product/12.1.0/dbhome_1/network/admin] 13:24:11 $ tnsping ICEDB
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 13-FEB-2020 13:24:14
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db))
TNS-12533: TNS:illegal ADDRESS parameters
[oracle@piscis: ICEPRD [/u01/app/oracle/product/12.1.0/dbhome_1/network/admin] 13:24:11 $ tnsping ICEDB TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 13-FEB-2020 13:24:14 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db)) TNS-12533: TNS:illegal ADDRESS parameters
[oracle@piscis: ICEPRD [/u01/app/oracle/product/12.1.0/dbhome_1/network/admin]   13:24:11 $ tnsping ICEDB

TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 13-FEB-2020 13:24:14

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db))
TNS-12533: TNS:illegal ADDRESS parameters

Este tipo de error es generado por una sintaxis incorrecta en el archivo tnsnames.ora. Puede ser un paréntesis que falta o que sobra

En mi caso era un paréntesis que se había puesto donde no debía.

Revisemos el archivo tnsnames.ora

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
ICEDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521) <----- Aquí falta el paréntesis
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ice_db)
)
)
) <------- Este paréntesis sobra
ICEDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521) <----- Aquí falta el paréntesis (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db) ) ) ) <------- Este paréntesis sobra
ICEDB =
        (DESCRIPTION = 
                (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521) <----- Aquí falta el paréntesis
                (CONNECT_DATA = 
                        (SERVER = DEDICATED)
                        (SERVICE_NAME = ice_db)
        )
)
)  <------- Este paréntesis sobra

Corregimos el problema ajustando los cambios

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
ICEDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ice_db)
)
)
ICEDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db) ) )
ICEDB =
        (DESCRIPTION = 
                (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521))
                (CONNECT_DATA = 
                        (SERVER = DEDICATED)
                        (SERVICE_NAME = ice_db)
        )
)

Y listo, eso es todo ….

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
[oracle@piscis: ICEPRD [/u01/app/oracle/product/12.1.0/dbhome_1/network/admin] 13:27:50 $ tnsping ICEDB
TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 13-FEB-2020 13:27:51
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db)))
OK (0 msec)
[oracle@piscis: ICEPRD [/u01/app/oracle/product/12.1.0/dbhome_1/network/admin] 13:27:50 $ tnsping ICEDB TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 13-FEB-2020 13:27:51 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db))) OK (0 msec)
[oracle@piscis: ICEPRD [/u01/app/oracle/product/12.1.0/dbhome_1/network/admin]   13:27:50 $ tnsping ICEDB

TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 13-FEB-2020 13:27:51

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.170) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ice_db)))
OK (0 msec)

Saludos…

 

 

Sin respuestas

Deja un comentario