Hey,
My problem:
I installed ODI and Sql oracle developer, first time connected was established after a day, on rebooting the laptop connection has been lost and listener was stopped: (due to automatically and dynamically change in IP address)
on connecting in SQL oracle developer with the oracle database this error is shown
17002 due to listener is down and it has to be started, but listener is not starting
note that it is trying to connect with the old IP address (now it is changed automatically)
this is my listener.ora file:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.102)(PORT = 1521))
)
)
this is my tsnames.ora file
# tnsnames.ora Network Configuration File: E:\oradb\homes\OraDB21Home1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1522))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.102)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.MyDemoSQL.com)
)
)
PDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclpdb.MyDemoSQL.com)
)
)
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1522))
(CONNECT_DATA =
(SID = XE)
)
)