Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SEC_ERROR_BAD_DATABASE

807567Jul 16 2003 — edited Feb 9 2004
We are running I-Planet 6.0 SP1 using servlets and running on a Sun Blade 2000 dual CPU system




and using Solaris 9. The web application requires client certificates. Suddenly we are getting, during high volume usage, SEC_ERROR_BAD_DATABASE messages and the server has to be stopped and restarted. This is occurring on about an hourly basis during the heaviest 8-10 hours of the day, but does not occur when the load slacks off.

Any ideas or suggestions as to what to look for? We've looked at the certificates and all appears fine, and indeed it will run for a time without changes.

There seems to be no cpu, memory or process bottlenecks that we can find.

Comments

Stick

Here is an alert that we run:

SELECT distinct

a.segment1

,b.line_num

,b.need_by_date

,to_CHAR(b.creation_date, 'dd-mon-rr')

,d.email_address

,max(f.action_date)

,(trunc(sysdate) - trunc(f.action_date))

,d.Full_name

INTO

&reqnum

,&linenum

,&needdate

,&creatdate

,&email

,&appdate

,&dayswait

,&name

FROM

PO_REQUISITION_HEADERs_all a

,PO_REQUISITION_LINES_all b

,PO_REQ_DISTRIBUTIONS_all c

,hr_employees d

,po_action_history f

where

       suggested_buyer_id is not null

and b.requisition_line_id = c.requisition_line_id

and a.authorization_status = 'APPROVED'

and a.requisition_header_id = b.requisition_header_id

and suggested_buyer_id = d.employee_id

and b.source_type_code = 'VENDOR'

and a.org_id =405

and NVL(b.modified_by_agent_flag,'N') = 'N'

and b.line_location_id is null

and f.object_id = a.requisition_header_id

and f.object_type_code = 'REQUISITION'

and f.action_code = 'APPROVE'

and nvl(b.cancel_flag, 'N') = 'N' -----is null

and nvl(b.closed_code, 'N') = 'N' -----is null

and f.sequence_num = (select max(e.sequence_num)

     from po_action_history e

     where e.object_id = a.requisition_header_id

       and e.object_type_code = 'REQUISITION')    

and nvl(a.TRANSFERRED_TO_OE_FLAG, 'N') = 'N'

and (trunc(sysdate) - trunc(f.action_date)) >= 6

group by a.segment1 ,b.line_num ,b.need_by_date ,b.creation_date

,d.email_address ,f.action_date, d.full_name

order by 8,3

Hope this helps

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2004
Added on Jul 16 2003
4 comments
415 views