Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g :

pts.
Tags:
ERP
Oracle
Oracle 8i
Windows 2000 Server
Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g : Current Environment : Operation System : Window NT4.0 Oracle : 8i (8.1.7) Developer 2K : Forms 6.0.5.33.0, Report 6.0.5.33.0 We have ERP System in house Developed. Everything working fine. Now we want to Migrate Oracle 8i (8.1.7) to Oracle 10g. For testing purpose, We have downloaded Oracle 10g from Oracle site. Installed Oracle 10g on Other Computer. Migrate Database using Export / Import from Oracle 8.1.7 to 10g. Completed Installation and database migration successfully. My ERP application running successfully. Now if i made any changes in my any Forms (6.0.5.33.0) and compile it / or just recompile (without any changes) any forms , it gives following error Code. " ora-00600 internal error code, arguments [17069], [39843448],[],[]... Error due to accessing of synonyms. " In any schema, if we use following code in form , it will not compile. e.g Declare a date; begin select sysdate into a from dual; end; but above code will run correctly in sqlplus of any version (8.0.5, 8.1.7, 10.1.0). We have also tried to solve above problem by droppeing synonymes and recreate it. But the problem remains same. So Please advice me whether Oracle 10g and Forms (6.0.5.33.0) is compatible or not. Give me Solution as early as possible. So that we can take decision to purchase Oracle 10g.

Answer Wiki

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

Oracle Forms 6i on NT over a 10G database is definately not supported and has never been certified.

Forms 6i itself, as a product, was desupported on 1st January 2005.

Whilst there was some inter-operabilty between Forms 6i and AS/DB 9i you will need to lift your forms to 9/10 to work with a 10G database.

SQLplus has not changed greatly over the years and it’s no suprise that an 8i version would continue to work with 10G
as the plus bits are local and the SQL bits are mostly ANSI standard.

As far as compiling Forms is concerned, the compile process has a dependency on objects outside of the Forms Tool ( ie server objects ), and these objects will have radically changed from 8i to 10g – I belive that is the crux of your problem.

Regards
JJ

Discuss This Question: 2  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
  • Annbuck
    You could patch your forms to 6.0.8. We run forms 6.0.8 successfully against 9.2 database. You probably ought to migrate to Forms 9i to run against the 10g database. They are the matching pair. You need to check this with Oracle Support.
    0 pointsBadges:
    report
  • Swatis
    Thanks to all for giving positive response. Just for your information, We have Compile our forms and reports in forms 6i (6.0.8.25.2) using patch 16. Also we have done minor modification in forms and reports and it's working ok with 10g. So now we can use forms 6i with oracle10g. Swati
    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