Preparing for 10 g and Banner 7 2005

Preparing for 10 g and Banner 7 2005 Charles Ash Practice Director Infrastructure and Operations Services Sun. Gard SCT

Session Rules of Etiquette u u u Please turn off your cell phone/pager If you must leave the session early, please do so as discreetly as possible Please avoid side conversation(s) during the session Thank you for your cooperation! 2

Topics of Discussion/Agenda u u 10 g and Banner u Checklist for Moving to 10 g u 3 Overview Q&A

Overview

Definition of Terms u Oracle 10 g means both RDBMS and Application Server running on 10 g. n n 5 Application Server = 10 g - AS Database Management System = RDBMS in context

Differences Between 9 i And 10 g u Robust database management tools u Improved manageability n n Monitoring n Changes to installations and upgrades n 6 Tuning System management

What to Expect u u u 7 Toolset change (moving from Forms and Reports 6 i to Forms and Reports 10 g Significant UI changes No client server deployment with Forms 10 g. Additional training may be required for end users. Transparent effect concerning the API effort All product upgrades will be BIG since all forms are getting redelivered. The upgrades will be comparable to Banner 5 forms + extra APIs being delivered.

Forms 6 i u When is Oracle Forms 6 i desupported by Oracle? n n 8 Oracle forms 6 i is desupported by Oracle in January 31, 2005 There is extended support (meaning no bug fixes and patches, no certification of new operating systems, but they will provide answers and workarounds) through January 31, 2008

10 g and Banner

Banner 6 to 7 u u u 10 Toolset change. Moving from Forms and Reports 6 i Forms and Reports 10 g Going from Banner 6 to 7 is more complex because every form gets redelivered since we are moving to the oracle forms 10 g toolset. Huge UI changes across forms in banner 7. No more client server deployment with Forms 10 G. You may need to get trained on application server and trained on INB With the API effort, the effect is more or less transparent to the end user. The system will behave like banner 6 All product upgrades will be BIG since all forms are getting redelivered. The upgrades will be comparable to Banner 4 forms + extra APIs being delivered.

Infrastructure u What do you have to change and plan for (mandatory) in order to move to Banner 7. 0? n Oracle 10 G toolset – Application Server 10 G forms and reports u u 11 No client server option in Application Server 10 G If you have the concurrent user model for your Oracle licensing, you should revisit your Oracle licensing based upon a variety of new solutions regarding Banner 7. 0, Workflow, ODS / EDW, etc.

Infrastructure u Hardware and software considerations - Banner 7 Oracle Versions n INB u Oracle Forms and Reports 10 g u Can only be deployed on the web. n n n Oracle Application Server 10 g, required for Banner 7 Database u 12 With Oracle de-supporting client/server, SCT has no choice but to follow suit. SSB u n No client/server since Oracle does not support it Will require a minimum of Oracle 9 i, Release 2. Looking to support Oracle 10 g, currently testing in development, but will not require it.

Database Changes u Database Changes in Banner 7 n n n 13 Database changes are not extensive through out Banner Database changes are mostly in Banner Student for Concurrent Curricula Database changes are there for the New VBS. No conversion scripts for VBS but seed data is delivered modeled on existing VBS in Student and Financial Aid Database changes for Multiple Pidm Prevention Tables for which APIs are being created have extra columns added for Data Origin ( new column ) and Userid (if it did not exist before) Each API comprises 3 packages. So there will be a lot of new database packages delivered.

Documentation Of Database Changes u When will we know what database changes have been made in Banner 7. 0? n n 14 We will be publishing an early version of delta reports soon This will be a report by product that lists all the database changes since the last release (banner 6. x). Will be posted to Action. Web

What Is The Upgrade Process? u Given that you have no modifications, are there any differences in upgrading to Banner 7. 0, compared to prior upgrades? n Banner upgrade process similar to Banner 6. X n New toolset – Oracle application server 10 g n n 15 Internet Native Banner required – infrastructure change if client is on client/server Banner If the you elect to use the new VBS with FGAC, PII, Online multiple PIDM prevention – additional setup required.

What Is The Upgrade Process? u If you have modifications, what is the effort required to upgrade to Banner 7. 0? n n n 16 Analyze mods to forms and convert to new version and new look and feel If you intend to implement integration strategy, analyze impact of new APIs on all modified objects Banner upgrade process similar to Banner 6. X Internet Native Banner required – infrastructure change if client is on client/server Banner If elect to use the new VBS with FGAC, PII, Online multiple PIDM prevention – additional setup required

What About In-House Code? u Will existing application code need to be re-written? Examples are Plus interfaces or other third party interfaces? n n n All interfaces have to be retested when Banner 7. 0 is released Very few database table changes to core tables in Banner 7. 0 so majority of existing interfaces “should work” You may want to consider use of APIs in your existing application interfaces 17

Migration Options u What are the options of moving to Banner 7. 0? n n n 18 You will need to apply the Banner 6 upgrades (if you are on 5. x). Then you will have to apply Banner 7. When moving from 5 to 6 you will be using the Oracle Forms 6 i toolkits When moving from 6 to 7 you will have to plan on revalidating the environment or providing a second environment to support the Application Server 10 g toolkit

SCT Banner 7 u u u 19 As we speak Sun. Gard SCT is about to enter Beta testing for Banner 7. SCT Banner 7. 0 will require a minimum of Oracle 9 i, Release 2 database with JVM (Version 9. 2. 0. 3, Enterprise Edition). We will not require Oracle 10 g database for SCT Banner 7. 0.

How do we get to 10 g ? u u u 20 Internet Native Banner 6. x IS NOT and WILL NOT be certified to run on Oracle 10 g – not the RDBMS, not the Application Server. The reason for this is that Banner 6. x INB uses forms that are designed to run on forms 6 i not forms 10 g. Therefore it is incompatible with the Oracle 10 g Application Server. Self-Service Banner 6. 5 is already certified for Oracle 9. 0. 4. x (10 g - AS) This is what Sun. Gard SCT installs on new sites. If you are running on a Banner 6 version certified to run SSB on 9. 0. 4. x then upgrade your SSB i. AS server to a 10 g - AS server. That will be one less thing to deal with when you move to Banner 7.

Checklist for Moving to 10 g

Checklist For Moving To 10 g u Are you already running Banner 6 ? u u If not, you need to get there first. Are you running client-server? u u u 22 If you are, then you need to move to the web. Look into possible licensing issues. If you are running on a Banner 6 version certified to run SSB on 9. 0. 4. x then upgrade your SSB i. AS server to a 10 g - AS server. That will be one less thing to deal with when you move to Banner 7.

Checklist For Moving To 10 g u u u If both INB and SSB are running under the same Oracle Home then consider splitting them. INB and SSB should really be on two different servers. Is your Banner 6. x database running on at least 9. 2. 0. 3 ? (Because of Patch 68, you should really be at 9. 2. 0. 5. ) n n 23 If not, then upgrade to the latest RDBMS version available on your platform. Oracle 10 g database is not required or Banner 7. Once Sun. Gard SCT announces support for it, you can focus on upgrading to it.

Checklist For Moving To 10 g u u Have you remained a vanilla site? Any form that has been locally modified will have to be at the very least converted and recompiled under 10 AS and tested to verify that it is compatible with SCT Banner 7. 0. Most likely, it will not be compatible because of the extensive changes made to forms. Have you remained a vanilla site? n 24 Customized programs will have to be retested as well. You may decide to use the opportunity to rewrite them to take advantage of the APIs.

Checklist For Moving To 10 g u Is your database clean? n n 25 Conversion programs tend to work better when they have less data to deal with and when the database is internally healthy (no excess fragmentation, etc…) Goremal ( Email) table has a primary key added in Banner 7. ( Infomration announced multiple times on boracle ). Please clean up the data in this table and eliminate duplicates. There is a script available on ACtion. Web that locates possible duplicates

Questions and Answers