Support of Oracle 8 and 9i

pts.
Tags:
Oracle
Oracle 8i
Oracle 9i
We currently support several systems running Oracle 8 that are upgrading to 9i. From a support perspective, can someone help me identify any key differences that might need special attention the my Oracle 8 experience does not cover? Thank you.

Answer Wiki

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

Are speaking in terms of what might be new in Oracle9i, what might have worked in Oracle8 but not in Oracle9?

Discuss This Question: 4  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
  • 17051966
    Your question is quite open ended and vague and, therefore, difficult to answer precisely. Oracle 9i offers a large number of features that are not available in Oracle 8 or 8i. Look at the following book - Robert Freeman - Oracle 9i New Features, Oracle Press, 2002 One major difference between 8 and 9i is that 9i does not support the Server Manager, SQLPLUS INTERNAL or CONNECT INTERNAL. This may require changes in several scripts depending on how extensively you use these options. You can replace SQLPLUS INTERNAL with SQLPLUS "/ as sysdba" under 9i. The quotation marks are a part of the syntax.
    0 pointsBadges:
    report
  • Catalysttx
    Wow, that's a really broad question. I'd go out to metalink and read some of the new features papers. You are definitely going to want to use some of the new features like undo segments and other performance improvements, and there were neat new functionality extensions for developers. Something for everyone....have a peek at the docs/white papers. Lyn, in the middle of 9i upgrades herself
    0 pointsBadges:
    report
  • Oconnra
    We did our 8i to 9i upgrade last year. We increased the size of the System tablespace to 300 meg. It is using 160 meg with the additional Java objects. We also took advantage of the SPFILE feature so we can dynamically change some of the database parameters. We have implemented Locally managed tablespaces in many of our databases and we are currently trying out the UNDO tablespace in place of REDO. I agree with the recommendation to get the New Features book or if you have training dollars, take the New Features class from Oracle.
    0 pointsBadges:
    report
  • Smeagol
    I'd recommend that you do a full regression test of your application; always a good move when doing a major database upgrade. It A) identifies places where the application code no longer works quite as it used to, and B) gives some degree of confidence around the upgrade, so that the database isn't blamed for everything which goes wrong post-upgrade!! Thinking back to our own experiences of 9i upgrades, they've been smooth in general, but we did have some funnies in our data warehouse with materialized views which were solved by recompiling them.
    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