The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > High Level Programming
Google UNIX.COM


High Level Programming Post questions about C, C++, Java, SQL, and other programming languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
High CPU activity running Oracle stocksj UNIX and Linux Applications 4 08-14-2008 07:00 AM
how to capture oracle export log while running as background process hippo2020 SUN Solaris 4 07-03-2007 11:39 AM
Jobs scheduled in crontabs are not running after a migration to oracle 9i alexcol UNIX for Advanced & Expert Users 4 03-27-2007 07:35 PM
Running Solaris Sparc Apps on X86 Solaris stocksj UNIX for Dummies Questions & Answers 1 12-12-2006 02:13 PM
skgpspawn failed running oracle db 9.2.0.5.0 on aix 5.3 hawkerpacific Filesystems, Disks and Memory 0 10-25-2005 01:37 AM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 08-20-2002
Registered User
 

Join Date: Aug 2002
Posts: 4
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
Reply With Quote
Forum Sponsor
  #2  
Old 08-24-2002
Neo's Avatar
Neo Neo is offline
Administrator
 

Join Date: Sep 2000
Location: Asia Pacific
Posts: 4,466
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.
Reply With Quote
  #3  
Old 08-24-2002
Registered User
 

Join Date: Aug 2002
Posts: 4
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
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 09:53 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0