Oracle ORACLE9I B10508-01 manual

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

Oracle9 i Ins talla tion Gu ide, R elease 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 Aut hor: Plat form T echn ologie s Div ision Contribut ors: John Dewitt, Grant Hayden , Steve Holc k, Pierre Krabbendam, K evin O’Rourke, Sam Ravindhr an, David R obles, Regi na[...]

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

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

v Installat ion Procedur e Requirements ................ ................. ........... ................. ................. ............... 3-4 Oracle Server Databas e Administrator Account..................... ........... ................. ................. .... 3-5 Oracle 9 i Account is NOT the SYS or S YSTEM Account ........ ........... .........[...]

vi Oracle Univer sal Install er ......... ........... ................. ................. ................. ........... ................. .............. 4-3 Instal ling an Ora cle9 i Database ................ ............ ................. ................. ........... ................. ........ 4-3 Instal ling Oracle9 i Client ................ ...[...]

vii Relinkin g the Oracle Code ....... ................ ............ ................. ................. ........... ................. ............. 5- 29 Step 1 Shutdown the Given Databa se(s) .......... ............ ................. ................. ................ ........ 5-29 Step 2 Remove Images ............ ................. .............[...]

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

ix Send Us Y our Comments Orac le9 i Installation Guide, Re lease 2 (9.2.0.2) for hp OpenV MS Alpha P art No. B1050 8-01 Oracle Corporati on welcomes yo ur comments and su ggesti ons on the quality and usefulness of this pub lica tion. Y our in put is an i mpor tant part o f th e info rmat ion u sed for r evis ion. ■ Di d you fi nd an y er ror s?[...]

x[...]

xi Preface Purpo se This guide and th e Oracle9i Ad ministrator ’ s Refere nce Release 2 (9 .2.0.2) for hp Open VMS Alpha provide instructions f or install ing and conf iguring Or acle9 i Releas e 2 (9.2.0.2) o n hp OpenVMS Alpha sy stems . Docum entatio n for th e products that are included with this so ftware is in the Oracle9 i generic docum e[...]

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 ar e entitled to install and use only those pr oducts for which you have a current Oracle license agr eement. T ypographi c Con vention s Command Synt ax HP OpenVMS A lpha comman d syntax appears in 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 databa se system is provided in the f ollowing documents: ■ Oracle9i Adminis trator ’ s Reference Rele ase 2 (9.2.0.2) for hp Open VMS Alpha ■ Oracle9 i Data base Ad ministra tor ’ s Gu ide ■ Oracle9 i Net Serv ices Adm inistrat or ’ s[...]

xv Orac le Services and Supp or t The Oracle corporat e web page i s located at the follo wing web site: http ://ww w.oracl e.com Oracle Corporati on offers a wide range of services to help faci litate corporate system so lutions, including Oracle Edu cation courses, Oracle Co nsultin g services, and Oracle Su pport Services from the website . In a[...]

xvi Pr oduct docume ntatio n can be foun d at th e fol lowing web si te: http ://do cs.orac le.com Customer Service Global Customer Service contacts ar e listed at the fo llowing web site: http ://ww w.oracl e.com/ suppo rt/ Education and T r aining T raining informat ion and worl dwide schedu les are available from the followin g web site: http :/[...]

Or acle9i I nstallati on 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 Requireme nts ■ Product Dependencies ■ Configuration Restrictions ■ Oracle Net Link ing Options[...]

Oracle 9i Installation Overview 1-2 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Oracle9 i Inst allat ion Over v iew The installatio n of Oracle9 i pr oduct s ha s fi ve sta ges: 1. Plannin g your installa tion: Use this chapter to help you pla n and pr epare for your ins tallat ion . This chapter provides information a [...]

Oracle9i In stallation Ov er view Or acle9i I nstallati on 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 O racle instan ce . It may be installed in one of thr ee instal lation types: Enterprise Ed ition, Standar d Edition, or Cu[...]

Oracl e9i Da tab ase Co nfig urati ons 1-4 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Oracle9 i Database Confi guratio ns When you ins tall the O racle9 i database pr oduct, you are pro mpted to select a database configura tion that is suited to your needs . Se lect fr om one of five Ora cle9 i database configuratio ns[...]

Oracle9i Da tabase Conf iguratio ns Or acle9i I nstallati on Plannin g 1-5 Cust omi zed This environment allows you to cr eate a customiz ed database configuration of Oracle pr oducts that meets specialized requir ements. Select this option only if you are pr epared to pr ovide detailed pr oduct and database environment choices . Choosing this opti[...]

Oracl e9i Da tab ase Co nfig urati ons 1-6 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS The follow ing list provides descri ptions of data base config urations: ■ General Purpose configuration : If you select this option with an Enterprise Edition o r Standar d Edition instal lati on, then the Databa se Configuratio n [...]

Installati on With Existing Oracle D atabases Or acle9i I nstallati on Plannin g 1-7 ■ Software Only option: If you select th is option, then the Oracle Universal Instal ler (OUI) installs only Orac le9 i softw are . Database Co nfigurati on Ass istan t doe s not star t aft er in stall atio n, and no p re conf igur ed d ata base i s installed. If[...]

System Installation R equirement s 1-8 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Syste m Instal lation Requirement s V erify that your system meets the requir ements that are des cribed in the following sections b efore you instal l Oracle9 i pro duc ts. ■ T ime Requirements ■ Har dware Requir ements ■ Disk Spac[...]

System Inst allation Requiremen ts Or acle9i I nstallati on Plannin g 1-9 Minimum global pages/sections an amou nt of dis k space equal to twice the amoun t of RAM for most sy stems. CD-ROM Devi ce A CD-ROM drive supported by HP OpenVMS is r equired . Orac le uses ODS-5 format CD-R OM disks. File Syst em ODS-5 is required for the softwar e. Refer t[...]

System Installation 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 r equirements fo r Oracle9 i Client. Images T wo shared imag es that are linked with client code are built and installed when you link Oracle9 i Enterprise Edition . The new s hare d images r edu[...]

System Inst allation Requiremen ts Or acle9i In stallatio n Planning 1-11 Operating System Software Requ irements Ta b l e 1 – 3 lists the operatin g system softw are r equirements for Oracle9 i pr oducts. T o determine your curr ent operating system information, enter the following command: $ SH OW SY STEM /N OPROCE SS /F ULL T o see informat io[...]

System Installation 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 conf iguring X-W indow s. Orac le Net VMS Mailbo x Driver The Oracle Net [...]

Product De pendencies Or acle9i In stallatio n Planning 1-13 Pr oduct Dep endencies Some Oracle pro ducts depend on other Oracle products to work pr operly . Use the following tables to determine the pr oduct dependencies . T his section ha s the fol lowin g sub sect ion s: ■ Important Compa tibility Issues ■ Additiona l Pr od uct-Specific Inst[...]

Produ ct Depend encies 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 Restrictions and Requirements for Oracl e9 i and Options. Pro duct Name: Restr ictio ns and Req uirements Oracle inter Media 9.2.0.2.0: Y ou must have at le ast 10 MB o f disk space available for the inter Media T ext data dictionary[...]

Configu ration Re strictions Or acle9i In stallatio n Planning 1-15 Orac le Advanced Secur ity 9.2.0.2.0: Refe r to "Oracle Advanced Security" on page 1- 15 for inform ation about Orac le Advanced Security authentica tion support re q u ir em e n t s . Orac le TCP/IP with SSL Pr otocol Supp ort 9.2.0.2.0: SSL 3.0 o r later Orac le Adv anc[...]

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 difficulty of ensuring valid re f e re nc i n g . Oracle Corporation ther efore r ecomm[...]

Silent Mode Installatio n Or acle9i In stallatio n Planning 1-17 using the –responseFile ar gument in stead of interactive GUI in put and output. If th e -responseFile flag is given, then th e installation is assumed to be a silent mode type. A silent ins tallation can also be performed in BA TCH mode, as lon g as the process has est ablished an [...]

Silent Mode 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 answers to insta llation questio ns that oth erwise would be provided by the user in an int eractive installa tion session. Each answer is stored as a value for a variable tha t is identified [...]

Silent Mode Installatio n Or acle9i In stallatio n Planning 1-19 FROM_LOCA TION is the complete path o f the source of the pr oducts to be installed (i n other 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 Mode 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 r elease of Ora cle9 i for HP OpenVMS. The following sections ar e included: ■ Product Set on pa ge 2-2 ■ Changes a nd Enhancements on page 2-2 ■ Know n Restric tions on page 2 -6[...]

Prod uct Set 2-2 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Pr oduct Set The following components ar e included on the product CD-ROM: Oracle9 i Release 2 (9.2.0.2) Oracle Net Release 2 (9.2.0.2) Changes a nd Enhancement s In order to take full advanta ge of the latest OpenVMS CPU and compiler optimi zations in Oracle [...]

Chang es and Enh ancements Releas e Inf ormation 2-3 Orac le9 i Rele ase 2 Dependenc y on ODS-5 Dis k Structure In general , ODS-5 form at allows VMS to suppo rt Microsoft W ind ows file nam ing formats. Longer file n ames, addit ional charact er suppor t, and the ability to have lower case and mixed-case f ile names ar e some of the features suppo[...]

Change s and Enha ncements 2-4 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Chec king Dis k Format T o check the current disk format, use the following DCL command: $ SH OW DE VICE/FU LL < de vice- name > The Volume Status: will display the current ODS level. The de fault when initializ ing disks is ODS-2. Changing[...]

Chang es and Enh ancements Releas e Inf ormation 2-5 Initializat ion P arameters in Oracle9 i Release 2 Th at Have Been Desup por ted AL W A YS_ANTI_JOIN AL W A YS_SEMI_JOIN JOB_QUEUE_INTER V AL OP T IMIZER_ PERCENT_P ARALLE L HASH_MUL TIBLOCK_IO_CO UNT DB_BLOCK_LRU_ LA TCHES DB_B LOCK _MA X_DI R TY_T A RGE T SOR T_MUL TIBLOCK_REA D_COUNT DB_FILE_ [...]

Know n Restrictions 2-6 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Known Re stri 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 . Several init.ora parameters that mimi c asynchronous behavi[...]

Known Re strictions Releas e Inf ormation 2-7 EJB BE ANS Oracle 9 i for HP OpenVMS does not support EJ B on the server . If customers have i AS in mid tier , however , they can still us e the database on OpenVM S in order to use EJB.[...]

Know n Restrictions 2-8 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS[...]

CD-R OM Pre-in stallatio n Requi rements 3-1 3 CD-R OM Pre-installation Requirements This chapte r describes the pre-install ation ste ps required for an Oracle9 i sof tware installa tion. ■ HP OpenVMS an d Installation -Spe cific Issues and Restrictions ■ Installation Procedur e Requir ements ■ HP OpenVMS Alpha SYSGEN Parameters ■ HP OpenV[...]

HP OpenVMS and Insta llation-Specific Issue s and Restriction s 3-2 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS HP OpenVMS and In stallatio n-Specific I ssues and Restrict ions The follow ing issu es and restrictions can a ffect the installation or use of Oracle9 i on HP OpenVMS Alpha . Re-installing Oracl e9 i Release [...]

HP Ope nVMS and Inst allation-Sp ecific Issues a nd Restrictions CD-R OM Pre-in stallatio n Requi rements 3-3 Upgrading and Migra ting If you ar e upgrading an existing system, then some issues may exist that exceed the scop e of this man ual. It is possible to m igrate Oracle8 i Release 2 (8.1.6) and Oracl e8 i Release 3 (8.1.7) an d Oracle 9 i Re[...]

Installat ion Procedur e Requiremen ts 3-4 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS ■ Ex ceed do es no t ha nd le s cre en c oo rdin ate s co rrec tl y . The Orac le Universal Installer win dow and related Oracle Univ ersal Inst aller dia logs or conf iguration assistants can enco unter display problems when run th[...]

Installat ion Procedur e Requiremen ts CD-R OM Pre-in stallatio n Requi rements 3-5 Oracle Server Database Admini strator Accoun t Create an HP Open VM S Alp ha u ser ac cou nt t o adm inist er t he O racl e9 i Enterprise Edition insta llation and maintenance, or m o dify your existing Oracle u ser account to meet the accoun t quotas and privil ege[...]

Installat ion Procedur e Requiremen ts 3-6 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS 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 r estricti ons noted below . The Oracle9 i account will own the runtime libra ries and executable ima[...]

Installat ion Procedur e Requiremen ts CD-R OM Pre-in stallatio n Requi rements 3-7 $ SET DEF AULT SYS $SYSTEM $ RU N AUT HORIZE 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 softw are: UAF> ADD Oracle9i /PAS SWORD =ORACLE /UIC= [277, 100]- /DEV ICE= < device> / DIREC TO[...]

Installat ion Procedur e Requiremen ts 3-8 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Setting Ac coun t Privil eges The follow ing privileges are required as both authorized and default privileges f or the Oracle9 i database a dministrator accou nt: ■ CMKRNL ■ GROUP ■ GRPN AM ■ IMPERSONA TE ■ LOG_IO ■ NETMB[...]

Installat ion Procedur e Requiremen ts CD-R OM Pre-in stallatio n Requi rements 3-9 At the UAF pr ompt, use the MODIFY command to add the r equired def ault and author ized privileges as f ollows: UAF> MODI FY ORAC LE9 - /PRI VILEG E=(CMKR NL,NET MBX,O PER,PFN MAP,P RMGBL ,PRMMBX, SHARE ,SYSG BL, - SYSNAM, TMPMB X,GROUP, GRPNA M,IMP ERSONAT E,LO[...]

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 additional information explaining the meanings of the quotas and how to determine their values. Process Rights for Database Administrato rs The Oracle server Database Administ[...]

Installat ion Procedur e Requiremen ts CD-ROM P re-i nsta llat io n Requ irem ent s 3-11 Then grant the rights identifier to the Oracle9 i account as follows: UAF> GRAN T/IDENTI FIER ORA_T EST_DBA ORAC LE9i If you add the ORA_TEST_DBA rights identifier , but grant only ORA_DBA to ORACLE9i, then th e acco unt 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_A GENT_ID identifier to your syst em before starting th e ins tallat ion . Use the followin g command: UAF > ADD /I[...]

HP OpenVMS Alpha SYSGEN P arameters CD-ROM P re-i nsta llat io n Requ irem ent s 3-13 HP OpenVMS Alpha SYSGEN P arameters For instructions on calculating M IN_GBLP AGES, MIN_GBLS ECTIONS, and MIN_MAXBO BMEM, r efer to the READMEVMS.DO C in the RDBMS dir ectory . Using the Rese rved Memory Registry Through its interface with in the SYSMAN ut ility ,[...]

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 eserv ed memo ry siz e = <size > greate r tha n cre ated SGA size = <s ize> ** ** P lease reduce reser ved m emory s ize t o avo id wasti ng me mory. ** ** M emory was no t rese rved for the SGA. SGA size = < s[...]

HP OpenVMS Alpha SYSGEN P arameters CD-ROM P re-i nsta llat io n Requ irem ent s 3-15 the DBA and system administrator may be the same person . The instru ctions in this section ar e directed to the system adm inistrator . For sett ing or modify ing SYSGEN param eters, OpenVMS provid es the AUT OGEN utility . Y ou can also use S YSGEN, but this is [...]

HP Open VMS Alph a System 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 s tep generates new SYSGEN pa rameters in a file named S ETP 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 or m as the SYSTEM User CD-ROM P re-i nsta llat io n Requ irem ent s 3-17 ■ Create a n Open VMS Account to Own Ora cle Software ■ Cr eate an Open VMS Account to Own the Apache Server Create an Op enVMS Account to Ow n Ora c le Softw are The oracle9 account is the OpenVMS user a ccount that owns the Oracle9 i software after[...]

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 f or Oracle Produ cts CD-ROM P re-i nsta llat io n Requ irem ent s 3-19 Set Di splay Before starting th e Oracle Uni versal Inst aller , set your d isplay appropriately . Enter: $ SE T DIS PLAY/CR EATE/T RANSP ORT=TCP IP/NO DE=< w orkstati on_na me or IP_addr ess > and verify tha t it is correct by using the follow ing comma nd: [...]

Setup T asks f or Oracle Prod ucts 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 vironm ent The Java Runtime Envi r onment ( JRE) that is certified for use with O racle9 i software is used by Oracle Java applications such as the Oracle Universa l Installer and is the only Java application support[...]

Insta llation 4-1 4 Installation This chapter d escribes how to sta rt the Oracle Univ ersal Installer a nd how to ins tall Oracle 9 i products on yo ur system . Review and complete th e tasks th at are listed in Chapter 1, "Oracle9i Installation Planning" and Chap ter 3, "C D- ROM Pre-installatio n Requirements" bef ore beginni[...]

Installat ion Mount Options 4-2 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Instal lation Moun t Options Mount and Unmount the Or acle9 i CD-ROM If you run the Or acle Universal Ins taller while the current workin g directory is in the CD-ROM, then perfor m the following steps to mount the next CD -ROM: Mount the Oracle[...]

Oracle Univ ersal Installer Insta llation 4-3 Orac le Univer sal In staller The following procedur e describes the installation of products with the use of the Oracle Universal In staller (OUI). Installing an Oracle9 i Database 1. Log in as the Ora cle user . 2. Start the Orac le Universal Insta ller from the CD-ROM moun t-point d ir ector y at the[...]

Oracle Universal I nstaller 4-4 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS 4. The File Lo cations W indow appears. ■ Source: Y ou should not need to change the default. This points to the installa tion files. ■ Destinati on (Name): Enter a name to r efer to your ORA CLE_HOME. ■ Des tin at io n (Pa th) : Ent er th[...]

Oracle Univ ersal Installer Insta llation 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 t he desi r ed char acter set. ■ Click Next . 12. The Enable Real A pplication Cluster s (RAC) window appears. ■ Select YES if [...]

Oracle Universal I nstaller 4-6 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Installing Oracle9 i Client 1. Log in as the Oracle user . 2. Start the Orac le Universal Insta ller from the CD-ROM moun t-point d ir ector y at the SYSTEM directory level wi th the followin g command: $ @< ddcn >:[disk1]runInstaller If t[...]

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

Oracle Universal I nstaller 4-8 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Orac le9 i Databa se Custom Installa tion When you se lect Custom Installati on, the A vailable Pro duct Components win dow app ears . It displays a ll products an d co mponents that are a vailable for installa tion . A typical Custom in stallat[...]

Oracle Univ ersal Installer Insta llation 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 R eal Application Clusters (RAC) on OpenVMS is no dif fer ent than insta lling non -RAC, except for the scr ee[...]

Oracle Universal 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. Cr eate a copy of the Password file: $ copy orapw sidA .; orapw sidB .; 6. Cr eate a copy of the instan ce s pec ific param ete r fil e: $ copy init sidA .ora init sidB . ora 7. Cr eate a copy of the properties file : $ copy sid_ sidA .p[...]

Oracle Univ ersal Installer Instal lation 4-11 List Of P arameter s The following parameters need to be defined before 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_databas[...]

Oracle Universal 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-Install ation 5-1 5 P ost-Insta llation After completing th e Oracle Universal Inst a ller session , you must perform certain post -in stall atio n st eps, and you must conf igu re Orac le9 i . This chapter contains the following sections: ■ User Pa sswor ds on page 5-12 ■ Configuratio n T asks to Perform a s the System User on page 5- 12[...]

Database Configuration Assist ant (DBCA) 5-2 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS Datab ase Configuration 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 th e following DCL co[...]

Data base Conf igur atio n Ass ist ant (D BC A) P ost-Install ation 5-3 The following sections co ntain examples tha t illustrate th e use of silent mo de. DBCA Silent Mode Example 1 : Creating a Clone Data base T o crea te a clon e database, enter the following into SYS$SCRA TCH:DBCA .ARGS: -sil ent -cre ateDa tabase -tem plate Name Trans actio n_[...]

Database Configuration Assist ant (DBCA) 5-4 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS -tem plate Name copy_ of_or a9i -dat afile JarLoca tion / disk$ disk1/o racle 9i/or a9i/assi stant s/dbc a/templa tes Then, assuming that the O RACLE_HOME environment is set up by executing the orauser script, invo ke DBCA. Log file[...]

Data base Conf igur atio n Ass ist ant (D BC A) P ost-Install ation 5-5 The following sample DBCA.R SP file is included here for r eference: #### ##### ####### ###### ##### ####### ##### ##### ######## ##### ##### ######## ##### ### ## ## ## DBCA resp onse file ## ## ---- ----- ----- ---- ## ## C opyri ght 1 998, 2 001, Oracle Corpo ratio n. All R [...]

Database Configuration Assist ant (DBCA) 5-6 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS # Na me : RESP ONSEF ILE_VER SION # Da tatyp e : Stri ng # De scrip tion : Vers ion o f the d ataba se to create # Va lid v alues : "9.0 .0" # De fault value : None # Ma ndato ry : Yes #--- ----- ------- ------ ----- -----[...]

Data base Conf igur atio n Ass ist ant (D BC A) P ost-Install ation 5-7 # De fault value : <db_ name> specif ied i n GDB NAME # Ma ndato ry : No #--- ----- ------- ------ ----- ------- ----- ----- -------- ----- ----- -------- ----- --- SID = "or cl9i" #--- ----- ------- ------ ----- ------- ----- ----- -------- ----- ----- --------[...]

Database Configuration Assist ant (DBCA) 5-8 Oracle 9 i Insta llation Guide Release 2 (9.2.0.2) f or HP Alpha OpenVMS #--- ----- ------- ------ ----- ------- ----- ----- -------- ----- ----- -------- ----- --- #NAT IONAL CHARACT ERSET= "UTF 8" #--- ----- ------- ------ ----- ------- ----- ----- -------- ----- ----- -------- ----- --- # Na[...]

Data base Conf igur atio n Ass ist ant (D BC A) P ost-Install ation 5-9 # Na me : VARI ABLES FILE # Da tatyp e : Stri ng # Desc ripti on : Locati on of the fil e containi ng varia ble val ue pair # Va lid v alues : A va lid f ile-sys tem f ile. The vari able value pair fo rmat # in this file # is < varia ble>=<v alue> . Eac h pair s hou[...]

Database Configuration 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 DBAPA SSWORD = "pas sword " #--- ----- ------- ------ ----- ------- ----- ----- -------- ----- ----- -------- ----- --- [...]

Data base Conf igur atio n Ass ist ant (D BC A) Po s t - I n s t a l l a t i o n 5-11 # De fault value : none # Ma ndato ry : YES #--- ----- ------- ------ ----- ------- ----- ----- -------- ----- ----- -------- ----- --- #SYS DBAPA SSWORD = "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 reco mmends that you change the password for user names immediately after insta llation. T o cha nge a pa ssword: 1. Start SQL*Plus by using th e following com mand: $ sq lplus 2. Connect with the user na me and passw[...]

Configur ation T asks to P erf orm 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 Shutdo wn (Optional) Y ou can conf igure your system to a utomatically start Ora cle databases wh en your system st arts up an d to shut d own Oracle d atabases w hen your sy stem shu ts down . A utomating da tabase startup i[...]

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-Inst allati on f or Orac le Pr oducts Perform the product-specific steps as necessa ry for your instal lation . Not all products re quire post-installation setup. It is not necessar y to read pr oduct docume ntation be for[...]

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 ha ve established netw ork connectivity over TCP/IP . For m ore advanced networ k configuration, refer to the Oracle 9i Ne t Servic es Admi nistra tor ’ s G uide . Ora cle Option s Orac le inter Me[...]

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 refer ences and con figuration files that are associated with Oracle precompilers. Pro*C/C++ For precompiler Pro*C/C++, the configura tion file is pcscfg.cfg. This file installs w[...]

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 conten t. Use any text edit or to customiz e it to your site require ment s. For more information o n configuri ng the pmscfg.cfg file, re fer to the SQL*[...]

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 that is shipped with the O racle9 i softwa r e. It contains all that is needed in a "gen er al purpose" environment. If th e starter database files are selected, th[...]

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 assw ords Man ually T o manual ly chan ge a pa sswor d and unl ock an account, r eview t he list o f default admin istrative us er names, pas swords, a nd funct ions in T able 5–1, "Defaul t User Names and Passwo rds" . Select a user , and then [...]

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 name s and pas swords. T able 5–1 Default U ser 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 , a[...]

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 admi nistrat 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 ALOG_ROLE EXP_FULL_DA T ABASE HS_ADM IN_RO LE 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 D atabases The Oracle9 i softw a re ide nti fies a d atab a se by its globa l d atabase name . A global database name co nsists of the data base name and net work domain . Th e global database nam e uniquely dis tinguishes a da[...]

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 param eter and the DB_DOMAIN name parameter combine to create the global database name value that is assig ned to the SER VICE_NA MES parameter in the init.ora file . The System Identifier (SID) iden tifies a specific Oracle9 i database in stance . 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 s ystem01.d bf The data dictionar y . This inc ludes definition s of tables, v iews, and s tored procedur es needed by the Oracle da tabase. Note: The dat abase main tains inform ation in this area automa tically . The SY STEM tables[...]

Starter Databa se Conten ts Po s t - I n s t a l l a t i o n 5-25 Locat ing th e Initia liz ation P aram eter Fi le Th e data base 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 databa se i[...]

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 File s 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 i[...]

Adding or Upgrad ing Products 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 defini tions of sch ema obje cts, includ ing tab les, views, s napshots, indexes, clu sters, synon yms, seq uences, procedures, functions, and packag es ■ Integrity co nstraints ?[...]

Add ing or Upgrad 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, red o log, and cont rol ). 6. Mount the distributio n media. 7. Run Oracle U niversal Installer. Select custo m install. After completing th ese preliminary steps, you are ready to [...]

Reli nki ng 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 un der the following co nditions: ■ Change to operating system , for example upgrade ■ Change to Oracle Net con figuration ■ Change to RDBMS configuration Step 1 Shutdown th e Given Database(s) First verify that you [...]

Relinking the Or acle 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 pr oducts that are in cluded with Oracle9 i : ■ Oracle9i Database Compon ents on pa ge A- 2 ■ Oracle9i Client Com ponents on page A-8 ■ Product Descriptio ns on page A-2 Note: The Cu stom installa tion type is no t listed for any of the three top-level components becau[...]

Oracle 9i Databa se Component s A-2 Ora cle9 i Ins tallation Guide Re lease 2 (9 .2.0.2) f or HP Alpha Ope nVMS Oracle9 i Database Components The follow ing sections co ntain alpha betic al lists of the com ponents that are available with each insta llation type of the Ora cle9 i server top-level component . Enter prise Edit ion This section a lpha[...]

Oracle9i Dat abase Compo nents Orac le9i Produc ts A-3 ■ Thin JDB C Ja va-ba sed Encry pti on Sup port , inc lud ing: * DES40 E ncryp tion * MD5 In tegrit y * RC4_ 40 E ncryp tion * RC4_ 56 E ncryp tion * RC4_ 128 Enc rypti on * RC4_ 256 Integr ity * SHA-1 In tegrity ■ Authenticatio n Support, including: * Kerber os (with SSO support) * SSL (wi[...]

Oracle 9i Databa se Component 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 Suppor t ■ Oracle Partitio ning ■ Oracle Real Applica tion Clusters ■ Oracle Spati al ■ Oracle SQLJ, which includes the fol lowing: ■[...]

Oracle9i Dat abase Compo nents Orac le9i Produc ts A-5 ■ Oracle 9 i JVM, wh ich includes the follo wing: ■ Jav a V irtu al Mac hine ■ Oracle 9 i Server (the Oracle9 i d ataba se), which includ es the following : ■ Oracle Databas e Demos ■ PL/SQ L ■ PL/SQ L Gatewa y ■ SQL*Plus SE L ist This s ection alph abetically lists th e component[...]

Oracle 9i Databa se Component 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, w hich include the followi ng: ■ Oracle JDBC Thin Driver f or JDK 1.1 ■ Oracle JDBC Thin Driver f or JDK 1.2 ■ Oracle JDBC/O CI Driver for JDK 1.1 ■ Oracle JDBC/O CI Driver for JDK 1.2 ■ Oracle Locale Bu[...]

Oracle9i Dat abase Compo nents Orac le9i Produc ts A-7 ■ Oracle XML S QL Utilit y ■ Oracle 9 i JVM, wh ich includes the follo wing: ■ Jav a V irtu al Mac hine ■ Oracle 9 i Server (the Oracle9 i d ataba se), which includ es the following : ■ Oracle Databas e Demos ■ PL/SQ L ■ PL/SQ L Gatewa y ■ SQL*Plus[...]

Oracle 9i Client Com ponents A-8 Ora cle9 i Ins tallation Guide Re lease 2 (9 .2.0.2) f or HP Alpha Ope nVMS Oracle9 i Client Components The follow ing sections provide info rmation o n the Oracle9 i Client components. Runtime Ed ition This s ection alph abetically lists th e component s that ar e available with each installatio n type of the Oracl[...]

Oracle9i Clien t Componen ts Orac le9i Produc ts A-9 ■ Thin JDB C Ja va-ba sed Encry pti on Sup port , inc lud ing: * DES40 E ncryp tion * DES56 E ncryp tion * MD5 In tegrit y * RC4_ 40 E ncryp tion * RC4_ 56 E ncryp tion * RC4_ 128 Enc rypti on * RC4_ 256 Integr ity * SHA-1 In tegrity ■ Authenticatio n Support, including: * Kerber os (with SSO[...]

Oracle 9i Client Com ponents A-10 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS ■ Oracle SQLJ, which includes the fol lowing: ■ SQLJ Runti me ■ SQLJ T rans lator ■ Oracle Universal In staller , which in cludes the follo wing: ■ Oracle Java Runtime Environment version ■ Oracle Utilit ies, which includ es th[...]

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

Oracle 9i Client Com ponents A-12 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS ■ Thin JDBC Java-ba sed Encryption Support, including: * DES40 E ncryp tion * DES56 E ncryp tion * MD5 In tegrit y * RC4_4 0 Encryption * RC4_5 6 Encryption * RC4_1 28 Encryptio n * RC4_2 56 Int egrity * SHA-1 In tegrity ■ Authenticati[...]

Oracle9i Clien t Componen ts Ora cle9i Produc ts A-13 ■ Oracle JDBC Drivers, w hich 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 Ne t ■ Oracle SQLJ, which includes the fol lowing: ■ SQLJ Runti m[...]

Prod uct Desc ri ptio ns A-14 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS Pr oduct Des criptio ns The following list provid es descriptions and rele ase numbers for pro ducts that are avai lable fo r instal latio n . Some of the described pr oducts are automatically installed wit h other products . Refer to the r el[...]

Product De scriptions Ora cle9i Produc ts A-15 3. Oracle Management Pac k for Oracl e Applications r elease 9 .0.1 The Oracle Managemen t Pack for Oracle Application s extends Oracle Enterprise Manager to enable adm inistrators to correlate all tiers of their Oracle Applicatio ns deploym ent . This deploym ent extends from Oracle Applications- spec[...]

Prod uct Desc ri ptio ns A-16 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS 7. Oracl e I nte grati on Ser ver r elease 9.2.0.2.0 Oracle Integrati on Server is a suite of installa ble component s that Oracle Corporation design ed to transform tradit ional busine sses into e-busines ses . It integrat es and facili tates[...]

Product De scriptions Ora cle9i Produc ts 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 cl asses, speci fied by J avaSoft, that pro vide vendor-independent access to r elational data. Fo r m ore i nf orm at ion , re fer t o Oracle9 i JDBC Developer ’ s Guide and R[...]

Prod uct Desc ri ptio ns A-18 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS 15. Oracl e Names r elease 9.2.0.2.0 Oracle Names is a distributed naming ser vice developed for Oracle environments to help simpli fy the setup and administ ration of global, client/server comp uting netwo rks . It es tabl ish es an d main ta[...]

Product De scriptions Ora cle9i Produc ts A-19 18. Oracle Partiti oning release 9.2.0.2.0 Oracle Partitio ning provides more control in managing tables an d indexes by directing all maintenan ce operations to i ndividual partitions rather than to tables and i ndex names. Fo r m ore i nf orm at ion , re fer t o Or acl e9i Co ncep ts and Oracle9i Dat[...]

Prod uct Desc ri ptio ns A-20 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS 21. Oracle Real Application Cl usters Guard rel e a s e 9 .0 . 1 Oracle R eal Applicati on Clusters Guar d is an optional f eature that pr ovides enha nced high a vaila bili ty fo r clus ters . Oracle Rea l Applications Clusters Guard support [...]

Product De scriptions Ora cle9i Produc ts A-21 24. Oracle SQLJ r elease 9.2.0.2.0 Oracle SQLJ provides a s tandard method to embed SQL s tatements in Java programs . O racle SQLJ con sists of the f ollowing compon ents: a. Oracle SQLJ Runtime r elease 9.2.0.2.0 (Installed with SQLJ) Oracle SQLJ Runtime is a thin layer of pur e Java code that r uns [...]

Prod uct Desc ri ptio ns A-22 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS 28. Oracle Utilitie s r elease 9.2.0.2.0 Oracle Utilit ies consists of the follow ing products for database admin istrati on: ■ Export Utility ■ Import Utilit y ■ Migratio n Utility ■ OCOPY ■ ORADIM ■ Password Uti lity R ecovery Ma[...]

Product De scriptions Ora cle9i Produc ts A-23 31. Or acle9 i Advanced Analy tic Services — Data Mining re le a se 9 . 0 . 1 Oracle 9 i Advance d Analytic Services — Da ta Mining, which is embe dded in the Oracle 9 i database, enab les you to bui ld integrated bus iness intelligen ce applicatio ns with co mplete programma tic control of data mi[...]

Prod uct Desc ri ptio ns A-24 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS 35. Pro*COBOL r elease 1.8.76 and r elease 9.0.1 Pro *COBOL takes SQL statements that are em bedded in a COBOL program an d converts them to standard COBOL code . Wh en you precompile this code, the result is a COBOL program tha t you can comp[...]

Product De scriptions Ora cle9i Produc ts A-25 38. SQL*Plus r elease 9.2.0.2 .0 SQL*Pl us 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 a n Oracle databa se. Fo r m ore i nf orm at ion , re fer t o SQL*P lus User ’ s Guide an d Reference. 39. SQL*Plus W orksheet r elease 9.0.1 (In stalled with [...]

Prod uct Desc ri ptio ns A-26 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS[...]

Ora cle9i 64 -bi t Featu re B-1 B Orac le9 i 64-bit Feature This appendix intr oduces the 64-bit featur e or V ery Large Mem ory (VLM) and mak es sett ing and ot her r ecomm enda tion s for thi s featu re . T opics covered in this appendix are: ■ Introduction to the Oracl e9i 64-bit Feature ■ Suggested Parameter Settings ■ Other Re commen dat[...]

Intro duction to the Or acle9i 64-bit Feat ure 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 Fea ture This section in cludes the follo wing informa tion: ■ Intr oducin g the Oracl e9i 64-bit Featur e ■ Benefit s of the Oracl e9i 64- bit Featur e ■ Implementation of the [...]

Suggested P arameter Settin gs Ora cle9i 64 -bi t Featu re B-3 sec tion s that ar e not ba cked by any fi le . Th ese global sections are not pageable an d do not require a backin g file. Sug gested P arameter Sett ings 1. Big Oracle Blo cks (BOB) provide the ability to support larger I/O transf ers between memory an d disk . B OB complem ents larg[...]

Othe r Recommendat 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 t he number 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 rows of the tables i[...]

Oracle T ranspa ren t Gateway C-1 C Orac le T ransparent Gatewa y This chapter describes ho w to instal l the gateway software fr om the distribution CD-ROM . The following topics ar e included: ■ System Requirem ents for Oracle T ranspar ent Gateway ■ Instal ling Oracle T r ansparent Gatew ay ■ Remov ing O racle T ran sparent Ga tewa y[...]

System Requirements 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 Syste m Requirements f or Oracl e T ransp arent Gate wa y Review your system har dware and softwar e to ensure th at it meets requir ements, and then determine gateway configurat ion before you install the ga teway [...]

System Requiremen ts f or Oracle T ransparent Gatew a y Oracle T ranspa ren t Gateway C-3 RDB Ga teway Requirem ents Ta b l e C – 1 d es c r i b e s th e h a rd w a re a n d s o f t wa re re q u i re m e n t s f or a n R D B g a te w a y . Use it to ensur e that your system meets req uirements to cr eate a gateway for RD B. T able C–1 RDB Gatew[...]

System Requirements 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 d es c r i b e s th e h a rd w a re a n d s o f t wa re re q u i re m e n t s f or a n R M S ga te w a y . Use it to ensure that your system meets req uirements to cr eate [...]

System Requiremen ts f or Oracle T ransparent Gatew a y Oracle T ranspa ren t Gateway C-5 Operating System HP O penVMS 7 .3 Operating System Patch Use the late st patch kit from Hewlett -Pa ckard. H ewle tt-Pack ard provides patch information at: http://www .compa q.com/support Oracle Net Requiremen ts Oracle Ne t on HP Open VMS is devel oped and c[...]

System Requirements 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 Gatewa y Config urations The follow ing gat eway configura tions have been tested by Oracle Corpor ation at the time of this docum ent release . O racle Corporatio n continues to pr ovide support for the m o[...]

System Requiremen ts f or Oracle T ransparent Gatew a y Oracle T ranspa ren t Gateway C-7 RDB Gat ewa y W orksheet Enter your system va lues in the follow ing Ta b l e C – 3 to prepar e for an RDB gateway configuration. RMS Gate wa y W orksheet Enter your sys tem values in the foll owing Ta b l e C – 4 to prepare fo r an RMS gateway configurati[...]

Installing Oracle T ransparent Gat ewa y C-8 Ora cle9 i Ins tallation Guide Re lease 2 (9 .2.0.2) f or HP Alpha Ope nVMS Instal ling Or acl e T rans parent Gate way Use the following pr ocedures and tables to install Oracle T ransparent Gateway . Mounting T ransparen t Gatewa y from the CD-ROM Instal l the gateway sof tware fr om th e CD-ROM as fol[...]

Removing Oracle T ransparent Gatew a y Oracle T ranspa ren t Gateway C-9 Install ation Prompts f or RDB Ga tewa y 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 RD B database. Follow the in structions in the R esponse column for each entry in the Scr[...]

Removi ng Or acle T rans pare nt Ga teway C-10 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS[...]

Apache Serv er Install ation/Config uration D-1 D Apache Server Installation/ Configuration This appendix lis ts the procedure and step s to install and conf igure Apache Server for HP OpenVMS Alpha. The follo wing topics ar e included: ■ Post-Ins talla tion 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 t[...]

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-Inst allati on Chec klist After you configure the Oracle HTTP Server , perform the f ollowing tasks to ensure a su cces sfu l sta rtup: ■ Run AUT OGEN ■ Check Disk Q uota ■ Check for SET TERMINAL/INQUIRE Each of these tasks is e[...]

T est th e In st alla tion Apache Serv er Install ation/Config uration D-3 Failure to do so might result in ill-formed HTM L intermittently bein g returned to clients . This problem migh t also appear w hen executing CGI scripts. T est the Instal lation Now y ou will m anually start th e Oracle H TTP Server to verify the installation and configurat[...]

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 20 0 OK Date : Tue, 23 Ma y 2000 17:05: 05 GMT Serv er: A pache/1 .3.12 (Open VMS) Last -Modi fied: M on, 22 May 2000 15 :33:2 7 GMT ETag : "33df ec-681-3 92953 47" Acce pt-Ra nges: b ytes Cont ent-L ength[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serv er Install ation/Config uration D-5 P erf ormance Consi derations Y ou should have prior experience tuning the performance of the OpenVMS operating sys tem . For general informat ion on OpenVMS performance, see the OpenVM S Perf orma nce Man agement Manu al at th e follow ing U RL: http ://ww [...]

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 f or the Oracle Account SYSUAF , use the sys tem manager account and run the AUTHOR IZE utility . For example: $ SET DEF AULT SY S$SYSTEM $ RU N AUT HORIZE UAF> SHOW ORACLE DIOLM (NonPooled) Number of[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serv er Install ation/Config uration D-7 User name: ORACLE Owner : APA CHE WEB SERVE R ... Maxj obs: 0 Fil lm: 100 Bytlm : 64000 Maxa cctjo bs: 0 S hrfill m: 0 Pbytlm: 0 Prcl m: 8 DIOlm : 150 WSdef: 20 00 ... UAF> MODI FY ORAC LE/FIL LM=30 0/PRCLM =20 %UAF -I-MD FYMSG, 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 Ser ver En vironment The installatio n procedur e creates a file named HTTPD.CONF and places it in APACHE$ROOT:[CONF] . The HTTPD.CONF f ile stores info rmation that th e Oracle HTTP Server uses to set up the[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serv er Install ation/Config uration D-9 http:/ /www . apach e.org/docs HTTP_CORE.C AccessConfig AccessFileName AllowOv erride Auth Name AuthT ype BindAddr ess CoreDumpDirectory DefaultT ype <Directory> <DirectoryMatch> Documen tRoot Err orDocument Err orLog <Files> <FilesMa tc[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-10 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS LimitRequest Fields LimitRequestLine Listen ListenBa cklog <Loc ation > <Loc ation Match > LogLevel MaxClien ts MaxKeepAliveReques ts MaxRequestPerCh ild MaxSpar eServe rs MinSpar eServers NameV irtualHost Optio[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-11 ServerSig natur e ServerT ok ens ServerT ype StartServers Ti m e O u t UseCano nicalName 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 AliasM atch Redi rect Redire ctM atch Redi rect T em p Redire ct[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-12 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS MOD_AUT OINDEX.C AddAlt AddAltB yEncoding AddAlt yByT ype AddDescri ption AddIcon AddIconByE ncoding AddIconByT ype DefaultIco n Fancy Indexin g HeaderName IndexIgnore IndexOptions IndexOrderDefault Read meN ame MOD_CGI .C [...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-13 MOD_I NCLUDE. C MOD_ INFO.C AddModul eInfo 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 angu age ForceT y pe Remov eHan dler SetHandl er Ty p e s C o n f i g MOD_NEG[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-14 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS MOD_ST A TUS.C ExtendedStatus MOD_ UNIQUE_I D.C MOD_USER DIR.C UserDir Suppo rted an d Unsupp or te d Features The server documentation fr o m the Apache Softwar e Foundation at the following web site: http:/ /www . apach e[...]

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_ PEARL MOD_ PROXY MOD_REWRITE MOD_SPELING MOD_SSL MOD_USER TRACK MOD_VHOST_A LIAS Unsupported Directive s The following directives are not supported: Agent Log AllowCO NNECT Anony mous Anonym ous_Au thorita tive Anonym[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-16 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS CacheDirLength CachedirLevels CacheForceCompletion CacheGcInterval CacheLastModifiedFactor CacheMaxExpire CacheRoot CacheSize CheckSpelling CookieExpires CookieT r acking Example Expir esActive Exp ir esB yT ype Expir esDef[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-17 ProxyRequests ProxyV ia Refe rerIg nore Refe rerLo g Rewr iteBas e Rewr iteCond RewriteEng ine Rewr iteLock Rewr iteLog Rewr iteLog Level Rewr iteMap RewriteOp tions Rewr iteRule Sc rip tI nt erp rete rSo urce V irt ualDocumen tRoot V irtua lDocumen tRootIP[...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-18 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS -"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: Displ ays a list of th e HTTPD options. -l: Display s a list[...]

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-19 http:/ /www . apach e.org/do cs/han dler .htm l Content Negotiation The MOD_NEGOTIA TI ON module provides content negotiation . Thi s mod ule le ts you specify lang uage varian ts of HTML files . T o specify langu age variants on OpenVMS, use an undersco re[...]

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

Running the Oracle HTTP Serv er on OpenV MS Apache Serve r Installation /Configu ration D-21 $ SET SEC URITY /ACL=(ID ENTIF IER=y ourFTPn ame,A CCESS= READ+WR ITE) [di recto ry] When replacing existing f iles: $ SET SEC URITY /ACL=(ID ENTIF IER=y ourFTPn ame,A CCESS= READ+WR ITE) [di recto ry]*.* 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 G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS AP ACHE$SPECI FIC Concealed logical name that defines s ystem-specific files in AP ACHE$ROOT (device:[AP ACHE.SPECIFIC.node-name]) AP ACHE$C GI_MOD E System logical name th at contr ols how CGI env ir onment logicals are d [...]

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

Runnin g the Oracle HTTP Serv er on OpenV MS D-24 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS 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, refe r t o: $ ED IT AP ACHE$CO MMON:[ CONF] HT[...]

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 symbo l takes the form that is designated by the name of the environment logical . Y ou can determine how environment logicals are set when the server executes a CG I program. Y ou can d efine th [...]

Runnin g the Oracle HTTP Serv er on OpenV MS D-26 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS Ref erencing Input CGI scripts that reference input to the Oracle HTTP Se rver must refer to APACHE$INPUT. Executing C GI On OpenVMS, CGI images execute within a DCL pr ocess . Y ou cannot execute CGI imag es directly . Log[...]

Security Inf ormation Apache Serve r Installation /Configu ration D-27 $ SA Y "Co ntent-t ype: i mage/ gif" $ SA Y "" $ AP ACHE$ DCL_BIN APACH E$ROO T:[ICON S]APA CHE_P B.GIF $ EX IT Running the Oracle HTTP Server on OpenVMS 3ñ19 Secur ity Inf ormati on The Oracle HTTP Server for OpenVMS is a non-privileged, user -mode, socket-[...]

Se curit y In fo rmatio n D-28 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS ■ Changing the "carriage-cont rol" attribute on socket (BG) devices. The server also en ables or disa bles (or both) th e ca rriage-cont r ol attribute on BG (socket) devices for certain strea m operations. T wo protected, s harea[...]

Apache Apache Serve r Installation /Configu ration D-29 logical names ar e placed in the system lo gical name table . Shutdown i s accomplish ed by send ing a KILL sign al 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 f rom a suitably p[...]

Apach e D-30 Oracle9 i Insta llation G uide Releas e 2 (9.2.0.2 ) fo r HP Alp ha OpenV MS http ://ww w.openv ms.com paq.c om/open vms/p roduc ts/ips/a pache /apac he_licen se.tx t This product also includes software that is developed by Hewlett-Packard.[...]

Index- 1 Inde x Numerics 64-bit feature, B-1 A account creating t he oracle account, 3-1 7 accoun t privileges sett ing, 3-8 account quotas minimum values, 3-9 ADA, versi on, 1-12 Adminis trat or disk space requirement s, 1-10 response fil e, 1-19 admin istra tors ,5 - 1 2 authenti catio n methods Kerbe ros, 1-1 5 Secure So cket Lay er, 1-15 AUTHO [...]

Index- 2 databas e creation methods selectin g, 1-5 data d ictionar y defined , 5-26 data fi les, 5-23 data base p ass word s, 5- 19 database us er names, 5-19 initial izati on paramet er file, 5-25 redo l og files, 5-25 rollb ack segments , 5-26 tablespa ces, 5 -23 table space s and, 5- 23 databas e environments and Oracle Data base Configurat ion[...]

Index- 3 response fil es, 4-11 setting permission s for creation, 3-18 supporte d file systems , 3-3 G general pu rpose database. See data base environ ments, 1-4 GENPARAMS par ameter, 3-15 glob al d ata base name defined , 5-22 grou ps OSDBA and OSOPER, 5-12 H hard war e memory, 1-8 requirements, 1 -8 home dir ectory, 3 -17 I identifier s, process[...]

Index- 4 M MAXSYSGROUP, 3-6 MDSYS user name data base r oles , 5-20 passw ord, 5- 20 migra ting exist ing Oracle databa ses, 1-7 migrat ion Oracle Data Migration Assistant, 3-3 modifyin g system pa rameters, 3-13 MRU, B-4 multiple data bases, 3 -12 multiple Orac le homes system identifier, 5-23 N Net8 Co nfiguration Assistant, 5-14 non-in teractiv [...]

Index- 5 defined , A-18 linki ng options, 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-1 1 Oracle Part itioning defined , A-19 Oracle PL/SQL Gateway defi[...]

Index- 6 ent erpr ise ed iti on de fin ed, A-23 requirements, 1 -14 Oracle9 i Server defined , A-23 Oracle9 i, insta llation types availa ble with, A-2 oraIns t.loc file , 3-2 oraInven tory directory, 4-8 ORDPLUGIN user n ame data base r oles , 5-20 ORDPLUGINS, user name and password, 5-20 ORDSYS data base r oles , 5-20 user name and password, 5-20[...]

Index- 7 relinkin g Oracle co de, 5-29 Oracle products, 5-29 requirements CD-ROM, 1-9 file permi ssions, 3-16 file sy stems, 3-3 hard war e, 1- 8 inter Media, 1-14 Java Runt ime E nviro nmen t, 1-14 , 3 -2, 3-20 Kerbero s authen ticati on, 1- 15 memory, 1-8 operatin g system, 1-11 orac le accou nt, 3-17 Orac le Ad vanced Securi ty, 1-15 Oracle Opti[...]

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 start up and shutdown, 5-13 svrcustom.rsp file, 1-19 SYS accoun t, 3-6 SYS user name databas e roles of, 5-21 describ ed, 5-21 password of, 5-21 SYSGEN pa ramete rs, 3-1[...]

Index- 9 user names CTXSYS, 5-20 DBSNMP, 5-20 MDSYS, 5-2 0 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 con tained in, 5-24 V Very Larg e Mem ory , B-1 VLM, reserving memory, 3-13 VMS mailb ox driver, 1-12 W wind ow manager requirements, 1 -1[...]

Index- 10[...]