Transcript Lesson 2
The SCT Banner Pieces
SCT Banner Overview
SCT Banner is a mature product
Original versions built in the late 80's
Written to integrate Student, HR, Alumni, Financial
Aid, and Finance information
Has had a lot of functionality added to it over the
years
It is a BIG application now
2
Installed SCT Banner
Documentation set
Banner basics
Software
Directory structures
Environment variables
3
SCT Banner files
Location of other SCT Banner files and their uses
On the RDBMS server
On the Client
On the Application server (Internet Native Banner)
On the Web server (Self Service)
4
SCT Banner Documentation set
SCT Banner features a documentation set in PDF
format
Install Guides
Release Guides
Upgrade Guides
A set of Technical Reference Manuals
A set of User Reference Manuals
5
Banner Documentation
installation
Unloaded from the Documentation CD
Requires decryption password
File shared to end users
Directory is bdoc5x
setup5x
Server Install Guide
Client Install Guide
Bookshelf Install Guide
6
SCT Banner Documentation
manuals
bdoc5x directory
Product manual directories
Index directory
_index5x
Technical reference directory
fin5x, alumni5x, stud5x, etc
trm5x
bkshlf5x.pdf
Startup page for the Banner Bookshelf
7
SCT Banner User Manuals
User Reference Manuals
Available online to all SCT Banner users
Set up through an SCT Banner form GUAUPRF
Define location of Acrobat Reader
Define location of Banner Bookshelf
8
SCT Banner Technical Manuals
Technical Reference Manuals
Available online to all SCT Banner users
Set up through an SCT Banner form GUAUPRF
Define location of Acrobat Reader
Define location of Banner Bookshelf
9
SCT Banner Basics –
Naming Conventions
Software
Product modules
Product directories
Software Objects
Pro*C source code
Pro*Cobol source code
Forms binaries (FMB)
Database object source code
10
Banner Basics - Products
Software
Product modules
Admin
Finaid
Payweb
Common
BANINAS
Aluweb
General
VR-Student
Wtailor
Student
VREpos
Infoacc
Arsys
VRBrite
Intcomp
Alumni
Genweb
Finance
Stuweb
Payroll
Scomweb
Posnctl
Facweb
11
Banner Basics – Product directories
Software
Product directories are named after the product
Each of these directories has a common set of subdirectories
c
cob
forms
dbprocs
views
plus
misc
12
Banner Basics –
Compiler conventions
Software
There are different naming conventions for each type of software
objects within these directories
Pro*C
*.pc - Pro*C source file
*.h - C header file
*.c - C source file
Pro*Cobol
*.pco - Pro*Cobol source file
*.cob - Pro*Cobol copylibs
13
Banner Basics – Forms conventions
Software
There are different naming conventions for each type of software
objects within these directories
Forms
*.fmb -
Forms binary source file
*.mmb -
Menu binary source file
*.pll - Procedure Library
*.ogd -
*.gif - GIF files
*.ico -
Icon files
*.rdf -
Reports binary source file
Graphics Library
14
Banner Basics – SQL conventions
Software
There are different naming conventions for each type of
software objects within these directories
dbprocs
xxKxxxx.sql - package source code
xxPxxxx.sql - procedure source code
xxFxxxx.sql - function source code
xxTxxxx0.sql - trigger source code
views
xxVxxxx0.sql - view creation
plus - xxxxxxx.sql
15
Exercise 1
1.
What SCT Banner products did you purchase?
2.
What SCT Banner products are installed?
3.
Who has access to the Banner manuals?
4.
Which manual discusses distributed Banner
security?
16
Banner Basics – Web products
Software
There is a difference in the naming conventions used for the web
products
dbprocs (cont.)
HWSKxxxx.sql/BWSKxxx.sql - Student Web package source code
HWGKxxxx.sql/BWGKxxxx.sql - General Web package source code
HWRKxxxx.sql/BWRKxxxx.sql - Finaid Web package source code
HWPKxxxx.sql/BWPKxxxx.sql - Employee Web package source code
HWAKxxxx.sql/BWAKxxxx.sql - Alumni Web package source code
17
Banner Basics – Web products
Software (continued)
TWGKxxxx.sql - Web Tailor Global package source code
BWLKxxxx.sql – Faculty Web package
BWCKxxxx.sql – Common Web package
misc
Compile scripts for Pro*C, Pro*Cobol
Other supporting web package(s)
18
Banner Basics - Objects
Database
Product owners
Product codes
Important users
Database Objects
Tables
Views
Packages (procedures and functions)
Triggers
19
Banner Basics – Product owners
Product Owners and Codes
General
GENERAL
G
Student
SATURN
S
Finance
FIMSMGR
F
AR
TAISMGR
T
Position Control POSNCTL
N
Payroll
PAYROLL
P
FinAid
FAISMGR
R
Alumni
ALUMNI A
Web for …
WTAILOR
TW
20
Banner Basics - Example
Database objects (Tables and views)
Example:
G
L
R
V
R
B
L
1
2
3
4
5
6
7
1 - Primary Module (S- Student, G- General, F- Finance)
2 - Sub-module (L- Letter generation, G- General Person)
3 - Type of object (R- Report, A- Form, R- Repeating table)
4-7 - Meaningful name
IF Pos 2 is a T and Pos 3 is a V, then the object is a validation table
21
Banner Basics - Triggers
Triggers
aT_abcdddd_xxxxxxxxxxxxxxxxxx (Total no more than 29)
a = Product identifier (S) Student, (P)ayroll
T = Trigger
abcddd = Table name
xxxxx = Meaningful trigger name
22
Banner Basics - Procedures
Database
Procedures and Functions
P_xxxxxxxxxxxxxxxxxx (Total no more than 29)
F_xxxxxxxxxxxxxxxxxx (Total no more than 29)
xxxxx = Meaningful name (Up to 27 characters)
Cursors
xxxxxxxxxxxxxxxxxxxxxxxxxxx_C
23
Banner Basics – Referential Integrity
Referential integrity
Parent/Child relationships are enforced at the database level
No child data without a referenced parent key
No deletion of parent key while child records exist
24
Banner Basics – RI example
Permanent
Address
STVATYP
Parent Table
PR
Foreign Key
FK1_SPRADDR_INV_STVATYP_CODE
on
SPRADDR_ATYP_CODE
Primary Key
PK_STVATYP
on
STVATYP_CODE
101
PR
SPRADDR
Child Table
25
Exercise 2
1.
2.
3.
What can you tell me about the column
SPRADDR_ATYP_CODE?
The package for Admissions Checklist
Processing was accidentally dropped. How
would you restore it?
Which product does HWSKANAM belong to?
26
Banner Basics - Installer
There is an installer (baninst) for the SCT Banner
product on the RDBMS machine
Different on each platform
Modeled off of the old Oracle character mode
installer
Menu interface for a bunch of shell scripts
27
Banner Basics – Unloading Banner
There is an unload and decrypt program that will
unload the SCT Banner forms executable files onto
a Windows machine
Requires a decryption password
After unloading forms executables, they must be
copied to the final forms/file server location(s)
28
Banner Basics - BANNER_HOME
BANNER_HOME is a variable used to define the
location of an SCT Banner software tree
Used by SCT Banner software as a base alias to
find other SCT Banner software
29
Banner Basics - BANENV (Unix)
BANENV is a shell script that is used to manage setting of
the SCT Banner variables
Modeled on the oraenv file
Usually invoked from oraenv once the desired SID is
known
Other systems follow this same premise
banlogic.com (VMS)
registry (NT)
30
Banner Basics - Important Users
BANINST1
Owns all the functions, packages, procedures, and views
BANSECR
Owns the SCT Banner security tables and objects
31
Exercise 3
1.
What schema owner should own your views?
2.
Do you still have your original install directory?
32
Banner Installation - Software
Two CD-ROMs of SCT Banner software
Database contents and supporting code
Client forms
All software on the CD-ROMs is encrypted
Encryption Keys are on a sheet of paper shipped
with the order. DO NOT LOSE!
Software is decrypted and downloaded onto
RDBMS server
33
Banner Installation - Process
The SCT Banner database software is installed on
the RDBMS server in several steps:
Download Software
Create SCT Banner Environment
Create SCT Banner Instance
Create SCT Banner Database Objects
Compile Pro*C and Pro*Cobol
34
Banner New Installation – Step 1
The first step is to download the software
There are four basic steps in downloading:
Identify Products to download
Define Global Variables
Download the software
Build the environment control scripts
35
Banner New Installation –
Identify products
Identify Products to download (banpswd.shl)
First, two C programs (crypfile.c and inipassr.c) must be
compiled to use in decrypting the SCT Banner products
Once these are done, the install script will ask for a decrypt
password
This will then build a menu with the appropriate products
marked for downloading
36
Banner New Installation –
Global definitions
Define Global Variables (banprmp.shl)
BANNER_HOME
EXE_HOME
ORACLE_HOME
ORACLE_SID
C
COBOL
37
Banner New Installation –
Software download
Download the software (bansrce.shl)
This process will download the software from the
CD
Decrypt
Decompress
Populates the following directory structure:
38
SCT Banner Software Directory
Root Directory
BANNER_ROOT
FOCEXP_ROOT
BANNER
(BANNER_HOME)
FOCEXP
(FOCEXP_HOME)
alumni
alumni
arsys
arsys
common
common
finaid
finaid
finance
finance
general
general
install
install
payroll
payroll
posnctl
posnctl
student
student
upgrades
upgrades
links
The Banner Software Default Directory Structure
39
Banner Software Directories
BANNER_HOME
Defines the home directory of the SCT Banner products
Each product has its own directory
General is a special product
Contains executables and administrative objects
Common is used for cross-product objects
Upgrades are used to stage SCT Banner upgrades
Links directory is used to centralize process access
40
Banner General Directories
general
c
cob
dbprocs
forms
exe
gif
ico
install
misc
plus
verify
views
The Product Software Default Directory Structure
41
Banner Product Directories
C directory contains the Pro*C source
COB directory contains the Pro*Cobol source and
Cobol copybooks
DBPROCS contains the source for database
procedures, functions, triggers, and O:A functions
and procedures
FORMS contains the source for the forms,
libraries, menus and reports
42
Banner Product Directories
MISC directory contains the Perl scripts used on
the NT platform and Shell scripts for UNIX.
On VMS the COM directory contains the DCL
scripts
PLUS directory contains SQL*Plus scripts
VIEWS contains source for the database views and
O:A views
43
General Directories
General directory contains some special
subdirectories:
EXE contains all the executables for all products
GIF contains the .gif files used in SCT Banner
ICO contains the icon files used in SCT Banner
ADMIN and PLUS directory under General also contains
administration and upgrade scripts
44
Banner New Installation – Step 2
The install process then builds some environment
manipulation scripts for managing SCT Banner variables
(bansubs.shl):
banenv - for the Bourne shell
cbanenv - for the C shell
kbanenv - for the Korn shell
*banali - for printer aliasing for the
various shells
Banlogic - for VMS
45
Banner New Installation –
Environment creation
The next step of the install process will create an SCT
Banner environment on the RDBMS server
Build the LINKS directory (banlnks.shl –UNIX only)
Update the environment (bansenv.shl)
Oraenv is then modified to point to the banenv and cbanenv
files (UNIX)
Oratab is modified with the new database
Banlogic.com is modified with directory locations (VMS)
46
Banner New Installation – Step 3
The next set of steps creates the SCT Banner
database
Uses a pre-created database (bancrdb.shl, bancrtb.shl are
provided for reference)
Creates the SCT Banner accounts (bancrus.shl)
Modifies the SCT Banner database configuration (baninit.shl)
47
Banner New Installation – Step 4
The next set of steps in the NEW install will create
the database objects
Import SCT Banner tables and sample data (banimp.shl)
Build SCT Banner procedures and functions (bandbpr.shl)
Import views and create synonyms (banvwsy.shl)
48
Multiple Banner environments
Multiple SCT Banner software environments
Initial install only built one code tree
Need to copy this to another tree to use as an upgrade
staging area
Must manage the access to these different sets of SCT
Banner code by using:
Shell scripts
Icons
DOS .bat files
49
Multiple Banner databases
Multiple SCT Banner instance databases
Initial install only built one database
Need to clone this to a training database and a production
staging database
Must manage the access to these different SCT Banner
databases by using:
Shell files/registry/DCL procedures
Icons
DOS .bat files
50
Banner Default Databases SEED
Out-of-the-box SCT Banner
Used to run new SCT Banner upgrades against first
Upgrade issues are then SCT issues
Work out the details before upgrading production
database
51
Banner Default Databases TRNG
Used for implementation training
Out-of-the-box SCT Banner with some additions
Training user accounts
Training data
Usually cloned from SEED
52
Banner Default Databases PPRD
Used for implementation and conversion
Out-of-the-box SCT Banner with some deletions
Most SEED data is cleaned out of the database
Used to build the Production database
Should be backed up as soon as users start
populating validation and rule tables
53
Exercise 4
1.
You’ve just upgraded Oracle – will you be able to
compile Pro*C and Pro*Cobol?
2.
Does the Banner installer itself set up the Job
Submission user ID and directory?
3.
What user IDs do your users use when logging
into the PPRD database?
54
Banner environment
Multiple SCT Banner environments will need both
Oracle and SCT Banner variables set
.profile or .login calls oraenv (UNIX)
Login.com calls orauser_SID.com (VMS)
ORAENV sets:
orauser_SID.com sets:
ORAENV_ASK
--
ORACLE_HOME
ORA_DB
ORACLE_SID
ORA_SID
PATH
SQLPATH
55
Banner environment - Others
VMS
Command procedural calls:
Banlogic.com
Orauser_SID.com
NT/Win2000
Path environment
Registry
56
Banner environment variables
Based on the SID, the appropriate environment
file is called
BANENV/Registry sets:
BANLOGIC sets:
BANNER_HOME
BAN_HOME
BANNER_LINKS
BAN_ROOT
BANNER_ADMIN
<MODULE$PATH>
EXE_HOME
GEN$EXE
ORACLE_PATH
ORA_PATH
PATH
SQLPATH
57
Banner database performance
Management of an SCT Banner database
involves proactively managing:
Memory
Are your users complaining?
Is your system page-faulting?
Running SQL scripts to maintain the system
Disk storage
Fragmentation
Database objects
Invalid state
58
Banner Database Administration
Close relationships with the System and Network
staff
Patches and upgrades are maintained
Backup and recovery in place
Network access
It also involves being able to:
Create databases
Clone databases
Upgrade all Oracle software
“How to have a life and be a DBA also”
59
Banner - Memory Management
SCT Banner moves a lot of data and involves a lot
of code
OLTP vs. DSS
This means that the DBA must take an active
stance on monitoring and managing SCT Banner's
use of memory
Checking the SGA:
How often does the database get data from disk vs. memory?
How often are the stored packages accessed?
60
Oracle - Memory Management
The main areas the DBA must be concerned with
are:
Data Base Buffers - v$sysstat
Shared pool - pins and gets
Redo logs - Checking the alert logs, v$sysstat
Data Dictionary cache - v$rowcache
Library cache - v$librarycache
Sort Areas - temporary tablespace
61
Banner - Storage Management
SCT Banner databases take active storage
management
Tables grow constantly
Indexes become unusable
Database use causes problems like storage
fragmentation and row chaining
New tables with upgrades
62
Oracle - Storage Management
The storage management tasks the DBA will be
most heavily involved in are:
Tablespace growth
Table sizing
Rollback segment sizing
Restructuring the database
Resizing/moving tables and indexes
Tablespace placement
RAID vs. non-RAID
63
Banner – Disk Storage Management
RAID
Important to have for an Oracle system
Jbod – Lowest data cost – low overhead
0 – low data cost – load balancing
0, 0+1 – high data cost – most expensive
5 – Highest data cost – safe
It takes four I/Os for one write
(read data, read parity,write data, write parity)
Minimum of three disks, plus 66-87% of space
The more disks, the higher the gain
Not good with REDO –
Sequential vs random writes
64
Banner - Object Management
SCT Banner is installed in one tablespace, usually
named DEVELOPMENT
Can be divided into many tablespaces as required
by the institution
Access reasons
Performance reasons
Maintenance reasons
Multi-institution reasons
65
Banner utilities
SCT-supplied data catalog tool GURPDED
Run through Job Submission
SCT-supplied tool called GURRDDL
Used to resize tables
Used to resize indexes
Handles the referential constraints
Handles the permissions
Handles the synonyms
Can be used to move one or many tables
66
Oracle fragmentation
Databases can fragment, even with the best of
software
Fragmentation causes performance problems
Tools are being developed to perform background
defragmentation
Most common method of defragmentation is
export/import
67
Oracle locally managed tablespaces
Oracle is moving towards a methodology that will
reduce table management
Uses a few basic extent sizes for each tablespace
Tables are grouped into tablespaces according to
size and growth characteristics
68
Banner – General object management
There are sets of scripts provided with SCT
Banner that are used to compile/recompile
database objects
General Packages, Procedures, Functions, and Triggers
/sct/banner/general/dbprocs/gendbpr.sql
General Views
/sct/banner/general/views/genview.sql
69
Banner – Student object management
There are sets of scripts provided with SCT
Banner that are used to compile/recompile
database objects
Student Packages, Procedures, Functions, and Triggers
/sct/banner/student/dbprocs/studbpr.sql
Student Views
/sct/banner/student/views/stuview.sql
70
Banner - Object management utility
SCT-supplied tool called GURALTR
Searches database for invalid objects and
builds a recompile script
Used to recompile database objects (not sys nor system)
Packages
Package Bodies
Triggers
Procedures
Functions
71
Exercise 5
1.
2.
3.
How many different Banner code trees does your
oraenv script handle?
What is the purpose of the BANNER_LINKS
directory?
Even though studbpr.sql is in the Student
product directory, what schema owner owns the
database procedures in this script?
72
Compiling invalid objects
Run utlrp.sql as SYS to compile ALL database objects
Use GURALTR to recompile ALL non-SYS and nonSYSTEM database objects
BANINST1 owns the database packages, procedures,
functions and views
Use GURALTRB to recompile BANINST1 objects
Run multiple times for dependencies
After manipulating ANY database objects, run GURALTR to
fix any broken dependencies
73
Banner database triggers
BANINST1 does not own the database triggers
Each product owner owns their respective set of database
triggers
Compile scripts for the triggers are located in the product's
dprocs directory in the xxxdbpr.sql file
Must use these in conjunction with GURRDDL when rebuilding
tables
74
Banner administrative software
There is an administrative directory for SCT
Banner on the RDBMS server
$BANNER_HOME/admin
Banenv (UNIX/NT)
Banlogic (VMS)
profile.ban
upcase.shl
$BANNER_HOMEHadmin/v6/oratools
75
Banner non-database related software
SCT Banner also requires management of all the
software outside of the database
Executable compiles
Pro*C
Pro*Cobol
SQL*Plus scripts
SQL*Loader scripts
76
Banner Pro*C - 1
Each product owner may have a set of Pro*C
programs
Located in /sct/banner/<product>/c
Based on old Oracle RPTs
Ugly but consistent design
.h - Header files (General/c only)
guarpfe.h - Routines for RPT emulation
guastdf.h - Routines for C print formatting
77
Banner Pro*C - 2
.c - C source files (General/c only)
guarpfe.c - Routines for RPT emulation
guastdf.c - Routines for C print formatting
guaorac.c - Routines for Oracle interface
.pc - Pro*C source files
gurjobs.pc - Job Submission Pro*C program
gjrrpts.pc - SCT Banner Reports print program
78
Banner Pro*C - 3
The compile scripts for each product's set of
Pro*C programs are in the corresponding MISC
directory (the same applies for OVMS and NT)
General Pro*C
Student Pro*C
/sct/banner/general/misc/gencmplc.shl
/sct/banner/student/misc/stucmplc.shl
Finance Pro*C
/sct/banner/finance/misc/fincmplc.sql
79
Banner Pro*Cobol - 1
Each product owner may have a set of Pro*Cobol
programs
Located in /sct/banner/<product>/cob
/sct/banner/general/cob also contains the
Pro*Cobol copylibs
*.pco - Pro*Cobol source files
80
Banner Pro*Cobol - 2
The compile scripts for each product's set of
Pro*Cobol programs are in the corresponding
product MISC directory
General Pro*Cobol
Student Pro*Cobol
/sct/banner/general/misc/gencmpl.shl
/sct/banner/student/misc/stucmpl.shl
Finance Pro*Cobol
/sct/banner/finance/misc/fincmpl.sql
81
Banner SQL*Plus
SCT Banner also has SQL*Plus scripts that are used by
the various SCT Banner products
Located in: /sct/banner/<product>/plus
General also has some scripts that are used for admin
and upgrade purposes
LOGIN.SQL
GURALTRB
GURRDDL
GOSTAGE
82
Banner SQL*Loader
SCT Banner also has SQL*Loader scripts that are
used to load outside data
Test scores
EDI
Located in: /sct/banner/<product>/loader
*.ctl - SQL*Loader control files
83
Exercise 6
1.
Run the
$BANNER_HOME/admin/V6/oratools/freebyte.sql
script. How many free, used, and total bytes
are in the development tablespace in the
TRNG database?
2.
What is the fully qualified name of the script
to compile the GSASECR.fmb file?
84
Banner - Access methods
Considerations need to be made for:
Access to the SCT Banner system
Database(s)
Forms
Report output
User vs. developer access
SCT Banner System vs. SQLPLUS
Microsoft Access
85
Creating an SCT Banner
Database
Production databases are usually created
sometime after the initial SCT Banner installation
by the site
Memory sizes, block size, disk storage
requirements, network considerations, and user
load must be taken into account when configuring
the production database
86
Banner Database creation methods
Creation is done through one of the many tools
available
Command line method has more creation flexibility
GUI mode (orainst) is easier, but requires modification before
the SCT Banner data can be loaded
87
Cloning a Banner Database –
Oracle7/8i
Cloning is done through a database recovery
mechanism
Database files are copied to new directory structure
Produce a control file re-creation script by issuing as sys:
alter database backup controlfile to trace;
New instance is “recovered” using modified control file,
and new control files are created
88
Cloning a Banner Database –
Oracle 8i/9i
1.
Use RMAN to make a backup of the source database
2.
The clone database is created and opened NOMOUNT
3.
Run the duplicate command in RMAN to perform the clone
4.
The procedure is fully documented in the 'Backup and
Recovery' section of the Oracle 8i Administrators Guide
89
SCT Banner - Backup Strategies
Cold backups
Involves taking the database offline
Should be performed occasionally
Online backups
Oracle has very good recovery mechanisms
Allows the database to remain in service
With RMAN, backup and recovery can be completely
automated
90
Exercise 7
1.
Why is the method used to clone Oracle7
databases not a good one for Oracle8
databases?
2.
What is your current backup strategy?
3.
Is it documented?
91
Self Service Banner (SSB)
Products
The SCT Self Service Banner … products are an
add-on set of software functionality
Provides a self-service browser interface to many
SCT Banner functions
Is not “Internet Native” Banner
Customizable look and feel
Rules-defined access and display
92
Self Service Banner services
Implemented by using database packages and
procedures
Generates dynamic HTML pages from the
database
Uses Oracle’s 9iAS Mod_plsql
Uses Oracle's PL/SQL Toolkit package
Has an administrative tool called Web Tailor
93
Documentation
The end user guides are available through
Banner Bookshelf through the Product User
Manuals
The Upgrade Guides and Release Guides are
available through Banner Bookshelf
Each product has its own set of Guides
Web Tailor has its own set of Guides
94
Self Service Banner Software
Install
SCT Self Service Banner… installs are done on the SCT
Banner RDBMS server
Packages are built in the database
The software is installed in Web for product directories
/sct/banner/aluweb
/sct/banner/facweb
/sct/banner/genweb
/sct/banner/payweb
/sct/banner/scomweb
/sct/banner/stuweb
/sct/banner/wtlweb
95
Self Service Banner
Software Structure
Each SCT Self Service Banner … product
directory contains some of the following
structure:
c-
C programs used in web applications
dbprocs - Web packages
gif -
graphics objects for buttons
html -
Product web pages
misc -
Web administrative scripts
96
Self Service Banner
Install
There is no SCT Banner install on the web server
The server is configured to connect to the SCT Banner
database through Oracle Net
PL/SQL Toolkit is loaded into the database
Web For … .gif and .htm files are copied from the database
server to the web server
An Apache listener is created to present the initial page for
general access to the SSB system, homepage.htm
97
Self Service Banner
Web Server Install
From the web server, for each SCT Banner
instance:
Create a DAD (Database Access Descriptor)
Created with Oracle’s 9iAS DAD Gateway GUI tool
Uses a generic username/password/connect descriptor that
logs into the database on behalf of the SSB user
http://host:port/pls/admin_/gateway.htm, where host is your
complete host name or IP address
98
Gateway.htm
Click on Gateway Database Access Descriptor Settings
Enter
DAD Name: SID_SSB
Schema Name: www_user
Oracle User Name: www_user
Oracle Password: u_pick_it
Oracle Connect String: SID
Click Apply
Repeat for each database.
99
PL/SQL Toolkit
Install the latest PL/SQL Toolkit patch into Oracle
9iAS.
Apply the same level toolkit into each database by
running a provided script in
$ORACLE_HOME\Apache\modplsql\cfg
Owaload.sql
100
Self Service Banner
Web server directories
Copy .gif and .htm files for each product from
the directories on the RDBMS server to the
appropriate directory on the web server:
/sct/banner/*web/gif
/sct/ssb/SID/*gifs
/sct/banner/*web/htm
/sct/ssb/SID/*help
101
Self Service Banner
Web Server listener
Configure the Web server to ‘serve up’ SSB
Create the HTTP listener
Set DocumentRoot and <Directory to the /sct/ssb/SID
directory
Set Port to the Port that the users will use
Set Listen to the Port that Apache will listen for
Set DirectoryIndex to hompage.htm
102
Self Service Banner homepage.htm
The next step is to set up the homepage.htm
file
Copy from:
/sct/ssb/SID/wtlhelp/homepage.htm
To:
/sct/ssb/SID/homepage.htm
Replace //your server name:port/test/owa/ with your site's
Mod_plsql reference and DAD
i.e. //bandev:8080/pls/SEED/
103
Self Service Banner
Web Server
There are links that must be built in the Web tailor product
to point to your institutions specific sites (Alumni,
Admissions, campus directory, etc)
It is recommended to have a dedicated web server for SSB
Apply the latest Apache and/or 9iAS security and update
patches
As of August, 2003
8.1.7.4
Mod_plsql 3.0.9.8.4
Jserv Rollup #3
104
Self Service Banner
Objects
The only SCT Banner software to manage on
the web server are the web objects needed by
the Web For … products
.gif files
.htm files
Web Tailor image files
These will be updated as new versions come
out
105
Self Service Banner
RDBMS Software
There are sets of scripts provided with SCT
Banner that are used to compile/recompile
database objects
Stuweb Packages, Procedures, Functions, and Triggers
/sct/banner/stuweb/dbprocs/hstudbpr.sql
Genweb Packages, Procedures, Functions, and Triggers
/sct/banner/genweb/dbprocs/hgendbpr.sql
106
Self Service Banner
Client
Netscape 4.x
Explorer 5.x/6.x
Generally, stay a release or two back from the
latest and greatest browsers
Supports other browsers (opera, mozilla)
Can use Windows 95 up to the latest
Can use MacOS
107
Exercise 8
1.
2.
3.
From where is each web page generated?
How would you reload the PL/SQL toolkit in the
database?
What SCT Banner software must be on the Web
server?
108
Internet Native Banner
Parts
In Internet Native Banner, the Oracle runforms
software has been modified to run in two parts:
The runform engine running on an application server
A Java applet that performs the display and data entry
tasks
The forms server then “tags up” the SCT Banner
forms before delivering
109
Internet Native Banner
Products
There are two products involved:
The Apache web server utilizing servlet technology
The Oracle Forms web runtime engine (included in 9iAS)
Apache handles the HTTP(S) connection request
to SCT Banner
The Oracle Forms web runtime engine handles the
forms management
110
Internet Native Banner - Installs
There are two supported ways to install this:
Oracle 9iAS http server-only installation, plus the Forms and
Reports 6i server
Plus patchset 13 for Oracle Forms and Reports 6i
9iAS Enterprise Edition
Plus patchset 13 for Oracle Forms and Reports 6i
111
INB – files to be modified
D:\ORACLE\iSuites\Apache\Apache\conf\httpd.conf
D:\ORACLE\iSuites\Apache\Jserv\conf\jserv.properties
Forms servlet configuration file
D:\ORACLE\806\conf\6iserver.conf
Forms servlet initializaion
D:\ORACLE\806\forms60\server\formsweb.cfg
Servlet engine classpath
D:\ORACLE\iSuites\Apache\Jserv\servlets\zone.properties
Apache listener configuration
Virtual path definitions for web forms
D:\ORACLE\806\forms60\server\default.env
Environment variables for the FORMS and REPORTS servlets
112
INB – httpd.conf
Configure the Web server to ‘web up’ INB
Edit the HTTP listener
Set DcumentRoot and <Directory to the D:\sct\inb\SID
directory
Set Port to the Port that the users will use
Set Listen to the Port that Apache will listen for
113
INB – Zone.properties and
Jserv.properties
Zone.properties
servlet.SID.code=oracle.forms.servlet.ListenerServlet
servlet.SIDD.initArgs=envfile=d:\sct\ssb\seed\conf\seed.env
Jserv.properties
# Oracle Forms and Reports Servers
wrapper.classpath=D:\ORACLE\806\forms60\java\f60srv.jar
wrapper.path=D:\oracle\isuites\bin;D:\ORACLE\806\bin
114
INB – formsweb.cfg
You can set up additional code trees with
separate environment files by changing:
archive_jini=f60all_jinit.jar to
archive_jini=f60all_jinit.jar,banicons.jar
serverURL= to serverURL=/servlet/PPRD
form=test.fmx to form=guainit.fmx
pageTitle=Oracle Forms Server to pageTitle=Internet Native
Banner
width=650 to width=800
height=500 to height=500
115
INB – Formsweb.cfg
Other changes:
separateFrame=false to separateFrame=true
background= to background=no
lookAndFeel=Oracle to lookAndFeel=Generic
archive=f60web.jar to archive=f60web.jar,banicons.jar
archive_ie=f60all.cab to
archive_ie=f60all.cab,banicons.jar
connectMode=socket to connectMode=http
116
INB – Formsweb.cfg
Comment out the following lines:
;serverApp=default
;serverPort=9001
;serverHost=144.17.90.12
Add:
[seed]
serverURL=/servlet/SEED
[seedsecurity]
serverURL=/servlet/SEED
form=gsasecr.fmx
117
INB - Jinitiator
Note that Patchset 13 ships Jinitiator version 1.3.1.9.
If you do plan on using Jinitiator version 1.3.1.9,
then the following lines in formsweb.cfg need to be
appropriately edited for your version of Jinitiator.
object_classid=clsid:CAFECAFE-0013-0001-0009-ABCDEFABCDEF
object_executable=jinit.exe#Version=1,3,1,9
mimetype=application/x-jinit-applet;version=1.3.1.9
Other Jinitiator versions can be freely downloaded
after creating a free OTN (Oracle Technology
Network) account from
http://otn.oracle.com/software/products/developer/htdocs/jinit.htm
118
INB – base.htm, baseie.htm
Edit each of the these files
Base.htm, baseie.htm:
Two (2) lines were added to the file:
<PARAM NAME="imageBase" VALUE="%imageBase%">
<PARAM NAME="clientDPI" VALUE="%clientDPI%">
Three (3) lines are commented out:
;<PARAM NAME="serverPort" VALUE="%serverPort%">
;<PARAM NAME="serverHost" VALUE="%serverHost%">
;<PARAM NAME="serverApp" VALUE="%serverApp%">
119
INB – basejini.htm
Modify this file with:
<PARAM NAME="imageBase" VALUE="%imageBase%"> and
imageBase="%imageBase%"
<PARAM NAME="clientDPI" VALUE="%clientDPI%"> and
clientDPI="%clientDPI%"
Six (6) lines are commented out:
;<PARAM NAME="serverPort" VALUE="%serverPort%">
;<PARAM NAME="serverHost" VALUE="%serverHost%">
;<PARAM NAME="serverApp" VALUE="%serverApp%">
;serverPort="%serverPort%"
;serverHost="%serverHost%"
;serverApp="%serverApp%"
120
INB – Servlets environments
Copy D:\oracle\806\forms60\server\default.env to
D:\oracle\806\forms60\server\ban5.env
Add the following lines
LOCAL=SID_ban
TNS_ADMIN=D:\oracle\806\net80\admin
Change the following lines for your environment
FORMS60_PATH=D:\sct\SID\fmx
REPORTS60_PATH=D:\sct\SID\fmx
PRINTER=sctmtal5
GRAPHICS60_PATH=D:\sct\SID\fmx
121
INB – 6iserver.conf
Stop the OracleHTTPServer service in the Control
Panel.
Edit the D:\oracle\806\conf\6iserver.conf to add a
virtual directory for the Banner help files and to
rewrite the url.
Alias /hlp/
"D:\sct\inb\SEED\doc\hlp\“
Alias /bookshelf/ “D:\sct\inb\SEED\doc\pdf\
122
INB - DAD
GJIREVO requires a DAD (Database Access Descriptor).
To create a DAD edit
D:\oracle\102\Apache\modplsql\cfg\wdbsvr.app change:
;admindad = portal30
Run gateway.htm: http://host:port/pls/admin_/gateway.htm
DAD Name: SID
Schema Name: www_user
Oracle User Name: www_user
Oracle Password: u_pick_it
Oracle Connect String: SID_ban
123
INB – gif files
On your database server or your forms server
change directory to the location of your gif files
Execute the jar (Java archive tool) command
jar cvf banicons.jar *.gif
Copy or binary ftp the banicons.jar file to
D:\Oracle\Forms60\java
124
INB – Files in general/extras
(upgrade)
fmrpcweb.res (copy or ascii ftp to
D:\Oracle\806\Forms60 and rename to fmrweb.res)
For F1 display help add this line to fmrweb.res
112 : 0 : "F1"
: 1004 : "Help (Item Properties)"
cgicmd.dat (copy or ascii ftp to the
D:\Oracle\806\Report60\Server).
Edit the cgicmd.dat file appropriately as documented in
the file cgicmd.dat.
125
Starting INB – NT/Win2000
Click on Start -> Settings -> Control Panel -> Services
Stop/Start the OracleHTTPServer service.
Stop/Start the OracleReportServer service.
Execute INB (Internet Native Banner)
Start your browser with the URL (example only):
http://HOST.anyu.edu:80/servlets/f60servlet?config=banSID
When the guainit form starts, enter
Username: saisusr
Password: u_pick_it
126
Starting INB - UNIX
Log on as Oracle
. Oraenv
cd $ORACLE_HOME/Apache/Apache/bin
./apachectl start
Start a web browser and enter your url:
(set ias ORACLE_HOME)
http://HOST:port/servlets/f60servlet?config=banSID
127
Exercise 9
1.
2.
What is the major difference between base.htm,
baseie.htm or basejini.htm?
You just installed a new patch to Forms – what
do you need to change for a new version of
jinitiator?
128
End of Session
Any Questions?
129
Thank you for your participation today