OraFAQ Forum: Server Administration » ORA-12224: TNS: no listener

Home » RDBMS Server » Server Administration » ORA-12224: TNS: no listener

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12224: TNS: no listener [message #209456]

Thu, 14 December 2006 23:56

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.

Report message to a moderator

Re: ORA-12224: TNS: no listener [message #209540 is a reply to message #209456]

Fri, 15 December 2006 07:42

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.

Report message to a moderator

Re: ORA-12224: TNS: no listener [message #209669 is a reply to message #209456]

Sat, 16 December 2006 09:48

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

Report message to a moderator

Previous Topic:	Table size in Oracle 9i
Next Topic:	SGA Size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 14:55:58 CST 2025