Oracle Audio Technologies B10508-01 manuel d'utilisation

Oracl e9 i Installation Guide Release 2 (9.2.0.2) f or hp OpenVMS Alpha P ar t No. B10508-01 Decembe r 2002[...]

Oracle9 i Ins tallat ion Gu ide, Re lease 2 (9.2. 0.2) for hp Op enVM S Alpha Part No. B1050 8-01 Copyrigh t © 2002 Ora cle Corpo ration . All rights reserved . Prima ry Auth or: Platf orm T echnol ogies Divis ion Contributors : John Dew itt, Grant Hayden , Steve Holc k, Pierre Krabbendam, Kevi n O’Rourke, Sam Ravindhr an, David R obles, Regina [...]

iii Contents Send Us Your Comments ............ ................. ................. ................. ........... ................. ................. ....... ix Pref ace .............. ................. ................. ........... ................. ................. ........... ................. ................. ................. . xi 1 Oracle9 [...]

iv Silent Mode Installati on .................. ........... ................. ................. ................. ........... ................. ...... 1- 16 What Is a Silent Installa tion? ..................... ............ ................. ................. ................. ........... .. .... 1-16 What Is a Response File?............ ..........[...]

v Installat ion Procedur e Requirements ................ ................. ................. ........... ................. ............... 3-4 Oracle Server Database A dministrator Account..................... ........... ................. ................. .... 3-5 Oracle9 i Account is NOT the SYS or S YSTEM Account .............. ........... ....[...]

vi Oracle Univer sal Installer .................... ................. ................. ................. ........... ................. .............. 4-3 Instal ling an Ora cle9 i Database ............................ ........... ................. ................. ................. ........ 4-3 Installin g Oracle9 i Client ...................... [...]

vii Relinking t he Oracle Code ....... ................ ............ ................. ................. ................. ........... ............. 5-29 Step 1 Shutdown the Given Database( s) ................ ........... ................. ................. ................. .. 5- 29 Step 2 Remove Images .................. ................. .......[...]

viii D Apache Server Inst al lation/Configuration Post-Installa tion Checklist .............. ................ ................. ............ ................. ................. ................ ... D-2 Run AUTOGEN ......... ................. ........... ................. ................. ........... ................. ................. ........ D-[...]

ix Send Us Y our Comments Orac le9 i Installation Guide, Re lease 2 (9 .2.0.2) for hp OpenVMS Alpha P art No. B1050 8-01 Oracle Corporati on welcomes yo ur comments and su ggestion s on the quality and usefulness of this publ ica tion. Y our in put is an i mpor tant part o f th e info rmat ion u sed for r evis ion. ■ Did you fi nd an y err or s? [...]

x[...]

xi Preface Purpose This guide and th e Oracle9i Ad ministrator’ s Refere nce Release 2 (9 .2.0.2) for hp Open VMS Alpha provide instructions fo r install ing and configu ring Oracl e9 i Release 2 ( 9.2.0.2) o n hp OpenVMS Alpha sys tems . Docum entatio n for the products that are included with this soft ware is in the Oracle9 i generic docume nta[...]

xii Documentat ion Accessib ility Our goal is to make Oracle pr oducts, services, and supporting documentation accessible, with go od usabi lity , to the disabled community . T o that end, our documentatio n includes features that make informa tion avai lable to users of assistive techn ology . This docume ntation is available in HTML format, an d [...]

xiii Instal l Only Licensed Pr oducts Y ou are en titled to install and use only those products for which you have a curr ent Oracle license agreem ent. T ypographic C on ventions Command Synt ax HP OpenVMS A lpha comman d syntax appears i n monospace font . The " $ " character at the beginning of command examples should not be entered at[...]

xiv Related Documentat ion Informa tion ab out syste m adm inistra tion an d tuning f or a productio n database system is provided in the fol lowing d ocuments: ■ Oracle9i Adminis trator ’s Refer ence Rele ase 2 (9.2.0.2) for hp Open VMS Alpha ■ Oracle9 i Data base Admin istra tor ’ s Guide ■ Oracle9i N et Serv ices Admi nistrat or ’ s [...]

xv Orac le Services and Supp or t The Oracle corporat e web page is loca ted at the followi ng web site: http ://www. oracl e.com Oracle Corporati on offers a wide range of services to help facilita te corporate system solut ions, incl uding Ora cle Educ ation courses, Oracle Co nsulting se rvices, and Oracle Support S ervices from the website . In[...]

xvi Pr oduct document atio n can be foun d at th e foll owing web sit e: http ://docs .orac le.com Customer Service Global Customer Service contacts ar e listed at the following web site: http ://www. oracl e.com/ support / Education and T raining T raining informat ion and worldwide schedu les are available from the followin g web site: http ://ed[...]

Orac le9i Ins tallation Plannin g 1-1 1 Orac le9 i Installation Planning This chapter describes the Oracle9 i installatio n types and configura tions. The following topics are included: ■ Oracle9i In stallation Overview ■ System Install ation Requirement s ■ Product Dependencies ■ Configuration Restrictions ■ Oracle Net Linking Options[...]

Oracle 9i Installation Overview 1-2 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Oracle9 i Installat ion Over view The installatio n of Oracle9 i pr oduct s ha s five sta ges: 1. Planning yo ur installatio n: Use this chapter to help you plan and prepare for your instal lat ion . This chapter provides information a bout[...]

Oracle9i In stallation Ov erview Orac le9i Ins tallation Plannin g 1-3 Orac le9 i Database The Oracle9 i Database is an obje ct-oriente d relation al da tabase man agement system that con sists of an Or acle databas e and an Or acle instan ce . It may be installed in one of thr ee instal lation types: Enterprise Ed ition, Standar d Edition, or Cus [...]

Oracle9 i Da tabas e Co nfig urati ons 1-4 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Oracle9 i D atabase Configur ations When you ins tall the O racle9 i database product, you ar e pro mpted to select a database configura tion that is suited to your needs . Sele ct fr om one of five Ora cle9 i database configuratio n[...]

Oracle9i Da tabase Conf iguratio ns Orac le9i Ins tallation Plannin g 1-5 Custo mi zed This environment allows you to cr eate a customize d database con figuration of Oracle pr oducts that meets specialized requirem ents. Select this option only if you are pr epared to pr ovide detailed pr oduct and database environment choices . Choosing this opti[...]

Oracle9 i Da tabas e Co nfig urati ons 1-6 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS The following list provides descriptio ns of data base config urations: ■ General Purpose configuration: If you sel ect this option with an Enterprise Edition or Standar d Edition instal lati on, then the Database Con figuration As[...]

Installation With Existing Oracle Dat abases Orac le9i Ins tallation Plannin g 1-7 ■ Software Only option: If you select th is option, then the Oracle Universal Installer (O UI) installs only Oracle9 i softw are . Database Co nfigurati on Assi stant doe s not star t afte r in stall atio n, and no p re confi gur ed d atab ase i s installed. If a c[...]

System I nstallation R equirement s 1-8 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Syste m Installa tion Requirement s V erify that your system meets the requirem ents that are described in the following sections befo re you install Ora cle9 i pro duc ts. ■ T ime Requirements ■ Hardw are Requir ements ■ Disk Spa[...]

System Inst allation Re quiremen ts Orac le9i Ins tallation Plannin g 1-9 Minimum global pages/sections an amou nt of dis k space equa l to twice th e amoun t of RAM for most sy stems. CD-ROM Devi ce A CD-ROM drive supported by HP OpenVMS is r equired . Oracl e uses ODS-5 format CD-ROM disks. File System ODS-5 is required for the software. Ref er t[...]

System I nstallation R equirement s 1-10 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Ta b l e 1 – 2 lists the disk space req uirements for Oracle9 i Client. Images T wo shared imag es that are linked with client code are built and insta lled when you link Oracle9 i Enterprise Edition . The new sh are d images r ed[...]

System Inst allation Re quiremen ts Oracl e9i Insta llatio n Planning 1-11 Operating Sy stem Software Requireme nts Ta b l e 1 – 3 lists the operatin g system softw are r equirements for Oracle9 i products. T o determine your current operating system information, enter the following command: $ SH OW SYST EM /N OPROCE SS /FUL L T o see informat io[...]

System I nstallation R equirement s 1-12 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS If a clock is not displ ayed on your screen, then X-W in dows is n ot configured corre ctly . See "Se t Displ ay" on pa ge 3-19 for i nstructions o n co nfiguring X-W indows . Orac le Net VMS Mailbo x Driver The Oracle Net[...]

Product De pendencies Oracl e9i Insta llatio n Planning 1-13 Pr oduct Dependen cies Some Oracle pro ducts depend on other Oracle products to work pr operly . Use the following tables to determine the pr oduct dependencies . This section ha s the fol lowin g sub sect ions: ■ Important Compatibi lity Issues ■ Additional Product-S pecific Install [...]

Produ ct Dependencie s 1-14 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS List of the Res trictions and Requirements for Oracl e9 i and Options. Pro duct Name: Restrictions an d Requirem ents Oracle inter Media 9.2.0.2.0: Y ou must h ave at leas t 10 MB of di sk space avail able for the inter Media T ext data dictiona[...]

Configu ration Re strictions Oracl e9i Insta llatio n Planning 1-15 Oracle Ad vanced Securi ty 9.2.0.2.0: Refe r to "Oracle Advanced Security" on page 1- 15 for inform ation about Oracle Advanced Security authentica tion support req ui r em e n t s . Orac le TCP/IP with SSL Pr otocol Supp ort 9.2.0.2.0: SSL 3.0 or later Orac le Adv anced [...]

Oracle Net Linking Op tions 1-16 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Copying Oracle Executables Moving executables fr om one OpenVMS machine to another is not r ecommended due to the usage of shar ed libraries an d to the dif ficulty of ensuring valid ref e re n c i n g . Oracle Corporation therefo re r ecom[...]

Silent Mode Installation Oracl e9i Insta llatio n Planning 1-17 using the –responseFile argument instea d of interactive GUI input and output. If th e -responseFile flag is given, then th e installation is assumed to be a silent mode type. A silent instal lation can also be performed in BA TCH mode, as lon g as the process has est ablished an X c[...]

Silent M ode Installa tion 1-18 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS What Is a Response File? A response file contains an swers to insta llation questio ns that oth erwise would be provided by the user in an int eractive installatio n session. E ach answer is stored as a value for a variable that is identifie[...]

Silent Mode Installation Oracl e9i Insta llatio n Planning 1-19 FROM_LOCA TION is the complete path o f the source of the pr oducts to be installed (in ot her words, to the [.Disk1.stage]products.jar file) from CD number 1. If contents of CDs wer e copied to a local file system, then specify that path. ORAC LE_HOME is the d irectory into which the [...]

Silent M ode Installa tion 1-20 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS[...]

Releas e Inf ormation 2-1 2 Release Inf ormation This chapter provides informatio n specific to thi s release of Oracle9 i for HP OpenVMS. The following sections ar e included: ■ Product Set on page 2-2 ■ Changes a nd Enhancements on page 2-2 ■ Known R estrict ions on page 2 -6[...]

Prod uct Set 2-2 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Pr oduct Set The following components are included on the product CD-ROM: Oracle9 i Release 2 (9.2.0.2) Oracle Net Release 2 (9.2.0.2) Changes and Enhancements In order to take full advanta ge of the latest OpenVMS CPU a nd compiler optimi zations in Oracle s[...]

Changes a nd Enh ancements Releas e Inf ormation 2-3 Orac le9 i Rele ase 2 Dependenc y on ODS-5 Dis k Structure In general, O DS-5 format a llows VMS to support Microsoft W ind ows file nam ing formats. Longer file n ames, addi tional ch aracter suppor t, and the ability to h ave lowercas e and mixed-case f ile names ar e some of the features suppo[...]

Change s and Enha ncements 2-4 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Chec king Disk For mat T o check the current disk format, us e the following DCL command: $ SH OW DEVI CE/FU LL < de vice-na me > The Volume Status: will display the current ODS level. The default when initializ ing disks is ODS-2. Changin[...]

Changes a nd Enh ancements Releas e Inf ormation 2-5 Initializat ion P arameters in Oracle9 i Release 2 That Have Been De suppor ted AL W A YS_ANT I_JOIN AL W A YS_SEMI_JOIN JOB_QUEUE_INTER V AL OP T IMIZER_ PERCENT_P ARALLEL HASH_MUL TIBLOCK_IO_COUNT DB_BLOCK_LRU_ LA TCHES DB_B LOCK _MA X_DI R TY_T A RGE T SOR T_MUL TIBLOCK_READ_COUNT DB_FILE_DIR [...]

Know n Restrictions 2-6 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Known Rest ri ctio ns RMAN Runs Onl y Over TCP/IP The connection to bot h the catalog and the database mu st be a TCP/IP connection . OpenVMS OpenVMS alw ays performs it s I/O asynch ronously . S everal init.ora parameters that mimic as ynchronous beha[...]

Known Restrictio ns Releas e Inf ormation 2-7 EJB BE ANS Oracle9 i for HP OpenVMS does not support EJB o n the server . If customers have i AS in mid tier , however , they can still us e the database on Open VMS in order to use EJB.[...]

Know n Restrictions 2-8 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS[...]

CD-R OM Pre-in stallatio n Requirem ents 3-1 3 CD-R OM Pre-installation Requirements This chapter d escribes the pre-install ation ste ps required for an Oracle9 i soft ware installa tion. ■ HP OpenVMS and Insta llation-Spe cific Iss ues and Restrictions ■ Installation Procedur e Requireme nts ■ HP OpenVMS Alpha SYSGEN Parameters ■ HP OpenV[...]

HP OpenVMS and Installatio n-Specific Issue s and Restrictions 3-2 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS HP OpenVMS and In stallatio n-Specific I ssues and Restrict ions The follow ing issues an d restrictions can a ffect the installation or use of Oracle9 i on HP OpenVMS Alpha . Re-installing Oracl e9 i Release [...]

HP OpenVM S and Inst allation-Specif ic Issues and Restrictions CD-R OM Pre-in stallatio n Requirem ents 3-3 Upgrading and Migrati ng If you ar e upgrading an existing system, then some issues may exist that exceed the scope of this man ual. It is possible to m igrate Oracle8 i Release 2 (8.1.6) and O racle8 i Release 3 (8.1.7) and Oracle9 i Releas[...]

Installat ion Procedur e Requiremen ts 3-4 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS ■ Exc eed do es no t ha nd le s cre en c oo rdin ates co rrec tl y . The Oracle Universal Installer win dow and related Oracle Univ ersal Inst aller dialo gs or configura tion assistants can enco unter display problems when run thr[...]

Installat ion Procedur e Requiremen ts CD-R OM Pre-in stallatio n Requirem ents 3-5 Oracle Server Databa se Admini strator Account Create an HP O pen VM S Alp ha use r acc oun t to admi niste r th e O racl e9 i Enterprise Edition insta llation and ma intenance, or m o dify your exist ing Oracle u ser account to meet the account qu otas and privil e[...]

Installat ion Procedur e Requiremen ts 3-6 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Although thi s guide refers to this account as the Oracle9 i account, you can assign any name or number to th e account with the UIC restrictions noted below . The Oracle9 i account will own the runtime libra ries and executable imag[...]

Installat ion Procedur e Requiremen ts CD-R OM Pre-in stallatio n Requirem ents 3-7 $ SET DEF AULT SYS$S YSTEM $ RU N AUTHO RIZE 2. At the UAF pr ompt, enter the ADD command to cr eate the user account fr om which you w ill install th e product software: UAF> ADD Or acle9i /PAS SWORD=O RACLE /UIC= [277,100 ]- /DEV ICE= <de vice> / DIREC TO[...]

Installat ion Procedur e Requiremen ts 3-8 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Setting Ac count P rivil eges The following privileges are required as both authorized and default privileges for the Oracle9 i database a dministrator account: ■ CMKRNL ■ GROUP ■ GRPN AM ■ IMPERSONA TE ■ LOG_IO ■ NETMBX [...]

Installat ion Procedur e Requiremen ts CD-R OM Pre-in stallatio n Requirem ents 3-9 At the UAF pr ompt, use the MODIFY command to add the r equired default and authoriz ed privileges as foll ows: UAF> MODIFY ORAC LE9 - /PRI VILEGE= (CMKR NL,NET MBX,OPE R,PFN MAP,P RMGBL,PR MMBX, SHARE ,SYSGBL, - SYSNAM, TMPMBX, GROUP, GRPNA M,IMPER SONAT E,LOG _[...]

Installat ion Procedur e Requiremen ts 3-10 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Appendix B, "Oracl e9i 64-bit Feat ure" has addi tional i nformation explaining the meanings of the quotas and how to determine their values. Process Rights for Database Administrato rs The Oracle server Database Admin [...]

Installat ion Procedur e Requiremen ts CD-ROM Pr e-i nsta llat ion R equ irem ent s 3-11 Then grant the rights identifier to the Oracle9 i account as follows: UAF> GRANT/ IDENTI FIER ORA_TES T_DBA ORAC LE9i If you add the ORA_TEST_DBA rights identifier , but gra nt only ORA_DBA to ORACLE9i, then th e account woul d have i nsufficient privileges [...]

Installat ion Procedur e Requiremen ts 3-12 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Process Rights for Intellig ent Age nt (OEMA G ENT) T o instal l the Intellig ent Agent , you must add the ORA_AGENT_ID identifier to your syste m before starting th e instal lation . Use the followin g command: UAF > ADD /IDE[...]

HP OpenVMS Alpha SYSGEN P arameters CD-ROM Pr e-i nsta llat ion R equ irem ent s 3-13 HP OpenVMS Alpha SYSGEN P arameters For instructions on calculating M IN_GBLP AGES, MIN_GBLSECTIONS, an d MIN_MAXBO BMEM, r efer to the READMEVMS.DO C in the RDBMS dire ctory . Using the Rese rved Memor y Re gistry Through its interface within th e SYSMAN utility [...]

HP Open VMS Alpha SY SGEN P arameters 3-14 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS ** R eserved memo ry siz e = <size > greate r tha n create d SGA size = <size > ** ** P lease r educe reser ved mem ory s ize t o avoid wasti ng me mory. ** ** M emory w as no t rese rved fo r the SGA. SGA siz e = <[...]

HP OpenVMS Alpha SYSGEN P arameters CD-ROM Pr e-i nsta llat ion R equ irem ent s 3-15 the DBA and system adm inistrator may be the same person . The instructio ns in this section ar e directed to the system adm inistrator . For setti ng or modify ing SYSGEN param eters, OpenVMS provid es the AUT OGEN utility . Y ou can also use SYSGEN, but this is [...]

HP Open VMS Alpha Syst em Conf igurati on 3-16 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS This ste p generates n ew SYSGEN pa rameters in a file named SETP ARAMS.DA T and runs the SYSGEN utility to set these parameter values as specified in that file. HP OpenVMS Alph a System Config uration If your system fai ls to[...]

Setup T asks to P erf orm as the SYSTEM User CD-ROM Pr e-i nsta llat ion R equ irem ent s 3-17 ■ Create an OpenVMS Account to Own Oracle Softwa re ■ Create an OpenVMS Account to Own the Apache Server Create an Op enVMS A ccount to Own Ora cle Software The oracle9 account is the OpenVMS user a ccount that owns the Oracle9 i software after insta [...]

Setup T asks to Perf or m as the Oracle User 3-18 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS privileges t o run the Apache Server on a port < 10 23. Images th at ar e linked with privileges during instal lation in th e 'oracle' account ensure that this can be done. For detail s on how to co nfigure the[...]

Setup T asks for Or acle Produ cts CD-ROM Pr e-i nsta llat ion R equ irem ent s 3-19 Set Di splay Before starting the O racle Univ ersal Inst aller , set your d isplay appropriately . Enter: $ SE T DISPL AY/CR EATE/T RANSPOR T=TCP IP/NO DE=< work stati on_na me or IP_addr ess > and verify that it is correct by using the follow ing comma nd: $[...]

Setup T asks for Or acle Products 3-20 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Jav a Runtime En vironment The Java Runtime Environment (JRE) that is certified for use with Oracle9 i soft ware is used by Oracle Java appli cations such as the Oracle Universal In staller and is the only Java application supported t[...]

Install ation 4-1 4 Installation This chapter desc ribes how to sta rt the Oracle Univ ersal Installer a nd how to ins tall Oracle9 i products on yo ur system . R eview and com plete the task s that are listed in Chapter 1, "Oracle9i Installation Planning" and Chapt er 3, "C D- ROM Pre-installation R equirements" bef ore beginni[...]

Installat ion Mount Opti ons 4-2 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Instal lation Moun t Options Mount and Unmount the Or acle9 i CD-R OM If you run the Oracl e Universal Ins taller while the current working d irectory is in the CD-ROM, then perform th e following steps to mount the next CD- ROM: Mount the Ora[...]

Oracle Univ ersal Installer Install ation 4-3 Orac le Univer sal In staller The following procedur e describes the installation of products with the use of the Oracle Universal Insta ller (OUI). Installing an Or acle9 i Database 1. Log in as the Oracle user . 2. Start the Oracle Un iversal Insta ller from the CD-ROM moun t-point directory at the SY[...]

Oracle Univ ersal I nstaller 4-4 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS 4. The File Lo cations W indow appears. ■ Source: Y ou should not need to change the defau lt. This points to the installatio n files. ■ Destinati on (Name): Enter a name to r efer to your ORA CLE_HOME. ■ Des tin at ion ( Pa th) : Ent er[...]

Oracle Univ ersal Installer Install ation 4-5 10. The Datafiles Location window appears. ■ Enter a path for the location of the data files. ■ Click Next . 11. The Database Chara cter Set window appears. ■ choo se the desi r ed char acter set. ■ Click Next . 12. The Enable Real Applica tion Cluster s (RAC) window appears. ■ Select YES if y[...]

Oracle Univ ersal I nstaller 4-6 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Installing Oracle9 i Client 1. Log in as the Oracle user . 2. Start the Oracle Un iversal Insta ller from the CD-ROM moun t-point directory at the SYSTEM directory level with th e following com mand: $ @< ddcn >:[disk1]runInstaller If th[...]

Oracle Univ ersal Installer Install ation 4-7 6. The A vailable Products window appears. ■ Choose Oracle9 i Client. ■ Click Next to continue. 7. The Instal lation T y pes window appears. ■ Choose a n insta llation type: Cus tom, Ad ministra tor , or Runtime. ■ Click Next. 8. The Summary window appears. ■ This window displays all of the op[...]

Oracle Univ ersal I nstaller 4-8 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Orac le9 i Database Custom Installa tion When you se lect Custom Installati on, the A vailable Product Co mponents win dow app ears . It displays all pr oducts and co mponents that are available fo r installa tion . A typical Custo m installat[...]

Oracle Univ ersal Installer Install ation 4-9 Installing Real Ap plicati on Cluste rs Because the disk on which the Oracle soft war e will be ins talled is mo unted cluster wide, and is therefore accessible from multiple nodes, ins talling Real Appli cation Clusters (RAC) on OpenVMS is no dif fer ent than insta lling non-RA C, except for the scr ee[...]

Oracle Univ ersal I nstaller 4-10 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS 5. Create a copy of the Password file: $ copy orapw sidA .; orapw sidB .; 6. Create a copy of the instan ce s pecif ic param ete r fil e: $ copy init sidA .ora init sidB . ora 7. Create a copy of the properties file: $ copy sid_ sidA .prop[...]

Oracle Univ ersal Installer Installa tion 4-11 List Of P arameter s The following parameters need to be defined befor e starting an instance that will participate in RA C: cluster_database = true undo_tablespace = UNDOTBS1 or UNDOTBS2 service_names = sidA or s idB instance_name = sidA or s idB instance_number = 1 or 2 thread = 1 or 2 cluster_databa[...]

Oracle Univ ersal I nstaller 4-12 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS[...]

P ost-Installatio n 5-1 5 P ost-Install ation After completing the Ora cle Universal Inst alle r session, you must perform certain post -in stall atio n ste ps, an d you must conf igur e Oracle 9 i . This chapter contains the following sections: ■ User Pa sswor ds on page 5-12 ■ Configuratio n T asks to P erform as the System User on page 5- 12[...]

Database Co nfiguration Assist ant (DBCA) 5-2 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS Database Con figuration Assis tant (DBCA) Inte ractive Mo de T o invoke DBCA (Datab ase Configu ration As sistant) in the interactive mo de, perform the followin g: 1. Set up the X-W indows environment by using the follo wing DCL [...]

Datab ase Conf igura tio n Ass ist ant (D BCA ) P ost-Installatio n 5-3 The following sections conta in examples that il lustrate the u se of silent mod e. DBCA Silent Mode Exam ple 1 : Creating a Clone Databas e T o create a clone database, enter the following into SYS$SCRA TCH:DBCA .ARGS: -sil ent -cre ateData base -tem plateNa me Trans actio n_P[...]

Database Co nfiguration Assist ant (DBCA) 5-4 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS -tem plateNa me copy_ of_or a9i -dat afileJa rLoca tion / disk$di sk1/o racle 9i/ora9i /assi stant s/dbca/t empla tes Then, assuming that the ORACLE_ HOME environment is set up by executing the orauser script, invoke DB CA. Log fi[...]

Datab ase Conf igura tio n Ass ist ant (D BCA ) P ost-Installatio n 5-5 The following sample DBCA.RSP file is included here for r eference: #### ####### ##### ###### ####### ##### ##### ######## ##### ##### ######## ##### ##### ### ## ## ## DBCA resp onse fil e ## ## ---- ----- -------- - ## ## C opyrigh t 1 998, 2 001, Or acle Corpo ration. All R [...]

Database Co nfiguration Assist ant (DBCA) 5-6 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS # Na me : RESP ONSEFIL E_VER SION # Da tatype : Stri ng # De scripti on : Vers ion of the d ataba se to cr eate # Va lid val ues : "9.0 .0" # De fault v alue : None # Ma ndatory : Yes #--- ------- ----- ------ ------- --[...]

Datab ase Conf igura tio n Ass ist ant (D BCA ) P ost-Installatio n 5-7 # De fault v alue : <db_ name> s pecif ied i n GDBNAM E # Ma ndatory : No #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- --- SID = "or cl9i" #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----[...]

Database Co nfiguration Assist ant (DBCA) 5-8 Oracle9 i Install ation Guide Release 2 (9.2 .0.2) f or HP Alpha Open VMS #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- --- #NAT IONALCH ARACT ERSET= "UTF8" #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- --- # N[...]

Datab ase Conf igura tio n Ass ist ant (D BCA ) P ost-Installatio n 5-9 # Na me : VARI ABLESFI LE # Da tatype : Stri ng # Desc ription : Locati on of the fil e conta ining varia ble val ue pair # Va lid val ues : A va lid fil e-sys tem f ile. The vari able value pa ir fo rmat # in this fi le # is < variabl e>=<v alue> . Each p air s hou[...]

Database Co nfiguration Assist ant (DBCA) 5-10 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- --- #SYS DBAPASS WORD = "pas sword " #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- ---[...]

Datab ase Conf igura tio n Ass ist ant (D BCA ) Po s t - I n s t a l l a t i o n 5-11 # De fault v alue : none # Ma ndatory : YES #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- --- #SYS DBAPASS WORD = "pas sword " #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ---[...]

User Pass words 5-12 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS User Passwor ds Oracle Corporation recommends that you change the pa ssword for user names immediately after insta llation. T o cha ng e a pa ssword: 1. Start SQL*Plus by using the follo wing comm and: $ sq lplus 2. Connect with the user na me and pass[...]

Configur ation T asks to P erfo rm as the Oracle User Po s t - I n s t a l l a t i o n 5-13 A utomate Databas e Star tup and Shutdown (Opti onal) Y ou can conf igure your system to a utomatica lly start Ora cle databases wh en your system st arts up an d to shut dow n Oracle d atabases w hen your syste m shu ts down . Aut omating da tabase startup [...]

P ost-Installation f or Oracle Products 5-14 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS P ost-Instal lation f or Orac le Pr oducts Perform the product-specific steps as necessa ry for your installat ion . Not all products re quire post-installation setup. It is not necessary to read product documenta tion before co[...]

P ost-Installation f or Oracle Produ cts Po s t - I n s t a l l a t i o n 5-15 If you can successfull y connect to the server with SQL*P lus, then you have established network co nnectivity over TCP/IP . For more advanced networ k configuration, refer to the Oracle 9i Net S ervic es Admin istra tor ’ s Guide . Oracle Op tion s Orac le inter Me di[...]

P ost-Installation f or Oracle Products 5-16 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Oracle Precompile rs The following list provides references and configuration files tha t are associated with Oracle precompilers. Pro*C/C++ For precompiler Pro*C/C++, the configura tion file is pcscfg.cfg. This file installs wi[...]

P ost-Installation f or Oracle Produ cts Po s t - I n s t a l l a t i o n 5-17 PRO TO TYP E INFO For precompiler PROTOTYPE INFO, the con figuration file is xxxcfg.cfg. This file installs w ithout content. Use any text editor to customize it to your sit e require ment s. For more information o n configuring th e pmscfg.cfg file, re fer to the SQL*Mo[...]

Starter Datab ase Conte nts 5-18 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Starter Database Contents The starter database is a seed database tha t is shipped with the O racle9 i software. It contains all that is needed in a "gener al purpose" environment. If the s tarter database files are selected, then[...]

Starter Databa se Conten ts Po s t - I n s t a l l a t i o n 5-19 Unloc king and Resetting P asswor ds Manua lly T o manually chan ge a pass wor d and unlo ck an acco unt, r eview th e list of def ault admin istrative user n ames, pas swords, and function s in T able 5–1, "Default User Names and Passwo rds" . Select a user , and then un[...]

Starter Datab ase Conte nts 5-20 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Ta b l e 5 – 1 describes th e default use r names an d pas swords. T able 5–1 Default Use r Names a nd P ass wor ds User N ame P ass wor d Descriptio n See Also CTXSYS CTXSYS CTXSYS is the Oracle Te x t user name with CONN ECT , DBA, an[...]

Starter Databa se Conten ts Po s t - I n s t a l l a t i o n 5-21 SYS CHANGE_ON _INST ALL SYS is used for performing database adminis trat ion tasks . SYS include s the follow ing databa se rol es: AQ_ADMINISTRA TOR_ROLE AQ_USER_ROLE CONNECT CTXAPP DBA DELETE _CA T ALOG_ROL E EXECUTE_CA T A LOG_ROLE EXP_FULL_DA T ABASE HS_ADMI N_ROL E IMP_FUL L_DA [...]

Starter Datab ase Conte nts 5-22 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Identify ing Datab ases The Oracle9 i softw a re iden ti fies a da tab a se by its globa l d atabase name . A global database na me co nsists of the databa se name and net work domain . Th e global database nam e uniquely dis tinguishes a d[...]

Starter Databa se Conten ts Po s t - I n s t a l l a t i o n 5-23 The DB_NAME parameter an d the DB_DOMAIN name parameter combine to create the global database name value that is assig ned to the SER VICE_NAM ES parameter in the init.ora file . The System Identifier (SID) iden tifies a specific Oracle9 i database insta nce . The SID uniqu ely dist [...]

Starter Datab ase Conte nts 5-24 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS SYSTEM syste m01.d bf The data dictionary . This inclu des definition s of tables, view s, and s tored procedur es needed by the Oracle da tabase. Note: The database main tains in formation in this area automatic ally . The SYSTE M tablespa[...]

Starter Databa se Conten ts Po s t - I n s t a l l a t i o n 5-25 Locatin g th e Initia liza tion Paramet er File The datab ase ini tiali zat ion param ete r fil e ( init.ora ) is g enerated when a da tabase is created. The init.ora file is used to bring up the instance an d to create the database and th e data dictionary . When th e database is co[...]

Starter Datab ase Conte nts 5-26 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS Locatin g Control Files The starter database con tains three control files . Th ese files ar e located in the ora_root:[oradata.< db_name >] dir ectory . The files control01.ctl , control02.ctl , and control03.ctl are automatically in[...]

Adding or Up grading Pr oducts Po s t - I n s t a l l a t i o n 5-27 ■ Names of the Oracle databa se users ■ Privileges and roles granted to each user ■ Names and d efini tions of sch ema obje cts, includin g table s, views, s napshots, indexes, clu sters, synonym s, seque nces, procedures, functions, and packag es ■ Integrity const raints [...]

Addi ng or Up grad ing P rodu ct s 5-28 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS 5. Back up the old code and databa se fi les ( data, r ed o log, and contr ol ). 6. Mount the distributio n media. 7. Run Oracle U niversal Installer. Select custom in stall. After completing th ese preliminary steps, you are ready t[...]

Relin king the O racle Code Po s t - I n s t a l l a t i o n 5-29 Relinki ng the Orac le Code The Oracle code must be relinked und er the following co nditions: ■ Change to operating system, fo r example upgrade ■ Change to Oracle Net con figuration ■ Change to RDBMS configuration Step 1 Shutdown the G iven D atabase(s) First verify that you [...]

Relinking the Oracle Code 5-30 Oracl e9 i Instal lation Gu ide Releas e 2 (9.2.0 .2) f or HP Alpha Ope nVMS[...]

Orac le9i Produc ts A-1 A Orac le9 i Pr oducts This appendix describes the pro ducts that are included with Oracle9 i : ■ Oracle9i Database Component s on pag e A-2 ■ Oracle9i Client Com ponents on page A-8 ■ Product Descriptions on page A-2 Note: The Custom installa tion type is no t listed for any of the three top-level components becaus e [...]

Oracle 9i Database C omponent s A-2 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS Oracle9 i D atabase Comp onents The following sections co ntain alphab etic al lists of the compo nents that are available with each insta llation type of the Orac le9 i server top-level component. Enter prise Edit ion This section alpha [...]

Oracle9i Dat abase Compo nents Orac le9i Produc ts A-3 ■ Thin JDB C Jav a-ba sed E ncry ption Sup port, inc lud ing: * DES40 E ncryption * MD5 In tegrit y * RC4_ 40 Enc ryp tion * RC4_ 56 Enc ryp tion * RC4_ 128 Encr ypti on * RC4_ 256 I ntegri ty * SHA-1 Inte grity ■ Authenticatio n Support, including: * Kerber os (with SSO support) * SSL (wit[...]

Oracle 9i Database C omponent s A-4 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS ■ Oracle Net, which in cludes the followin g: ■ Oracle Net Listener ■ Oracl e Pr otoco l Support ■ Oracle Partitio ning ■ Oracle Real Applicatio n Clusters ■ Oracle Spati al ■ Oracle SQLJ, which includes the fol lowing: ■ [...]

Oracle9i Dat abase Compo nents Orac le9i Produc ts A-5 ■ Oracle9 i JVM, which i ncludes the follo wing: ■ Jav a V irtua l Mach ine ■ Oracle9 i Server (the Oracle9 i database), which includes the fol lowing: ■ Oracle Da tabas e Demos ■ PL/SQ L ■ PL/SQL Gatewa y ■ SQL*Plus SE L ist This se ction alph abetically l ists th e components th[...]

Oracle 9i Database C omponent s A-6 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS ■ Oracle JDBC Drivers, which include the followi ng: ■ Oracle JDBC Thin Driver for JDK 1.1 ■ Oracle JDBC Thin Driver for JDK 1.2 ■ Oracle JD BC/O CI Driver f or JDK 1.1 ■ Oracle JD BC/O CI Driver f or JDK 1.2 ■ Oracle Locale B[...]

Oracle9i Dat abase Compo nents Orac le9i Produc ts A-7 ■ Oracle XML S QL Utility ■ Oracle9 i JVM, which i ncludes the follo wing: ■ Jav a V irtua l Mach ine ■ Oracle9 i Server (the Oracle9 i database), which includes the fol lowing: ■ Oracle Da tabas e Demos ■ PL/SQ L ■ PL/SQL Gatewa y ■ SQL*Plus[...]

Oracle 9i Client Compon ents A-8 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS Oracle9 i C lient Components The following sections provide informa tion on th e Oracle9 i Client components. Runtime Ed ition This se ction alph abetically l ists th e components that ar e available wi th each installatio n type of the Orac[...]

Oracle9i Clien t Componen ts Orac le9i Produc ts A-9 ■ Thin JDB C Jav a-ba sed E ncry ption Sup port, inc lud ing: * DES40 E ncryption * DES56 E ncryption * MD5 In tegrit y * RC4_ 40 Enc ryp tion * RC4_ 56 Enc ryp tion * RC4_ 128 Encr ypti on * RC4_ 256 I ntegri ty * SHA-1 Inte grity ■ Authenticatio n Support, including: * Kerber os (with SSO s[...]

Oracle 9i Client Compon ents A-10 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS ■ Oracle SQLJ, which includes the fol lowing: ■ SQLJ Runti me ■ SQLJ T ransla tor ■ Oracle Universal In staller , which in cludes the follo wing: ■ Oracle Java Runtime Environment version ■ Oracle Utilit ies, which includes th e [...]

Oracle9i Clien t Componen ts Ora cle9i Products A-11 Administrator Edition Oracle9 i Client Admini strator includes th e components in the Ora cle9 i Client Runtime and also the following components, which ar e list ed alphabetically . Refer to the release notes for your plat form for updates on com ponent ava ilability . ■ Advanced Queuing ■ D[...]

Oracle 9i Client Compon ents A-12 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS ■ Thin JDBC Java-ba sed Encryption Support, including: * DES40 E ncryption * DES56 E ncryption * MD5 In tegrit y * RC4_40 En cryption * RC4_56 En cryption * RC4_128 E ncryption * RC4_2 56 Inte grity * SHA-1 Inte grity ■ Authenticatio n S[...]

Oracle9i Clien t Componen ts Ora cle9i Products A-13 ■ Oracle JDBC Drivers, which include the followi ng: ■ Oracle JDBC Thin Driver for JDK 1.1 ■ Oracle JDBC Thin Driver for JDK 1.2 ■ Oracle JDBC/OCI Driver for JD K 1.1 ■ Oracle JDBC/OCI Driver for JD K 1.2 ■ Oracle Net ■ Oracle SQLJ, which includes the fol lowing: ■ SQLJ Runti me ?[...]

Prod uct De scr ip tio ns A-14 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS Pr oduct Des criptio ns The following list provides descriptions and releas e numbers for products that ar e avai lable fo r instal lation . Som e of the described products are a utomatically installed wit h other products . Refer to the relea [...]

Product De scriptions Ora cle9i Products A-15 3. Oracle Management Pac k for Oracle Ap plications r elease 9.0.1 The Oracle Managemen t Pack for Oracle Application s extends Oracle Enterprise Manager to enable administrators to correlate all tiers of their Oracle Applications d eployme nt . This deploym ent extends from Oracle Applications-s pecifi[...]

Prod uct De scr ip tio ns A-16 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS 7. Oracl e I ntegr ati on Serv er rele ase 9.2.0.2.0 Oracle Integrati on Server is a suite of installa ble components tha t Oracle Corporation designed to transform tradit ional businesses into e-businesses . It integrates and facili tates comm[...]

Product De scriptions Ora cle9i Products A-17 10. Oracle Ja va Database Connec tivity (JD BC) Drivers release 9.2.0.2.0 Oracle J DBC Drivers ar e a stan dard s et of Java clas ses, speci fied by JavaS oft, that provide ven dor-independent access to r elational data. For m ore i nf orm at ion , re fer to Oracle9i J DBC Developer ’ s Guid e and Ref[...]

Prod uct De scr ip tio ns A-18 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS 15. Oracle Names release 9.2.0. 2.0 Oracle Names i s a distributed naming service developed for Oracle environments to help simpli fy the setup and administ ration of global, client/server computi ng networ ks . It es tabl ishe s and main tains[...]

Product De scriptions Ora cle9i Products A-19 18. Oracle Partition ing release 9.2.0.2.0 Oracle Partitioni ng provides more control in managing tables and indexes by directing all maintenance operat ions to individu al partitions rather than to tables and in dex names. For m ore i nf orm at ion , re fer to Or acle 9i Con cep ts an d Oracle9i Data W[...]

Prod uct De scr ip tio ns A-20 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS 21. Oracle Real Application Cl usters Guard rel e a se 9 .0 . 1 Oracle Re al Application Clusters Guar d is an optional fe ature that pr ovides enha nced high a vaila bilit y for clust ers . Oracle Rea l Applications Clusters Guard s upport s a[...]

Product De scriptions Ora cle9i Products A-21 24. Oracle SQLJ release 9.2.0 .2.0 Oracle SQLJ provides a s tandard method to embed SQL st atements in Java programs . O racle SQLJ con sists of the fol lowing components: a. Oracle SQLJ Runtime releas e 9.2.0.2.0 (In stalled with SQLJ) Oracle SQLJ Runtime is a thin layer of pure Java code that r uns ab[...]

Prod uct De scr ip tio ns A-22 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS 28. Oracle Utilities r elease 9.2.0.2 .0 Oracle Utilit ies consists of the follow ing products for database admin istrati on: ■ Export Utility ■ Import Utility ■ Migratio n Utility ■ OCOPY ■ ORADIM ■ Password Uti lity Re covery Ma n[...]

Product De scriptions Ora cle9i Products A-23 31. Oracl e9 i Advanced Analytic Services — Data Mining re le a s e 9 . 0 . 1 Oracle9 i Advanced Analytic Services — Da ta Mining, which is embe dded in the Oracle9 i database, enab les you to build integrated bus iness intelligen ce applicatio ns with compl ete programmatic co ntrol of data min ing[...]

Prod uct De scr ip tio ns A-24 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS 35. Pro*COBOL re lease 1.8.76 and re lease 9.0.1 Pro* COBOL takes SQL statements that are embedded i n a COBOL program an d converts them to standard COBOL code . Wh en you precompile this code, the result is a COBOL program that you can compil[...]

Product De scriptions Ora cle9i Products A-25 38. SQL*Plus r elease 9.2.0.2.0 SQL*Plu s is a co mmand li ne interf ace that en ables yo u to use SQ L and PL/SQL database la nguag es with an Ora cle databa se. For m ore i nf orm at ion , re fer to SQL*Plu s User ’ s Guid e and Refe rence. 39. SQL*Plus W orksheet release 9.0.1 (Installed with Oracl[...]

Prod uct De scr ip tio ns A-26 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS[...]

Ora cle9i 64 -bit Featu re B-1 B Orac le9 i 64-bit Feature This appendix intr oduces the 64-bit featur e or V ery Large Memory (VLM ) and mak es setti ng and ot her r ecomm end ation s for thi s featu r e. T opics covered in this appendix a re: ■ Introduction to the Oracle 9i 64-bit Feature ■ Suggested Parameter Settings ■ Other Re commen dat[...]

Introduct ion to the Oracle 9i 64-bit F eature B-2 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS Intr oduct ion to the Orac le9 i 64-bit Featu re This section in cludes the follo wing informa tion: ■ Intr oducin g the Oracle9 i 64-bit F eatur e ■ Benefits of the Oracl e9i 64- bit Featur e ■ Implementation of the [...]

Suggested P arameter Settin gs Ora cle9i 64 -bit Featu re B-3 sec tion s that are not ba cked by any fi le . Th ese global sectio ns are not pageable and do not require a backing file. Suggested P arameter Sett ings 1. Big Oracle Bloc ks (BOB) provide the ability to support larger I/O transfers between memory an d disk . BOB compleme nts large SGA [...]

Other Re commendat ions B-4 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS Check statis tics, such a s V$SYSST A T , to see if the numb er of sorts to disk is high compared to in-memory sorts . If it is, then increase the value of SOR T_AREA_ SIZE. Other R ecommendation s Check the size in number of r o ws of the tables[...]

Oracle T ranspa ren t Gateway C-1 C Orac le T ransparent Gatewa y This chapter describes ho w to install the ga teway software fr om the distribution CD-ROM . Th e following topics are included: ■ System Requirem ents for Oracle T ransparen t Gateway ■ Installin g Oracle T r ansparent Gatew ay ■ Removi ng O racle T ran sparent Ga tewa y[...]

System Requ irements f or Oracle T ransparent Gate wa y C-2 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS System Requirements f or Oracl e T ranspare nt Gate way Review your system har dware and softwar e to ensure th at it meets requirem ents, and then determ ine gateway conf iguration before you install the ga teway [...]

System Re quiremen ts f or Oracle T ransparent Gat ew ay Oracle T ranspa ren t Gateway C-3 RDB Gat eway Requireme nts Ta b l e C – 1 de s c r i b e s th e h a rd w a re a n d so f tw a re re q u i re m e n t s f or a n R D B g a t e wa y . Use it to ensure that your system meets req uirements to cr eate a gateway for RD B. T able C–1 RDB Gatewa[...]

System Requ irements f or Oracle T ransparent Gate wa y C-4 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS RMS Gateway Requiremen ts Ta b l e C – 2 de s c r i b e s th e h a rd w a re a n d so f tw a re re q u i re m e n t s f or a n R M S g a t ew a y . Use it to ensure that your system meets requir ements to cr eate[...]

System Re quiremen ts f or Oracle T ransparent Gat ew ay Oracle T ranspa ren t Gateway C-5 Operating System HP O penVMS 7 .3 Operating System Pat ch Use the lates t patch kit f rom Hewlett -Pa ckard. H ewlett- Pack ard provides patch information at: http://www .compa q.com/support Oracle Net Requiremen ts Oracle Net on HP OpenVM S is devel oped and[...]

System Requ irements f or Oracle T ransparent Gate wa y C-6 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS T ested Gateway Configurations The following gate way configura tions have been tested by O racle Corpor ation at the time of this docum ent release . Or acle Corporation con tinues to provide support for the m ost[...]

System Re quiremen ts f or Oracle T ransparent Gat ew ay Oracle T ranspa ren t Gateway C-7 RDB Gat ewa y W orksheet Enter your system values in the follow ing Ta b l e C – 3 to pr epar e for an RDB gateway configuration. RMS Gate wa y W orksheet Enter your sys tem values in the followi ng Ta b l e C – 4 to prepare fo r an RMS gateway configurat[...]

Installing Oracle T ransparent Gate wa y C-8 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS Installi ng Orac le T ranspar ent Gate wa y Use the following pro cedures and tables to install Oracle T ransparent Gateway . Mounting T ransparent G ateway fr om the CD-ROM Install the ga teway softwa re fr om the CD- ROM as fol[...]

Removing Oracle T ransparent Gatew ay Oracle T ranspa ren t Gateway C-9 Install ation Prompts f or RDB Ga teway Use the following pattern (Scr een: Response) as a guide during your gateway installa tion: Location o f RDB database: Enter the complete path for RDB da tabase. Follow the in structions in the Re sponse column for each entry in the Scree[...]

Removi ng Orac le T ransp are nt Ga teway C-10 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS[...]

Apache Serv er Install ation/Configur ation D-1 D Apache Server Installation/ Configuration This appendix lis ts the procedure and step s to install and configure Apach e Server for HP OpenVMS Alpha. The following topics ar e included: ■ Post-Ins tallation Checklist on page D-2 ■ Te s t t h e I n s t a l l a t i o n on page D -3 ■ Running the[...]

P ost-Installation Ch ecklist D-2 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS P ost-Instal lation Che c klist After you configure the Oracle HTTP Server , perform the f ollowing tasks to ensure a su cces sful sta rtup: ■ Run AUT OGEN ■ Check Disk Q uota ■ Check for SET TERMINAL/INQUIRE Each of these tasks is ex[...]

T es t th e In st alla ti on Apache Serv er Install ation/Configur ation D-3 Failure to do so might result in ill-formed HTML intermittently bein g returned to clients . This problem migh t also appear w hen executing CGI scripts. T est the Instal lation Now you will m anually s tart th e Oracle H TTP Server to verify the installation and configura[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-4 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS HTTP /1.1 200 OK Date : Tue, 23 May 2000 17:05: 05 GMT Serv er: Apa che/1 .3.12 (OpenVM S) Last -Modifi ed: M on, 22 May 20 00 15 :33:2 7 GMT ETag : "33dfec- 681-3 92953 47" Acce pt-Rang es: b ytes Cont ent-Len gth:[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serv er Install ation/Configur ation D-5 P erf ormance Consi derations Y ou should have prior experience tuning the performance of the OpenVMS operating system . For general information on OpenVMS performance, see the OpenVM S Perfor manc e Man agement Manu al at th e follow ing URL : http ://www. [...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-6 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS T o change the quotas for the O racle Account SYSUAF , use the system manager account and run the AUTHORIZE uti lity . For example: $ SET DEF AULT SYS$S YSTEM $ RU N AUTHO RIZE UAF> SHOW O RACLE DIOLM (NonPooled) Number of[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serv er Install ation/Configur ation D-7 User name: O RACLE Owner : APACH E WEB SERVE R ... Maxj obs: 0 Fillm : 100 Bytlm : 64000 Maxa cctjobs : 0 S hrfill m: 0 Pb ytlm: 0 Prcl m: 8 DIOlm: 150 WSdef: 20 00 ... UAF> MODIFY ORAC LE/FIL LM=300/ PRCLM =20 %UAF -I-MDFY MSG, user r ecord(s ) upd ated [...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-8 Ora cle9 i Ins tallation Guide Re lease 2 (9.2.0 .2) f or HP Alpha Ope nVMS Customiz ing the S erver En vironment The installatio n procedur e creates a file named HTTPD.CONF and places it i n APACHE$ROOT:[CONF] . The HTTPD.CONF file stores information that the Orac le HTTP Server uses to set up the [...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serv er Install ation/Configur ation D-9 http://w ww . apach e.org/do cs HTTP_CORE.C AccessConfig AccessFileName AllowOv erride Auth Name AuthT ype BindAddr ess CoreDumpDirectory DefaultT ype <Directory> <DirectoryMatch> Documen tRoot Erro rDocument Err orLog <Files> <FilesMa t[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-10 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS LimitRequest Fields LimitRequestLine Listen ListenBa cklog <Locati on> <Locati onMa tch > LogLevel MaxClien ts MaxKeepAliveReques ts MaxRequestPerCh ild MaxSpar eServers MinSpar eServers NameV irtualHost Options P[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-11 ServerSignat ure ServerT okens ServerT ype StartServers Ti m e O u t UseCanoni calName User Vi r t u a l H o s t MOD_ACCESS.C allow deny order MOD_ACTIONS. C Action Script MOD_ALI AS.C Alias AliasMat ch Redi rect Redire ctM atch Redi rect T em p Redire ctPe[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-12 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS MOD_AUT OINDEX.C AddAlt AddAltB yEncoding AddAltyB yT ype AddDescrip tion AddIcon AddIconByE ncoding AddIconByT ype DefaultIcon Fancy Indexin g HeaderName IndexIgnore IndexOptions IndexOrderDefault Read meNam e MOD_CGI .C Scr[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-13 MOD_I NCLUDE.C MOD_I NFO.C AddModuleIn fo MOD_LOG _CONFIG.C CustomLog LogFormat Tr a n s f e r L o g MOD_MI ME.C AddChar set AddEncodi ng AddHandler AddLanguage AddT ype DefaultL anguag e ForceT y pe Remove Han dler SetHandl er Ty p e s C o n f i g MOD_NEGO[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-14 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS MOD_ST A TUS.C ExtendedStatus MOD_UN IQUE_ID. C MOD_USER DIR.C UserDir Suppor ted an d Unsupp or ted Feature s The server documentation fr o m the Apache Softwar e Foundation at the following web site: http://w ww . apach e.o[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-15 MOD_MI ME_MAGIC MOD_MMAP _ST A TIC MOD_P EARL MOD_P ROXY MOD_REWRITE MOD_SPELING MOD_SSL MOD_USER TRACK MOD_VHOST_A LIAS Unsupported Directive s The following directives ar e n ot supported: AgentLog AllowCONNE CT Anony mous Anonymou s_Au thorita tive Anony[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-16 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS CacheDirLength CachedirLevels CacheForceCompletion CacheGcInterval CacheLastModifiedFactor CacheMaxExpire CacheRoot CacheSize CheckSpelling CookieExpires CookieT racking Example Expir esActive Expi r esB yT ype Expir esDefaul[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-17 ProxyRequests ProxyV ia Refe rerIg nore Refe rerLog Rewrite Base Rewrite Cond RewriteEng ine Rewr iteLock Rewr iteLog Rewr iteLog Level Rewr iteMap RewriteOp tions Rewrite Rule Sc rip tIn t erpre te rSo urce V irtua lDocumen tRoot V irtua lDocumen tRootIP V[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-18 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS -"V": Displays the HTTP D base version, its bu ild date, and a list o f compile settings that influence the behavior and performance of the server . -h: Display s a list of th e HTTPD optio ns. -l: Displays a li st [...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-19 http://w ww .apach e.org/docs /han dler .htm l Content Negotiation The MOD_NEGOTIA TI ON module provides content negotiation . This module lets you specify lang uage varian ts of HTML files . T o specify langu age varia nts on OpenVMS, use an underscor e in[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-20 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS File N aming Co n ventions In general, users wh o are running the Oracle HTTP Server for OpenVMS can specify either UNIX-style file names or OpenVMS-style file names . The Oracle HTTP Server usually displays UNIX-sty le file [...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-21 $ SET SEC URITY/A CL=(ID ENTIF IER=you rFTPn ame,A CCESS=RE AD+WR ITE) [di rectory ] When replacing existing files : $ SET SEC URITY/A CL=(ID ENTIF IER=you rFTPn ame,A CCESS=RE AD+WR ITE) [di rectory ]*.* Logic al Names The Oracle HTTP Server for OpenVMS cr[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-22 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS AP ACHE$SPECIFIC Concealed logical name t hat defines s ystem-specific files in AP ACHE$ ROOT (device:[AP AC HE.SPECIFIC.node-name]) AP ACHE$CG I_MODE System logical na me that contr ols how CGI env iro nment logicals ar e de[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-23 OpenVM S Clus ter Conside ration s An OpenVMS Cluster is a group of OpenVMS syst ems that work together as one virtual system . The O racle HTTP Server runs in an OpenVMS Cluster so you can take adv antag e of t he r esou r ce sha rin g tha t inc r eases th[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-24 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS T o avoid con fusion, al ways use the approp riate concea led logical name to specify the file that you want to edit . For example, to edit a clusterwide version of HTTPD.CONF, refer t o: $ ED IT APAC HE$CO MMON:[ CONF]HT TPD[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-25 CGI En vironment Logical By default, an environment lo gical symbol ta kes the form that is designated by th e name of the environment logical . Y o u can determine how en vironment logicals are set when the server executes a CG I program. Y ou can d efine [...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-26 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS Refere ncing Input CGI scripts that reference input to the Oracle HTTP Server m ust refer to APACHE$INPUT. Executing CGI On OpenVMS, CGI images execute within a DCL pr ocess . Y ou cannot execute CGI images directly . Logical[...]

Security Inf ormation Apache Serve r Installation /Configu ration D-27 $ SA Y "Cont ent-t ype: i mage/gi f" $ SA Y "" $ AP ACHE$DC L_BIN APACH E$ROOT: [ICON S]APA CHE_PB.G IF $ EX IT Running the Oracle HTTP Server on OpenVMS 3 ñ19 Securit y Inf ormati on The Oracle HTTP Server for OpenVMS is a non-privileged, user-m ode, socket[...]

Sec urit y Inf ormation D-28 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS ■ Changing the "carriage-contr ol" attribute on socket (BG) devices. The server also enabl es or disa bles (or both) th e ca rriage-control attribute on BG (sock et) devices for certain strea m operations. T wo protected, shar eable i[...]

Apache Apache Serve r Installation /Configu ration D-29 logical names are placed in the system logical na me table . Shutdown is accomplish ed by sendin g a KILL signa l t o the maste r pr oc ess a nd it s sub pr oce ss. These actions r equire en hanced privileges (DET ACH, SYSNAM, WORLD, and so forth) and are usually performed from a suita bly pri[...]

Apache D-30 Oracle9 i Insta llation Gui de Releas e 2 (9.2.0.2 ) fo r HP Alpha OpenVMS http ://www. openv ms.com paq.com /open vms/p roducts/ ips/a pache /apache_ licen se.tx t This product also includes software that is developed by Hewlett-Packard.[...]

Index- 1 Index Numerics 64-bit feature, B-1 A account creating t he oracle account, 3-1 7 account pr ivileges setting , 3-8 account quotas minimum values, 3-9 ADA, versio n, 1-12 Adminis trato r disk space requirements, 1-10 response fil e, 1-19 adminis trato rs ,5 - 1 2 authenti cation me thods Kerbero s, 1-1 5 Secure So cket Lay er, 1-15 AUTHO RI[...]

Index- 2 databas e creation methods selectin g, 1-5 data d ictionary defined , 5-26 data files, 5-23 databa se p assw ord s, 5- 19 database user n ames, 5-19 initial ization pa ramet er file, 5-25 redo log fi les, 5-25 rollbac k segments , 5-26 tablespa ces, 5- 23 table spaces and, 5- 23 database environments and Oracle Data base Configurat ion Ass[...]

Index- 3 response fil es, 4-11 setting permissions for creation, 3-18 supported file systems , 3-3 G general purpose dat abase. See data base environme nts, 1-4 GENPARAMS par ameter, 3-15 glob al da tabas e name defined , 5-22 grou ps OSDBA and OS OPER, 5-12 H hardw are memory, 1-8 requirements, 1 -8 home dir ectory, 3-17 I identifier s, process ri[...]

Index- 4 M MAXSYSGROUP, 3-6 MDSYS user name databa se r oles , 5-20 passw ord, 5- 20 migra ting existin g Oracle databa ses, 1-7 migrati on Oracle Data Migration Assistant, 3-3 modifyin g system pa rameters, 3-13 MRU, B-4 multiple d ata bases, 3 -12 multiple Orac le homes system iden tifier, 5-23 N Net8 Config uration Assistant, 5-14 non-inte racti[...]

Index- 5 defined , A-18 linking opti ons, 1-16 Oracle Protocol Support install ation ty pes availab le with, A-4, A-6 pre-insta llation tas ks shutting down list eners, 3-20 Oracle Net Server defined , A-18 Oracle Options requirements, 1 -14 Oracle Para llel Server re-ins talling, 4-11 Oracle Part itioning defined , A-19 Oracle PL/SQL Gateway defin[...]

Index- 6 ent erpr ise ed iti on de fin ed, A-23 requirements, 1 -14 Oracle9 i Server defined , A-23 Oracle9 i, installa tion types available with, A-2 oraIns t.loc file , 3-2 oraInventor y directory, 4-8 ORDPLUGIN user n ame databa se r oles , 5-20 ORDPLUGINS, user n ame and password, 5-20 ORDSYS databa se r oles , 5-20 user name and password, 5-20[...]

Index- 7 relinkin g Oracle code, 5-29 Oracle products, 5-29 requirements CD-ROM, 1-9 file permi ssions, 3-16 file syst ems, 3-3 hardw are , 1- 8 inter Media, 1-14 Java Runt ime E nviro nmen t, 1-14 , 3- 2, 3-20 Kerberos authen ticati on, 1-15 memory, 1-8 operatin g system, 1-11 orac le accou nt, 3-17 Orac le Adva nced Se curi ty, 1-15 Oracle Option[...]

Index- 8 SQL*Plus describ ed, A-25 SQL*Plus Works heet describ ed, A-25 SQLJ describ ed, A-21 SQLJ Ru ntim e describ ed, A-21 standard. rsp files, 1-19 starti ng in stan ces, 3- 12 startup an d shutdown, 5-13 svrcustom.rsp file, 1-19 SYS account, 3- 6 SYS user name database roles of, 5-21 describ ed, 5-21 password of, 5-21 SYSGEN pa ramete rs, 3-13[...]

Index- 9 user names CTXSYS, 5-20 DBSNMP, 5-20 MDSYS, 5-20 ORDPLUGINS, 5-20 ORDSYS, 5-20 OUTLN, 5-20 SCOTT, 5-21 SYS, 5-21 SYSTEM, 5-21 USERS ta blespace, des cribed, 5-24 USERS01. DBF data file, 5-24 tablespace contai ned in, 5-24 V Very Larg e Mem ory , B-1 VLM, reserving memory, 3-13 VMS mailb ox driver, 1-12 W window ma nager requirements, 1 -11[...]

Index- 10[...]