Upgrading to 10g(10.1) from 8.0.6; Oracle Forms 5.0.6.8.0 and Oracle Reports 3.0.5.8.0 and Pro*C/COBOL for v8.0.4.4

pts.
Tags:
C
COBOL
Development
SQL
Tech support
Hi, We are researching upgrading to 10g(10.1) for database and Developer tools. The database is currently 8.0.6 and we use Oracle Forms 5.0.6.8.0; Oracle Reports 3.0.5.8.0; and precompile Pro*C/COBOL programs with the 8.0.4.4 environment. There appears to be quite a bit of information on the database upgrade. I am looking for Forms and Reports data as well as Pro*C and Pro*COBOL. The platform is currently AIX 4.3.3 ML11 and we will be upgrading to AIX 5.2.5 prior to the database upgrade. Would someone be able to point me to some reference materials? Are there any land mines I should be concerned with? Is this possible? Would going to 6i or 9i for Developer be an option if 10g is not? Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out this link

http://www.eweek.com/article2/0,1759,1623551,00.asp

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Vitor78
    HI, In order to migrate to AS 10g you have to check the hardware compatibility with Oracle. We stepped on one of the land mines recently - we were going to migrate from 9iAS release 1 to 10g release 1, but we run HP-UX 11.0 on a 32-bit processor, guess what.. Oracle does not support 32-bit processors for 10g... You should also upgrade your forms 5 applications to 9i. We have done it quite easily. There is a lot of articles and postings on OTN. Good luck!
    0 pointsBadges:
    report
  • Prahalski
    I can't speak to the developer tools, but I would first make sure the database upgrade is possible. You may have to upgrade first to an interim Oracle release (like 9i) before going to 10G. Oracle does not list support for 8.0.6 past AIX 4.3.3 and if you are running 64 bit Oracle, it won't even load on a 5.x system as the binaries are different. While a 32 bit build may work in AIX5, you are taking a risk. If you are planning on building a 10g instance and restoring data from a backup, check the 10g release notes to make sure of the earliest format 10G will accept. On the OS side, if you are in a clustered environment and using PSSP, you have to get to PSSP 3.4 first, then upgrade to AIX 5.1, upgrade to PSSP 3.5, then upgrade to 5.2. Since 8.0.6 has been in extended assistance for a while, I would also recommend that you get to the latest patch level (8.0.6.3.0) before you start any of the above. Good Luck!
    0 pointsBadges:
    report
  • Migrationexperts
    My suggestion will be that you should migrate your Forms / Reports / Pro*Cs to 9i using Oracle preferred migration tool Forms*Nova from www.wayne-burt.com. Then you can open / save under 10g. It works very well. There are many good references. Email your query for a whitepaper from Wayne-Burt at webmaster@wayne-burt.com
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following