urgent lister tns:no lister

[sonaliak]

I have a oracle8 server and 2 client machines. One inside the firewall and one outside. I can connect from the one which is inside and the ouside one fails with the above error.
The server is NT and the client is Win98.
We are using tcp/ip
I read lot of related articles from metalink and from dbasupport.
http://www.dbasupport.com/forums/sho...threadid=10863

TNS Ping Utility for 32-bit Windows: Version 8.0.5.0.0 - Production on 31-MAY-01
11:40:49

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=SCOOTER)(PORT=1521))
TNS-12541: TNS:no listener

This machine can ping to the server.

I checked tnsnames.ora file on that client it looks fine.
One more point: this client can connect to some other oracle server but not just this one.
I added a use_shared_socket= true in registry of this server
and stopped and started service and listner.
Is there any thing I am missing ?

What else should I check ?

thanks

[santoshym]

Hi

I feel this is something which is related with ur firewall server which will usually have certaint port numbers open might be a problem with the port number although Iam not sure.The ping command will work thru ur firewall server because I feel it uses a port number which is open at ur firewall.Check with you network & Security administrator on the above issue

Hope this helped

Regards

[sambavan]

Did you get to read this article from metalink?

http://metalink.oracle.com/metalink/...1&p_showHelp=1

Sam

[sonaliak]

It also says that I should stop and start oracle.. How do I do that.. this may look like a silly question but I am new..
thanks

[sambavan]

if you are making any changes on the init.ora file then you have to shutdown and start up your instance to get the changes take effect.


To bounce the instance, on the dos prompt
svrmgrl
svrmgr> connect internal
svrmgr> shutdown immediate
svrmgr> startup
svrmgr> exit


Sam