DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: ORA-12542 Error

  1. #1
    Join Date
    Mar 2001
    Posts
    23

    Unhappy ORA-12542 Error

    I can connect to my database fine with no error. However, one of our applications keep giving this ORA-12542 TNS: Address already in use error once in a while. The application can return data with no problem sometimes but this error message comes up quite often. I have checked the Listener Log and the Listener Trace file, and i don't see any error in either. Is there any way I can further diagnose this problem? Thanks!!


    Below is the last entries from the Listener.log:
    (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Test1.TestC1)(CID=(PROGRAM=c:\windows\system32\inetsrv \w3wp.exe)(HOST=TestC1)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=12.59.245.18)(PORT=3679)) * establish * Test1.TestC1 * 0
    06-JUL-2005 12:59:06 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Test1.TestC1)(CID=(PROGRAM=c:\windows\system32\inetsrv \w3wp.exe)(HOST=TestC1)(USER=NETWORK?SERVICE))) * (ADDRESS=(PROTOCOL=tcp)(HOST=12.59.245.18)(PORT=3682)) * establish * ATR1.ATRC1 * 0
    06-JUL-2005 12:59:06 * service_update * ATR1 * 0
    06-JUL-2005 12:59:45 * service_update * ATR1 * 0

    Below is the last few line from the listener.trc:
    [06-JUL-2005 12:59:06:468] nsbeqaddr: handshake is complete; redirecting
    [06-JUL-2005 12:59:06:468] nscon: sending NSPTRD packet
    [06-JUL-2005 12:59:06:468] ntt2err: soc 276 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0
    [06-JUL-2005 12:59:06:468] nstimarmed: no timer allocated
    [06-JUL-2005 12:59:06:484] ntt2err: soc 276 error - operation=5, ntresnt[0]=530, ntresnt[1]=995, ntresnt[2]=0
    [06-JUL-2005 12:59:06:484] nsclose: closing transport
    [06-JUL-2005 12:59:06:484] nsclose: global context check-out (from slot 5) complete

  2. #2
    Join Date
    Mar 2003
    Posts
    38
    Is it a Java application?

    Nathan

  3. #3
    Join Date
    Mar 2001
    Posts
    23
    No, it's a .NET web application.

  4. #4
    Join Date
    Mar 2003
    Posts
    38
    What is your version of Oracle? I'm not fmailliar with .NET. Are you using ODBC to connect?

    Nathan

  5. #5
    Join Date
    Mar 2001
    Posts
    23
    It's Oracle 9i (9.2.0.6.0) using Oracle OLEDB and ODP.NET.

  6. #6
    Join Date
    Mar 2003
    Posts
    38
    Note:252614.1 on Metalink refers to this. It has something to do with Garbage Collection within your application.

    Is your application developed using VB or C#?

    Nathan

  7. #7
    Join Date
    Mar 2001
    Posts
    23
    C# with ASP.NET.

    Thanks!

  8. #8
    Join Date
    Mar 2003
    Posts
    38
    Do you have access to Metalink?

    Nathan

  9. #9
    Join Date
    Mar 2001
    Posts
    23
    Yes, I found the article, I'll take a look to see if this is cauing the problem. Thanks for the link!

  10. #10
    Join Date
    Mar 2001
    Posts
    23
    We are actually doing what the article suggested. . .

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