Hace poco estabamos realizando una instalación de Oracle 11g y cambiamos el puerto del listener, configuramos el listener.ora el tnsnames.ora pero aún asi no funcionaba.
Entrada en el tnsnames.ora
TEST11G =(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =TEST)(PORT = 1523)))
(CONNECT_DATA =
(SERVICE_NAME = TEST11G)))
Entrada del listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEST)(PORT = 1523))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
)
)
ADR_BASE_LISTENER = /oracle/app/oracle