TNS: no listner (ERROR)
I have installed forms6i and we have 10g database. Forms are connecting with database. but the runtime application is giving the following error.
TNS:no listner. Though on the same machine if we install developer and patch 18 it does connects with 10g.
sqlnet.log is displaying the following error:
***********************************************************************
Fatal NI connect error 12224, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bss-ora-app)(PORT=1521))(CONNECT_DATA=(SID=bssglb)(CID=(PROGRAM=C:\Oracle\OraDev\BIN\ifrun60.EXE)(HOST=IT-IMRAN)(USER=imbaig))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production
Time: 23-MAY-2007 10:20:05
Tracing not turned on.
Tns error struct:
nr err code: 12224
TNS-12224: TNS:no listener
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
NOW the error can be removed if we change HOST=bss-ora-app to HOST=bss-ora-db but the TNSNAMES.ora file contains no entry with bss-ora-app
all the connectins are establisg with bss-ora-db where from sqlnet.log file is reading this entry and not connecting. Please help to rectify this problem.
Regards,
Imran