Need help with C app on Oracle running on Solaris 6


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
Need help with C app on Oracle running on Solaris 6

Hello,

I would really appreciate some help with a problem my current client is having. He has an old legacy app that does his company's financial accounting and ERP for manufacturing, etc. The app was written by a company called "Just in time" in Austin, TX, and they are no longer in business.

The app was running on a Sparc20 running SunOS 5.4 with Oracle on the backend before the system lost its root drive and crashed. They subsequently moved the Oracle and app to a Sun E450 running Solaris 6. The oracle was reinstalled, etc. They copied all the directories and filesystems they could from the old machine to the new. The app runs fine for the most part.

The app is mostly made up of C files created with a Pro*C compiler, and shell scripts which call some of these programs to do automated tasks such as invoice printing, etc. The shell scripts are mainly run via cron once a day. The problem is, the programs called via the shell scripts are not working anymore. They have not worked since moving to the new box. They don't even work on the old machine, anymore. The app does work fine interactively, though, and they are able to use the SAME C program modules called by the shell scripts, to do their work from the main app.

I have been trying to debug just ONE of the programs called by a shell script. One of the parameters passed to the C program is the term type, in this case, vt220. The app has its own termcap sort of file to look up the term type passed to it. vt220 exists in the file. However, the program dies at some point with an error message saying that it wasn't able to find the CRT from its file. Here is the error:

* Error From CIMJIT...Invalid CRT Specified:
Unable to Locate Entry in CRT File: nf_tcl
Press <Return> to Continue

Note that there is nothing after the "invalid CRT specified:" part. It should print whatever value it got for the CRT or term. I have recompiled the program with some debugging printf statements for the args to main. The C program called by the script also calls functions in other C programs. I have only been able to go to one other file before the program dies with this error. It's not easy to explain all of this without actually going thru the app like I have, but I am trying to explain the main points.

If anyone can provide some input or help, I'd really appreciate it. One thing I have thought about is the difference between SunOS5.4 and Solaris 6, ie SunOS 5.6. I think I have all the source and make files and am trying to compile the whole app on the new machine from scratch. It's not very helpful without all the documentation etc. I have also tried running truss on the shell script. I see a few ENOTTY errors on ioctl calls but that's about it.

Any help would be greatly appreciated. Thanks.

Salman
# 2  
My suggestion would be to first rebuild the system using the original OS on the new hardware..... and then after that is up and running well, consider an OS upgrade.

It is really 'too much work' to try to mend and upgrade a crashed app AND OS, all at once.... baby steps..... first simply rebuild the app without changing the OS version.
# 3  
That is a wise suggestion, and what I would have done under "normal" circumstances. However, I was hired for a couple of weeks and asked to fix this problem, which wasn't really what I was told in the interview. Anyways, I did manage to fix it. Not just this one but another one they dumped on me after I got this one. The IT manager wasn't kidding when he said, "Congrats! You seem to have found the needle in the haystack!" Anyways, all's well that ends well, I guess. Thanks for your response.

Salman
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
what is the command to see which database ie..oracle in running on solaris 10
tv.praveenkumar
what is the command to see which database ie..oracle in running on solaris 10... Solaris
2
Solaris
AIX 6.1 app running on 5.x?
KevB
Hi, A quick question. If I build an application on AIX 6.1 TL3 using XL C/C++ 8.0 and Oracle 10g, can I then take those binaries and run them on AIX 5.3 and previous? Regards Kevin... AIX
3
AIX
Installation Guide for Solaris Cluster 3.2 Software and Oracle 10g Release 2 Real App
Linux Bot
Here are steps for installing the Solaris 10 11/06 OS, Solaris Cluster (formerly Sun Cluster) 3.2 software, QFS 4.5, and Oracle 10gR2 RAC. Also provided are instructions on how to configure QFS and Solaris Volume Manager for use with Oracle 10gR2 RAC. More...... High Performance Computing
0
High Performance Computing
more of an APP questions. basic oracle quesitons
Optimus_P
1) how is a hot backup performed. i am thinking it does 1 of 2 things. 1) it exports the db and then you backup the exported files. OR 2) you just backup the files on disk as teh db is running. i dont need to know HOW it is done. but just the basic concept of a hotbackup. i cant find it...... UNIX for Advanced & Expert Users
1
UNIX for Advanced & Expert Users