Thanks for the question, Wendell.
Asked: August 19, 2016 - 2:10 pm UTC
Last updated: August 20, 2016 - 7:20 am UTC
Version: 9i
Viewed 1000+ times
You Asked
We are migrating or legacy 32 9i Pro*C server code over on to a new Oracle Solaris 11 Unix and Oracle 12c server.
Can we run the legacy 32 legacy code running on the 32 bit server pointing to the new 12c database server?
Oracle will be doing the database migration from 9i 32 bit DB server to the 12c 64 DB server.
If this is possible, we can do a regression test against the DB migration.
Can we just put the legacy 32 bit code and recompile it and run it in 32 bit mode on the 64 bit server and DB?
and Connor said...
"Can we run the legacy 32 legacy code running on the 32 bit server pointing to the new 12c database server?"
Normally yes, that is, you can connect to the new database "remotely" via SQLNet, but connectivity between 9i and 12c might be a bit of stretch. If you can get your code to run with the 10g or 11g client, you'll have more luck.
"Can we just put the legacy 32 bit code and recompile it and run it in 32 bit mode on the 64 bit server and DB?"
That depends on your platform, what compilers you have, what libraries etc are installed (and available) on that platform (eg. I think some ports no longer ship the 32bit libraries at all).
My recommendation - re-link your apps with the 10g or 11g 32bit libraries and connect to 12c via SQL Net, or "swallow the medicine" and get those apps 64bit ready.
Is this answer out of date? If it is, please let us know via a Comment