ignoring errors in alert log file

Posted on 2012-09-20
Medium Priority
Last Modified: 2013-05-01
I have Oracle version database.
I am consistently getting the following error:
ORA-03137: TTC protocol internal error

When ever we get a error in the alert log it sends out a message, the users are ignoring it.
Is there a way to put something in the script that checks the alert log so it can skip or avoid this message.

Would appreciate your response,
thanks .Gyans
Question by:gyans
LVL 28

Accepted Solution

Naveen Kumar earned 668 total points
ID: 38420727
My view is why are you getting this error in the alert.log of the database. Can the dba team not help to fix the error for you ?
LVL 16

Assisted Solution

by:Richard Olutola
Richard Olutola earned 668 total points
ID: 38420985
The best thing is to investigate the error and resolve the problem.

If you do decide to ignore an error alert then you will need to code that into your script. I don't know which script you're referring to. If this is some kind of shell script then just amend it to ignore that particular error code.

Do you not have access to the code?
Do you know who wrote the code?

LVL 29

Assisted Solution

MikeOM_DBA earned 664 total points
ID: 38421897
ORA-03137: TTC protocol internal error
This error can be ignored (check it out in Oracle Support).
When ever we get a error in the alert log it sends out a message,  the users are ignoring it.
Who originates the message? DB Console? Grid Control? If any of these, then just change the eMail notification address so the users do not get the error, otherwise, if it's a custom script,  change the script to ignore the message.

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 38428786
I have access to the code.
I am a new DBA, the error is coming from a package written by the user.
If I send you the code can you help me rewrite it to ignore the error.
He is not fixing it.
So I was trying to ignore it.
LVL 13

Expert Comment

ID: 38439495
Please do share The code here

Author Comment

ID: 39106027
I've requested that this question be deleted for the following reason:

the answers were not pertaining to the question .
LVL 29

Expert Comment

ID: 39106028
The question was: "Is there a way to put something in the script that checks the alert log so it can skip or avoid this message."
But the OP did not post any "script" or any information related to such script.
Therefore the answer were pertinent to confirming that it was alright to ignore the error messages.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

807 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