background image

Running the Oracle HTTP Server on OpenVMS

D-20

Oracle9

i

 Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

File Naming Conventions

In general, users who are running the Oracle HTTP Server for OpenVMS can 
specify either UNIX-style file names or OpenVMS-style file names

.  

The Oracle 

HTTP Server usually displays UNIX-style file names.

The ODS-5 volume structure, introduced in HP OpenVMS Alpha Version 7.2-1, 
supports long file names, allows the use of a wider range of characters within file 
names, and preserves case within file names

.  

However, the DEC C RTL that is 

shipped with HP OpenVMS Alpha Version 7.2-1 does not provide full support for 
extended file names on ODS-5 devices

.  

This lack of full support imposes certain 

restrictions on users running the Oracle HTTP Server for HP OpenVMS Alpha.

Because mixed UNIX-style and OpenVMS-style extended file names are not yet 
supported by the DEC C RTL, you might be required to use UNIX-style syntax 
when interacting with the Oracle HTTP Server

.  

An example would be appending 

additional directories or a file name to a root.

The following examples illustrate mixed UNIX-style and OpenVMS-style file names 
that are not supported in HP OpenVMS Alpha Version 7.2-1:

doc/foo.bar.bar

./tmp/foo.bar.b^_ar

~foo^.bar

You can, however, modify the last example so that it will work as an OpenVMS 
extended file name that has a tilde (~) as the first character

.  

Precede the leading 

tilde (~) with the Extended File Specifications escape character (^)

.  

For example:

^~foo^.bar

For more information about using the tilde (~) in OpenVMS extended file names, 
see the 

OpenVMS Guide to Extended File Specifications

 at the following web site:

http://caedmon.zko.dec.com/72final/6536/6536pro.html

Mixed UNIX-style and OpenVMS-style file names will be supported in a future 
release of the DEC C RTL for HP OpenVMS Alpha.

File Transfer Process and Access Control List

When performing a File Transfer Process (FTP) operation, ensure that the Access 
Control List (ACL) for the target directory on the Oracle HTTP Server allows FTP 
access, as follows:

When transferring new files:

Summary of Contents for ORACLE9I B10508-01

Page 1: ...Oracle9i Installation Guide Release 2 9 2 0 2 for hp OpenVMS Alpha Part No B10508 01 December 2002 ...

Page 2: ...ermission of Oracle Corporation If the Programs are delivered to the U S Government or anyone licensing or using the programs on behalf of the U S Government the following notice is applicable Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are commercial computer software and use duplication and disclosure of the Programs including documentation shall be subject to t...

Page 3: ...tallation With Existing Oracle Databases 1 7 System Installation Requirements 1 8 Time Requirements 1 8 Hardware Requirements 1 8 Minimum Hardware Requirements 1 8 Disk Space Requirements 1 9 Images 1 10 Operating System Software Requirements 1 11 Product Dependencies 1 13 Important Compatibility Issues 1 13 Additional Product Specific Installation Requirements 1 13 Configuration Restrictions 1 15...

Page 4: ...eters in Oracle9i Release 2 That Have Been Desupported 2 5 Initialization Parameters in Oracle9i Release 2 That Are Becoming Obsolete 2 5 Known Restrictions 2 6 The following items are not supported 2 6 3 CD ROM Pre installation Requirements HP OpenVMS and Installation Specific Issues and Restrictions 3 2 New ORA_ROOT 3 2 Java Runtime Environment JRE 3 2 Character Mode 3 2 Upgrading and Migrating ...

Page 5: ...Multiple Databases 3 12 Completing Account Setup 3 12 Verifying Privileges 3 12 HP OpenVMS Alpha SYSGEN Parameters 3 13 Using the Reserved Memory Registry 3 13 Using AUTOGEN 3 14 HP OpenVMS Alpha System Configuration 3 16 Setup Tasks to Perform as the SYSTEM User 3 16 Create an OpenVMS Account to Own Oracle Software 3 17 Create an OpenVMS Account to Own the Apache Server 3 17 Setup Tasks to Perfor...

Page 6: ...User Passwords 5 12 Configuration Tasks to Perform as the System User 5 12 Configuration Tasks to Perform as the Oracle User 5 13 Set Initialization Parameters 5 13 Post Installation for Oracle Products 5 14 Oracle Net 5 14 Oracle Options 5 15 Shared Server 5 15 Oracle Precompilers 5 16 Oracle Supported Protocols 5 17 Starter Database Contents 5 18 Unlocking and Resetting User Passwords 5 18 Revie...

Page 7: ...ure B 2 Introducing the Oracle9i 64 bit Feature B 2 Benefits of the Oracle9i 64 bit Feature B 2 Implementation of the Oracle 64 bit Feature on HP OpenVMS Alpha B 2 Suggested Parameter Settings B 3 Other Recommendations B 4 C Oracle Transparent Gateway System Requirements for Oracle Transparent Gateway C 2 RDB Gateway Requirements C 3 RMS Gateway Requirements C 4 Tested Gateway Configurations C 6 G...

Page 8: ...How to Configure Apache D 8 Modules and Directives D 8 Supported and Unsupported Features D 14 File Formats D 19 File Naming Conventions D 20 File Transfer Process and Access Control List D 20 Logical Names D 21 OpenVMS Cluster Considerations D 23 Common Gateway Interface CGI D 24 Security Information D 27 Process Model D 27 Privileged Images D 27 Privileges Required to Start and Stop the Server D...

Page 9: ... presented Do you need more information If so where Are the examples correct Do you need more examples What features did you like most about this manual If you find any errors or have any other suggestions for improvement please indicate the chapter section and page number if available You can send comments to us at the following e mail address osdwrite_us oracle com If you would like a reply plea...

Page 10: ...x ...

Page 11: ... Oracle9i Release 2 9 2 0 2 on hp OpenVMS Alpha systems Documentation for the products that are included with this software is in the Oracle9i generic documentation set Refer to important release information in Chapter 2 Release Information Audience This document is intended for anyone responsible for installing Oracle9i Release 2 9 2 0 2 on OpenVMS Alpha systems ...

Page 12: ... Documentation JAWS a Windows screen reader may not always correctly read the code examples in this document The conventions for writing code require that closing braces should appear on an otherwise empty line however JAWS may not always read a line of text that consists solely of a bracket or brace Accessibility of Links to External Web Sites in Documentation This documentation may contain links...

Page 13: ...that brackets have a different meaning when used in command syntax italics Italic type indicates a logical including logicals portions of filenames It is also used for emphasis UPPERCASE Uppercase letters indicate Structured Query Language SQL reserved words initialization parameters and environment logicals hyphen A hyphen indicates a command that is too long to fit on a single line Enter the lin...

Page 14: ... s Guide Oracle9i Net Services Reference Guide Oracle9i Database Performance Tuning Guide and Reference Information about migrating from a previous version of Oracle Server is provided in Oracle9i Database Migration ellipses Ellipses indicate an arbitrary number of similar items CHKVAL fieldname value1 value2 valueN italics Italic type indicates a variable Substitute a value for the logical librar...

Page 15: ... MetaLink Oracle MetaLink is the Oracle Corporation web service for technical information Members of Oracle MetaLink can search for updates alerts patches and other information about products releases and operating systems and can set preferences to be notified automatically of new information MetaLink offers a variety of services to assist in setting up and administering Oracle products including...

Page 16: ...e Technology Network OTN at the following web site http technet oracle com OTN delivers technical papers code samples product documentation self service developer support and Oracle key developer products to enable rapid development and deployment of applications built on Oracle technology Support for Hearing and Speech Impaired Customers Oracle Corporation provides dedicated Text Telephone TTY ac...

Page 17: ...on Planning This chapter describes the Oracle9i installation types and configurations The following topics are included Oracle9i Installation Overview System Installation Requirements Product Dependencies Configuration Restrictions Oracle Net Linking Options ...

Page 18: ...alling software Use the Oracle Universal Installer that is provided on your CD ROM to install Oracle products requires DECWindows Motif Refer to Chapter 4 Installation 4 Completing the post installation tasks Create database objects establish the user environment and configure the installed Oracle products for the local system Refer to Chapter 5 Post Installation 5 Installing the clients If you wa...

Page 19: ...alls a preconfigured starter database networking services and Oracle utilities Custom If you select this type then the Oracle Universal Installer installs the products that you select from the Enterprise Edition and from the Standard Edition options Oracle9i Client The Oracle9i Client is a front end database application that connects to the database through one or more application servers Three cl...

Page 20: ...four and five are configurations for special needs The following section describes some of these configurations Environment Descriptions General Purpose Users of this database type perform a variety of database tasks ranging from simple transactions to complex queries Select this database environment for general purpose use Online Transaction Processing Users of this database type perform large nu...

Page 21: ...your selected environment and database configuration It starts automatically unless you selected software only after Oracle9i software has been installed during Oracle9i installation When installing Oracle9i software using any database configuration option other than the Custom and Software Only the Oracle Universal Installer OUI prompts for a global database name and System Identifier SID After O...

Page 22: ...rocessing option If you select this option then the Database Configuration Assistant creates a preconfigured ready to use OLTP database Data Warehouse option If you select this option then the Database Configuration Assistant creates a database that is fully enabled for data warehousing applications Customized installation option If you select this option then the Database Configuration Assistant ...

Page 23: ...he command line For more information on running Database Configuration Assistant from the command line refer to Non interactive Mode on page 5 2 For more information on database character sets refer to Oracle9i Database Globalization Support Guide Release 2 9 2 Installation With Existing Oracle Databases You can access different versions of Oracle on the same computer system at the same time using...

Page 24: ...of products installed and the type of hardware used Duration of a typical installation takes approximately 1 to 3 hours Hardware Requirements Software needs to be installed on an ODS 5 formatted disk Refer to Oracle9i Release 2 Dependency on ODS 5 Disk Structure on page 2 3 for details Minimum Hardware Requirements Following is a list of the minimum hardware requirements to install Oracle9i produc...

Page 25: ...your node run the following command show memory reserved System Memory Resources on 13 JUL 2002 09 57 11 72 Memory Reservations pages Group Reserved In Use Type ORA_PROD_SGA SYSGBL 5120 0 Allocated ORA_PROD_SGA SYSGBL 5 0 Page Table Total 40 04 Mbytes reserved 5125 0 Please consult Hewlett Packard documentation if you require more information about reserving memory Disk Space Requirements The Orac...

Page 26: ... including precompiled user programs by removing direct references to Oracle Net and other common routines The image names are in the form of libclntsh so and oracle exe Table 1 1 Disk Space Requirements for Oracle9i Server Installation Type Required Disk Space Enterprise Edition 3 3 GB Standard Edition 3 3 GB Custom depends upon the components selected but a minimum of 2 GB From a staging area on...

Page 27: ...es for OpenVMS UCX If you wish to use the TCP IP protocol adapter for Oracle Net then you should have Version 5 1 ECO 4 or higher of TCP IP Services for HP OpenVMS Alpha installed TCP IP protocol stacks from other vendors may work with Oracle but customers use these products at their own risk Any TCP IP problems that cannot be reproduced using TCP IP Services for HP OpenVMS Alpha will simply be re...

Page 28: ...ows Oracle Net VMS Mailbox Driver The Oracle Net VMS Mailbox driver protocol IPC is included in NETWORK You do not need an Oracle Net license to use the VMS Mailbox driver Programmatic Interface Support The following DEC compilers were used to certify the programmatic interfaces Programmatic Interface Certification Release Pro C C release 6 4 008 C release 6 3 020 Pro COBOL DEC COBOL release 2 8 P...

Page 29: ...linked against an Oracle9i installation Contact your Sales Representative concerning releases of these products that have been certified with Oracle9i Additional Product Specific Installation Requirements This section provides additional product specific information For descriptions of these products see Appendix A Oracle9i Products Warning If you are upgrading to Oracle9i from a previous version ...

Page 30: ... 5 Oracle9i JVM 9 2 0 2 0 This product includes Java Virtual Machine JVM and Java utilities See the Java README file on the Oracle9i CD ROM for restrictions and requirements Pro C C 9 2 0 2 0 C release 6 4 008 C release 6 3 020 Pro COBOL 1 8 75 DEC COBOL release 2 8 Pro COBOL 9 2 0 2 0 DEC COBOL release 2 8 Pro FORTRAN 1 8 75 DEC FORTRAN release 7 1 SQL Module Ada DEC Ada 3 5a23 Networking and Sys...

Page 31: ...ucts Kerberos requires MIT Kerberos Version 5 release 1 1 The Kerberos authentication server must be installed on a physically secure machine Secure Socket Layer SSL requires a wallet that is compatible with the Oracle Wallet Manager version 2 1 Wallets that were created in earlier releases of the Oracle Wallet Manager are not forward compatible Oracle Advanced Security provides and installs Secur...

Page 32: ...e shows the range of use for Oracle Net drivers in client server and distributed database configurations The data in this table is provided with the assumption that clients in a client server configuration run the Oracle tool and that servers run the Oracle database For distributed database examples the clients and servers each run both an Oracle tool and the Oracle database Limited Limited only f...

Page 33: ...eFile flag is given then the installation is assumed to be a silent mode type A silent installation can also be performed in BATCH mode as long as the process has established an X connection via the SET DISPLAY command Note Because the design of OUI causes GUI classes to be loaded but not displayed a silent installation still requires an X connection ...

Page 34: ...nstall an Oracle product multiple times on multiple computers or if you prefer not to use the GUI because of performance reasons over a slow remote X connection If the options that you select while installing on each computer are always the same then you save the time of reviewing each installation screen and selecting the various installation options Silent installations can also ensure that mult...

Page 35: ... or for the string OPENVMS_VALUE_REQUIRED and provide values for those items 3 Modify other fields as applicable refer to comments within the response file that you are modifying List of Response File Names File Name Description enterprise rsp Enterprise Edition Installation of Oracle9i Server standard rsp Standard Edition Installation of Oracle9i Server custom rsp Custom Edition Installation of O...

Page 36: ...Silent Mode Installation 1 20 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Page 37: ...ease Information This chapter provides information specific to this release of Oracle9i for HP OpenVMS The following sections are included Product Set on page 2 2 Changes and Enhancements on page 2 2 Known Restrictions on page 2 6 ...

Page 38: ... are unique to this release of Oracle9i for HP OpenVMS 2349006 CHANGE CALL TO SYS CREPRC TO HAVE PRC M_IMGDMP SET In releases prior to Oracle9i Release 2 9 2 0 2 when one of the background processes terminated abruptly with an access violation no useful information was readily available regarding the cause for termination For troubleshooting certain actions needed to be taken and the crash needed ...

Page 39: ...CTX INSTALL NETCONFIG RDBMS UTIL and so forth The disks on which Oracle database files reside can be formatted as either ODS 2 or ODS 5 Oracle Note 205630 1 can be viewed at Oracle MetaLink Alternatively use the search function and search for ODS 5 for more information Precautions Do not change the format of any VMS disk without first making a backup of the disk Conversion from ODS 2 to ODS 5 does...

Page 40: ...the Set Volume command SET VOLUME STRUCTURE_LEVEL 5 device name Example SET VOLUME STRUCTURE_LEVEL 5 2 DKC100 Formatting a New Disk If you plan to use a new empty disk then use the Initialize command to format the new disk to ODS 5 format as follows INITIALIZE STRUCTURE 5 device name volume label Example INITIALIZE STRUCTURE 5 2 DKC100 TESTVOL Oracle9i Release 2 New Directory Structure Beginning w...

Page 41: ...COUNT DB_BLOCK_LRU_LATCHES DB_BLOCK_MAX_DIRTY_TARGET SORT_MULTIBLOCK_READ_COUNT DB_FILE_DIRECT_IO_COUNT GC_DEFER_TIME GC_RELEASABLE_LOCKS GC_ROLLBACK_LOCKS LM_LOCKS LM_RESS USE_INDIRECT_DATA_BUFFERS Initialization Parameters in Oracle9i Release 2 That Are Becoming Obsolete ROLLBACK_SEGMENTS FAST_START_IO_TARGET TRANSACTIONS_PER_ROLLBACK_SEGMENT LOG_CHECKPOINT_INTERVAL DB_BLOCK_BUFFERS BUFFER_POOL_...

Page 42: ... limitations Oracle9i for HP OpenVMS with iAS mid tier with VMS back end database configuration is supported For information about iAS support contact http infodec_us oracle com The following items are not supported RAC Guard and RAC High Availability Extensions RAC Guard and RAC High Availability Extensions are not supported in this release due to the lack of cluster failover in the Operating Sys...

Page 43: ...estrictions Release Information 2 7 EJB BEANS Oracle9i for HP OpenVMS does not support EJB on the server If customers have iAS in mid tier however they can still use the database on OpenVMS in order to use EJB ...

Page 44: ...Known Restrictions 2 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Page 45: ...required for an Oracle9i software installation HP OpenVMS and Installation Specific Issues and Restrictions Installation Procedure Requirements HP OpenVMS Alpha SYSGEN Parameters HP OpenVMS Alpha System Configuration Setup Tasks to Perform as the SYSTEM User Setup Tasks to Perform as the Oracle User Setup Tasks for Oracle Products ...

Page 46: ...ment JRE The JRE that is shipped with Oracle9i is used by Oracle Java applications such as the Oracle Universal Installer and is the only Java application that is supported to run with these applications Customers must not modify this JRE unless it is done through a patch provided by Oracle Support Services The inventory can contain multiple versions of the JRE each of which can be used by one or ...

Page 47: ...sk The datafiles and redolog files however can be placed on ODS 2 formatted disks as well Oracle9i server must be able to verify that files have been written to disk File systems that do not support this verification are not supported for use with Oracle databases although Oracle software can be installed on them Optimal Flexible Architecture Optimal Flexible Architecture OFA the Oracle standard s...

Page 48: ...ications InterConnect installation The last text field on this dialog box which prompts for Consumer Name appears truncated when viewed through Exceed This dialog box displays as expected when viewed through native X Windows on OpenVMS To correct any problems with hidden dialog fields perform the following steps 1 Select the xconfig application under the Exceed Program Group from the Windows Start...

Page 49: ...ccount 2 Run AUTHORIZE to add a record in the User Authorization File UAF 3 Use AUTHORIZE to set the following account requirements Account quotas Account privileges Process rights identifiers 4 Exit AUTHORIZE to complete the account setup Deciding Account Information To add an account you must supply the following information Account name Account password USER and GROUP numbers for the UIC octal ...

Page 50: ...ame Oracle9i Account UIC Must Be Greater than MAXSYSGROUP The UIC GROUP number of the Oracle9i account must be greater than the system parameter MAXSYSGROUP which defaults to octal 10 GROUP numbers 1 through MAXSYSGROUP are reserved for use by the OpenVMS operating system itself If the UIC GROUP number is not greater than the system parameter MAXSYSGROUP then the Oracle9i account cannot issue the ...

Page 51: ...CLE UIC 277 100 DEVICE device DIRECTORY Oracle9i OWNER ORACLE DBA In this example the account name is Oracle9i Note that the UIC GROUP number is 277 The UIC GROUP number must be larger than MAXSYSGROUP After adding the account you must alter the account privileges and quotas Although this can be done in any order usually the account privileges are set before the account quotas For more information...

Page 52: ...dministrator account CMKRNL GROUP GRPNAM IMPERSONATE LOG_IO NETMBX OPER PFNMAP PRMGBL PRMMBX SHARE SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX WORLD Use the AUTHORIZE utility to set the account privileges for the Oracle9i database administrator account Note An exception is explained in Security Issues with Multiple Databases on page 3 12 Note Appendix B Oracle9i 64 bit Feature has additional information th...

Page 53: ...ing a record with the default quotas use the MODIFY command to alter the default values The following example changes the Enqueue quota ENQLM from the default value to a value of 150 UAF MODIFY ORACLE9i ENQLM 150 Account Quotas The following table lists the Oracle9i account quotas their minimum recommended values and their equivalent HP OpenVMS Alpha quota names as displayed by the DCL commands SH...

Page 54: ...ple to grant the ORA_ sid _DBA rights identifier to the Oracle9i account for an instance called TEST issue the following command UAF ADD IDENTIFIER ORA_TEST_DBA FILLM 100 Open file quota JTQUOTA 8192 Job table quota MAXDETACH 0 the default Max detached processes MAXJOBS 0 the default Max active jobs PGFLQUOTA 1 500 000 recommended Paging file quota WSDEFAULT 2048 Working set default WSEXTENT 8192 ...

Page 55: ...umber must be greater than MAXSYSGROUP By granting the ORA_ sid _DBA identifier you can similarly restrict user privileges to an instance named sid Process Rights for SGA Protection Releases of the Oracle RDBMS on HP OpenVMS Alpha after Release 7 3 2 3 0 feature a change in the way that the software runs and accesses the SGA Previous to Release 7 3 2 3 2 the SGA was protected by allowing only proc...

Page 56: ...NL privilege to every DBA Oracle9i account This privilege allows a DBA to activate any process rights identifiers and to install shared images For security reasons Oracle Corporation recommends that the OpenVMS system administrator handle these tasks This person should be responsible for starting Oracle9i instances from a controlled account with a UIC group greater than MAXSYSGROUP If this is not ...

Page 57: ... aligned physical pages This allows the system to optimize the mapping of the SGA The memory is pre allocated and zeroed This results in faster SGA mapping and faster instance startup To reserve memory for an SGA use the SYSMAN utility The size qualifier is specified in megabytes For example to reserve memory for a 6 GB SGA for the SID named TEST use the following commands MCR SYSMAN SYSMAN RESERV...

Page 58: ...E ZERO PAGE SYSMAN EXIT Then run AUTOGEN and reboot the system To avoid rebooting the system SYSMAN can be used to free the memory reservation Then you may start the instance The risk is that the system may not have enough fluid pages to create the SGA Also the performance advantages of using reserved memory are not available To review memory reservations on your node run the following command sho...

Page 59: ...e old values before trying again 1 Run the AUTOGEN utility with the SAVPARAMS parameter by entering the following command SYS UPDATE AUTOGEN SAVPARAMS GETDATA This step saves current parameters to a file named AGEN FEEDBACK DAT 2 If you have not already done so then run AUTOGEN GETDATA to ensure that the file PARAMS DAT has been generated SYS UPDATE AUTOGEN GETDATA 3 Examine the parameter settings...

Page 60: ... set up your environment for Oracle9i Warning The REBOOT parameter in this example will cause the system to automatically reboot when the SYSGEN is complete See Also For more information about using the AUTOGEN utility see the OpenVMS System Management Utilities Reference Table 3 3 HP OpenVMS Alpha System Configuration Summary System Factors Requirement for Oracle9i HP OpenVMS Alpha Parameters Min...

Page 61: ...n OpenVMS user account that owns the Apache server after installation If you use a default Apache configuration one that listens to ports lower than 1024 which are reserved to System then Oracle Corporation recommends for security reasons that a separate account owner be set up for Apache Configure the Apache server to assign ownership of listener and module actions to this account It is not neces...

Page 62: ...ps whose files are not intended to be visible to the public The nobody account may serve as a model for the Apache account Setup Tasks to Perform as the Oracle User Log in to the Oracle9 account and perform the following tasks as necessary Set Permissions for File Creation Set Display Set Permissions for File Creation Set default file protections for the oracle9 account to ensure that group and wo...

Page 63: ...workstation if you are installing from a remote system If you are not sure of the X server and screen settings then use 0 zero for both Setup Tasks for Oracle Products The following products require pre installation steps to be completed before you install Oracle9i software Precompilers and Tools Network and System Management Products Precompilers and Tools Complete pre installation tasks for the ...

Page 64: ...If you have an existing installation of Oracle Net8 server then shut down all listeners before installing Oracle Net To determine if any listeners are running enter the following command lsnrctl status listener_name The listener_name field is required if the listener has a name other than the default name listener To shut down a running listener enter the following command lsnrctl stop listener_na...

Page 65: ...nd complete the tasks that are listed in Chapter 1 Oracle9i Installation Planning and Chapter 3 CD ROM Pre installation Requirements before beginning the installation This chapter contains the following sections Installation Mount Options on page 4 2 Installation Option Installing Oracle9i from the Hard Drive on page 4 2 Oracle Universal Installer on page 4 3 ...

Page 66: ...on by copying the contents of each CD ROM to your system hard drive You must have a file system that is not in use by other applications You must also have at least 2 5 GB of disk space available 1 Copy the CD ROMs to your system hard drive Copy the contents of each CD ROM to a directory on a disk For example copy first CD disk disk1 cdrom copy second CD disk disk1 cdrom 2 Start the Oracle Univers...

Page 67: ...directory For more information about ODS 5 format requirements refer to Oracle9i Release 2 Dependency on ODS 5 Disk Structure on page 2 3 ddcn disk1 runInstaller scratchPath ODS5_temp_dir After the Oracle Universal Installer starts the Welcome window appears Click Next to continue the installation 3 The Inventory Location window appears If this is the first time that any Oracle9i products are inst...

Page 68: ...nue 6 The Installation Types window appears Choose an installation type Enterprise Edition Standard Edition or Custom Click Next 7 The Database Configuration window appears Select a database that is suited to your needs Click Next 8 The Database Identification window appears The Software Only option will not install the starter database If you choose this option the next step will use the Enable R...

Page 69: ...rogress Errors or warnings produce a dialog box where you can choose to fix and retry to ignore and continue or to abort a If you chose to install Software Only then the End of Installation window appears next b If you chose to install a starter database then the Configuration Tools window appears followed by the Database Configuration Assistant window c When configuration is complete the End of I...

Page 70: ... ODS5_temp_dir 3 After the Oracle Universal Installer starts the Welcome window appears Click Next to continue the installation 4 The Inventory Location window appears If this is the first time that any Oracle9i products are installed on the current system then the Inventory Location window appears Enter a directory where the inventory of all installations will be kept If this is not the first tim...

Page 71: ...r click Previous to change your selections 9 The Install window appears This window indicates installation progress Errors or warnings produce a dialog box where you can choose to fix and retry to ignore and continue or to abort 10 From the End of Installation window you may exit or install additional products This window appears when your installation is complete You may choose to exit OUI or to ...

Page 72: ...pecific directory names or Rdb gateway attributes The Summary window appears Reviewing a Log of an Installation Session The Oracle Universal Installer creates the oraInventory directory the first time that it is run in order to keep an inventory of products that it installs on your system as well as an inventory of other installation information The location of the OraInventory directory is define...

Page 73: ...ser sidA 2 set default ora_root network 3 Create the DCL script needed for bequeath connections create_orasrv_beq ora_db sidB db_name for example create_orasrv_beq DISK DISK1 Oracle9i Home1 ORADATA DB92 _ sidB DB92 4 set default ora_root dbs Caution Do not delete or manually alter the oraInventory directory or its contents Doing so can prevent the Oracle Universal Installer from locating products ...

Page 74: ... starting the instance refer to the List Of Parameters following these numbered steps 9 Ensure that parameter remote_login_passwordfile is set to SHARED default EXCLUSIVE 10 SQL connect as sysdba 11 SQL startup 12 SQL alter database add logfile thread 2 group 4 ora_db redo04 rdo size 100m group 5 ora_db redo05 rdo size 100m group 6 ora_db redo06 rdo size 100m 13 SQL alter database enable public th...

Page 75: ...er to Database Configuration Assistant DBCA on page 5 2 Non Interactive Installation and Configuration For non interactive installations use the Silent Mode Installation which is described in Chapter 1 Oracle9i Installation Planning on page 1 16 Cleaning Up After a Failed Installation If an installation fails then before you attempt another installation you might need to remove files that the Orac...

Page 76: ...Oracle Universal Installer 4 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Page 77: ...er on page 5 12 Configuration Tasks to Perform as the Oracle User on page 5 13 Post Installation for Oracle Products on page 5 14 Starter Database Contents on page 5 18 Adding or Upgrading Products on page 5 27 Relinking the Oracle Code on page 5 29 Note This chapter describes basic configuration only Refer to the Oracle9i Administrator s Reference Release 2 9 2 0 2 for hp OpenVMS Alpha and to the...

Page 78: ...warnings into a log file From the command line enter the following command to see all of the DBCA options that are available when using silent mode dbca help Note Because of the DCL limit of eight command line parameters on OpenVMS it is not possible to specify directly on the command line all of the required parameters to create a database Therefore as a workaround DBCA command line arguments may...

Page 79: ...et up by executing ORACLE_HOME orauser invoke DBCA Log files are located in the same place as with an interactive install In this example Disk disk1 oracle9i ora9i admin ora9i create Also check the ORACLE_HOME assistants dbca logs directory DBCA Silent Mode Example 2 Creating a Seed Template To create a seed template enter the following into SYS SCRATCH DBCA ARGS silent createCloneTemplate sourceD...

Page 80: ...REATE_TYPE field determines which of the other sections are applicable Each field has a comment header block with the following entries Name Datatype Description Valid values Default value and Mandatory Yes No descriptions For example Name CREATE_TYPE Datatype String Description Type of database creation Valid values createDatabase createTemplateFromDB createCloneTemplate Default value None Mandat...

Page 81: ...specify the values in the following format Type Example String value Boolean True or False Number numeric value StringList value1 value2 Examples 1 dbca progress_only responseFile response file Display a progress bar depicitng progress of database creation process 2 dbca silent responseFile response file Creates database silently No user interface is displayed 3 dbca silent createDatabase cloneTem...

Page 82: ...eateTemplateFromDB createCloneTemplate Default value None Mandatory Yes CREATE_TYPE createDatabase End of GENERAL section CREATEDATABASE section is used when CREATE_TYPE is defined as createDatabase CREATEDATABASE Name GDBNAME Datatype String Description Global database name of the database Valid values db_name db_domain when database domain isn t NULL db_name when database domain is NULL Default ...

Page 83: ... Valid values Directory containing compressed datafile jar Default value None Mandatory Yes when the clone template is used for database creation DATAFILEJARLOCATION Name CHARACTERSET Datatype String Description Character set of the database Valid values Check Oracle9i National Language Support Guide Default value US7ASCII Mandatory NO CHARACTERSET US7ASCII Name NATIONALCHARACTERSET Datatype Strin...

Page 84: ...lue of registerWithDirService is TRUE DIRSERVICEUSERNAME name Name DIRSERVICEPASSWORD Datatype String Description The password of the directory service user You can also specify the password at the command prompt instead of here Mandatory YES if the value of registerWithDirService is TRUE DIRSERVICEPASSWORD password Name LISTENERS Datatype String Description Specifies list of listeners to register...

Page 85: ... section is used when CREATE_TYPE is defined as createTemplateFromDB createTemplateFromDB Name SOURCEDB Datatype String Description The source database from which to create the template Valid values The format is host port sid Default value none Mandatory YES SOURCEDB myhost 1521 orcl Name SYSDBAUSERNAME Datatype String Description A user with DBA role Default value none Mandatory YES SYSDBAUSERNA...

Page 86: ...CREATE_TYPE is defined as createCloneTemplate createCloneTemplate Name SOURCEDB Datatype String Description The source database is the SID from which to create the template This database must be local and on the same ORACLE_HOME Default value none Mandatory YES SOURCEDB orcl Name SYSDBAUSERNAME Datatype String Description A user with DBA role Default value none Mandatory YES SYSDBAUSERNAME system ...

Page 87: ...ing Description Name for the new template Default value None Mandatory Yes TEMPLATENAME My Clone TEMPLATE Name DATAFILEJARLOCATION Datatype String Description Location of the data file jar Valid values Directory where the new compressed datafile jar will be placed Default value ORACLE_HOME assistants dbca templates Mandatory NO DATAFILEJARLOCATION ...

Page 88: ...D BY PASSWORD Configuration Tasks to Perform as the System User Log in as the system user and perform the following tasks Create Additional OpenVMS Accounts Automate Database Startup and Shutdown Optional Set Initialization Parameters Create Additional OpenVMS Accounts If necessary create additional OpenVMS accounts with the AUTHORIZE utility Each DBA user on the system must be granted the ORA_DBA...

Page 89: ...form as the Oracle User Perform the following task as the oracle user Set Initialization Parameters Modify init ora Parameters When you create a database your initsid ora parameters are automatically set You can manually modify the initialization parameters in the initsid ora with an OpenVMS editor Activate the modified initsid ora file by shutting down and restarting the database Do not use logic...

Page 90: ...ted Protocols Oracle Net Configuring a complete Oracle network is beyond the scope of this manual and is covered in detail in the Oracle9i Net Services Administrator s Guide and the Oracle9i Net Services Reference Guide Verify and complete your initial configuration with the following steps 1 Following installation check the status of the listener by using the command lsnrctl status listener_name ...

Page 91: ... tablespaces for Oracle interMedia Text do not exist or if you do not want to use the DRSYS tablespace then create additional tablespaces before proceeding Shared Server Oracle servers that are configured with Shared Server require a higher setting for the initialization parameter SHARED_POOL_SIZE or a custom configuration that uses LARGE_POOL_SIZE If you created a database manually then you shoul...

Page 92: ... cfg file refer to Pro COBOL Precompiler Programmer s Guide Pro COBOL18 For precompiler Pro COBOL18 the configuration file is pcccob cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pcccob cfg file refer to Pro COBOL Precompiler Programmer s Guide Pro FORTRAN For precompiler Pro FORTRAN the configuration fi...

Page 93: ...ing any protocol 1 Verify that you have created and installed the necessary configuration files for the network 2 Start the listener on the server lsnrctl start listener name 3 Check the listener process lsnrctl status listener name 4 As the oracle user start SQL Plus to test the connection sqlplus username password service_name Configuring the Secure Socket Layer Note You cannot use Oracle Precom...

Page 94: ...ng Redo Log Files Locating Control Files Using Rollback Segments Using the Data Dictionary Unlocking and Resetting User Passwords Passwords for all Oracle system administration roles and privileges except SYS SYSTEM and SCOTT are expired upon installation You are required to unlock user names and to reset passwords for all other administrative user names before using them You can do this through D...

Page 95: ...d Passwords All databases that are created by Database Configuration Assistant include the SYS SYSTEM and DBSNMP user names and passwords In addition Oracle Corporation provides several other administrative users Unlock users and reset passwords before using these administrative accounts Note If you want unauthenticated access to your data via HTTP then unlock the ANONYMOUS user account See Also O...

Page 96: ...ministrator user name Oracle Spatial User s Guide and Reference ORDPLUGINS ORDPLUGINS ORDPLUGINS is the Oracle interMedia Audio and Video user name with the CONNECT and RESOURCE roles ORDPLUGINS allows non native plug in formats Oracle9i interMedia User s Guide and Reference ORDSYS ORDSYS ORDSYS is the Oracle interMedia Audio Video and Image administrator user name with CONNECT JAVAUSERPRIV and RE...

Page 97: ...AIDPRIV JAVAUSERPRIV OEM_MONITOR RECOVERY_CATALOG_OWNER RESOURCE SELECT_CATALOG_ROLE SNMPAGENT TIMESERIES_DBA TIMESERIES_DEVELOPER Oracle9i Database Administrator s Guide SYSTEM MANAGER You can use SYSTEM to perform database administration tasks SYSTEM includes the AQ_ADMINISTRATOR_ROLE and DBA database roles Oracle9i Database Administrator s Guide SCOTT TIGER SCOTT includes the CONNECT and RESOUR...

Page 98: ...er the database name and the network domain make the global database name unique The domain portion is a string of no more than 128 characters that can contain alpha numeric period and additional characters The domain name is also assigned to the DB_DOMAIN parameter in the init ora file Note Any database user can be granted limited SYS role database privileges to use the Oracle Enterprise Manager ...

Page 99: ...and the initialization parameter file is in the ora_root admin orcl pfile directory The ORCL directory is named after the DB_NAME parameter value Tablespaces and Data Files An Oracle9i database is divided into smaller logical areas of space known as tablespaces Each tablespace corresponds to one or more physical data files Data files contain the contents of logical database structures such as tabl...

Page 100: ...tement Note You might need to expand this tablespace if you are executing a SQL statement that involves a lot of sorting such as ANALYZE COMPUTE STATISTICS on a very large table or the constructs GROUP BY ORDER BY or DISTINCT TOOLS tools01 dbf The Installer creates this data file when the user wants to install any third party or Oracle tools products USERS users01 dbf As you generate and enter dat...

Page 101: ... redo log files that are located in the ora_root oradata db_name directory Table 5 3 describes the redo log files See Also Oracle9i Database Administrator s Guide and Oracle9i Database Reference for more information on database specific initialization parameters and their default values Table 5 3 Redo Log files Redolog Files Disk Size Description redo01 rdo redo02 rdo redo03 rdo 100 MB 100 MB 100 ...

Page 102: ... database The rollback segments of the starter database are as follows Rollback segment SYSTEM is contained in tablespace SYS and is used by SYS Rollback segments _SYSSMU1 through _SYSSMU10 are a pool of rollback segments that any instance can use if it requires a rollback segment They are contained in tablespace UNDOTBS n and are used by PUBLIC Using the Data Dictionary The data dictionary is a p...

Page 103: ...e you add or upgrade a product perform the following steps 1 Verify that your system has Oracle9i installed 2 Log onto your HP OpenVMS Alpha machine 3 Run the following ORAUSER file for your database set default Oracle_Home orauser sid 4 If you plan to upgrade any Oracle product tables change the Oracle SYSTEM password to MANAGER See Also Oracle9i Concepts and Oracle9i Database Reference for more ...

Page 104: ...ersal Installer Select custom install After completing these preliminary steps you are ready to load and configure your Oracle products Adding a Product Summary 1 Execute ora_root bin runInstaller 2 Point to existing ORACLE_HOME 3 Select custom install 4 Select products to install 5 Configure products if OUI asks questions 6 Click Install button 7 Exit OUI 8 Start an instance 9 Build or upgrade da...

Page 105: ...B_TABLE Invoke SQLPLUS and connect SYS Select from the view V PROCESS If no other processes are active and if you are pointed to the right instance then shut down the given database After the database is shut down all Oracle background processes will no longer exist Type SHOW SYSTEM at the DCL prompt to verify Step 2 Remove Images Type REMORACLE at the system prompt REMORACLE Step 3 Invoke the Ora...

Page 106: ...Relinking the Oracle Code 5 30 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Page 107: ...ge A 8 Product Descriptions on page A 2 Note The Custom installation type is not listed for any of the three top level components because it allows you to install all components in the current top level component category Some components can be installed only through a Custom installation Such components have an availability of No listed in this appendix for other installation types ...

Page 108: ...des all the components in the Standard Edition with the exception of the Oracle Enterprise Manager Standard Management Pack Refer to the release notes for your platform for updates on component availability Advanced Queuing Advanced Replication Character Set Scanner Common Schema Demos Object Type Translator which includes the following Oracle INTYPE File Assistant Oracle Advanced Security which i...

Page 109: ...version 3 with SSO support Enterprise User Security including Oracle Wallet Manager Oracle Call Interface Oracle Dynamic Services Oracle JDBC Drivers which include the following Oracle JDBC Thin Driver for JDK 1 1 Oracle JDBC Thin Driver for JDK 1 2 Oracle JDBC OCI Driver for JDK 1 1 Oracle JDBC OCI Driver for JDK 1 2 Oracle Locale Builder Oracle Locator Note Oracle Wallet Manager is a feature of ...

Page 110: ...ext Oracle Trace Oracle Universal Installer which includes the following Oracle s Java Runtime Environment version Oracle Utilities which includes the following Export Migration Utility Recovery Manager SQL Loader Oracle XML Developer s Kit Oracle XML SQL Utility Oracle9i Advanced Analytic Services Data Mining Note When Oracle Net Client is installed by using the Enterprise Edition or Standard Edi...

Page 111: ...the Oracle9i server Standard Edition top level component Refer to the release notes for your platform for updates on component availability Advanced Queuing Advanced Replication Character Set Scanner Common Schema Demos Object Type Translator which includes the following Oracle INTYPE File Assistant Enterprise User Security including Oracle Wallet Manager Oracle Call Interface Oracle Dynamic Servi...

Page 112: ...Net Listener Oracle Protocol Support Oracle SQLJ which includes the following SQLJ Runtime SQLJ Translator Oracle Text Oracle Trace Oracle Universal Installer which includes the following Oracle s Java Runtime Environment version Oracle Utilities which includes the following Export Migration Utility Recovery Manager SQL Loader Oracle XML Developer s Kit Note When Oracle Net Client is installed by ...

Page 113: ...s Oracle9i Products A 7 Oracle XML SQL Utility Oracle9i JVM which includes the following Java Virtual Machine Oracle9i Server the Oracle9i database which includes the following Oracle Database Demos PL SQL PL SQL Gateway SQL Plus ...

Page 114: ...llation type of the Oracle9i Client Runtime top level component Refer to the release notes for your platform for updates on component availability Advanced Queuing Documentation for your HP OpenVMS Alpha Oracle Advanced Security which includes the following Encryption and Integrity Support including DES40 Encryption DES56 Encryption 3DES_112 Encryption 2 key option 3DES_168 Integrity 3 key option ...

Page 115: ...O support Enterprise User Security including Oracle Wallet Manager Oracle Dynamic Services Server Oracle JDBC Drivers which include the following Oracle JDBC Thin Driver for JDK 1 1 Oracle JDBC Thin Driver for JDK 1 2 Oracle JDBC OCI Driver for JDK 1 1 Oracle JDBC OCI Driver for JDK 1 2 Oracle Net Note Kerberos is installable through the Custom installation Authentication Methods window Note Oracl...

Page 116: ...or HP Alpha OpenVMS Oracle SQLJ which includes the following SQLJ Runtime SQLJ Translator Oracle Universal Installer which includes the following Oracle Java Runtime Environment version Oracle Utilities which includes the following Export Import Recovery Manager SQL Loader PL SQL ...

Page 117: ...se notes for your platform for updates on component availability Advanced Queuing Documentation for your HP OpenVMS Alpha Object Type Translator Oracle Advanced Security which includes the following Encryption and Integrity Support including DES40 Encryption DES56 Encryption 3DES_112 Encryption 2 key option 3DES_168 Integrity 3 key option MD5 Integrity RC4_40 Encryption RC4_56 Encryption RC4_128 E...

Page 118: ...entication Support including Kerberos with SSO support SSL with X 509 version 3 with SSO support Enterprise User Security including Oracle Wallet Manager Oracle Call Interface Oracle Dynamic Services Server Oracle Enterprise Manager which includes the following Note Kerberos is installable through the Custom installation Authentication Methods window Note Oracle Wallet Manager is a feature of Orac...

Page 119: ...iver for JDK 1 2 Oracle Net Oracle SQLJ which includes the following SQLJ Runtime SQLJ Translator Oracle Universal Installer which includes the following Oracle s Java Runtime Environment version Oracle Utilities which includes the following Export Import Recovery Manager SQL Loader Oracle XML Developer s Kit Oracle XML SQL Utility PL SQL Pro C C Pro COBOL 1 8 75 Pro COBOL 9 0 1 Pro FORTRAN 1 8 75...

Page 120: ...ses or nodes automated collection of performance and resource usage data and central monitoring and administration of remote systems using intelligent agents For more information refer to Getting Started with the Oracle Diagnostics Pack 2 Oracle Standard Management Pack release 9 0 1 The Oracle Standard Management Pack combines the diagnostic tuning and change management functions of the Oracle En...

Page 121: ...n SQL indexing strategies instance parameters controlling I O SGA performance and object sizing placement and reorganization The applications that are included in the Oracle Tuning Pack are Oracle SQL Analyze Oracle Expert Outline Editor Outline Management Oracle Index Tuning Wizard Reorg Wizard and the Tablespace Map For more information refer to Database Tuning with the Oracle Tuning Pack 5 Orac...

Page 122: ...er to the Oracle generic documentation 8 Oracle Intelligent Agent release 9 2 0 2 0 Oracle Intelligent Agent monitors targets on a managed node for registered events and scheduled jobs that are sent by the Console Oracle Intelligent Agent also collects statistical data for Capacity Planner and Performance Manager which are data collecting applications in the Oracle Diagnostics Pack For more inform...

Page 123: ...graphical user interface for viewing modifying and defining locale specific data For more information refer to Oracle Globalization Support Guide 13 Oracle Locator release 9 2 0 2 0 Installed with Oracle interMedia Oracle Locator enables Oracle9i to support online Internet based geocoding facilities for locator applications and proximity queries For more information refer to Oracle9i Spatial User ...

Page 124: ... 2 0 Oracle Net provides products that enable client connections to databases across a network A client side application sends a request to Oracle Net to be transported across the network to the server Oracle Net not Oracle Universal Installer installs TCP IP and Named Pipes For more information refer to Oracle Net Administrator s Guide 17 Oracle Net Listener release 9 2 0 2 0 Oracle Net Listener ...

Page 125: ...g in a stateless mode in which each HTTP request maps to a new database session This is the recommended configuration if you want to develop stateless PL SQL based web applications For more information refer to Oracle Internet Application Server Release Using mod_plsql and to Oracle9i Administrator s Reference Release 2 9 2 0 2 for HP OpenVMS Alpha 20 Oracle Real Application Clusters release 9 0 1...

Page 126: ...g information regarding addresses road networks and sales territories Oracle Spatial provides powerful spatial type management indexing methods and spatial operators for the deployment of location based services and it extends the capabilities of existing Oracle based applications For more information refer to Oracle9i Spatial User s Guide and Reference 23 Oracle Spatial Index Advisor release 9 0 ...

Page 127: ...Reference 25 Oracle Text release 9 2 0 2 0 formerly Oracle interMedia Text Oracle Text uses standard SQL to index to search and to analyze text and documents that are stored in the Oracle database in files and on the Web Oracle Text analyzes document themes and gists and it searches text using various search strategies It also renders search results in several formats and it analyzes and indexes m...

Page 128: ...c key security credentials for clients and servers It generates a public private key pair and creates a certificate request for submission to a certificate authority For more information refer to Oracle Advanced Security Administrator s Guide 30 Oracle XML Developer s Kit release 9 2 0 2 0 This kit consists of a set of APIs for parsing and generating XML data These interfaces have been written for...

Page 129: ...nistrator s Guide and Oracle9i Advanced Analytic Services Data Mining Concepts 32 Oracle9i JVM Enterprise Edition release 9 2 0 2 0 The Oracle9i JVM includes Oracle Java Virtual Machine CORBA 2 0 Object Request Broker Machine embedded JDBC drivers SQLJ translator For more information refer to Oracle9i Java Developer s Guide 33 Oracle9i Server release 9 2 0 2 0 Oracle9i Server is the database compo...

Page 130: ...code When you precompile this code the result is a FORTRAN program that you can compile and use to build applications that access an Oracle database For more information refer to Pro Fortran Supplement to the Oracle Precompilers Guide 37 SQL Module Ada release 9 2 0 2 0 SQL Module Ada takes SQL statements that are embedded in an Ada program and converts them to standard Ada code When you precompil...

Page 131: ...otocol Support release 9 2 0 2 0 TCP IP Protocol Support enables client server conversation over a network using TCP IP and Oracle Net This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP IP if the Oracle database is running on a host system that supports network communication using TCP IP Multi Threaded Server MTS Su...

Page 132: ...Product Descriptions A 26 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Page 133: ...ture Topics covered in this appendix are Introduction to the Oracle9i 64 bit Feature Suggested Parameter Settings Other Recommendations Attention The 64 bit feature is a standard feature of Oracle9i for HP OpenVMS Alpha and cannot be de installed 64 bit feature tuning is under constant revision Therefore this information will be updated as further tuning suggestions are realized ...

Page 134: ...data The system does not need to swap data in and out of memory to process all of the transaction requests and can more effectively accommodate requests for larger amounts of data The 64 bit feature can benefit both query intensive DSS and read write OLTP transactions For DSS the database feature provides particular advantage for index builds full table scans ad hoc queries and multi way joins For...

Page 135: ...BLOCK_SIZE the more serious the impact on single row lookups 2 Configure the size of the Oracle buffer cache such that it will provide the best possible cache hit ratio without affecting memory requirements of other Oracle and system processes For example for a 3 GB buffer cache with DB_BLOCK_SIZE 8192 set DB_ BLOCK_BUFFERS 400000 3 To enable Cost Based Optimizer CBO set optimizer_mode choose To u...

Page 136: ... tables involved in the query but columns from one of the tables are used repeatedly in the where clause in joins in etc try to fit as many blocks from this table as possible into the cache to see if DB_BLOCK_BUFFERS can be increased To ensure the hard hit tables are cached and stay in the most recently used MRU end of the cache perform either of the following steps Type using SQLPLUS alter table ...

Page 137: ...Gateway This chapter describes how to install the gateway software from the distribution CD ROM The following topics are included System Requirements for Oracle Transparent Gateway Installing Oracle Transparent Gateway Removing Oracle Transparent Gateway ...

Page 138: ...to Chapter 1 Oracle9i Installation Planning and Chapter 2 Release Information for the database requirements The requirements for Oracle networking on the gateway computer are Oracle Net Server release 9 2 0 The requirements for Oracle networking on the Oracle database server computer are Oracle Net Client release 9 2 0 The requirements for RMS are RMS release xxxxx where xxxxx is the complete vers...

Page 139: ... Hewlett Packard Hewlett Packard provides patch information at http www compaq com support Oracle Net Requirements Oracle Net on HP OpenVMS is developed and certified using Hewlett Packard TCP IP Services for OpenVMS UCX If you wish to use the TCP IP protocol adapter for Oracle Net you should have version 5 1 ECO 4 or higher of TCP IP Services for HP OpenVMS Alpha installed TCP IP protocol stacks ...

Page 140: ...Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed RDB RDB release 9 2 0 2 0 Table C 2 RMS Gateway Requirements Hardware Software Requirements Processor A HP Alpha workstation running the required version of OpenVMS Mem...

Page 141: ... upward compatible so that existing applications will continue to work without modification Thus later releases of TCP IP are upward compatible with Oracle Net provided that the vendor specified Application Programming Interface API does not change with new releases Oracle Database Server Oracle9i Enterprise Edition server release 2 9 2 0 2 0 Oracle database server can reside on any supported plat...

Page 142: ...rating System RDB release 9 2 0 2 0 tg4rdb release 9 2 running on HP OpenVMS Alpha RMS release 9 2 0 2 0 tg4rms release 9 2 running on HP OpenVMS Alpha Gateway Installation Worksheets Select the worksheet in one of the following tables that is appropriate for your system Use the values that you enter as a reference during the configuration process RDB Gateway Worksheet RMS Gateway Worksheet See Al...

Page 143: ... name Oracle database server platform OS and its version number ORACLE_HOME of Oracle database server full path name Gateway machine name Gateway machine platform OS and its version number ORACLE_HOME of the gateway full path name Location of RDB database to which the gateway will connect Table C 4 RMS Gateway Installation Worksheet Description Value Oracle database server machine name Oracle data...

Page 144: ...tion prompts as indicated for your platform in Installation Prompts for Transparent Gateway Installation Prompts for Transparent Gateway The Oracle Universal Installer screens and the sequence in which they appear depend on your platform Select the installation prompt section that corresponds to the gateway that you wish to install Installation Prompts for RDB Gateway Installation Prompts for RMS ...

Page 145: ...r confirms that the installation has been completed Check the contents of the installActions log file located in the orainventory_location logs directory Installation Prompts for RMS Gateway There are no installation prompts for the RMS gateway Removing Oracle Transparent Gateway Remove the gateway as follows 1 Start the Oracle Universal Installer 2 Click the De install Products button on the Welc...

Page 146: ...Removing Oracle Transparent Gateway C 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Page 147: ...e and steps to install and configure Apache Server for HP OpenVMS Alpha The following topics are included Post Installation Checklist on page D 2 Test the Installation on page D 3 Running the Oracle HTTP Server on OpenVMS on page D 4 Security Information on page D 27 Open Source Licenses on page D 29 Apache on page D 29 ...

Page 148: ... HTTP Server for OpenVMS AUTOGEN will probably increase the page file size and the number of swap file pages Check Disk Quota If the disk quota is too low the Oracle HTTP Server will not start Either raise the disk quota for the user account ORACLE or grant the account the EXQUOTA privilege thus allowing it to bypass disk quota restrictions Use the following commands SHOW QUOTA USER server uic DIS...

Page 149: ...you just installed HTTP host domain port If this is a new installation the browser should display the standard introductory page with the following bold text at the top If you see this it means that the installation of the Apache web server software on this system successful The Apache logo is displayed at the bottom TELNET Test You can also use TELNET on the local host to test the installation Us...

Page 150: ... Troubleshooting If you do not receive a response from the Oracle HTTP Server check the following Look in your SYLOGIN COM file and make sure there is no SET TERMINAL INQUIRE statement for NETWORK processes Look for the following files APACHE ROOT 000000 APACHE SERVER LOG APACHE ROOT LOGS ERROR_LOG Running the Oracle HTTP Server on OpenVMS Starting and Stopping the Server To startup the Oracle HTT...

Page 151: ... you should experience performance difficulties refer to this table for guidelines in making adjustments For heavier loads we point out which values in our experience need to be increased as load increases Keep in mind that no one set of values will be appropriate for all situations Table D 1 Sample Values for the ORACLE Account Parameter Default On Hewlett Packard Web Server ASTLM NonPooled Total...

Page 152: ...at can be active at the same time 100 300 Increase this value for a heavy load You might also need to increase the SYSGEN parameter CHANNELCNT because it limits BIOLM DIOLM and FILLM JTQUOTA Pooled Byte quota for the job wide logical name table 4096 8192 PGFLQUO Pooled Number of pages the user s process can use in the system page file 50000 250000 If you increase PGFLQUO you should monitor the fre...

Page 153: ...rocess can have open Set the SYSGEN parameter CHANNELCNT to 1024 unless it is already set to a higher value Global Pages and Global Sections If a browser installation stalls then this could be an indication that the number of global pages or global sections is too low Run AUTOGEN to evaluate the number of global pages and global sections that you need Some browsers might need more Excessive File B...

Page 154: ...ritten for the OSU server UNIX style path names are recognized by OpenVMS You can use either UNIX style or OpenVMS style path names in the configuration file However you cannot intermix the two styles within a specification In an OpenVMS Cluster you can specify either clusterwide or system specific files How to Configure Apache Perform the following steps to configure Apache to run while using an ...

Page 155: ...s HTTP_CORE C AccessConfig AccessFileName AllowOverride AuthName AuthType BindAddress CoreDumpDirectory DefaultType Directory DirectoryMatch DocumentRoot ErrorDocument ErrorLog Files FilesMatch HostnameLookups IdentityCheck IfDefine IfModule Include KeepAlive KeepAliveTimeout Limit LimitExcept LimitRequestBody ...

Page 156: ...elds LimitRequestLine Listen ListenBacklog Location LocationMatch LogLevel MaxClients MaxKeepAliveRequests MaxRequestPerChild MaxSpareServers MinSpareServers NameVirtualHost Options PidFile Port Require ResourceConfig RLimitCPU RLimitMEM RLimitNPROC Satisfy SendBufferSize ServerAdmin ServerAlias ServerName ServerPath ServerRoot ...

Page 157: ...ure ServerTokens ServerType StartServers TimeOut UseCanonicalName User VirtualHost MOD_ACCESS C allow deny order MOD_ACTIONS C Action Script MOD_ALIAS C Alias AliasMatch Redirect RedirectMatch RedirectTemp RedirectPermanent ScriptAlias ScriptAliasMatch MOD_ASIS C MOD_AUTH C AuthGroupFile AuthUserFile ...

Page 158: ...C AddAlt AddAltByEncoding AddAltyByType AddDescription AddIcon AddIconByEncoding AddIconByType DefaultIcon FancyIndexing HeaderName IndexIgnore IndexOptions IndexOrderDefault ReadmeName MOD_CGI C ScriptLog ScriptLogBuffer ScriptLogLength MOD_DIR C DirectoryIndex MOD_ENV C SetEnv UnsetEnv MOD_IMAP C ImapBase ImapDefault ImapMenu ...

Page 159: ...fo MOD_LOG_CONFIG C CustomLog LogFormat TransferLog MOD_MIME C AddCharset AddEncoding AddHandler AddLanguage AddType DefaultLanguage ForceType RemoveHandler SetHandler TypesConfig MOD_NEGOTIATION C CacheNegotiatedDocs LanguagePriority MOD_SETENVIF C BrowserMatch BrowserMatchNoCase SetEnvIf SetEnvIfNoCase MOD_SO C LoadModule ...

Page 160: ... following web site http www apache org docs provides most of the information needed to run your Oracle HTTP Server for OpenVMS Information specific to the OpenVMS operating system is provided below Modules Not Included The following modules are not included in this version of the Oracle HTTP Server for OpenVMS kit MOD_AUTH_ANON MOD_AUTH_DB MOD_AUTH_DBM MOD_AUTH_DIGEST MOD_CERN_META MOD_DIGEST MOD...

Page 161: ...OD_USERTRACK MOD_VHOST_ALIAS Unsupported Directives The following directives are not supported AgentLog AllowCONNECT Anonymous Anonymous_Authoritative Anonymous_LogEmail Anonymous_MustGiveEmail Anonymous_NoUserID Anonymous_VerifyEmail AuthDBAuthoritative AuthDBGroupFile AuthDBMAuthoritative AuthDBMGroupFile AuthDBUserFile AuthDBMUserFile AuthDigestFile CacheDefaultExpire ...

Page 162: ...s CacheForceCompletion CacheGcInterval CacheLastModifiedFactor CacheMaxExpire CacheRoot CacheSize CheckSpelling CookieExpires CookieTracking Example ExpiresActive ExpiresByType ExpiresDefault Header Metadir MetaFiles MetaSuffix MimeMagicFile MMapFile NoCache ProxyBlock ProxyDomain ProxyPass ProxyPassReverse ProxyReceiveBufferSize ProxyRemote ...

Page 163: ...ntRoot VirtualDocumentRootIP VirtualScriptAlias VirtualScriptAliasIP Command Line Options This section describes the HTTPD command line options supported on the Oracle HTTP Server Before you can use them you must first define HTTPD as a symbol as follows HTTPD APACHE ROOT 000000 APACHE_HTTPD EXE_ALPHA Then you can use the following format to enter a command line option HTTPD option where option is...

Page 164: ...al hosts Both IP based and name based virtual host support are available on the Oracle HTTP Server for OpenVMS For more information see the Apache Software Foundation documentation at the following web site http www apache org docs vhosts index html Dynamic Shared Object Support Dynamic shared object support provides a method to format code so that it will load into the address space of an executa...

Page 165: ...pache API to write your own modules that will run on the Oracle HTTP Server for OpenVMS For more information see the Apache Software Foundation documentation at the following web site http www apache org docs misc API html suEXEC Support The suEXEC feature provides the ability to run CGI programs under user IDs different from the user ID of the calling web server This is not supported by the Oracl...

Page 166: ...UNIX style syntax when interacting with the Oracle HTTP Server An example would be appending additional directories or a file name to a root The following examples illustrate mixed UNIX style and OpenVMS style file names that are not supported in HP OpenVMS Alpha Version 7 2 1 doc foo bar bar tmp foo bar b _ar foo bar You can however modify the last example so that it will work as an OpenVMS exten...

Page 167: ...er APACHE HTTPD_SHR System executive mode logical name pointing to installed shareable images Not intended to be modified by the user APACHE INPUT Used by CGI programs for PUT POST methods of reading the input stream APACHE PLV_ENABLE_ username System executive mode logical name defined during startup and used to control access to the services provided by the APACHE PRIVILEGED image Not intended t...

Page 168: ... greater than 512 characters it is defined as a multi item logical APACHE DEBUG_DCL_CGI If defined this system logical name enables APACHE VERIFY_DCL_CGI and APACHE SHOW_CGI_ SYMBOL APACHE VERIFY_DCL_CGI If defined this system logical name provides information for troubleshooting DCL command procedure CGIs by forcing a SET VERIFY before executing any DCL CGI Use with APACHE DEBUG_DCL_CGI APACHE SH...

Page 169: ... system specific version of the file in APACHE SPECIFIC directory If it does not find one then it looks for a clusterwide file in APACHE COMMON directory APACHE CGI_USE_DCLCOM_FOR_IMAGES If defined this system logical name forces CGI images to execute within a DCL process The default is to execute CGI images directly Note Direct execution of CGI images in not currently supported APACHE DL_NO_UPPER...

Page 170: ...sting For example you should specify APACHE COMMON or APACHE SPECIFIC instead of APACHE ROOT with Directory directives The following extract from the HTTPD CONF file refers to APACHE COMMON because the content for the default web page is in the clusterwide directories DocumentRoot apache common htdocs Directory apache common htdocs Options Indexes FollowSymLinks Multiviews AllowOverride None Order...

Page 171: ...truncated at 970 limitable with DEC C 1 Environment logicals are defined as local symbols unless they are greater than 970 characters If the environment value is greater than 970 characters it is defined as a multi item logical 2 Environment logicals are defined as logicals If the environment value is greater than 512 characters it is defined as a multi item logical APACHE DCL_ENV is a foreign sym...

Page 172: ... by forcing a SET VERIFY before executing any DCL CGI Enabled by APACHE DEBUG_DCL_CGI APACHE SHOW_CGI_SYMBOL If defined this system logical name provides information for troubleshooting the CGI environment by dumping all of the symbols and logicals job process for a given CGI Enabled by APACHE DEBUG_DCL_CGI Displaying Graphics with CGI Command Procedures To display a graphics file with a CGI comma...

Page 173: ...ses are created to service incoming HTTP requests and to execute CGI scripts Because the server runs as a single job the OpenVMS security profile for each process is identical and no enhanced mechanism is required for these processes to communicate with one another Resource utilization is controlled by a single user account ORACLE where pooled quotas are defined Privileged Images The Oracle HTTP S...

Page 174: ... 3 is a bit mask which enables or disables the two services Bit 0 controls binding to privileged ports Bit 1 controls fetching user default path information The second and third parameters are the minimum and maximum port that is allowed to be bound When a call to either service is made the service code 1 Temporarily enables the privileges SYSPRV OPER SYSNAM and NETMBX 2 Performs the function 3 Re...

Page 175: ... the server environment You can configure the server to allow execution of arbitrary user scripts but standard practice is to limit such activity to scripts that are written by completely trusted users The Oracle HTTP Server includes directives that allow a web administrator to control script execution and client access The use of these directives is described in numerous books and is not duplicat...

Page 176: ...Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS http www openvms compaq com openvms products ips apache apache_license txt This product also includes software that is developed by Hewlett Packard ...

Page 177: ... Blocks B 3 BOB B 3 C CATNSNMP SQL file capabilities 5 20 changes and enhancements 2 2 character mode issues and restrictions 3 2 clientadmin rsp file 1 19 clientcustom rsp file 1 19 clientprogmr rsp file 1 19 commands lsnrctl 3 20 runInstaller starting 4 3 4 6 umask 3 18 compatibility issues 1 13 configuration restrictions 1 15 control files CONTROL01 CTL 5 26 CONTROL02 CTL 5 26 CONTROL03 CTL 5 2...

Page 178: ...e database roles 5 20 described 5 20 dropping with CATNSNMP SQL file 5 20 password 5 20 DCL command to check disk format 2 4 DEC compilers 1 12 DEC ADA 3 4 2 1 12 default control files CONTROL01 CTL 5 26 CONTROL02 CTL 5 26 CONTROL03 CTL 5 26 default data files DR01 DBF 5 23 INDX01 DBF 5 23 SYSTEM01 DBF 5 24 TEMP01 DBF 5 24 TOOLS DBF 5 24 USERS01 DBF 5 24 default initialization parameter file init ...

Page 179: ...ion aborted 4 11 character mode 3 2 cleaning up 4 11 non interactive 3 2 4 11 described 4 11 response files 4 11 oracle software owner 3 16 post installation tasks 5 1 pre installation tasks 3 1 requirements environment 3 19 Optimal Flexible Architecture 3 3 installation types with Oracle9i A 2 with Oracle9i Client A 8 with Oracle9i Enterprise Edition A 2 with Oracle9i server A 2 installing proced...

Page 180: ...on tasks 5 13 pre installation tasks 3 18 requirements 3 17 Oracle Advanced Security Oracle Wallet Manager 1 15 requirements 1 15 Wallet Manager defined A 22 Oracle Application Server Listener See Oracle HTTP Server Oracle Data Migration Assistant 3 3 and Oracle7 3 3 Oracle Database Configuration Assistant and Oracle interMedia 1 6 database creation methods selecting 1 5 database environments conf...

Page 181: ...8 installation worksheets for C 6 RDB installation worksheet for C 7 rdb installation prompts for C 9 removing C 9 rms installation worksheet for C 7 Oracle Universal Installer and migrating data 1 7 and upgrading software 1 7 database creation methods 1 5 defined A 21 inventory 3 2 4 8 log files 4 8 response files list of 1 19 Oracle Utilities defined A 22 Oracle Visual Information Retrieval requ...

Page 182: ...name 5 21 for SYSTEM user name 5 21 performance B 2 permissions file creation 3 16 setting with umask 3 18 PGA B 3 post installation tasks Oracle Precompilers 5 16 product specific 5 14 Secure Socket Layer 5 17 Shared Server 5 15 precompilers requirements 1 14 pre installation tasks as the System user 3 16 Oracle Net 3 20 shutting down listeners 3 20 Pro C 1 12 Pro C C described A 23 requirements ...

Page 183: ...ration 1 15 Roles OEM_MONITOR 5 22 roles of CTXSYS user name 5 20 of DBSNMP user name 5 20 of MDSYS user name 5 20 of ORDPLUGINS user name 5 20 of ORDSYS user name 5 20 of OUTLN user name 5 20 of SCOTT user name 5 21 of SYS user name 5 21 of SYSTEM user name 5 21 rollback segments starter database 5 26 root user post installation tasks 5 12 runInstaller command 4 3 4 6 S SAVPARAMS parameter 3 15 s...

Page 184: ...tablespaces containing DR01 DBF 5 23 containing INDX01 DBF 5 23 containing SYSTEM01 DBF 5 24 containing TEMP01 DBF 5 24 containing TOOLS DBF 5 24 containing USERS01 DBF 5 24 defined 5 23 DRSYS 5 23 expanding for large sorts 5 24 in database 5 23 INDX 5 23 SYSTEM 5 24 TEMP 5 24 TOOLS 5 24 USERS 5 24 TCP IP protocol support and Secure Socket Layer 1 15 defined A 25 TEMP tablespace described 5 24 TEM...

Page 185: ... SYS 5 21 SYSTEM 5 21 USERS tablespace described 5 24 USERS01 DBF data file 5 24 tablespace contained in 5 24 V Very Large Memory B 1 VLM reserving memory 3 13 VMS mailbox driver 1 12 W window manager requirements 1 11 X XML Development Kit A 25 Oracle XML Developer s Kit A 22 X windows configuring 1 11 ...

Page 186: ...Index 10 ...

Reviews: