ERPstuff - Oracle EBS Community

Posted: **Fri Dec 15, 2006 3:23 am**

ORA-12224: TNS: no listener
THIS ERRO SHOWS AT CLIENT ORACLE 8 WINDOWS 2000
SERVER ORALCE 8 & WINDOWS 2003
SERVER DATABASE AND FORM WORKING WELL.
@ CLIENT WHEN I CONNECT CLIENT VIA NET8 EASY CONFIG SHOW THIS ERROR.

Posted: **Fri Dec 15, 2006 5:07 am**

have you check
1-tnsnames.ora at client end
2-init.ora global databasse name
3-port on which listner work

Posted: **Fri Dec 15, 2006 10:41 am**

As this was not an Oracle Apps database issue so I moved it here. Now coming to the problem check on server if listener is running.

c:\>lsnrctl80 status

start the listener service or start using lsnrctl80 start.

Note: Pl check the exact name of executable it should be lsnrctl or lsnrctl80.

Locally on server you will be able to login but when you will use connecting string then listener is used and if it is not running then it will give error.

Thanks