DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: ORA-12541: TNS: no listener

  1. #11
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Comment:

    tnsnames Local Naming
    Net service names are resolved using the tnsnames.ora file which resides on the client.

    onames Oracle Names
    Net service names and database service names are resolved centrally through an Oracle Names server.

    hostname Host Naming
    Net service names are resolved using the host naming method. Certain criteria must be met to use host naming.

  2. #12
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Volla!!

    Now you have two options... In your sqlnet.ora file, specify the domain name as it had been specified in the tnsnames and try.

    example say your tnsnames is to say

    orcl1.xyz.com= (....)


    in your sqlnet.ora file specify

    NAMES.DEFAULT_DOMAIN = xyz.com


    Second option is, just comment the NAMES.DEFAULT_DOMAIN

    and try....

    One of the above should work.

    Sam


    Thanx
    Sam



    Life is a journey, not a destination!


  3. #13
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    Your port numbers have to be the same in both your TNSNAMES entries and your LISTENER.ORA.

    If your listener is listening on port 1521 and the tnsnames is trying to contact port 1526 or any other port number besides 1521 you will get a NO LISTENER error

    Try that.
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  4. #14
    Join Date
    Oct 2001
    Posts
    13

    Smile

    Thank you everybody for all your help - I finally got it to work!

  5. #15
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    I believe that it could be just a minor mistake when configuring the Oracle .
    1. Have you startup Oracle Agent Service if you want to use
    OEM ?
    2. Can you use tnsping in your client machine to test the connection ?

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