Transcript Lesson 3

Upgrading SCT Banner
Upgrading SCT Banner


The process of maintaining SCT Banner involves
frequent upgrades for both enhancement and error
correction purposes
These tasks will involve using:

ActionWeb

Patches

Upgrades
2
ActionWeb - Services


ActionWeb is SCT's web site for:

Information on the SCT Banner products

FAQs

Finding information on defects

Finding and downloading patches

Entering technical request contacts
You must be a valid SCT customer
3
ActionWeb - Account


Requires setting up an account

Specific username and password

Uses reverse IP lookup
To set up an account:

Start at http://www.sct.com

Click on Client Support


In the ActionWeb Users box, click where prompted ("If
you do not have a valid User ID and Password, then Click
Here to continue.").
Click the ActionWeb FAQs link below, if needed
4
ActionWeb - Options


After logging into the account, the ActionWeb
home page displays several options
On the main page there are entries for:

Recent News

Instructions for downloading patches

How to sign up for SCT listservs

SCT Banner Release Schedule

SCT Banner FAQs
5
ActionWeb - Menus

On the left side of the main page are a set of
menus:

Profile - This is your personal profile

Contacts - Contacts opened by your institution

Extended Search - Extensive search of the SCT databases

Known Issues - Defect searches

FAQs - Various SCT Banner FAQs

Upgrades - Request SCT Banner documentation and upgrades
6
ActionWeb - Support

ActionWeb is one of the available avenues to
report SCT Banner problems



ActionLine is also available
Both ActionWeb and ActionLine go into the same
helpdesk pool
ActionMail
7
SCT Banner patches and
upgrades


Except for major upgrades, most enhancements and
patches will be downloaded off the ActionWeb
As issues are resolved and error corrections developed,
these fixes will be bundled into patch sets and posted on
the ActionWeb's electronic download site

These patch sets are compressed and encrypted

Must use a special program to decrypt (edread)
8
Finding patches



The first step is to use the Known Issues search
engine to locate defect and associated patch
numbers
New patch postings are also broadcast on the SCT
listserve BPOST
Once the proper patches are located, invoke the
download gadget to retrieve them
9
Downloading patches



There is a web gadget that allows for easy
packaging and downloading of patches and the
decryption program
Follow the directions on the main ActionWeb page
for downloading patches to set it up
Set up a directory structure to download and
decompress/decrypt these patches
10
Installing patches


Once the patch is downloaded, decompressed,
and decrypted, review the install instructions
Most downloads involve new software or database
objects, which will need to be:

Migrated to proper software directory

Compiled as needed

Installed into the database as needed
11
Managing patches



Patch management is one of the most challenging
of the SCT Banner maintenance duties
A methodology and conventions for storing,
testing, and applying patches should be developed
Patch installation does not necessarily coincide
with upgrade installations
12
SCT Banner Upgrades


SCT Banner upgrades come in two types:

Cumulative

Interim
Upgrades are applied in two parts:

Upgrade applied to the database

Upgrade applied to the software
13
Upgrade dependencies




Each SCT Banner product has its own upgrade
procedure
These upgrades must be applied in a particular
order to build dependencies properly
There is a dependency matrix for all upgrades in
the SCT Banner general FAQ section
Read Page Five of the Upgrade Installation Guide
14
Database Upgrades


GOSTAGE is a PL/SQL program that builds a
database upgrade script based on two SCT Banner
upgrade tables:

GUBSMOD
- Holds Modification
Identifier

GURSSQL
- Holds Modification SQL
Creates and runs a file called DOMOD.SQL which
will apply all of the upgrade changes to the
database
15
Software Upgrades




The upgrade to the software happen in sync with
the database upgrade
All changes to source code is migrated to the
software tree during this stage
All Pro*C, Pro*Cobol, and Forms executables are
compiled and moved to the appropriate executable
trees
Forms executables probably need to migrate to
other servers
16
Managing Upgrades

How many upgrades - the bare minimum

Remember the O/S and Oracle

The database server is not the only upgrade

Timing the upgrades

READ THE UPGRADE DOCUMENTS

Media verification
17
Step One

READ THE USER RELEASE NOTES!

Distribute them

Make copies

Users will make upgrade timing decisions based upon them
18
Step Two

Backups


The databases

Make sure you have a cold backup

Check on disk space if in archivelog mode
The SCT Banner directories

This will replace the existing files
19
Step Three

Restricting access

Revoke user access

Change user passwords

Restricted Mode

Stopping the named listener

Change the port number so you can access the
database while doing the upgrade
20
Step Four

Position to the correct directory

Make sure you are doing the correct upgrade

Make sure the paths are set

DO IT EVERY TIME YOU RESTART THE UPGRADE!
21
Step Five

Edit the login.sql file


DO IT FOR EACH DATABASE!
Create a subdirectory for each database within the upgrade for
the SPLPREF variable

Change the passwords?

PAY CLOSE ATTENTION TO THE TABLE SIZING!!

Site-specific changes may be affected
22
Step Six

Nruready.sql

Modification tables

GUBSMOD

GURSSQL

Possibly a set of these tables for each product

The import error message

Verify the import
23
Step Seven

You are provided several lists of changes that should
be reviewed before any upgrade.

You may need to resize tablespaces and quotas

Items can be deleted, increased, added of modified


Tables

Indexes

Views

Stored objects
Objects, options and menus are now modified as part
of GOSTAGE
24
Step Seven (cont.)

Changes the database structure
The GOSTAGE Process
GUBSMOD
GURDMOD
GOSTAGE
GURSSQL
domod.sql
xURVERS
domod.sql
25
Step Eight

Migrate from stage to permanent directories



Check that you are pointing to the correct SCT
Banner code tree
Extra migration step for the forms
Unix users should verify which type of link is used
(soft vs. hard)
26
Step Nine


Compile the COBOL programs

Uses the make file or com file

Run in the background
Not required for subsequent databases
27
Step Ten


Compile the C programs

Uses the make file or com file

Run in the background
Not required for subsequent databases
28
Step Eleven


Baseline data changes

Dynamic help

Role level security objects

Rule codes

Graphs
Data conversion

Performed after structural changes

Each one is specific

Very seldom used
29
Steps Twelve and Thirteen

Forms and Reports

Now done on the forms server

Review each file for necessary include files

Make site-specific changes

Passwords

Connect strings
30
Step Fourteen

Letter generation/population selection variables
need recompilation

When necessary, the instructions are very explicit

Not done very often
31
Step Fifteen

Referential Integrity created in Step 7

This step may disable some of the constraints
32
Step Sixteen

If there are any reports that involve changes to the
database or data dictionary, this step lists the
reports and how to create the output listings
33
Step Seventeen

The final run of the GOSTAGE process

Renames the original domod.sql and listab1.lst files

Drops all obsolete tables

Drops temporary objects

Updates xURVERS table
34
Step Eighteen

Verify the upgrade

Part A


Part B


The GURALTR script finds all invalid objects owned by
the BANINST1 and recompiles them
Re-synchronize any changes to classes
Part C

Run Xrudone.sql
35
End of Session
Any Questions?
36