How to configure tns listener to access remote application?
955649Nov 6 2012 — edited Nov 12 2012Hi all,
Hope doing well,
sir i am trying to access host database in my client system. both are connected with the same network through LAN.
i have installed oracle client in client system. but when i running web application getting this error: ORA-12541: TNS:no listener
i have googled for that and i got that if in tns.ora file we set the ip address of client system instead of localhost it will work.
i changed that in my tns.ora file which is here
# tnsnames.ora Network Configuration File: C:\app\securax\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
GRAND1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Grand1)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_GRAND1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
but still getting same error.
how to come out from this error?
thanks