Oracle9iInstallation Guide Release 2 (9.2.0.2) for hp OpenVMS AlphaPart No. B10508-01December 2002

x

Starter Database Contents5-24 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSSYSTEM system01.dbfThe data dictionary. This include

Starter Database ContentsPost-Installation 5-25Locating the Initialization Parameter FileThe database initialization parameter file (init.ora) is gene

Starter Database Contents5-26 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSLocating Control FilesThe starter database contains

Adding or Upgrading ProductsPost-Installation 5-27 Names of the Oracle database users Privileges and roles granted to each user Names and definitio

Adding or Upgrading Products5-28 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS5.Back up the old code and database files (data,

Relinking the Oracle CodePost-Installation 5-29Relinking the Oracle CodeThe Oracle code must be relinked under the following conditions: Change to op

Relinking the Oracle Code5-30 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

Oracle9i Products A-1AOracle9i ProductsThis appendix describes the products that are included with Oracle9i: Oracle9i Database Components on page A-2

Oracle9i Database ComponentsA-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSOracle9i Database Components The following

Oracle9i Database ComponentsOracle9i Products A-3 Thin JDBC Java-based Encryption Support, including:* DES40 Encryption* MD5 Integrity* RC4_40 Encryp

xiPrefacePurposeThis guide and the Oracle9i Administrator’s Reference Release 2 (9.2.0.2) for hp OpenVMS Alpha provide instructions for installing and

Oracle9i Database ComponentsA-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS Oracle Net, which includes the following: Oracl

Oracle9i Database ComponentsOracle9i Products A-5 Oracle9i JVM, which includes the following: Java Virtual Machine Oracle9i Server (the Oracle9i da

Oracle9i Database ComponentsA-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS Oracle JDBC Drivers, which include the following

Oracle9i Database ComponentsOracle9i Products A-7 Oracle XML SQL Utility Oracle9i JVM, which includes the following: Java Virtual Machine Oracle9i

Oracle9i Client ComponentsA-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSOracle9i Client ComponentsThe following sections pro

Oracle9i Client ComponentsOracle9i Products A-9 Thin JDBC Java-based Encryption Support, including:* DES40 Encryption* DES56 Encryption* MD5 Integrit

Oracle9i Client ComponentsA-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS Oracle SQLJ, which includes the following: SQLJ

Oracle9i Client ComponentsOracle9i Products A-11Administrator EditionOracle9i Client Administrator includes the components in the Oracle9i Client Runt

Oracle9i Client ComponentsA-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS Thin JDBC Java-based Encryption Support, includin

Oracle9i Client ComponentsOracle9i Products A-13 Oracle JDBC Drivers, which include the following: Oracle JDBC Thin Driver for JDK 1.1 Oracle JDBC

xiiDocumentation AccessibilityOur goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disa

Product DescriptionsA-14 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSProduct DescriptionsThe following list provides descripti

Product DescriptionsOracle9i Products A-153.Oracle Management Pack for Oracle Applications release 9.0.1The Oracle Management Pack for Oracle Applica

Product DescriptionsA-16 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS7.Oracle Integration Server release 9.2.0.2.0Oracle Integ

Product DescriptionsOracle9i Products A-1710.Oracle Java Database Connectivity (JDBC) Drivers release 9.2.0.2.0Oracle JDBC Drivers are a standard set

Product DescriptionsA-18 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS15.Oracle Names release 9.2.0.2.0Oracle Names is a distri

Product DescriptionsOracle9i Products A-1918.Oracle Partitioning release 9.2.0.2.0Oracle Partitioning provides more control in managing tables and ind

Product DescriptionsA-20 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS21.Oracle Real Application Clusters Guard release 9.0.1O

Product DescriptionsOracle9i Products A-2124.Oracle SQLJ release 9.2.0.2.0Oracle SQLJ provides a standard method to embed SQL statements in Java prog

Product DescriptionsA-22 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS28.Oracle Utilities release 9.2.0.2.0Oracle Utilities con

Product DescriptionsOracle9i Products A-2331.Oracle9i Advanced Analytic Services — Data Mining release 9.0.1Oracle9i Advanced Analytic Services — Data

xiiiInstall Only Licensed ProductsYou are entitled to install and use only those products for which you have a current Oracle license agreement.Typogr

Product DescriptionsA-24 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS35.Pro*COBOL release 1.8.76 and release 9.0.1Pro*COBOL

Product DescriptionsOracle9i Products A-2538.SQL*Plus release 9.2.0.2.0SQL*Plus is a command line interface that enables you to use SQL and PL/SQL da

Product DescriptionsA-26 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

Oracle9i 64-bit Feature B-1BOracle9i 64-bit FeatureThis appendix introduces the 64-bit feature or Very Large Memory (VLM) and makes setting and other

Introduction to the Oracle9i 64-bit FeatureB-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSIntroduction to the Oracle9i 64-bit

Suggested Parameter SettingsOracle9i 64-bit Feature B-3sections that are not backed by any file. These global sections are not pageable and do not req

Other RecommendationsB-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSCheck statistics, such as V$SYSSTAT, to see if the number

Oracle Transparent Gateway C-1COracle Transparent GatewayThis chapter describes how to install the gateway software from the distribution CD-ROM. The

System Requirements for Oracle Transparent GatewayC-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSSystem Requirements for Orac

System Requirements for Oracle Transparent GatewayOracle Transparent Gateway C-3RDB Gateway RequirementsTable C–1 describes the hardware and software

xivRelated DocumentationInformation about system administration and tuning for a production database system is provided in the following documents: O

System Requirements for Oracle Transparent GatewayC-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSRMS Gateway RequirementsTabl

System Requirements for Oracle Transparent GatewayOracle Transparent Gateway C-5Operating SystemHP OpenVMS 7.3Operating System PatchUse the latest pat

System Requirements for Oracle Transparent GatewayC-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSTested Gateway Configuration

System Requirements for Oracle Transparent GatewayOracle Transparent Gateway C-7RDB Gateway WorksheetEnter your system values in the following Table C

Installing Oracle Transparent GatewayC-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSInstalling Oracle Transparent GatewayUse

Removing Oracle Transparent GatewayOracle Transparent Gateway C-9Installation Prompts for RDB GatewayUse the following pattern (Screen: Response) as a

Removing Oracle Transparent GatewayC-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

Apache Server Installation/Configuration D-1DApache Server Installation/ConfigurationThis appendix lists the procedure and steps to install and config

Post-Installation ChecklistD-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSPost-Installation ChecklistAfter you configure the

Test the InstallationApache Server Installation/Configuration D-3Failure to do so might result in ill-formed HTML intermittently being returned to cli

xvOracle Services and SupportThe Oracle corporate web page is located at the following web site:http://www.oracle.comOracle Corporation offers a wide

Running the Oracle HTTP Server on OpenVMSD-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSHTTP/1.1 200 OKDate: Tue, 23 May 2000

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-5Performance ConsiderationsYou should have prior experience tuning

Running the Oracle HTTP Server on OpenVMSD-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSTo change the quotas for the Oracle A

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-7Username: ORACLE Owner: APACHE WEBSERVER...Maxjobs: 0 Fillm: 100

Running the Oracle HTTP Server on OpenVMSD-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSCustomizing the Server EnvironmentThe

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-9http://www.apache.org/docsHTTP_CORE.CAccessConfigAccessFileNameAl

Running the Oracle HTTP Server on OpenVMSD-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSLimitRequestFieldsLimitRequestLineLi

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-11ServerSignatureServerTokensServerTypeStartServersTimeOutUseCanon

Running the Oracle HTTP Server on OpenVMSD-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSMOD_AUTOINDEX.CAddAltAddAltByEncodin

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-13MOD_INCLUDE.CMOD_INFO.CAddModuleInfoMOD_LOG_CONFIG.CCustomLogLog

xviProduct documentation can be found at the following web site:http://docs.oracle.comCustomer ServiceGlobal Customer Service contacts are listed at t

Running the Oracle HTTP Server on OpenVMSD-14 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSMOD_STATUS.CExtendedStatusMOD_UNIQUE

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-15MOD_MIME_MAGICMOD_MMAP_STATICMOD_PEARLMOD_PROXYMOD_REWRITEMOD_SP

Running the Oracle HTTP Server on OpenVMSD-16 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSCacheDirLengthCachedirLevelsCacheFor

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-17ProxyRequestsProxyViaRefererIgnoreRefererLogRewriteBaseRewriteCo

Running the Oracle HTTP Server on OpenVMSD-18 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS-"V": Displays the HTTPD b

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-19http://www.apache.org/docs/handler.htmlContent NegotiationThe MO

Running the Oracle HTTP Server on OpenVMSD-20 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSFile Naming ConventionsIn general, u

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-21$ SET SECURITY/ACL=(IDENTIFIER=yourFTPname,ACCESS=READ+WRITE) [d

Running the Oracle HTTP Server on OpenVMSD-22 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSAPACHE$SPECIFIC Concealed logical na

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-23OpenVMS Cluster ConsiderationsAn OpenVMS Cluster is a group of O

Oracle9i Installation Planning 1-11Oracle9i Installation PlanningThis chapter describes the Oracle9i installation types and configurations.The followi

Running the Oracle HTTP Server on OpenVMSD-24 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSTo avoid confusion, always use the a

Running the Oracle HTTP Server on OpenVMSApache Server Installation/Configuration D-25CGI Environment LogicalBy default, an environment logical symbol

Running the Oracle HTTP Server on OpenVMSD-26 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSReferencing InputCGI scripts that re

Security InformationApache Server Installation/Configuration D-27$ SAY "Content-type: image/gif"$ SAY ""$ APACHE$DCL_BIN APACHE$RO

Security InformationD-28 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS Changing the "carriage-control" attribute on

ApacheApache Server Installation/Configuration D-29logical names are placed in the system logical name table. Shutdown is accomplished by sending a KI

ApacheD-30 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMShttp://www.openvms.compaq.com/openvms/products/ips/apache/apache_licens

Index-1IndexNumerics64-bit feature, B-1Aaccountcreating the oracle account, 3-17account privilegessetting, 3-8account quotasminimum values, 3-9ADA, ve

Index-2databasecreation methodsselecting, 1-5data dictionarydefined, 5-26data files, 5-23database passwords, 5-19database user names, 5-19initializati

Index-3response files, 4-11setting permissions for creation, 3-18supported file systems, 3-3Ggeneral purpose database. See database environments, 1-4G

Oracle9i Installation Overview1-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSOracle9i Installation OverviewThe installation o

Index-4MMAXSYSGROUP, 3-6MDSYS user namedatabase roles, 5-20password, 5-20migrating existing Oracle databases, 1-7migrationOracle Data Migration Assist

Index-5defined, A-18linking options, 1-16Oracle Protocol Supportinstallation types available with, A-4, A-6pre-installation tasksshutting down listene

Index-6enterprise edition defined, A-23requirements, 1-14Oracle9i Serverdefined, A-23Oracle9i, installation types available with, A-2oraInst.loc file,

Index-7relinkingOracle code, 5-29Oracle products, 5-29requirementsCD-ROM, 1-9file permissions, 3-16file systems, 3-3hardware, 1-8interMedia, 1-14Java

Index-8SQL*Plusdescribed, A-25SQL*Plus Worksheetdescribed, A-25SQLJdescribed, A-21SQLJ Runtimedescribed, A-21standard.rsp files, 1-19starting instance

Index-9user namesCTXSYS, 5-20DBSNMP, 5-20MDSYS, 5-20ORDPLUGINS, 5-20ORDSYS, 5-20OUTLN, 5-20SCOTT, 5-21SYS, 5-21SYSTEM, 5-21USERS tablespace, described

Index-10

Oracle9i Installation OverviewOracle9i Installation Planning 1-3Oracle9i DatabaseThe Oracle9i Database is an object-oriented relational database manag

Oracle9i Installation Guide, Release 2 (9.2.0.2) for hp OpenVMS Alpha Part No. B10508-01Copyright © 2002 Oracle Corporation. All rights reserved. Pri

Oracle9i Database Configurations1-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSOracle9i Database ConfigurationsWhen you insta

Oracle9i Database ConfigurationsOracle9i Installation Planning 1-5CustomizedThis environment allows you to create a customized database configuration

Oracle9i Database Configurations1-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSThe following list provides descriptions of da

Installation With Existing Oracle DatabasesOracle9i Installation Planning 1-7 Software Only option: If you select this option, then the Oracle Univer

System Installation Requirements1-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSSystem Installation Requirements Verify that y

System Installation RequirementsOracle9i Installation Planning 1-9Minimum global pages/sections an amount of disk space equal to twice the amount of R

System Installation Requirements1-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSTable 1–2 lists the disk space requirements f

System Installation RequirementsOracle9i Installation Planning 1-11Operating System Software RequirementsTable 1–3 lists the operating system software

System Installation Requirements1-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSIf a clock is not displayed on your screen, t

Product DependenciesOracle9i Installation Planning 1-13Product DependenciesSome Oracle products depend on other Oracle products to work properly. Use

iiiContentsSend Us Your Comments ...

Product Dependencies1-14 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSList of the Restrictions and Requirements for Oracle9i an

Configuration RestrictionsOracle9i Installation Planning 1-15Oracle Advanced Security 9.2.0.2.0: Refer to "Oracle Advanced Security" on pa

Oracle Net Linking Options1-16 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSCopying Oracle ExecutablesMoving executables from o

Silent Mode InstallationOracle9i Installation Planning 1-17using the –responseFile argument instead of interactive GUI input and output. If the -resp

Silent Mode Installation1-18 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSWhat Is a Response File?A response file contains answ

Silent Mode InstallationOracle9i Installation Planning 1-19FROM_LOCATION is the complete path of the source of the products to be installed (in other

Silent Mode Installation1-20 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

Release Information 2-12Release InformationThis chapter provides information specific to this release of Oracle9i for HP OpenVMS. The following secti

Product Set2-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSProduct SetThe following components are included on the product CD-

Changes and EnhancementsRelease Information 2-3Oracle9i Release 2 Dependency on ODS-5 Disk StructureIn general, ODS-5 format allows VMS to support Mic

ivSilent Mode Installation... 1-16Wha

Changes and Enhancements2-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSChecking Disk FormatTo check the current disk format,

Changes and EnhancementsRelease Information 2-5Initialization Parameters in Oracle9i Release 2 That Have Been DesupportedALWAYS_ANTI_JOIN ALWAYS_SEMI

Known Restrictions2-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSKnown RestrictionsRMAN Runs Only Over TCP/IPThe connection t

Known RestrictionsRelease Information 2-7EJB BEANSOracle9i for HP OpenVMS does not support EJB on the server. If customers have iAS in mid tier, howe

Known Restrictions2-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

CD-ROM Pre-installation Requirements 3-13CD-ROM Pre-installation RequirementsThis chapter describes the pre-installation steps required for an Oracle9

HP OpenVMS and Installation-Specific Issues and Restrictions3-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSHP OpenVMS and Ins

HP OpenVMS and Installation-Specific Issues and RestrictionsCD-ROM Pre-installation Requirements 3-3Upgrading and MigratingIf you are upgrading an exi

Installation Procedure Requirements3-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS Exceed does not handle screen coordinates

Installation Procedure RequirementsCD-ROM Pre-installation Requirements 3-5Oracle Server Database Administrator AccountCreate an HP OpenVMS Alpha user

vInstallation Procedure Requirements... 3-4Oracle Server

Installation Procedure Requirements3-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSAlthough this guide refers to this account

Installation Procedure RequirementsCD-ROM Pre-installation Requirements 3-7$ SET DEFAULT SYS$SYSTEM$ RUN AUTHORIZE 2. At the UAF prompt, enter the ADD

Installation Procedure Requirements3-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSSetting Account PrivilegesThe following pri

Installation Procedure RequirementsCD-ROM Pre-installation Requirements 3-9At the UAF prompt, use the MODIFY command to add the required default and a

Installation Procedure Requirements3-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSAppendix B, "Oracle9i 64-bit Feature&

Installation Procedure RequirementsCD-ROM Pre-installation Requirements 3-11Then grant the rights identifier to the Oracle9i account as follows:UAF>

Installation Procedure Requirements3-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSProcess Rights for Intelligent Agent (OEMA

HP OpenVMS Alpha SYSGEN ParametersCD-ROM Pre-installation Requirements 3-13HP OpenVMS Alpha SYSGEN ParametersFor instructions on calculating MIN_GBLPA

HP OpenVMS Alpha SYSGEN Parameters3-14 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS** Reserved memory size = <size> grea

HP OpenVMS Alpha SYSGEN ParametersCD-ROM Pre-installation Requirements 3-15the DBA and system administrator may be the same person. The instructions i

viOracle Universal Installer ... 4-3I

HP OpenVMS Alpha System Configuration3-16 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSThis step generates new SYSGEN parameter

Setup Tasks to Perform as the SYSTEM UserCD-ROM Pre-installation Requirements 3-17 Create an OpenVMS Account to Own Oracle Software Create an OpenVM

Setup Tasks to Perform as the Oracle User3-18 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSprivileges to run the Apache Server

Setup Tasks for Oracle ProductsCD-ROM Pre-installation Requirements 3-19Set DisplayBefore starting the Oracle Universal Installer, set your display ap

Setup Tasks for Oracle Products3-20 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSJava Runtime EnvironmentThe Java Runtime Envir

Installation 4-14InstallationThis chapter describes how to start the Oracle Universal Installer and how to install Oracle9i products on your system. R

Installation Mount Options4-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSInstallation Mount OptionsMount and Unmount the Orac

Oracle Universal InstallerInstallation 4-3Oracle Universal InstallerThe following procedure describes the installation of products with the use of the

Oracle Universal Installer4-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS4.The File Locations Window appears. Source: You sh

Oracle Universal InstallerInstallation 4-510.The Datafiles Location window appears. Enter a path for the location of the data files. Click Next.11.

viiRelinking the Oracle Code... 5-29Step

Oracle Universal Installer4-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSInstalling Oracle9i Client1. Log in as the Oracle us

Oracle Universal InstallerInstallation 4-76.The Available Products window appears. Choose Oracle9i Client. Click Next to continue.7. The Installatio

Oracle Universal Installer4-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSOracle9i Database Custom InstallationWhen you select

Oracle Universal InstallerInstallation 4-9Installing Real Application ClustersBecause the disk on which the Oracle software will be installed is mount

Oracle Universal Installer4-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS5.Create a copy of the Password file:$ copy orapwsi

Oracle Universal InstallerInstallation 4-11List Of ParametersThe following parameters need to be defined before starting an instance that will partici

Oracle Universal Installer4-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

Post-Installation 5-15Post-InstallationAfter completing the Oracle Universal Installer session, you must perform certain post-installation steps, and

Database Configuration Assistant (DBCA)5-2 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSDatabase Configuration Assistant (DBCA)

Database Configuration Assistant (DBCA)Post-Installation 5-3The following sections contain examples that illustrate the use of silent mode.DBCA Silent

viiiD Apache Server Installation/ConfigurationPost-Installation Checklist...

Database Configuration Assistant (DBCA)5-4 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS-templateName copy_of_ora9i-datafileJar

Database Configuration Assistant (DBCA)Post-Installation 5-5The following sample DBCA.RSP file is included here for reference:########################

Database Configuration Assistant (DBCA)5-6 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS# Name : RESPONSEFILE_VERSION#

Database Configuration Assistant (DBCA)Post-Installation 5-7# Default value : <db_name> specified in GDBNAME# Mandatory : No#---------------

Database Configuration Assistant (DBCA)5-8 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS#--------------------------------------

Database Configuration Assistant (DBCA)Post-Installation 5-9# Name : VARIABLESFILE # Datatype : String# Description : Location of the

Database Configuration Assistant (DBCA)5-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS#-------------------------------------

Database Configuration Assistant (DBCA)Post-Installation 5-11# Default value : none# Mandatory : YES#---------------------------------------------

User Passwords5-12 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSUser PasswordsOracle Corporation recommends that you change the

Configuration Tasks to Perform as the Oracle UserPost-Installation 5-13Automate Database Startup and Shutdown (Optional)You can configure your system

ixSend Us Your CommentsOracle9i Installation Guide, Release 2 (9.2.0.2) for hp OpenVMS AlphaPart No. B10508-01Oracle Corporation welcomes your comment

Post-Installation for Oracle Products5-14 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSPost-Installation for Oracle Products Pe

Post-Installation for Oracle ProductsPost-Installation 5-15If you can successfully connect to the server with SQL*Plus, then you have established netw

Post-Installation for Oracle Products5-16 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSOracle PrecompilersThe following list pr

Post-Installation for Oracle ProductsPost-Installation 5-17PROTOTYPE INFOFor precompiler PROTOTYPE INFO, the configuration file is xxxcfg.cfg. This f

Starter Database Contents5-18 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSStarter Database ContentsThe starter database is a s

Starter Database ContentsPost-Installation 5-19Unlocking and Resetting Passwords ManuallyTo manually change a password and unlock an account, review t

Starter Database Contents5-20 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSTable 5–1 describes the default user names and passw

Starter Database ContentsPost-Installation 5-21SYS CHANGE_ON_INSTALLSYS is used for performing database administration tasks. SYS includes the foll

Starter Database Contents5-22 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMSIdentifying DatabasesThe Oracle9i software identifie

Starter Database ContentsPost-Installation 5-23The DB_NAME parameter and the DB_DOMAIN name parameter combine to create the global database name value