ignoring errors in alert log file

Posted on 2012-09-20
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

    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

    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

    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.
    LVL 1

    Author Comment

    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 14

    Expert Comment

    Please do share The code here
    LVL 1

    Author Comment

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

    the answers were not pertaining to the question .
    LVL 29

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now