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
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.
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. ?????
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'?
Discuss This Question: 3  Replies
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'?