DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Listener.log question

  1. #1
    Join Date
    Nov 2000
    Posts
    74
    Is there another log that will list attempted access where there is an error message listing why connection cannot be established? I have a developer trying to set up a connection to an Oracle database but he doesn't show up on the listener log. Another developer is having no problems with the same access. Any ideas how to troubleshoot this?

    We use Oracle 8.1.7 on NT.

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The listener.log will only record successful connections. The developer should trap the error he is getting during the connect phase. Depending on whether you have tracing turned on or not, you might be able to look in the sqlnet.log file on the client for information.
    Jeff Hunter

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    1. Can you connect to the database from the server?

    2. Can you

    Code:
                 tnsping service_name
                 sqlplus sys/password@service_name
    3. If this fails then check the tnsnames.ora and sqlnet.ora file configurations. If they are correct, try stopping and starting the listener

    4. If you can reach the database successfully, then repeat the step 2 from the client system.

    5. If that fails, check all the tnsnames.ora files for the configurations to be correct

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    2. Can you

    Code:
                 tnsping service_name
                 sqlplus sys/password@service_name
    BTW, do you know that there are cases when you are able to connect, everything is OK but not to tnsping (TNS-03507 failure looking for address) :-)

    Do you know when?


  5. #5
    Join Date
    Oct 2000
    Posts
    467
    is that when you change the ip address or the hostname or perhaps the host file ?
    Vinit

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    When you tnsping a service name for a non-single instance DB.


  7. #7
    Join Date
    Oct 2000
    Posts
    467
    Originally posted by julian
    When you tnsping a service name for a non-single instance DB.

    And if that service name is not in tnsnames.ora
    Vinit

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    And if that service name is not in tnsnames.ora
    :-) Right


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