Need help with C app on Oracle running on Solaris 6


 
Thread Tools Search this Thread
Top Forums Programming Need help with C app on Oracle running on Solaris 6
# 1  
Old 08-20-2002
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  
Old 08-24-2002
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  
Old 08-25-2002
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 Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Solaris

what is the command to see which database ie..oracle in running on solaris 10

what is the command to see which database ie..oracle in running on solaris 10 (2 Replies)
Discussion started by: tv.praveenkumar
2 Replies

2. AIX

AIX 6.1 app running on 5.x?

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 (3 Replies)
Discussion started by: KevB
3 Replies

3. Windows & DOS: Issues & Discussions

Display running 'app' in terminal titlebar?

Hi. I was, not too long ago, an OS X home user. One of the things I remember from using the Apple-installed Terminal is: whenever an executable that took more than a split second to do its thing was running, its name would appear in the title bar in a way similar to "Terminal: ssh" or "Terminal:... (0 Replies)
Discussion started by: SilversleevesX
0 Replies

4. High Performance Computing

Installation Guide for Solaris Cluster 3.2 Software and Oracle 10g Release 2 Real App

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... (0 Replies)
Discussion started by: Linux Bot
0 Replies

5. Programming

Running app after logout and monitoring

Hello! I just programmed a very simple app, it's function is to report every minute the state of the memory and cpu and put it to and xml. All this stuff is working ok since I'm logged in into the machine, but i want it to run as a service, how can I do that?? P.S: Any one knows how can I... (1 Reply)
Discussion started by: ncatdesigner
1 Replies

6. Programming

find the fully-qualified path for the app my module is running in

Hi- I need the cpp call that will tell me the full path to the app I'm running in. For example, I'm running in a loaded library for either mozilla or firefox, but would like to know the full path to the executable /usr/bin/firefox /usr/bin/mozilla /usr/local/firefox1_5 etc... (For... (4 Replies)
Discussion started by: erwinfletch
4 Replies

7. UNIX for Advanced & Expert Users

more of an APP questions. basic oracle quesitons

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... (1 Reply)
Discussion started by: Optimus_P
1 Replies
Login or Register to Ask a Question