Oracle Audio Technologies B10508-01 manual

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186

Go to page of

A good user manual

The rules should oblige the seller to give the purchaser an operating instrucion of Oracle Audio Technologies B10508-01, along with an item. The lack of an instruction or false information given to customer shall constitute grounds to apply for a complaint because of nonconformity of goods with the contract. In accordance with the law, a customer can receive an instruction in non-paper form; lately graphic and electronic forms of the manuals, as well as instructional videos have been majorly used. A necessary precondition for this is the unmistakable, legible character of an instruction.

What is an instruction?

The term originates from the Latin word „instructio”, which means organizing. Therefore, in an instruction of Oracle Audio Technologies B10508-01 one could find a process description. An instruction's purpose is to teach, to ease the start-up and an item's use or performance of certain activities. An instruction is a compilation of information about an item/a service, it is a clue.

Unfortunately, only a few customers devote their time to read an instruction of Oracle Audio Technologies B10508-01. A good user manual introduces us to a number of additional functionalities of the purchased item, and also helps us to avoid the formation of most of the defects.

What should a perfect user manual contain?

First and foremost, an user manual of Oracle Audio Technologies B10508-01 should contain:
- informations concerning technical data of Oracle Audio Technologies B10508-01
- name of the manufacturer and a year of construction of the Oracle Audio Technologies B10508-01 item
- rules of operation, control and maintenance of the Oracle Audio Technologies B10508-01 item
- safety signs and mark certificates which confirm compatibility with appropriate standards

Why don't we read the manuals?

Usually it results from the lack of time and certainty about functionalities of purchased items. Unfortunately, networking and start-up of Oracle Audio Technologies B10508-01 alone are not enough. An instruction contains a number of clues concerning respective functionalities, safety rules, maintenance methods (what means should be used), eventual defects of Oracle Audio Technologies B10508-01, and methods of problem resolution. Eventually, when one still can't find the answer to his problems, he will be directed to the Oracle Audio Technologies service. Lately animated manuals and instructional videos are quite popular among customers. These kinds of user manuals are effective; they assure that a customer will familiarize himself with the whole material, and won't skip complicated, technical information of Oracle Audio Technologies B10508-01.

Why one should read the manuals?

It is mostly in the manuals where we will find the details concerning construction and possibility of the Oracle Audio Technologies B10508-01 item, and its use of respective accessory, as well as information concerning all the functions and facilities.

After a successful purchase of an item one should find a moment and get to know with every part of an instruction. Currently the manuals are carefully prearranged and translated, so they could be fully understood by its users. The manuals will serve as an informational aid.

Table of contents for the manual

  • Page 1

    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[...]

  • Page 2

    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 [...]

  • Page 3

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

  • Page 4

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

  • Page 5

    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 .............. ........... ....[...]

  • Page 6

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

  • Page 7

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

  • Page 8

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

  • Page 9

    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? [...]

  • Page 10

    x[...]

  • Page 11

    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[...]

  • Page 12

    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 [...]

  • Page 13

    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[...]

  • Page 14

    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 [...]

  • Page 15

    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[...]

  • Page 16

    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[...]

  • Page 17

    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[...]

  • Page 18

    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[...]

  • Page 19

    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 [...]

  • Page 20

    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[...]

  • Page 21

    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[...]

  • Page 22

    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[...]

  • Page 23

    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[...]

  • Page 24

    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[...]

  • Page 25

    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[...]

  • Page 26

    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[...]

  • Page 27

    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[...]

  • Page 28

    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[...]

  • Page 29

    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 [...]

  • Page 30

    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[...]

  • Page 31

    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 [...]

  • Page 32

    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[...]

  • Page 33

    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[...]

  • Page 34

    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[...]

  • Page 35

    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 [...]

  • Page 36

    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[...]

  • Page 37

    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[...]

  • Page 38

    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[...]

  • Page 39

    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[...]

  • Page 40

    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[...]

  • Page 41

    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 [...]

  • Page 42

    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[...]

  • Page 43

    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.[...]

  • Page 44

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

  • Page 45

    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[...]

  • Page 46

    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 [...]

  • Page 47

    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[...]

  • Page 48

    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[...]

  • Page 49

    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[...]

  • Page 50

    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[...]

  • Page 51

    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[...]

  • Page 52

    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 [...]

  • Page 53

    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 _[...]

  • Page 54

    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 [...]

  • Page 55

    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 [...]

  • Page 56

    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[...]

  • Page 57

    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 [...]

  • Page 58

    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 = <[...]

  • Page 59

    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 [...]

  • Page 60

    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[...]

  • Page 61

    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 [...]

  • Page 62

    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[...]

  • Page 63

    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: $[...]

  • Page 64

    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[...]

  • Page 65

    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[...]

  • Page 66

    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[...]

  • Page 67

    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[...]

  • Page 68

    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[...]

  • Page 69

    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[...]

  • Page 70

    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[...]

  • Page 71

    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[...]

  • Page 72

    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[...]

  • Page 73

    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[...]

  • Page 74

    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[...]

  • Page 75

    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[...]

  • Page 76

    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[...]

  • Page 77

    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[...]

  • Page 78

    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 [...]

  • Page 79

    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[...]

  • Page 80

    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[...]

  • Page 81

    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 [...]

  • Page 82

    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 #--- ------- ----- ------ ------- --[...]

  • Page 83

    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" #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----[...]

  • Page 84

    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[...]

  • Page 85

    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[...]

  • Page 86

    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 " #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ----- ---[...]

  • Page 87

    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 " #--- ------- ----- ------ ------- ----- ----- -------- ----- ----- -------- ----- ---[...]

  • Page 88

    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[...]

  • Page 89

    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 [...]

  • Page 90

    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[...]

  • Page 91

    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[...]

  • Page 92

    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[...]

  • Page 93

    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[...]

  • Page 94

    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[...]

  • Page 95

    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[...]

  • Page 96

    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[...]

  • Page 97

    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 [...]

  • Page 98

    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[...]

  • Page 99

    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 [...]

  • Page 100

    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[...]

  • Page 101

    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[...]

  • Page 102

    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[...]

  • Page 103

    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 [...]

  • Page 104

    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[...]

  • Page 105

    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 [...]

  • Page 106

    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[...]

  • Page 107

    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 [...]

  • Page 108

    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 [...]

  • Page 109

    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[...]

  • Page 110

    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: ■ [...]

  • Page 111

    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[...]

  • Page 112

    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[...]

  • Page 113

    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[...]

  • Page 114

    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[...]

  • Page 115

    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[...]

  • Page 116

    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 [...]

  • Page 117

    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[...]

  • Page 118

    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[...]

  • Page 119

    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 ?[...]

  • Page 120

    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 [...]

  • Page 121

    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[...]

  • Page 122

    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[...]

  • Page 123

    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[...]

  • Page 124

    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[...]

  • Page 125

    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[...]

  • Page 126

    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[...]

  • Page 127

    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[...]

  • Page 128

    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[...]

  • Page 129

    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[...]

  • Page 130

    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[...]

  • Page 131

    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[...]

  • Page 132

    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[...]

  • Page 133

    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[...]

  • Page 134

    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 [...]

  • Page 135

    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 [...]

  • Page 136

    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[...]

  • Page 137

    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[...]

  • Page 138

    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 [...]

  • Page 139

    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[...]

  • Page 140

    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[...]

  • Page 141

    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[...]

  • Page 142

    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[...]

  • Page 143

    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[...]

  • Page 144

    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[...]

  • Page 145

    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[...]

  • Page 146

    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[...]

  • Page 147

    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[...]

  • Page 148

    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[...]

  • Page 149

    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[...]

  • Page 150

    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:[...]

  • Page 151

    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. [...]

  • Page 152

    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[...]

  • Page 153

    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 [...]

  • Page 154

    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 [...]

  • Page 155

    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[...]

  • Page 156

    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[...]

  • Page 157

    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[...]

  • Page 158

    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[...]

  • Page 159

    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[...]

  • Page 160

    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[...]

  • Page 161

    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[...]

  • Page 162

    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[...]

  • Page 163

    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[...]

  • Page 164

    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 [...]

  • Page 165

    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[...]

  • Page 166

    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 [...]

  • Page 167

    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[...]

  • Page 168

    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[...]

  • Page 169

    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[...]

  • Page 170

    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[...]

  • Page 171

    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 [...]

  • Page 172

    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[...]

  • Page 173

    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[...]

  • Page 174

    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[...]

  • Page 175

    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[...]

  • Page 176

    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.[...]

  • Page 177

    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[...]

  • Page 178

    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[...]

  • Page 179

    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[...]

  • Page 180

    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[...]

  • Page 181

    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[...]

  • Page 182

    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[...]

  • Page 183

    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[...]

  • Page 184

    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[...]

  • Page 185

    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[...]

  • Page 186

    Index- 10[...]