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

x
?
Solved

ORA-604 in Oracle9i

Posted on 2001-09-06
3
Medium Priority
?
1,448 Views
Last Modified: 2011-09-20
Did anybody experience the following error messages in Oracle9i?
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict

The trace files do not show any helpful information.
0
Comment
Question by:orapjs01
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
ramkb earned 400 total points
ID: 6462561

Hi,

Are you running MTS on Oracle?  There is a bug related with ORA-601 on Linux.

This used to happen in 8i versions of Oracle, probably there may be a patch available for 9i.
I would suggest you to raise a TAR with Oracle support to get the appropriate patches for your environment.

Cheers,
Ramesh
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7034759
Please update and finalize this old, open question.  Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,
Moondancer - EE Moderator

P.S.  Please click your Member Profile, expand View Question History to navigate and update all your open and locked questions.
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7057572
Zero response, thus finalized.
Moondancer - EE Moderator
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question