Hi Team, We have a oracle Ds file which stops working time to time. T

gauravp over 10 years ago

Hi Team,

We have a oracle Ds file which stops working time to time. The error which user see on the screen is Details”. [Unable to connect to database: javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc/ABC].
After we redeploy the DS file datasource starts working as expected but this is not a permanent soulution for us. I have checked the maximum pool size is already set to 250. Kinldy suggest

Thanks,
...

Discussion posts and replies are publicly visible

Parents

0 rahulp over 9 years ago

Hi Ed,Alok,Stefanh

Here are the logs I received from Oracle database team :

Mon Jul 21 02:28:22 2014
Thread 1 advanced to log sequence 702
Current log# 2 seq# 702 mem# 0: /cpac/oradata/redo02.log
Mon Jul 21 07:00:19 2014
Thread 1 advanced to log sequence 703
Current log# 3 seq# 703 mem# 0: /cpac/oradata/redo03.log
Mon Jul 21 15:00:28 2014
Thread 1 advanced to log sequence 704
Current log# 1 seq# 704 mem# 0: /cpac/oradata/redo01.log
Mon Jul 21 21:45:02 2014
alter database backup controlfile to trace
Mon Jul 21 21:45:02 2014
Completed: alter database backup controlfile to trace
Mon Jul 21 23:00:43 2014
Thread 1 advanced to log sequence 705
Current log# 2 seq# 705 mem# 0: /cpac/oradata/redo02.log
Tue Jul 22 03:00:14 2014
Thread 1 advanced to log sequence 706
Current log# 3 seq# 706 mem# 0: /cpac/oradata/redo03.log
Tue Jul 22 09:00:16 2014
Thread 1 advanced to log sequence 707
Current log# 1 seq# 707 mem# 0: /cpac/oradata/redo01.log

@ Ed - Also the I want to specify the database we are facing issue with is a secondary database. Do we need to add the line(mentioned in your comment above) to the DS file of this DB or to the primary primary ds?

Thanks,
Rahul
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rahulp over 9 years ago

Hi Ed,Alok,Stefanh

Here are the logs I received from Oracle database team :

Mon Jul 21 02:28:22 2014
Thread 1 advanced to log sequence 702
Current log# 2 seq# 702 mem# 0: /cpac/oradata/redo02.log
Mon Jul 21 07:00:19 2014
Thread 1 advanced to log sequence 703
Current log# 3 seq# 703 mem# 0: /cpac/oradata/redo03.log
Mon Jul 21 15:00:28 2014
Thread 1 advanced to log sequence 704
Current log# 1 seq# 704 mem# 0: /cpac/oradata/redo01.log
Mon Jul 21 21:45:02 2014
alter database backup controlfile to trace
Mon Jul 21 21:45:02 2014
Completed: alter database backup controlfile to trace
Mon Jul 21 23:00:43 2014
Thread 1 advanced to log sequence 705
Current log# 2 seq# 705 mem# 0: /cpac/oradata/redo02.log
Tue Jul 22 03:00:14 2014
Thread 1 advanced to log sequence 706
Current log# 3 seq# 706 mem# 0: /cpac/oradata/redo03.log
Tue Jul 22 09:00:16 2014
Thread 1 advanced to log sequence 707
Current log# 1 seq# 707 mem# 0: /cpac/oradata/redo01.log

@ Ed - Also the I want to specify the database we are facing issue with is a secondary database. Do we need to add the line(mentioned in your comment above) to the DS file of this DB or to the primary primary ds?

Thanks,
Rahul
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data