Home » RDBMS Server » Server Administration » ORA-12224: TNS: no listener
ORA-12224: TNS: no listener [message #209456] Thu, 14 December 2006 23:56 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I am receving this error when I am connecting client 8 with server 8. server windiws 2003 and clieint windows 2000.

ORA-12224: TNS: no listener

When I run this command

c:>lsnrctl start
Lisneter has already been started.
Re: ORA-12224: TNS: no listener [message #209540 is a reply to message #209456] Fri, 15 December 2006 07:42 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Check if you have done the settings correct at the client side.

Check the following:

> HOST NAME
> PORT NO
> SERVICE NAME

Hope it helps.
Re: ORA-12224: TNS: no listener [message #209669 is a reply to message #209456] Sat, 16 December 2006 09:48 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
try to check

set ur TNS_ADMIN enviourment variable.

on command prompt.
cmd>set TNS_ADMIN=oraclehome/network/admin


also go through below link
http://www.dbmotive.com/oracle_error_codes.php?errcode=12224


regards
Taj
Previous Topic: Table size in Oracle 9i
Next Topic: SGA Size
Goto Forum:
  


Current Time: Sun Dec 04 14:43:52 CST 2016

Total time taken to generate the page: 0.11056 seconds