Oracle ORACLE9I B10508-01 страница 180 Скачать руководство пользователя

Страница: 180 / 186

Index-4

MAXSYSGROUP, 3-6
MDSYS user name

database roles, 5-20
password, 5-20

migrating existing Oracle databases, 1-7
migration

Oracle Data Migration Assistant, 3-3

modifying system parameters, 3-13
MRU, B-4
multiple databases, 3-12
multiple Oracle homes

system identifier, 5-23

Net8 Configuration Assistant, 5-14
non-interactive installation, 3-2
noninteractive installation.

See

installation,

non-interactive

OEM_MONITOR, 5-22
OEMAGENT

process rights, 3-12

OLTP.

See

transaction processing

OLTP transactions, B-2
OpenVMS

system parameters, 3-13

operating system

configuration, 3-16
requirements, 1-11

Optimal Flexible Architecture

installation issues and restrictions, 3-3

Oracle

Server DBA account, 3-5
tools, adding or upgrading, 5-27

oracle account

home directory, 3-17
how to create

how to create, 3-17

post-installation 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

inter

Media, 1-6

database creation methods

selecting, 1-5

database environments configured by, 1-5, 1-6
response file, 1-19

Oracle Enterprise Manager Quick Tours

defined, A-15

Oracle HTTP Server

defined, A-15

Oracle Integration Server

defined, A-16

Oracle Intelligent Agent

defined, A-16

Oracle

inter

Media

Locator

described, A-17

Oracle

inter

Media Image

defined, A-16

Oracle inventory

JRE locations, 3-2
log files, 4-8

Oracle Java Database.

See

Oracle JDBC Drivers

Oracle Java Tools

defined, A-17

Oracle JDBC Drivers

defined, A-17

Oracle Locale Builder

defined, A-17

Oracle Locator

described, A-17

Oracle Management Server

defined, A-17

Oracle Names

defined, A-18

Oracle Net

and Oracle Advanced Security, 1-15

Содержание ORACLE9I B10508-01

Страница 1: ...Oracle9i Installation Guide Release 2 9 2 0 2 for hp OpenVMS Alpha Part No B10508 01 December 2002 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 10: ...x ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 36: ...Silent Mode Installation 1 20 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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_...

Страница 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...

Страница 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 ...

Страница 44: ...Known Restrictions 2 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 76: ...Oracle Universal Installer 4 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 106: ...Relinking the Oracle Code 5 30 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 132: ...Product Descriptions A 26 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 146: ...Removing Oracle Transparent Gateway C 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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 ...

Страница 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 ...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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...

Страница 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 ...

Страница 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...

Страница 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...

Страница 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 ...

Страница 186: ...Index 10 ...

Результаты поиска

Содержание ORACLE9I B10508-01

Отзывы:

Похожие инструкции для ORACLE9I B10508-01

Бренды по названию

Популярные бренды

Oracle ORACLE9I B10508-01, Руководство по установке

Результаты поиска

Содержание ORACLE9I B10508-01

Отзывы:

Похожие инструкции для ORACLE9I B10508-01

Бренды по названию

Популярные бренды