Running 9.2 compiled applications on a 10g server

Hello,

I have a number of Pro*C applications that were compiled on an AIX machine with Oracle 9.2, and are now expected to be used on a newer AIX machine with 10g.

Does anyone know how to get it running? We used to run Oracle 7 compiled applications on 8i by setting the TWO_TASK environment variable, thus making the application connect to the DB via SQL-Net even although both run on the same machine, and by copying the Oracle 7 libclntsh.a file to the 8i machine. This worked perfectly in 8i but seemingly doesn't in 10g. The applications run, can connect to the DB, and some commands (like INSERT and SELECT COUNT(*)) work, but other commands (like SELECT *) fail with ORA-03115, ORA-03106, or with a memory fault. Any ideas what environment variables have to be set, or what files from the 9.2 installation have to be copied to the 10g machine, to make the applications run fine?

Thanks for any help
W. Rösler Received on Mon Aug 15 2005 - 03:38:04 CDT