BizTalk Utilities Xselerator XSLT IDE


Forum main page

Most active member

Login/out

Login page
Register
Log out

Search

Search page


Information Online

Events

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Your details

Profile editing page
Subscription list page
Address book page

Membership info

Member list page
View the most active member
User groups listing
Private message page
TopXML Discussion Forum TopXML Discussion Forum

Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

ORA-20:maximum number of processes (%s) exceeded

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> ORA-20:maximum number of processes (%s) exceeded Page: [1]
Login
Message << Older Topic   Newer Topic >>
ORA-20:maximum number of processes (%s) exceeded - 16 February 2007   
kmfinley

 

Posts: 15
Score: 0
Joined: 3 July 2006
Status: offline 		It appears that the Adapter or something is holding database connections open after the processing is completed.  I have confirmed with our DBA that this error occurs when there are more than 100 connections open at one time.  The send Port has Pooling set to TRUE and the Receive Location has a Connection Timeout of 30seconds.  Is there somewhere else to look ??

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Receiver
Event Category: None
Event ID: 0
Date:  16/02/2007
Time:  8:31:51 AM
User:  N/A
Computer: S116V504
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
  String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Oracle Data Provider for .NET/wkmWarpLogs/wkmWarpLog'
Oracle.DataAccess.Client.OracleException
ORA-20: maximum number of processes (%s) exceeded"
  Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
  }
  String ErrorCode = ""
  Int32 Severity = 0
  Int32 ProcessID = 3980
  String ProcessName = "d:\Program Files\Microsoft BizTalk Server 2004\BTSNTSvc.exe"
  String ThreadName = ""
  ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
  }
  WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "DEGT\btutr_str"
     String ProcessAccountName = "DEGT\btutr_str"
  }
  ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
  }
  String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Receive.EndPoint.Interval()
at BTSUtils.Core.Adapters.Receive.EndPoint.Base.Interval(Object State)"
  String EventSourceInstance = "f836bb05-8b79-4632-a7ab-56f88e353b11"
  String EventSourceName = "BizTalk Utilities Adapter for Databases Receiver"
  Int64 EventSequenceNumber = 18
  String EventSchemaVersion = "2.0.171.0"
  DateTime TimeStamp = 2/16/2007 8:31:51 AM
  String AppDomainName = "DefaultDomain"
  String MachineName = "S116V504"
  String RootRequestName = ""
  String RootRequestInstance = ""
  String RequestInstance = ""
  String RequestName = ""
  Int64 RequestSequenceNumber = 0
  Int32 EventLogEntryTypeID = 1
}
Post #: 1
RE: ORA-20:maximum number of processes (%s) exceeded - 16 February 2007   
kmfinley

 

Posts: 15
Score: 0
Joined: 3 July 2006
Status: offline 		I have a bit more information to provide on this issue.  Can you tell me if we need to make a configuration change on our receive port so that we can get rid of these connections when they are not in use.  Our Biztalk Database and Application server were rebooted this morning.  After about 5 hours there are around 75 Biztalk connections on this Oracle database.  See list below.  These are inactive connections, however count toward the maximum.













Row #
PID
USERNAME
OSUSER
STATUS
PROGRAM
SID
SRL#

1617
1188092
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
2829
14263

3233
1356006
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
4445
21203

4849
1712150
AMFMRM
kjsmith2
INACTIVE
SQLNav5.exe
82
18381

6465
1749026
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
7677
12906

8081
1916956
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
9293
11053

9697
1933504
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
108109
13015

112113
2068584
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
124125
16446

128129
2117662
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
140141
15978

144145
2130108
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
156157
18648

160161
2138172
ALLI
msinnet
INACTIVE
oracle@chodev60 (TNS V1-V3)
172173
17030

176177
2183200
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
188189
16768

192193
2195694
WKMGMT
SYSTEM
INACTIVE
rmbridgesendservice.exe
204205
10135

208209
2203752
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
220221
14006

224225
2216164
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
236237
11538

240241
2256966
AWORKS
SYSTEM
INACTIVE
beans_adapter_svc.exe
252253
254255

256257
2302186
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
268269
12882

272273
2588898
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
284285
14544

288289
2666566
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
300301
10087

304305
2715772
AWORKS
kmfinley
ACTIVE
SQLNav4.exe
316317
11572

320321
3182664
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
332333
12598

336337
3624994
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
348349
9475

352353
3878988
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
364365
10633

368369
3911906
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
380381
21324

384385
3956936
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
396397
12084

400401
4112462
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
412413
10895

416417
4132940
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
428429
9088

432433
4141096
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
444445
10064

448449
4153512
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
460461
14437

464465
4182218
WKMGMT
SYSTEM
INACTIVE
rmbridgereceiveservice.exe
476477
13670

480481
4194494
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
492493
10368

496497
4210818
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
508509
12801

512513
4218918
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
524525
14975

528529
4317238
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
540541
13620

544545
4362262
WKMGMT
phummel
INACTIVE
SQLNav4.exe
556557
10715

560561
4366424
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
572573
12942

576577
4370682
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
588589
19442

592593
4374628
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
604605
14314

608609
4378766
AWORKS
kmfinley
INACTIVE
SQLPLUSW.EXE
620621
21749

624625
4386882
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
636637
18052

640641
4395102
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
652653
13660

656657
4452468
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
668669
11152

672673
4481134
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
684685
17054

688689
4530430
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
700701
16409

704705
4534472
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
716717
18357

720721
4567232
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
732733
11702

736737
4640854
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
748749
10514

752753
4649002
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
764765
16531

768769
4661474
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
780781
11008

784785
4673738
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
796797
13655

800801
4694200
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
812813
14035

816817
4714628
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
828829
23177

832833
4751492
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
844845
20875

848849
4763758
BIZTALK
btuts_str
INACTIVE
BTSNTSvc.exe
860861
8483

864865
4837590
BIZTALK
btuts_str
INACTIVE
BTSNTSvc.exe
876877
19958

880881
4870264
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
892893
16826

896897
4874298
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
908909
15107

912913
4882468
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
924925
13163

928929
4898946
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
940941
15589

944945
4931726
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
956957
10188

960961
4960460
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
972973
15677

976977
4997138
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
988989
11708

992993
5005452
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
10041005
11777

10081009
5030076
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
10201021
14696

10241025
5054624
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
10361037
6400

10401041
5062690
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
10521053
11217

10561057
5070888
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
10681069
12778

10721073
512048
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
10841085
11155

10881089
5140570
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11001101
19615

11041105
5148900
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11161117
14717

11201121
516244
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11321133
8632

11361137
5169210
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11481149
12244

11521153
5173466
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11641165
9561

11681169
5202054
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11801181
14039

11841185
614644
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
11961197
11413

12001201
655386
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
12121213
11440

12161217
675904
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
12281229
9290

12321233
712720
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
12441245
11673

12481249
823464
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
12601261
15889

12641265
983060
BIZTALK
btutr_str
INACTIVE
BTSNTSvc.exe
12761277
12298

(in reply to kmfinley)
Post #: 2
RE: ORA-20:maximum number of processes (%s) exceeded - 16 February 2007   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		What is your connection pooling seetings on the Receive Port?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to kmfinley)
Post #: 3
RE: ORA-20:maximum number of processes (%s) exceeded - 19 February 2007   
kmfinley

 

Posts: 15
Score: 0
Joined: 3 July 2006
Status: offline 		Hi Pieter,

We are using version 4.0.5 and here is the Pooling configuration.  What happens if we hit the Max Pool Size, does it start to reuse connections??  Maybe this is where I need to make the adjustment?
Connect Lifetime 0
Decr Pool Size 1
Incr Pool Size 5
Max Pool Size 100
Min Pool Size 1
Pooling True
thanks
Karen

(in reply to kmfinley)
Post #: 4
RE: ORA-20:maximum number of processes (%s) exceeded - 25 February 2007   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		You max pool size is set to 100, you will need to reduce this. Also look at the Connection Lifetime setting and set this to a time value.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to kmfinley)
Post #: 5
RE: ORA-20:maximum number of processes (%s) exceeded - 20 March 2007   
kmfinley

 

Posts: 15
Score: 0
Joined: 3 July 2006
Status: offline 		Hi Pieter,

Can you give some more information around the Incr Pool Size and Decr Pool size properties?  I think we want 1 pool of a maximum of 20 connections that get reused, however we are having trouble finding the optimal numbers to set in the following properties.

Here are the current Connection Pooling properties and the default settings.  I have made changes to the Connection Lifetime and set it to 20 and changed the Max connections to 20 as well. 

Connection Lifetime 0
DecrPoolSize 1
Incr Pool size 5
Max Pool Size 100
Min Pool size 1
Pooling true
Connection Timeout 15

Any additioanl documentation on this would be great.

thanks
Karen

(in reply to Pieter)
Post #: 6
RE: ORA-20:maximum number of processes (%s) exceeded - 22 March 2007   
Pieter

 

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline 		According to the Oracle Documentation it is the following:





Decr Pool Size
1
Number of connections that are closed when an excessive amount of established connections are unused.




Incr Pool Size
5
Number of new connections to be created when all connections in the pool are in use.
This connection string attribute determines the number of new connections that are established when a pooled connection is requested, but no unused connections are available and Max Pool Size is not reached. If new connections have been created for a pool, the regulator thread skips a cycle and does not have an opportunity to close any connections for 6 minutes. Note, however, that some connections can be still be closed during this time if their lifetime has been exceeded.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to kmfinley)
Post #: 7
Page:   [1]
All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> ORA-20:maximum number of processes (%s) exceeded Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



Email TopXML

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.108