Скачать презентацию The SCT Banner Pieces SCT Banner Overview Скачать презентацию The SCT Banner Pieces SCT Banner Overview

ddd744c2633e0ccaeb582a13260835ee.ppt

  • Количество слайдов: 130

The SCT Banner Pieces The SCT Banner Pieces

SCT Banner Overview u SCT Banner is a mature product u Original versions built SCT Banner Overview u SCT Banner is a mature product u Original versions built in the late 80's u u u 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 n Documentation set n Banner basics n Software n Directory structures Installed SCT Banner n Documentation set n Banner basics n Software n Directory structures n Environment variables 3

SCT Banner files u Location of other SCT Banner files and their uses n SCT Banner files u Location of other SCT Banner files and their uses n On the RDBMS server n On the Client n On the Application server (Internet Native Banner) n On the Web server (Self Service) 4

SCT Banner Documentation set u SCT Banner features a documentation set in PDF format SCT Banner Documentation set u SCT Banner features a documentation set in PDF format u Install Guides u Release Guides u Upgrade Guides u A set of Technical Reference Manuals u A set of User Reference Manuals 5

Banner Documentation installation u Unloaded from the Documentation CD u Requires decryption password u Banner Documentation installation u Unloaded from the Documentation CD u Requires decryption password u File shared to end users u Directory is bdoc 5 x n setup 5 x u Server Install Guide u Client Install Guide u Bookshelf Install Guide 6

SCT Banner Documentation manuals u bdoc 5 x directory n Product manual directories u SCT Banner Documentation manuals u bdoc 5 x directory n Product manual directories u n Index directory u n _index 5 x Technical reference directory u n fin 5 x, alumni 5 x, stud 5 x, etc trm 5 x bkshlf 5 x. pdf u Startup page for the Banner Bookshelf 7

SCT Banner User Manuals u User Reference Manuals n Available online to all SCT SCT Banner User Manuals u User Reference Manuals n Available online to all SCT Banner users n Set up through an SCT Banner form GUAUPRF u Define location of Acrobat Reader u Define location of Banner Bookshelf 8

SCT Banner Technical Manuals u Technical Reference Manuals n Available online to all SCT SCT Banner Technical Manuals u Technical Reference Manuals n Available online to all SCT Banner users n Set up through an SCT Banner form GUAUPRF u Define location of Acrobat Reader u Define location of Banner Bookshelf 9

SCT Banner Basics – Naming Conventions u Software n Product modules n Product directories SCT Banner Basics – Naming Conventions u Software n Product modules n Product directories n Software Objects u Pro*C source code u Pro*Cobol source code u Forms binaries (FMB) u Database object source code 10

Banner Basics - Products u Software n Product modules Admin Finaid Payweb Common BANINAS Banner Basics - Products u Software n 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 u Software n Product directories are named after the Banner Basics – Product directories u Software n Product directories are named after the product n Each of these directories has a common set of subdirectories u cob u forms u dbprocs u views u plus u misc 12

Banner Basics – Compiler conventions u Software n There are different naming conventions for Banner Basics – Compiler conventions u Software n There are different naming conventions for each type of software objects within these directories u Pro*C n n *. h - C header file n u *. pc - Pro*C source file *. c - C source file Pro*Cobol n *. pco - Pro*Cobol source file n *. cob - Pro*Cobol copylibs 13

Banner Basics – Forms conventions u Software n There are different naming conventions for Banner Basics – Forms conventions u Software n There are different naming conventions for each type of software objects within these directories u Forms n *. fmb - Forms binary source file n *. mmb - Menu binary source file n *. pll - Procedure Library n *. ogd - n *. gif - GIF files n *. ico - Icon files n *. rdf - Reports binary source file Graphics Library 14

Banner Basics – SQL conventions u Software n There are different naming conventions for Banner Basics – SQL conventions u Software n There are different naming conventions for each type of software objects within these directories u dbprocs n n xx. Pxxxx. sql - procedure source code n xx. Fxxxx. sql - function source code n u xx. Kxxxx. sql - package source code xx. Txxxx 0. sql - trigger source code views n u xx. Vxxxx 0. sql - view creation plus - xxxxxxx. sql 15

Exercise 1 1. What SCT Banner products did you purchase? 2. What SCT Banner 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 u Software n There is a difference in the Banner Basics – Web products u Software n There is a difference in the naming conventions used for the web products u dbprocs (cont. ) n HWSKxxxx. sql/BWSKxxx. sql - Student Web package source code n HWGKxxxx. sql/BWGKxxxx. sql - General Web package source code n HWRKxxxx. sql/BWRKxxxx. sql - Finaid Web package source code n HWPKxxxx. sql/BWPKxxxx. sql - Employee Web package source code n HWAKxxxx. sql/BWAKxxxx. sql - Alumni Web package source code 17

Banner Basics – Web products u Software (continued) n TWGKxxxx. sql - Web Tailor Banner Basics – Web products u Software (continued) n TWGKxxxx. sql - Web Tailor Global package source code n BWLKxxxx. sql – Faculty Web package n BWCKxxxx. sql – Common Web package n misc u Compile scripts for Pro*C, Pro*Cobol u Other supporting web package(s) 18

Banner Basics - Objects u Database n Product owners n Product codes n Important Banner Basics - Objects u Database n Product owners n Product codes n Important users n Database Objects u Tables u Views u Packages (procedures and functions) u Triggers 19

Banner Basics – Product owners u Product Owners and Codes u General GENERAL G Banner Basics – Product owners u Product Owners and Codes u General GENERAL G u Student SATURN S u Finance FIMSMGR F u AR TAISMGR T u Position Control POSNCTL N u Payroll PAYROLL P u Fin. Aid FAISMGR R u Alumni ALUMNI A u Web for … WTAILOR TW 20

Banner Basics - Example u Database objects (Tables and views) n Example: G L Banner Basics - Example u Database objects (Tables and views) n 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 u a. T_abcdddd_xxxxxxxxx (Total no more than 29) u a Banner Basics - Triggers u a. T_abcdddd_xxxxxxxxx (Total no more than 29) u a = Product identifier (S) Student, (P)ayroll u T = Trigger u abcddd = Table name u xxxxx = Meaningful trigger name 22

Banner Basics - Procedures u Database n Procedures and Functions u u F_xxxxxxxxx (Total Banner Basics - Procedures u Database n Procedures and Functions u u F_xxxxxxxxx (Total no more than 29) u n P_xxxxxxxxx (Total no more than 29) xxxxx = Meaningful name (Up to 27 characters) Cursors u xxxxxxxxxxxxxx_C 23

Banner Basics – Referential Integrity u Referential integrity n Parent/Child relationships are enforced at Banner Basics – Referential Integrity u Referential integrity n Parent/Child relationships are enforced at the database level n No child data without a referenced parent key n No deletion of parent key while child records exist 24

Banner Basics – RI example Permanent Address STVATYP Parent Table PR Foreign Key FK Banner Basics – RI example Permanent Address STVATYP Parent Table PR Foreign Key FK 1_SPRADDR_INV_STVATYP_CODE on SPRADDR_ATYP_CODE Primary Key PK_STVATYP on STVATYP_CODE 101 PR SPRADDR Child Table 25

Exercise 2 u u u What can you tell me about the column SPRADDR_ATYP_CODE? Exercise 2 u u u 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 u u There is an installer (baninst) for the SCT Banner Basics - Installer u u 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 u u u There is an unload and decrypt Banner Basics – Unloading Banner u u u 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 u u BANNER_HOME is a variable used to define the Banner Basics - BANNER_HOME u u 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) u u BANENV is a shell script that is Banner Basics - BANENV (Unix) u u 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 u BANINST 1 n u Owns all the functions, Banner Basics - Important Users u BANINST 1 n u Owns all the functions, packages, procedures, and views BANSECR n Owns the SCT Banner security tables and objects 31

Exercise 3 1. What schema owner should own your views? 2. Do you still Exercise 3 1. What schema owner should own your views? 2. Do you still have your original install directory? 32

Banner Installation - Software u Two CD-ROMs of SCT Banner software n n u Banner Installation - Software u Two CD-ROMs of SCT Banner software n n u u u 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 u The SCT Banner database software is installed on the Banner Installation - Process u The SCT Banner database software is installed on the RDBMS server in several steps: n Download Software n Create SCT Banner Environment n Create SCT Banner Instance n Create SCT Banner Database Objects n Compile Pro*C and Pro*Cobol 34

Banner New Installation – Step 1 u The first step is to download the Banner New Installation – Step 1 u The first step is to download the software u There are four basic steps in downloading: n Identify Products to download n Define Global Variables n Download the software n Build the environment control scripts 35

Banner New Installation – Identify products u Identify Products to download (banpswd. shl) n Banner New Installation – Identify products u Identify Products to download (banpswd. shl) n n n 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 u Define Global Variables (banprmp. shl) n BANNER_HOME Banner New Installation – Global definitions u Define Global Variables (banprmp. shl) n BANNER_HOME n EXE_HOME n ORACLE_SID n COBOL 37

Banner New Installation – Software download u u Download the software (bansrce. shl) This Banner New Installation – Software download u u Download the software (bansrce. shl) This process will download the software from the CD u Decrypt u Decompress u Populates the following directory structure: 38

SCT Banner Software Directory Root Directory BANNER_ROOT FOCEXP_ROOT BANNER (BANNER_HOME) FOCEXP (FOCEXP_HOME) alumni arsys SCT Banner Software Directory Root Directory BANNER_ROOT FOCEXP_ROOT BANNER (BANNER_HOME) FOCEXP (FOCEXP_HOME) alumni arsys common finaid finance general install payroll posnctl student upgrades links The Banner Software Default Directory Structure 39

Banner Software Directories u BANNER_HOME n Defines the home directory of the SCT Banner Banner Software Directories u BANNER_HOME n Defines the home directory of the SCT Banner products u Each product has its own directory u General is a special product n Contains executables and administrative objects u Common is used for cross-product objects u Upgrades are used to stage SCT Banner upgrades u Links directory is used to centralize process access 40

Banner General Directories general c cob dbprocs forms exe gif ico install misc plus 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 u u C directory contains the Pro*C source COB directory contains Banner Product Directories u u 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 u u MISC directory contains the Perl scripts used on the Banner Product Directories u u 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 u General directory contains some special subdirectories: n EXE contains all the General Directories u General directory contains some special subdirectories: n EXE contains all the executables for all products n GIF contains the. gif files used in SCT Banner n ICO contains the icon files used in SCT Banner n ADMIN and PLUS directory under General also contains administration and upgrade scripts 44

Banner New Installation – Step 2 u The install process then builds some environment Banner New Installation – Step 2 u The install process then builds some environment manipulation scripts for managing SCT Banner variables (bansubs. shl): n banenv - for the Bourne shell n cbanenv - for the C shell n kbanenv - for the Korn shell n n *banali - for printer aliasing for the various shells Banlogic - for VMS 45

Banner New Installation – Environment creation u The next step of the install process Banner New Installation – Environment creation u The next step of the install process will create an SCT Banner environment on the RDBMS server u Build the LINKS directory (banlnks. shl –UNIX only) u Update the environment (bansenv. shl) n Oraenv is then modified to point to the banenv and cbanenv files (UNIX) n Oratab is modified with the new database n Banlogic. com is modified with directory locations (VMS) 46

Banner New Installation – Step 3 u The next set of steps creates the Banner New Installation – Step 3 u The next set of steps creates the SCT Banner database n Uses a pre-created database (bancrdb. shl, bancrtb. shl are provided for reference) n Creates the SCT Banner accounts (bancrus. shl) n Modifies the SCT Banner database configuration (baninit. shl) 47

Banner New Installation – Step 4 u The next set of steps in the Banner New Installation – Step 4 u The next set of steps in the NEW install will create the database objects n Import SCT Banner tables and sample data (banimp. shl) n Build SCT Banner procedures and functions (bandbpr. shl) n Import views and create synonyms (banvwsy. shl) 48

Multiple Banner environments u Multiple SCT Banner software environments n n n Initial install Multiple Banner environments u Multiple SCT Banner software environments n n n 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: u Shell scripts u Icons u DOS. bat files 49

Multiple Banner databases u Multiple SCT Banner instance databases n n n Initial install Multiple Banner databases u Multiple SCT Banner instance databases n n n 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: u Shell files/registry/DCL procedures u Icons u DOS. bat files 50

Banner Default Databases SEED n Out-of-the-box SCT Banner n Used to run new SCT Banner Default Databases SEED n Out-of-the-box SCT Banner n Used to run new SCT Banner upgrades against first n Upgrade issues are then SCT issues n Work out the details before upgrading production database 51

Banner Default Databases TRNG n Used for implementation training n Out-of-the-box SCT Banner with Banner Default Databases TRNG n Used for implementation training n Out-of-the-box SCT Banner with some additions u u n Training user accounts Training data Usually cloned from SEED 52

Banner Default Databases PPRD n Used for implementation and conversion n Out-of-the-box SCT Banner Banner Default Databases PPRD n Used for implementation and conversion n Out-of-the-box SCT Banner with some deletions u n n 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 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 u Multiple SCT Banner environments will need both Oracle and SCT Banner Banner environment u Multiple SCT Banner environments will need both Oracle and SCT Banner variables set n . profile or. login calls oraenv (UNIX) n Login. com calls orauser_SID. com (VMS) n ORAENV sets: orauser_SID. com sets: u ORAENV_ASK -- u ORACLE_HOME ORA_DB u ORACLE_SID ORA_SID u PATH SQLPATH 55

Banner environment - Others u VMS n Command procedural calls: u u u Banlogic. Banner environment - Others u VMS n Command procedural calls: u u u Banlogic. com Orauser_SID. com NT/Win 2000 n Path environment n Registry 56

Banner environment variables u Based on the SID, the appropriate environment file is called Banner environment variables u Based on the SID, the appropriate environment file is called n BANENV/Registry sets: BANLOGIC sets: u BANNER_HOME BAN_HOME u BANNER_LINKS BAN_ROOT u BANNER_ADMIN u EXE_HOME GEN$EXE u ORACLE_PATH ORA_PATH u PATH SQLPATH 57

Banner database performance u Management of an SCT Banner database involves proactively managing: n Banner database performance u Management of an SCT Banner database involves proactively managing: n Memory u u Is your system page-faulting? u n Are your users complaining? Running SQL scripts to maintain the system Disk storage u n Fragmentation Database objects u Invalid state 58

Banner Database Administration u Close relationships with the System and Network staff n n Banner Database Administration u Close relationships with the System and Network staff n n Backup and recovery in place n u Patches and upgrades are maintained Network access It also involves being able to: n Create databases n Clone databases n Upgrade all Oracle software u “How to have a life and be a DBA also” 59

Banner - Memory Management u SCT Banner moves a lot of data and involves Banner - Memory Management u SCT Banner moves a lot of data and involves a lot of code n u OLTP vs. DSS This means that the DBA must take an active stance on monitoring and managing SCT Banner's use of memory n Checking the SGA: u How often does the database get data from disk vs. memory? u How often are the stored packages accessed? 60

Oracle - Memory Management u The main areas the DBA must be concerned with Oracle - Memory Management u The main areas the DBA must be concerned with are: n Data Base Buffers - v$sysstat n Shared pool - pins and gets n Redo logs - Checking the alert logs, v$sysstat n Data Dictionary cache - v$rowcache n Library cache - v$librarycache n Sort Areas - temporary tablespace 61

Banner - Storage Management u SCT Banner databases take active storage management u Tables Banner - Storage Management u SCT Banner databases take active storage management u Tables grow constantly u Indexes become unusable u u Database use causes problems like storage fragmentation and row chaining New tables with upgrades 62

Oracle - Storage Management u The storage management tasks the DBA will be most Oracle - Storage Management u The storage management tasks the DBA will be most heavily involved in are: n Tablespace growth n Table sizing n Rollback segment sizing n Restructuring the database u Resizing/moving tables and indexes u Tablespace placement u RAID vs. non-RAID 63

Banner – Disk Storage Management u RAID n Important to have for an Oracle Banner – Disk Storage Management u RAID n Important to have for an Oracle system n Jbod – Lowest data cost – low overhead n 0 – low data cost – load balancing n 0, 0+1 – high data cost – most expensive n 5 – Highest data cost – safe u It takes four I/Os for one write (read data, read parity, write data, write parity) u Minimum of three disks, plus 66 -87% of space u The more disks, the higher the gain u Not good with REDO – Sequential vs random writes 64

Banner - Object Management u u SCT Banner is installed in one tablespace, usually Banner - Object Management u u SCT Banner is installed in one tablespace, usually named DEVELOPMENT Can be divided into many tablespaces as required by the institution n Access reasons n Performance reasons n Maintenance reasons n Multi-institution reasons 65

Banner utilities u SCT-supplied data catalog tool GURPDED n u Run through Job Submission Banner utilities u SCT-supplied data catalog tool GURPDED n u Run through Job Submission SCT-supplied tool called GURRDDL n Used to resize tables n Used to resize indexes n Handles the referential constraints n Handles the permissions n Handles the synonyms n Can be used to move one or many tables 66

Oracle fragmentation u u Databases can fragment, even with the best of software Fragmentation Oracle fragmentation u u 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 u u u Oracle is moving towards a methodology that Oracle locally managed tablespaces u u u 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 u There are sets of scripts provided with SCT Banner – General object management u There are sets of scripts provided with SCT Banner that are used to compile/recompile database objects n General Packages, Procedures, Functions, and Triggers u n /sct/banner/general/dbprocs/gendbpr. sql General Views u /sct/banner/general/views/genview. sql 69

Banner – Student object management u There are sets of scripts provided with SCT Banner – Student object management u There are sets of scripts provided with SCT Banner that are used to compile/recompile database objects n Student Packages, Procedures, Functions, and Triggers u n /sct/banner/student/dbprocs/studbpr. sql Student Views u /sct/banner/student/views/stuview. sql 70

Banner - Object management utility u u SCT-supplied tool called GURALTR Searches database for Banner - Object management utility u u SCT-supplied tool called GURALTR Searches database for invalid objects and builds a recompile script n Used to recompile database objects (not sys nor system) u Packages u Package Bodies u Triggers u Procedures u Functions 71

Exercise 5 u u u How many different Banner code trees does your oraenv Exercise 5 u u u 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 u u u Run utlrp. sql as SYS to compile ALL Compiling invalid objects u u u Run utlrp. sql as SYS to compile ALL database objects Use GURALTR to recompile ALL non-SYS and non. SYSTEM database objects BANINST 1 owns the database packages, procedures, functions and views n n u Use GURALTRB to recompile BANINST 1 objects Run multiple times for dependencies After manipulating ANY database objects, run GURALTR to fix any broken dependencies 73

Banner database triggers u BANINST 1 does not own the database triggers n n Banner database triggers u BANINST 1 does not own the database triggers n n n 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 u u There is an administrative directory for SCT Banner on Banner administrative software u u There is an administrative directory for SCT Banner on the RDBMS server $BANNER_HOME/admin n n Banlogic (VMS) n profile. ban n u Banenv (UNIX/NT) upcase. shl $BANNER_HOMEHadmin/v 6/oratools 75

Banner non-database related software u SCT Banner also requires management of all the software Banner non-database related software u SCT Banner also requires management of all the software outside of the database n Executable compiles u Pro*Cobol n SQL*Plus scripts n SQL*Loader scripts 76

Banner Pro*C - 1 u u Each product owner may have a set of Banner Pro*C - 1 u u Each product owner may have a set of Pro*C programs Located in /sct/banner//c n n u Based on old Oracle RPTs Ugly but consistent design . h - Header files (General/c only) n guarpfe. h - Routines for RPT emulation n guastdf. h - Routines for C print formatting 77

Banner Pro*C - 2 u . c - C source files (General/c only) n Banner Pro*C - 2 u . c - C source files (General/c only) n n guastdf. c - Routines for C print formatting n u guarpfe. c - Routines for RPT emulation guaorac. c - Routines for Oracle interface . pc - Pro*C source files n gurjobs. pc - Job Submission Pro*C program n gjrrpts. pc - SCT Banner Reports print program 78

Banner Pro*C - 3 u The compile scripts for each product's set of Pro*C Banner Pro*C - 3 u 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) n General Pro*C u n Student Pro*C u n /sct/banner/general/misc/gencmplc. shl /sct/banner/student/misc/stucmplc. shl Finance Pro*C u /sct/banner/finance/misc/fincmplc. sql 79

Banner Pro*Cobol - 1 u u Each product owner may have a set of Banner Pro*Cobol - 1 u u Each product owner may have a set of Pro*Cobol programs Located in /sct/banner//cob /sct/banner/general/cob also contains the Pro*Cobol copylibs *. pco - Pro*Cobol source files 80

Banner Pro*Cobol - 2 u The compile scripts for each product's set of Pro*Cobol Banner Pro*Cobol - 2 u The compile scripts for each product's set of Pro*Cobol programs are in the corresponding product MISC directory n General Pro*Cobol u n Student Pro*Cobol u n /sct/banner/general/misc/gencmpl. shl /sct/banner/student/misc/stucmpl. shl Finance Pro*Cobol u /sct/banner/finance/misc/fincmpl. sql 81

Banner SQL*Plus u u u SCT Banner also has SQL*Plus scripts that are used Banner SQL*Plus u u u SCT Banner also has SQL*Plus scripts that are used by the various SCT Banner products Located in: /sct/banner//plus General also has some scripts that are used for admin and upgrade purposes n LOGIN. SQL n GURALTRB n GURRDDL n GOSTAGE 82

Banner SQL*Loader u SCT Banner also has SQL*Loader scripts that are used to load Banner SQL*Loader u SCT Banner also has SQL*Loader scripts that are used to load outside data n n u Test scores EDI Located in: /sct/banner//loader n *. ctl - SQL*Loader control files 83

Exercise 6 u Run the $BANNER_HOME/admin/V 6/oratools/freebyte. sql script. How many free, used, and Exercise 6 u Run the $BANNER_HOME/admin/V 6/oratools/freebyte. sql script. How many free, used, and total bytes are in the development tablespace in the TRNG database? u What is the fully qualified name of the script to compile the GSASECR. fmb file? 84

Banner - Access methods u Considerations need to be made for: n Access to Banner - Access methods u Considerations need to be made for: n Access to the SCT Banner system u Database(s) u Forms u Report output n User vs. developer access n SCT Banner System vs. SQLPLUS n Microsoft Access 85

Creating an SCT Banner Database u u Production databases are usually created sometime after Creating an SCT Banner Database u u 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 u Creation is done through one of the many tools Banner Database creation methods u Creation is done through one of the many tools available n n 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 – Oracle 7/8 i u Cloning is done through a Cloning a Banner Database – Oracle 7/8 i u Cloning is done through a database recovery mechanism n Database files are copied to new directory structure n Produce a control file re-creation script by issuing as sys: u n 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 8 i/9 i 1. Use RMAN to make Cloning a Banner Database – Oracle 8 i/9 i 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 8 i Administrators Guide 89

SCT Banner - Backup Strategies u Cold backups n n u Involves taking the SCT Banner - Backup Strategies u Cold backups n n u Involves taking the database offline Should be performed occasionally Online backups n Oracle has very good recovery mechanisms n Allows the database to remain in service n With RMAN, backup and recovery can be completely automated 90

Exercise 7 u Why is the method used to clone Oracle 7 databases not Exercise 7 u Why is the method used to clone Oracle 7 databases not a good one for Oracle 8 databases? u What is your current backup strategy? u Is it documented? 91

Self Service Banner (SSB) Products u u The SCT Self Service Banner … products Self Service Banner (SSB) Products u u 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 u Is not “Internet Native” Banner u Customizable look and feel u Rules-defined access and display 92

Self Service Banner services u Implemented by using database packages and procedures u Generates Self Service Banner services u Implemented by using database packages and procedures u Generates dynamic HTML pages from the database u Uses Oracle’s 9 i. AS Mod_plsql u Uses Oracle's PL/SQL Toolkit package u Has an administrative tool called Web Tailor 93

Documentation u u The end user guides are available through Banner Bookshelf through the Documentation u u 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 u Each product has its own set of Guides u Web Tailor has its own set of Guides 94

Self Service Banner Software Install u SCT Self Service Banner… installs are done on Self Service Banner Software Install u SCT Self Service Banner… installs are done on the SCT Banner RDBMS server u Packages are built in the database u The software is installed in Web for product directories n /sct/banner/aluweb n /sct/banner/facweb n /sct/banner/genweb n /sct/banner/payweb n /sct/banner/scomweb n /sct/banner/stuweb n /sct/banner/wtlweb 95

Self Service Banner Software Structure u Each SCT Self Service Banner … product directory Self Service Banner Software Structure u Each SCT Self Service Banner … product directory contains some of the following structure: n c- C programs used in web applications n dbprocs - Web packages n gif - graphics objects for buttons n html - Product web pages n misc - Web administrative scripts 96

Self Service Banner Install u u u There is no SCT Banner install on Self Service Banner Install u u u 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 u From the web server, for each SCT Self Service Banner Web Server Install u From the web server, for each SCT Banner instance: n Create a DAD (Database Access Descriptor) u u n Created with Oracle’s 9 i. AS 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 u u Click on Gateway Database Access Descriptor Settings Enter n n Gateway. htm u u Click on Gateway Database Access Descriptor Settings Enter n n n DAD Name: SID_SSB Schema Name: www_user Oracle User Name: www_user Oracle Password: u_pick_it Oracle Connect String: SID u Click Apply u Repeat for each database. 99

PL/SQL Toolkit u u Install the latest PL/SQL Toolkit patch into Oracle 9 i. PL/SQL Toolkit u u Install the latest PL/SQL Toolkit patch into Oracle 9 i. AS. Apply the same level toolkit into each database by running a provided script in $ORACLE_HOMEApachemodplsqlcfg u Owaload. sql 100

Self Service Banner Web server directories u Copy. gif and. htm files for each Self Service Banner Web server directories u Copy. gif and. htm files for each product from the directories on the RDBMS server to the appropriate directory on the web server: n /sct/banner/*web/gif u n /sct/ssb/SID/*gifs /sct/banner/*web/htm u /sct/ssb/SID/*help 101

Self Service Banner Web Server listener u Configure the Web server to ‘serve up’ Self Service Banner Web Server listener u Configure the Web server to ‘serve up’ SSB u Create the HTTP listener n Set Document. Root and

Self Service Banner homepage. htm u The next step is to set up the Self Service Banner homepage. htm u The next step is to set up the homepage. htm file n Copy from: /sct/ssb/SID/wtlhelp/homepage. htm n To: /sct/ssb/SID/homepage. htm n Replace //your server name: port/test/owa/ with your site's Mod_plsql reference and DAD u i. e. //bandev: 8080/pls/SEED/ 103

Self Service Banner Web Server u u u There are links that must be Self Service Banner Web Server u u u 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 9 i. AS security and update patches n As of August, 2003 u 8. 1. 7. 4 u Mod_plsql 3. 0. 9. 8. 4 u Jserv Rollup #3 104

Self Service Banner Objects u The only SCT Banner software to manage on the Self Service Banner Objects u The only SCT Banner software to manage on the web server are the web objects needed by the Web For … products n n . htm files n u . gif files Web Tailor image files These will be updated as new versions come out 105

Self Service Banner RDBMS Software u There are sets of scripts provided with SCT Self Service Banner RDBMS Software u There are sets of scripts provided with SCT Banner that are used to compile/recompile database objects n Stuweb Packages, Procedures, Functions, and Triggers u n /sct/banner/stuweb/dbprocs/hstudbpr. sql Genweb Packages, Procedures, Functions, and Triggers u /sct/banner/genweb/dbprocs/hgendbpr. sql 106

Self Service Banner Client u Netscape 4. x u Explorer 5. x/6. x u Self Service Banner Client u Netscape 4. x u Explorer 5. x/6. x u Generally, stay a release or two back from the latest and greatest browsers u Supports other browsers (opera, mozilla) u Can use Windows 95 up to the latest u Can use Mac. OS 107

Exercise 8 u u u From where is each web page generated? How would Exercise 8 u u u 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 u In Internet Native Banner, the Oracle runforms software has Internet Native Banner Parts u In Internet Native Banner, the Oracle runforms software has been modified to run in two parts: u u n 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 u There are two products involved: n n u u Internet Native Banner Products u There are two products involved: n n u u The Apache web server utilizing servlet technology The Oracle Forms web runtime engine (included in 9 i. AS) 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 u There are two supported ways to install this: Internet Native Banner - Installs u There are two supported ways to install this: n u Oracle 9 i. AS http server-only installation, plus the Forms and Reports 6 i server Plus patchset 13 for Oracle Forms and Reports 6 i n 9 i. AS Enterprise Edition u Plus patchset 13 for Oracle Forms and Reports 6 i 111

INB – files to be modified u D: ORACLEi. SuitesApacheconfhttpd. conf n u D: INB – files to be modified u D: ORACLEi. SuitesApacheconfhttpd. conf n u D: ORACLEi. SuitesApacheJservconfjserv. properties n u Forms servlet configuration file D: ORACLE806conf6 iserver. conf n u Forms servlet initializaion D: ORACLE806forms 60serverformsweb. cfg n u Servlet engine classpath D: ORACLEi. SuitesApacheJservservletszone. properties n u Apache listener configuration Virtual path definitions for web forms D: ORACLE806forms 60serverdefault. env n Environment variables for the FORMS and REPORTS servlets 112

INB – httpd. conf u Configure the Web server to ‘web up’ INB u INB – httpd. conf u Configure the Web server to ‘web up’ INB u Edit the HTTP listener n Set Dcument. Root and

INB – Zone. properties and Jserv. properties u Zone. properties n n u servlet. INB – Zone. properties and Jserv. properties u Zone. properties n n u servlet. SID. code=oracle. forms. servlet. Listener. Servlet servlet. SIDD. init. Args=envfile=d: sctssbseedconfseed. env Jserv. properties n # Oracle Forms and Reports Servers n wrapper. classpath=D: ORACLE806forms 60javaf 60 srv. jar n wrapper. path=D: oracleisuitesbin; D: ORACLE806bin 114

INB – formsweb. cfg u You can set up additional code trees with separate INB – formsweb. cfg u You can set up additional code trees with separate environment files by changing: n archive_jini=f 60 all_jinit. jar to archive_jini=f 60 all_jinit. jar, banicons. jar n server. URL= to server. URL=/servlet/PPRD n form=test. fmx to form=guainit. fmx n page. Title=Oracle Forms Server to page. Title=Internet Native Banner n width=650 to width=800 n height=500 to height=500 115

INB – Formsweb. cfg u Other changes: n separate. Frame=false to separate. Frame=true n INB – Formsweb. cfg u Other changes: n separate. Frame=false to separate. Frame=true n background= to background=no n look. And. Feel=Oracle to look. And. Feel=Generic n archive=f 60 web. jar to archive=f 60 web. jar, banicons. jar n n archive_ie=f 60 all. cab to archive_ie=f 60 all. cab, banicons. jar connect. Mode=socket to connect. Mode=http 116

INB – Formsweb. cfg u Comment out the following lines: n n ; server. INB – Formsweb. cfg u Comment out the following lines: n n ; server. Port=9001 n u ; server. App=default ; server. Host=144. 17. 90. 12 Add: n [seed] n server. URL=/servlet/SEED n [seedsecurity] n server. URL=/servlet/SEED n form=gsasecr. fmx 117

INB - Jinitiator u u Note that Patchset 13 ships Jinitiator version 1. 3. INB - Jinitiator u u 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. n n u object_executable=jinit. exe#Version=1, 3, 1, 9 n u object_classid=clsid: CAFE-0013 -0001 -0009 -ABCDEF 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 u Edit each of these files u Base. INB – base. htm, baseie. htm u Edit each of these files u Base. htm, baseie. htm: n Two (2) lines were added to the file: u u n Three (3) lines are commented out: u ; u ; u ; 119

INB – basejini. htm u Modify this file with: n <PARAM NAME= INB – basejini. htm u Modify this file with: n and image. Base="%image. Base%" n and n client. DPI="%client. DPI%" n Six (6) lines are commented out: u ; u ; u ; u ; server. Port="%server. Port%" u ; server. Host="%server. Host%" u ; server. App="%server. App%" 120

INB – Servlets environments u u Copy D: oracle806forms 60serverdefault. env to D: oracle806forms INB – Servlets environments u u Copy D: oracle806forms 60serverdefault. env to D: oracle806forms 60serverban 5. env Add the following lines n n u LOCAL=SID_ban TNS_ADMIN=D: oracle806net 80admin Change the following lines for your environment n FORMS 60_PATH=D: sctSIDfmx n REPORTS 60_PATH=D: sctSIDfmx n PRINTER=sctmtal 5 n GRAPHICS 60_PATH=D: sctSIDfmx 121

INB – 6 iserver. conf u u Stop the Oracle. HTTPServer service in the INB – 6 iserver. conf u u Stop the Oracle. HTTPServer service in the Control Panel. Edit the D: oracle806conf6 iserver. conf to add a virtual directory for the Banner help files and to rewrite the url. n Alias /hlp/ "D: sctinbSEEDdochlp“ n Alias /bookshelf/ “D: sctinbSEEDdocpdf 122

INB - DAD u u GJIREVO requires a DAD (Database Access Descriptor). To create INB - DAD u u GJIREVO requires a DAD (Database Access Descriptor). To create a DAD edit D: oracle102Apachemodplsqlcfgwdbsvr. app change: n n ; admindad = portal 30 Run gateway. htm: http: //host: port/pls/admin_/gateway. htm u DAD Name: SID u Schema Name: www_user u Oracle User Name: www_user u Oracle Password: u_pick_it u Oracle Connect String: SID_ban 123

INB – gif files u u On your database server or your forms server INB – gif files u u On your database server or your forms server change directory to the location of your gif files Execute the jar (Java archive tool) command n u jar cvf banicons. jar *. gif Copy or binary ftp the banicons. jar file to D: OracleForms 60java 124

INB – Files in general/extras (upgrade) u fmrpcweb. res (copy or ascii ftp to INB – Files in general/extras (upgrade) u fmrpcweb. res (copy or ascii ftp to D: Oracle806Forms 60 and rename to fmrweb. res) n n u For F 1 display help add this line to fmrweb. res 112 : 0 : "F 1" : 1004 : "Help (Item Properties)" cgicmd. dat (copy or ascii ftp to the D: Oracle806Report 60Server). n Edit the cgicmd. dat file appropriately as documented in the file cgicmd. dat. 125

Starting INB – NT/Win 2000 u Click on Start -> Settings -> Control Panel Starting INB – NT/Win 2000 u Click on Start -> Settings -> Control Panel -> Services n Stop/Start the Oracle. HTTPServer service. n Stop/Start the Oracle. Report. Server service. u Execute INB (Internet Native Banner) u Start your browser with the URL (example only): n u http: //HOST. anyu. edu: 80/servlets/f 60 servlet? config=ban. SID When the guainit form starts, enter n Username: saisusr n Password: u_pick_it 126

Starting INB - UNIX u Log on as Oracle u . Oraenv u cd Starting INB - UNIX u Log on as Oracle u . Oraenv u cd $ORACLE_HOME/Apache/bin u . /apachectl start u Start a web browser and enter your url: (set ias ORACLE_HOME) http: //HOST: port/servlets/f 60 servlet? config=ban. SID 127

Exercise 9 1. 2. What is the major difference between base. htm, baseie. htm 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 End of Session Any Questions? 129

Thank you for your participation today Thank you for your participation today