MBF COMPANY CONFIDENTIAL FIELD INFORMATION BULLETIN SERVICE GROUP(S): MICRO,MINI,LARGE MFG: ORACLE NACS TYPE(S): N058 MFG. MODEL(S): Relational Data Base CATEGORY: SOFTWARE DESC: UNIX Software Package *** TABLE OF CONTENTS AS OF 02/01/91 *** FIB 00001.ORACLE for GPx Series 40 Software Announcement [ WPSS 181 ]01/02/91 SOFTWARE-ORACLE-Relational Data Base----------------Table Of Contents Pg01 of 01 FIB 00001 01/02/91 *** ORACLE for GPx Series 40 Software Announcement [ WPSS 181 ] *** MAI Systems Corporation announces the availability of ORACLE on the GPx Series 40 platform. The ORACLE product contains a Relational Database Management System engine, 4GL development tools, SQL interfaces for popular 4GLs and networking software for running applications and accessing data between systems. Some or all of these products can be used to develop a customized database suited specifically for the customer's needs. This Software Announcement outlines the installation and setup for the Series 40 platform. As an authorized distributor of ORACLE products, MAI can sell ORACLE directly. If problems arise with MAI terminals, printers or hardware platforms and Oracle, support is provided by MAI. Oracle provides licensed support to licensed users in the form of telephone support. Please contact the MAI Systems Corp. Education Center for information regarding training for ORACLE products. The phone number for the Education Department is (714) 730-3100. TABLE OF CONTENTS 1.0 SYSTEM REQUIREMENTS. . . . . . . . . . . . . . . . . . . . 1 2.0 ORACLE INSTALLATION INSTRUCTIONS . . . . . . . . . . . . . 2 3.0 ORACLE INSTALLATION CHECKLIST. . . . . . . . . . . . . . . 3 4.0 ADDITIONAL REFERENCE MATERIAL. . . . . . . . . . . . . . . 4 APPENDIX A - ORACLE INSTALLATION SCRIPT. . . . . . . . . . . A-1 ORACLE FOR GPx SERIES 40 1.0 SYSTEM REQUIREMENTS o The only software distribution media is 1/4" cartridge tape. o You must install ORACLE using the Bourne shell (/bin/sh). o The minimum operating system level for ORACLE is 1.0B*21. o The minimum operating system level for SQL*Net is 1.1A. o If the current operating system level is 1.0B*21, a patch tape is required to complete a successful installation. The patch tape is "Patch #30 - TPS ORACLE TERMINFO FILES". o Before ORACLE can be installed successfully, the UNX product must be installed from the operating system tape. (1.0B only) o Before ORACLE can be installed successfully, the TPS product must be installed from the operating system tape. o The user system running Oracle must have at least 8MB of internal memory. SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg001 NOTE: The UNX product is sent out as part of the base product on the 1.0C O/S tape and would not be a selectable option using the mbfinstall utility. NOTE: If you are installing Pro*C, the CDEV product must also be installed. NOTE: The CDEV product is also required if you want to re-link to SQL*Net TCP/IP. An MAI product key is required for CDEV. NOTE: A Master Reset on a terminal is required, prior to executing ORACLE, if MAI OFFICE is used on the same terminal otherwise various edit keys will not work properly. o The product RDBMS is mandatory to run the ORACLE products. All the other products are optional and can be installed based upon the user's needs. o The following are the known disk space requirements to load the individual ORACLE products from the distribution media: PRODUCT NAME MEGABYTES REQUIRED ---------------------- ------------------ ORACLE RDBMS........................................6.0 SQL*Forms...........................................2.5 SQL*ReportWriter....................................6.0 SQL*Plus............................................1.5 SQL*Loader..........................................0.4 Pro*C...............................................0.4 SQL*Report..........................................0.4 SQL*Net TCP/IP......................................0.3 CASE*Dictionary....................................10.0 SQL*Menu............................................2.0 An additional 6.0 MB is needed to accommodate the database, log and listing files that are generated when the ORACLE RDBMS Version 6.0 is installed. An additional 7.0 MB (approximately) are needed in the database to install CASE*Dictionary. o The following are the recommended values for the kernel parameters and shared memory parameters: SHMMAX = 524228 SHMSEG = 20 SEMMNS = 60 SHMMNI = 100 SHMALL = 512 SEMMNI = 10 To reconfigure your kernel, refer to the page 6-48 of the "BOSS/VX System Administrators Guide", M0187. Also refer to Chapter 5 of the "ORACLE Installation & User's Guide". o The following are the software requirements for the various ORACLE products. - Pro*C requires the CDEV product (C Software Development Set) which is on a separate distribution tape. In addition, the CDEV product requires an MAI public key to be installed when the software is loaded. SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg002 o Some programs turn off post processing of terminal I/O and do not turn it back on again when exiting. To avoid problems caused by this situation, add the following line to the user's .profile file. stty -nopost 2.0 ORACLE INSTALLATION INSTRUCTIONS This section will not give detailed information on how to install the ORACLE products. Instead, a checklist is provided to assist in the installation process. A "README" file is provided with the TPS product which details MAI specific ORACLE installation instructions and notes. The full path of this file is, "/usr/tps/Oracle/README". The manual, "ORACLE Installation & User Guide" provides detailed information on how to install each product. Refer to Chapter 3 for details on how to install the ORACLE RDBMS product. In Chapter 4, an explanation is given on how to install additional ORACLE systems. The manual also includes chapters on individual ORACLE products and provides details on installing each product. 3.0 ORACLE INSTALLATION CHECKLIST PHASE 1: PRE-INSTALLATION ACTIVITIES _____ Review ORACLE documentation. _____ Determine ORACLE home directory. _____ Decide on new DBA passwords system account: ______________________ sys account: ______________________ _____ Set up ORACLE account: _______________________ _____ Create DBA and ORACLE groups; assign root and ORACLE user ids to dba group _____ Increase operating system user process limit, if necessary. _____ Increase operating system swap space, if necessary. Adjust shared memory, semaphores and disk space, if necessary. _____ Load the software from the distribution media (tape). _____ Set the environmental variables. PHASE 2: INSTALLATION _____ Run "oracle.install" as root. _____ Run "oracle.install" as oracle. SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg003 PHASE 3: POST-INSTALLATION ACTIVITIES _____ Modify init.ora file parameters (optional) db_lock_buffers: __________________________ log_checkpoint_interval: __________________ process: __________________________________ _____ Create multiple control files _____ Edit each sh user's .profile (.login for csh users) _____ Edit /etc/rc command file to ensure orderly startup and shutdown. _____ Use the arch process (optional) 4.0 ADDITIONAL REFERENCE MATERIAL - ORACLE Installation & User's Guide - BOSS/VX System Administrators Guide - AT&T UNIX System V/386, Release 3.2 System Administrators Guide *************************************************************************** APPENDIX A ORACLE Installation Script INSTALLATION INSTRUCTIONS - ORACLE GPx Attached are the supplemental installation instructions for the following Oracle products. Oracle RDBMS Oracle Transaction Processing Oracle SQL*Forms Oracle SQL*ReportWriter Oracle SQL*Plus Oracle SQL*Calc Oracle Pro*C Oracle SQL*Menu Oracle Terminal Oracle Ora*kit This document describes the supplemental installation instructions for supported Oracle application software packages. This is not intended to serve as a replacement for the instructions provided by Oracle, but rather a supplement to provide details relevant to using Oracle on BOSS/VX. The products require the following host system and host software products: GPx 40 Modular Business System with 1/4" tape drive 1.0A BOSS/VX or later Operating System TPS product CDEV product (requires an installation key) Oracle Installation and User's Guide for V6.0. SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg004 The Oracle products must be installed as outlined in the following instructions. 1. Log in as 'root'. 2. There are two environment variables that you may wish to change, especially if you anticipate several concurrent Oracle users: Variable Default New Value maxup 35 maximum # of users + 5 shmseg 6 20 To change these variables you must edit the dct file as follows: # /etc/mkdct -r -o /etc/dct # vi /etc/dct.asc (make the required changes) # /etc/mkdct -o /etc/dct NOTE: '#' is the root system prompt. 3. Using the 'oprinfo' utility, select option 6 'Add a group', and create two groups, dba and oracle. Add root to the list of group members for the dba group. 4. Using the 'oprinfo' utility, select option 1 'Add a user', and create user name oracle. The default for 'group name (id)' is other (1), change this group to dba. Respond with 'y' when asked if you want to give the new user a .profile file. 5. Using 'vi', edit the .profile file just created in the oracle home directory, adding the following lines: ORACLE_HOME=/usr/oracle (or the directory name you have chosen) Add $ORACLE_HOME/bin to $PATH. Note that ORACLE_HOME must appear before $PATH for this to work correctly. Add ORACLE_HOME to the 'export' line in the .profile file. You will also want to enter ORACLE_HOME into your current environment by doing the following at the system prompt: # ORACLE_HOME=/usr/oracle; export ORACLE_HOME To verify this worked correctly, type 'env' at the system prompt. This will list all your current environment variables. The ORACLE_HOME should be . displayed. If not, try reentering the above lines. 6. Load the media supplied into the tape drive and transfer the contents to disk. You should be in the ORACLE_HOME directory. You can get there by doing the following: # cd $ORACLE_HOME Load the media using the following command: # cpio -icvBdum < /dev/tape Load ALL the products onto the disk. SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg005 7. Now refer to the Oracle installation guide. Chapter 3 is the most important, but the other chapters should be read. Follow ALL recommended installation procedures. In case of installation errors that cannot be resolved by the commands specified in the install log, remove all the products from the disk to clear any partial or incorrectly created files and reinstall the products from the tapes. Start with the chapter 3 instructions again. When asked to choose a default terminal type, choose the DEC vt100 option. It doesn't matter which vt100 options are selected since the terminal types will be redefined at a later point in the installation process. NOTE: Some of the Oracle prompts claim the installation will take from 10 to 20 minutes. This is generally closer to 60 - 90 minutes. 8. After the product installation is complete, you will need to install the DT4313 and DT4314 terminal definitions in order to use them with some of the Oracle products (SQL*Calc, SQL*Menu, and SQL*Forms). This step requires SQL*Plus be installed. You should be in the $ORACLE_HOME directory. First copy these files into the $ORACLE_HOME directory: /usr/tps/Oracle/dt4313_def.sql /usr/tps/Oracle/dt4314_def.sql $ cp /usr/tps/Oracle/dt4313_def.sql $ORACLE_HOME $ cp /usr/tps/Oracle/dt4314_def.sql $ORACLE_HOME NOTE: '$' is the oracle user prompt. Next, load these files into the Oracle database: $ sqlplus system/ You will see the SQL*Plus prompt 'SQL>'. Enter the following: SQL> start dt4313_def SQL> start dt4314_def SQL> exit Now, back at the oracle user prompt, do the following: $ crt dt4314 system/ $ crt -d dt4314 system/ This completes the terminal definition sequence and establishes the dt4314 as the default terminal. 9. SQL*ReportWriter Terminal Definitions. # cp /usr/tps/Oracle/dt4313-14.tdf $ORACLE_HOME/sqlreport/admin/terminal # cp /usr/tps/Oracle/srw_dt4313.kdf $ORACLE_HOME/sqlreport/admin/terminal # cp /usr/tps/Oracle/srw_dt4313.key $ORACLE_HOME/sqlreport/admin/terminal # cp /usr/tps/Oracle/srw_dt4314.kdf $ORACLE_HOME/sqlreport/admin/terminal # cp /usr/tps/Oracle/srw_dt4314.key $ORACLE_HOME/sqlreport/admin/terminal # cd $ORACLE_HOME/sqlreport/admin/terminal Make a backup of ther termdef.dat file. # cp termdef.dat termdef.dat.bak Edit the termdef.dat file, add the terminal definitions for the dt4313 and dt4314 terminals. SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg006 # vi termdef.dat Add the dt4313-14.tdf file to the end of the file and save it. Install the definitions. # termdef 4313 srw_dt4313 srw_dt4313.kdf # termdef 4314 srw_dt4314 srw_dt4314.kdf To use these terminal types, they will have to be specified on the command line when running sqlrep. Please refer to Oracle documentation for complete instructions. 10. Add the following line to the oracle user's .profile file to ensure correct function key responces: stty quit ^O where ^O is entered by holding down the Ctrl key while pressing the capital O. Please be sure this line is above the 'oraenv' line in the .profile file. 11. Automatic Database Startup The following lines have been provided to automatically startup the Oracle . database during system reboot and to shut the database down during system shutdown: /usr/tps/Oracle/S8lora /usr/tps/Oracle/K8lora These files do need to be modified. To do this you must be 'root'. You can become root by doing the following: $ su root You will then be prompted for the root password. It is best to modify these files in the '/usr/tps/Oracle' directory, just in case they need to be copied again. Using 'vi' edit both files and insert the correct ORACLE_HOME directory. Now, copy the files to the correct destination directories: # cp /usr/tps/Oracle/S8lora /etc/rc2.d # cp /usr/tps/Oracle/K8lora /etc/rc0.d Edit the /etc/oratab file. Change the last field to 'y'. Also make sure the first field correctly names the ORACLE_SID value. Enter ^D at the system prompt to return to the oracle user. 12. Function Key Definition Reports The steps followed in paragraph 8 also set up function key definitions for the SQL*Menu, SQL*Calc, and SQL*Forms products. In order to provide a list of the function keys defined, the following files have been provided: SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg007 /usr/tps/Oracle/funckeys.lis /usr/tps/Oracle/funckeys.rpf /usr/tps/Oracle/funckeys.rpt Copy these files to the appropriate directories: $ cp /usr/tps/Oracle/funckeys.lis $ORACLE_HOME $ cp /usr/tps/Oracle/funckeys.rpf $ORACLE_HOME/report $ cp /usr/tps/Oracle/funckeys.rpt $ORACLE_HOME/report You may print a list of the function key definitions: $ cat funckeys.lis | lpr 13. National Language Support The 'init.ora' file needs to be modified. The variable 'language' and 'nsl_sort' needs to be set. Please see appendix F of the Oracle RDBMS Database Administrator's Guide for further details. To use this the 'pfile' option on STARTUP should be used. Please refer to chapter 14 of the Oracle RDBMS Database Administrator's Guide. ORIGINATOR: X ORIGINATOR: Chuck Zimmerman SOFTWARE-ORACLE-Relational Data Base----------------FIB001 Pg008