How to track down a problem in an Oracle Application built sometime between 1999 – 2003?

Tags:
Oracle
Oracle applications
Working with an old application written by AMS back between 1999- 2003. Unfortunately as a state government we're working a database with limited resources like no access to code, etc. Now we are running into issues with users entering data with intermittent errors during data entry and/or data entered is not save. What would be the best method to track down the problem? Are using TOAD.


Software/Hardware used:
Application was built in Oracle 9 and currently being run in Oracle 11g2
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    The first step would be to identify the specific error codes you are getting.  Depending on the root cause, the solution could be on the application or the database side.
    84,805 pointsBadges:
    report
  • Maxwillalwaysberemembered
    Currently they are precompiling the Java code however I am new to Oracle and unfamiliar with what should be done to locate issues.  Nonetheless I am the application administrator and do run scripts on the backend.  Since I do use TOAD I have run several tools and have located specific errors and I have a trc file which I'm unable to read.  So I guess for my own sanity are there any simplified written procedures that could be used.  As I'm in a position that my voice in this matter does not carry much wait.  So I'm a newbie with a problem.... Nevertheless I've sent over my findings with hope that management stops running around and looks for a method to solve this issue.  It's a state government lifestyle at the expensive of the Users unable to get their real work done.    ?????
    30 pointsBadges:
    report
  • carlosdl

    What is a 'trc' file?

    What specific errors have you located?

    I doubt someone will give you a procedure you could follow as a recipe to investigate the issues, since we don't have any idea of the environment where this is happening. We just found out it is a Java application, but besides that, we are blind.

    If the application writes some kind of log, that could be a good place to start.

    Also, the DBA could review database events and logs, to see if there is something failing there.

    Operating system logs should also be reviewed.

    When the application fails, does it display some error message?

    What do you mean by 'they are precompiling the Java code'?


    84,805 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: