Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1832
  • Last Modified:

err msg in bdump

Hi experts,

Today I got a err msg in bdump in my oracle 10g DB as follows:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*** SERVICE NAME:(SYS$BACKGROUND) 2008-06-10 23:35:21.574
*** SESSION ID:(549.1) 2008-06-10 23:35:21.574
*** 2008-06-10 23:35:21.574
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01461: can bind a LONG value only for insert into a LONG column
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

How can I go into detail to check which recursive SQL statement having problem?

Best Regards,
Ken

0
kentanga
Asked:
kentanga
  • 2
1 Solution
 
schwertnerCommented:
This seems to be a bug.
To see details look in the trace (.trc).
Possibly you find there the SQL involved in this error
and decide if this is a bug or application error.
0
 
kentangaAuthor Commented:
Thanks Schwertner,

I checked the trace files of smon and I could not find out more relative and detail information. Should I check it in metalink for possible known bug recorded in oracle?

Regards,
Ken

0
 
schwertnerCommented:
What is the version of 10g?
If it is Release 1 migrate to Release 2.
If it is Release 2 upgrade to 10.2.0.4
Visit in metalink will not hurt, but upgrade
is the best way.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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