urgent lister tns:no lister
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: urgent lister tns:no lister

  1. #1
    Join Date
    Jan 2001
    Posts
    318
    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
    Sonali

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    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
    Santosh

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you get to read this article from metalink?

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

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jan 2001
    Posts
    318
    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
    Sonali

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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

    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width