-
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
-
Is it a Java application?
Nathan
-
No, it's a .NET web application.
-
What is your version of Oracle? I'm not fmailliar with .NET. Are you using ODBC to connect?
Nathan
-
It's Oracle 9i (9.2.0.6.0) using Oracle OLEDB and ODP.NET.
-
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
-
-
Do you have access to Metalink?
Nathan
-
Yes, I found the article, I'll take a look to see if this is cauing the problem. Thanks for the link!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|