• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • Last Modified:

Production problems

Windows server 2008 64bit

1 oracle 11g 64bit on server 2008
2 vs2010 c# on VM
3 ODTwithODAC112030 32 bit i think
4 win64_11gR2_client

Six projects one web in solution.
run run fine in vs2010 but not in production fails after 5 calls ora-12520

Can not set to shared server in oracle set as dedicated

Need help why wont it run in production?
  • 8
  • 7
  • 2
1 Solution
slightwv (䄆 Netminder) Commented:
Based on the error:

Is the production database listener listening for the service the web code is connecting to?

From the database server command prompt: lsnrctl status
vbytesdcAuthor Commented:
LSNRCTL for 64-bit Windows: Version - Production on 17-SEP-2012 13:32:58

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MAIN64.vbytes.local)(PORT=1521)))
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version - Production
Start Date                13-SEP-2012 15:54:36
Uptime                    3 days 21 hr. 38 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\MAIN64\listener\alert\log.xml
Listening Endpoints Summary...
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SASTOCKSXDB" has 1 instance(s).
  Instance "sastocks", status READY, has 1 handler(s) for this service...
Service "sashared" has 1 instance(s).
  Instance "sashared", status READY, has 2 handler(s) for this service...
Service "sastocks" has 1 instance(s).
  Instance "sastocks", status READY, has 1 handler(s) for this service...
The command completed successfully

this is run on the oracle server machine not the web server
slightwv (䄆 Netminder) Commented:
Is the web app trying to connect to either sashared or sastocks?

Can you post the connect string for one of the apps that is generating the ora-12520?

The "after 5 calls" is suspicious.  Even though 5 calls isn't a lot, are you sure the app is closing connections after it is done with them?  I also always dispose of them just to make sure.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

vbytesdcAuthor Commented:
connecting to sashared 64bit web server  
sastocks 32bit web server

samain64 is oracle 64bit server

Working on sashared, open and close conn each time.

thanks dave
slightwv (䄆 Netminder) Commented:
I'm not sure I understand that post.  The listener is showing it is listening for connections for two database instances:  sashared and sastocks.

You posted those are web servers.  This is what confuses me.

What is the database name or names on MAIN64.vbytes.local the apps are trying to connect to?
vbytesdcAuthor Commented:
web server 1 uses sastocks 32bit also not working but moving out  saweb
web server 2 user sashared 64bit saweb64

oracle server 64bit  main64 two instances sastocks and sashared 64bit
slightwv (䄆 Netminder) Commented:
Am I to take from this that none of the web servers can make more than 5 calls to either database?
vbytesdcAuthor Commented:
Reload servers and changed servers

web server 64bit  
db server 64bit

Had to change sqlnet.ora to NONE from NTS.

Again works in test running in vs2010
 (rel or debug)
Now times out after a few calls

Is there any way to trace calls?
thanks Dave
slightwv (䄆 Netminder) Commented:
Before you start tracing:  What is the processes parameter set to in the database?

Try increasing it.  For grins, double it and see if it stays at 5 calls before it fails.

You might also think about contacting Oracle Support directly.  They would probably have the best advice on where to start troubleshooting this one.

There are many ways to trace in Oracle.  I'm honestly not sure where to start.  It seems like a listener issue so maybe there:

While you look into that, I'll reach out to a Top .Net Expert on the site to see if they can jump in.
Bob LearnedCommented:
1) Does this limit of 5 calls apply to any mix of database calls, or the same one 5 times?  

2) IIS version?

3) Application pool settings (32 bit or 64).

4) Start the Task Manager, and make sure that the IIS worker process (w3wp.exe) is running as 64-bit (suffix = *32) for 32-bit processes.

5) I believe that you should double-check the ODP.NET version.  The file should be in the "new GAC", which is under the C:\Windows\Microsoft.NET\Assembly\GAC_64.  I have problems with some of the newer 11.3 ODP.NET versions (I use a 11.2 version).
vbytesdcAuthor Commented:
It's failing and causing a continuous loop. Just need to do a lot more testing .

I Think
Bob LearnedCommented:
Are you getting this issue with a single database call, or every one?  Is this a code issue, or a DBMS issue?
vbytesdcAuthor Commented:
Yes it is looking more and more as a code issue on my side. still testing thanks
vbytesdcAuthor Commented:
Found it. Connections were not being closed in some cases

thanks for the help
vbytesdcAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for vbytesdc's comment #a38442937

for the following reason:

Found it
slightwv (䄆 Netminder) Commented:
Didn't I reference closing the connections as a potential cause in http:#a38407504 ?
slightwv (䄆 Netminder) Commented:
Suggest accept: http:#a38407504


I also strongly suggest you physically dispose of the connections as well and not rely on cleanup to get rid of them.  I've seen issues in the past where Oracle would continue to see those connections as active.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 8
  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now