Home

Oracle Audio Technologies ORACLE9I B10508-01 User's Manual

1. Table 5 4 Database Control Files Control Files Description control01 ctl A control file is an administrative file Oracle9i requires a control02 ctl control file to start and run the database The control file control03 ctl records the physical structure of the database For example a control file contains the database name and the names and locations of the database data files and redo log files See Also Oracle9i Database Administrator s Guide for more information on setting this initialization parameter value Using Rollback Segments Rollback segments record the old values of data that are changed by each transaction whether or not the transaction has been committed Every database contains one or more rollback segments Use rollback segments to provide read consistency to roll back transactions and to recover the database The rollback segments of the starter database are as follows a Rollback segment SYSTEM is contained in tablespace SYS and is used by SYS a Rollback segments SYSSMUI through _SYSSMU10 are a pool of rollback segments that any instance can use if it requires a rollback segment They are contained in tablespace UNDOTBS lt n gt and are used by PUBLIC Using the Data Dictionary The data dictionary is a protected collection of tables and views containing reference information on the database its structure and its users The data that is stored in the dictionary includes the following 5 26
2. Export Utility Import Utility a Migration Utility a OCOPY ORADIM a Password Utility Recovery Manager a SQL Loader For more information refer to Oracle9i Utilities 29 Oracle Wallet Manager release 9 0 1 Oracle Wallet Manager stores and manages public key security credentials for clients and servers It generates a public private key pair and creates a certificate request for submission to a certificate authority For more information refer to Oracle Advanced Security Administrator s Guide 30 Oracle XML Developer s Kit release 9 2 0 2 0 This kit consists of a set of APIs for parsing and generating XML data These interfaces have been written for Java C and PL SQL This kit consists of the following components a XML Parser for Java a XML Parser for C a XML Parser for PL SQL a XML Class Generator for Java For more information refer to Oracle9i Application Developer s Guide XML and Oracle9i XML Reference A 22 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Descriptions 31 32 33 34 Oracle9i Advanced Analytic Services Data Mining release 9 0 1 Oracle9i Advanced Analytic Services Data Mining which is embedded in the Oracle9i database enables you to build integrated business intelligence applications with complete programmatic control of data mining functions that deliver powerful scalable modeling and real time scoring All model building and sc
3. Installation Type Required Disk Space Administrator 750 MB Runtime 650 MB Custom Up to a maximum of 800 MB Two shared images that are linked with client code are built and installed when you link Oracle9i Enterprise Edition The new shared images reduce the size of all Oracle client executable images including precompiled user programs by removing direct references to Oracle Net and other common routines The image names are in the form of libclntsh so and oracle exe 1 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS System Installation Requirements Operating System Software Requirements Table 1 3 lists the operating system software requirements for Oracle9i products Table 1 3 Operating System Software Requirements Software Requirements Operating System HP OpenVMS version 7 3 Oracle Net Requirements Oracle Net on HP OpenVMS is developed and certified using Hewlett Packard TCP IP Services for OpenVMS UCX If you wish to use the TCP IP protocol adapter for Oracle Net then you should have Version 5 1 ECO 4 or higher of TCP IP Services for HP OpenVMS Alpha installed TCP IP protocol stacks from other vendors may work with Oracle but customers use these products at their own risk Any TCP IP problems that cannot be reproduced using TCP IP Services for HP OpenVMS Alpha will simply be referred to the TCP IP vendor Vendor provided protocol services are usually upward compatible so
4. 5 etn ete ir ue nee i Pr e ek pee retro EE 3 3 Fil Systems ceo e ERO teet e ee DOES BEANS o ots ees 3 3 Optimal Flexible Architecture 2 ime ian atem neon mter iens 3 3 Using Hummingbird Exceed esses eene nen nennen nennen 3 3 Installation Procedure Requirements eee eene enne nnne 3 4 Oracle Server Database Administrator Account sse eene 3 5 Oracle9i Account is NOT the SYS or SYSTEM Account eee 3 6 Oracle9i Account UIC Must Be Greater than MAXSYSGROUD sse 3 6 Finding MAXSYSGROUP 2 0n na paee tuoi eee eret 3 6 Adding a Record in the User Authorization File UAF see 3 6 Setting Account Privileges ssessssseseeeee eee 3 8 Setting Account QUOTAS uer eee E e e eee de ier rure eee ie e e ene 3 9 Process Rights for Database Administrators sss 3 10 Process Rights for SGA Protection nnne nenne 3 11 Process Rights for Intelligent Agent OEM AGENT sss 3 12 Security Issues with Multiple Databases sssssssssssssseseeeeeneeneee 3 12 Completing Account Setup ciega terrre Er risen dere Fase e ERAT 3 12 Verifying Privil g s cem e agen hacen e Le time e Sie bo eta 3 12 HP OpenVMS Alpha SYSGEN Parameters esses e eee een 3 13 Using the Reserved Memory Registry sees eee nene nennen 3 13 Using AUTOGEN 2 treten io lsa r ae tate te e te b e PU Saa eta Lenses seb rd
5. Back up the old code and database files data redo log and control Mount the distribution media Run Oracle Universal Installer Select custom install After completing these preliminary steps you are ready to load and configure your Oracle products Adding a Product Summary 1 p 0 L 9 gr e 9 M Execute ora root bin runInstaller Point to existing ORACLE HOME Select custom install Select products to install Configure products if OUI asks questions Click Install button Exit OUI Start an instance Build or upgrade database tables menu 5 28 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Relinking the Oracle Code Relinking the Oracle Code The Oracle code must be relinked under the following conditions Change to operating system for example upgrade Change to Oracle Net configuration Change to RDBMS configuration Step 1 Shutdown the Given Database s First verify that you are pointed to the right database instance At the DCL prompt SHOW LOGICAL ORA SID ORA SID V9 LNMSJOB_TABLE Invoke SOLPLUS and connect SYS Select from the view v rRocESS If no other processes are active and if you are pointed to the right instance then shut down the given database After the database is shut down all Oracle background processes will no longer exist Type sHow svsTEM at the DCL prompt to verify Step 2 Remove Images lype REMORACLE at the sy
6. SYS 5 21 SYSTEM 5 21 USERS tablespace described 5 24 USERSO1 DBF data file 5 24 tablespace contained in 5 24 V Very Large Memory B 1 VLM reserving memory 3 13 VMS mailbox driver 1 12 W window manager requirements 1 11 X XML Development Kit A 25 Oracle XML Developer s Kit A 22 X windows configuring 1 11 Index 9 Index 10
7. Tablespaces and Data Files nnne enne 5 23 Locating the Initialization Parameter File sse 5 25 Locating Redo Log Files oreet eie d te mn tere imer Pana ined 5 25 Locating Control Files isis edo eee ate ean elena rhe dn en brc 5 26 Using Rollback Segments nissens etie tereti tree ir a Ir vases de rore dura bn inan 5 26 Using the Data Dictionary ssesssseeeee eee e nen nennen 5 26 Adding or Upgrading Products 1700 GL L L LJluYU seen ntes 5 27 Relinking the Oracle Code eene rere tre eene detiene treten 5 29 Step 1 Shutdown the Given Database s sss enn 5 29 Step 2 Remove mag es gne onde tad etae duri deed E e prae iaaa 5 29 Step 3 Invoke the Oracle Installation Utility ssssssssssseeeeeeneee 5 29 Oracle9j Products Oracle9i Database Components sss eee nennen n nennen nnne nnne A 2 Enterprise Editlol tinae uen terunt gene por eoe e ie E ET A 2 SE List Late eU toner a i DR dU e Et ee b e eic Hee eo et eH Lene gode A 5 Oracle9i Client Components esses e eene enne A 8 Runtime Editione rcr precem te egre terc EP eere t repete ire nett regt ent e A 8 Administrator Edition sin Re eee ee e Rete es A 11 Product Descriptions dn teala metal a dena idur da ee nn er aratai A 14 Oracle9i 64 bit Feature Introduction to the Oracle9i 64 bit Feature sss eene nnns B 2 Introducing the Oracle9i 64 bit Feature
8. Test the Installation on page D 3 Running the Oracle HTTP Server on OpenVMS on page D 4 Security Information on page D 27 Open Source Licenses on page D 29 Apache on page D 29 Apache Server Installation Configuration D 1 Post Installation Checklist Post Installation Checklist After you configure the Oracle HTTP Server perform the following tasks to ensure a successful startup a Run AUTOGEN a Check Disk Quota a Check for SET TERMINAL INQUIRE Each of these tasks is explained below Once you have completed them you can test the installation by starting the Oracle HTTP Server Run AUTOGEN After the installation run SYS UPDATE AUTOGEN COM AUTOGEN to evaluate your system parameters and make adjustments based on your hardware configuration and system workload On the Oracle HTTP Server for OpenVMS AUTOGEN will probably increase the page file size and the number of swap file pages Check Disk Quota If the disk quota is too low the Oracle HTTP Server will notstart Either raise the disk quota for the user account ORACLE or grant the account the EXQUOTA privilege thus allowing it to bypass disk quota restrictions Use the following commands SHOW QUOTA USER server uic DISK device name SET PROCESS PRIVILEGES EXQUOTA node name ORACLE Check for SET TERMINAL INQUIRE When the Oracle HTTP Server for OpenVMS is started the following login files are executed a SYLOGIN COM system login file a LOGIN COM
9. The following table shows the range of use for Oracle Net drivers in client server and distributed database configurations The data in this table is provided with the assumption that clients in a client server configuration run the Oracle tool and that servers run the Oracle database For distributed database examples the clients and servers each run both an Oracle tool and the Oracle database Table 1 4 Range of Use for Oracle Net Drivers Client Server Client Server Distributed Distributed Oracle Net Driver Client Tool RDBMS Server RDBMS Client RDBMS Server Oracle Net TCP IP Yes Yes Yes Yes Oracle Net OpenVMS Mailbox Limited Limited Limited Limited Limited Limited only for communication between products on the same ORACLE HOME Silent Mode Installation What Is a Silent Installation A silent installation with OUI Oracle Universal Installer is non interactive meaning that it takes place without using the Java GUI Graphical User Interface OUI gets its information from a text file that is specified on the command line by 1 16 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Silent Mode Installation using the responseFile argument instead of interactive GUI input and output If the responseFile flag is given then the installation is assumed to be a silent mode type Note Because the design of OUI causes GUI classes to be loaded but not displayed a s
10. login file for ORACLE Check these files to make sure that any SET TERMINAL INQUIRE statements are executed only in INTERACTIVE mode For example IF FSMODE eqs INTERACTIVE then SET TERMINAL INQUIRE D 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Test the Installation Failure to do so might result in ill formed HTML intermittently being returned to clients This problem might also appear when executing CGI scripts Test the Installation Now you will manually start the Oracle HTTP Server to verify the installation and configuration of theserver Enter the following command APACHECTL START Browser Test You can test the installation using your web browser Replace host domain in the following URL with the information for the Oracle HTTP Server you just installed HTTP host domain port If this is a new installation the browser should display the standard introductory page with the following bold text at the top If you see this it means that the installation of the Apache web server software on this system successful The Apache logo is displayed at the bottom TELNET Test You can also use TELNET on the local host to test the installation Use the following procedure 1 Enter the following command TELNET 0 80 The following text is displayed TELNET I TRYING Trying 127 0 0 1 TELNET I SESSION Session 01 host localhost port 80 TELNET I ESCAPE Escape cha
11. ssssssssessseseeeneeeeene nennen B 2 Benefits of the Oracle9i 64 bit Feature enne nnns B 2 Implementation of the Oracle 64 bit Feature on HP OpenVMS Alpha B 2 Suggested Parameter Settings iinet eres aeea eene nennen nnne nnne B 3 Other Recommendations e encuentro kd ree et eerte cnt eire bn eee tende B 4 Oracle Transparent Gateway System Requirements for Oracle Transparent Gateway sss C 2 RDB Gateway Requirements eerte tie de ett terrre trae eee re ie ess C 3 RMS Gateway Requirements ig aana iieis een e etra tiet pea bester Pe tiene Po rng C 4 Tested Gateway Configurations essorer iieii ennn C 6 Gateway Installation Worksheets sese eene nnne nnns C 6 Installing Oracle Transparent Gateway esses eee eene n nennen C 8 Mounting Transparent Gateway from the CD ROM ssssssssseseeneneereeneeen C 8 Installation Prompts for Transparent Gateway ssssesseeeeeee eee enn C 8 Removing Oracle Transparent Gateway sese nene e nennen C 9 vii D Apache Server Installation Configuration PostInstallation Checklist 4 n certet e e ct ete ee oeste te re edes D 2 R rcAUTOGEN 5 hie iti ree e e ri CH e d Hehe PO ER HT e RR E ERR egt D 2 Check Disk Quota A nete etc e ER ett aie e D 2 Check for SET TERMINAL INQUIRE esee eet entente nente nre nter nnne D 2 Test the Installation 5 eee ene ee He RE RENE NEUE GUI RENI RR D 3
12. system requirements 1 8 SYSTEM tablespace description 5 24 interMedia Option database objects 5 15 System user pre installation tasks 3 16 SYSTEM user name database roles of 5 21 described 5 21 password of 5 21 SYSTEMOI DBF data file 5 24 tablespace contained in 5 24 I tablespaces Index 8 containing DRO1 DBF 5 23 containing INDX01 DBF 5 23 containing SYSTEM01 DBF 5 24 containing TEMP01 DBF 5 24 containing TOOLS DBF 5 24 containing USERSO1 DBF 5 24 defined 5 23 DRSYS 5 23 expanding for large sorts 5 24 in database 5 23 INDX 5 23 SYSTEM 5 24 TEMP 5 24 TOOLS 5 24 USERS 5 24 TCP IP protocol support and Secure Socket Layer 1 15 defined A 25 TEMP tablespace described 5 24 TEMP01 DBF data file 5 24 tablespace contained in 5 24 TOOLS tablespace described 5 24 tools adding or upgrading 5 27 tools requirements 1 14 TOOLSO01 DBF data file 5 24 TOOLS DBF tablespace contained in 5 24 transaction processing See database environments database environments transaction processing database troubleshooting oralnventory log files 4 8 U UAF 3 5 UIC GROUP number 3 6 umask command setting 3 18 uname command 1 11 upgrading 3 3 Oracle products 5 27 to Oracle8 from Oracle7 1 13 upgrading existing Oracle databases 1 7 user and group numbers 3 5 user names CTXSYS 5 20 DBSNMD 5 20 MDSYS 5 20 ORDPLUGINS 5 20 ORDSYS 5 20 OUTLN 5 20 SCOTT 5 21
13. 1 14 process rights identifier 3 10 product dependencies 1 13 Program Global Area B 3 programmatic interfaces 1 12 Programmer disk space requirements 1 10 response file 1 19 protocol support post installation tasks 5 17 Secure Socket Layer 5 17 TCP IP defined A 25 Q query intensive transactions B 2 quotas account 3 9 R redo log files in starter database 5 25 REDOO1 LOG 5 25 REDOO2 LOG 5 25 REDOO3 LOG 5 25 related documentation xiv relinking Oracle code 5 29 Oracle products 5 29 requirements CD ROM 1 9 file permissions 3 16 file systems 3 3 hardware 1 8 interMedia 1 14 Java Runtime Environment 1 14 3 2 3 20 Kerberos authentication 1 15 memory 1 8 operating system 1 11 oracle account 3 17 Oracle Advanced Security 1 15 Oracle Options 1 14 Oracle Visual Information Retrieval 1 14 ORACLE HOME 3 2 Oracle9i JVM 1 14 precompilers 1 14 Pro C C 1 14 Pro COBOL 1 14 Pro FORTRAN 1 14 Secure Socket Layer 1 15 swap space 1 9 system configuration 3 16 system installation 1 8 tools 1 14 window manager 1 11 Reserved Memory Registry 3 13 response files clientadmin rsp 1 19 clientcustom rsp 1 19 clientprogmr rsp 1 19 custom rsp 1 19 dbca rsp 1 19 enterprise rsp 1 19 standard rsp 1 19 restrictions configuration 1 15 Roles OEM MONITOR 5 22 roles of CTXSYS user name 5 20 of DBSNMP user name 5 20 of MDSYS user nam
14. 5 data dictionary defined 5 26 data files 5 23 database passwords 5 19 database user names 5 19 initialization parameter file 5 25 redo log files 5 25 rollback segments 5 26 tablespaces 5 23 tablespaces and 5 23 database environments and Oracle Database Configuration Assistant 1 6 general purpose 1 4 database roles of CTXSYS user name 5 20 of DBSNMP user name 5 20 of MDSYS user name 5 20 of ORDPLUGINS user name 5 20 of ORDSYS user name 5 20 of OUTLN user name 5 20 of SCOTT user name 5 21 of SYS user name 5 21 of SYSTEM user name 5 21 DB BLOCK BUFFERS B 4 DB DOMAIN parameter 5 22 DB NAME parameter 5 22 DBAs See administrators dbca rsp file 1 19 DBSNMP user name database roles 5 20 described 5 20 dropping with CATNSNMP SOL file 5 20 password 5 20 DCL command to check disk format 2 4 DEC compilers 1 12 DEC ADA 3 4 2 1 12 default control files CONTROLO1 CTL 5 26 CONTROLO2 CTL 5 26 Index 2 CONTROLO3 CTL 5 26 default data files DRO1 DBF 5 23 INDX01 DBF 5 23 SYSTEMOI DBF 5 24 TEMP01 DBF 5 24 TOOLS DBF 5 24 USERSO1 DBF 5 24 default initialization parameter file init ora 5 25 default redo log files REDOO1 LOG 5 25 REDOO2 LOG 5 25 REDOO3 LOG 5 25 default tablespaces DRSYS 5 23 INDX 5 23 SYSTEM 5 24 TEMP 5 24 TOOLS 5 24 USERS 5 24 dependencies product 1 13 documentation related xiv DRO1 DBF data file 5 23 tablespace contained in 5 23 DRSY
15. Browser LeSt a n sten initi sie deena tle e ist nee e een iS ates table bre ina iei o bee ps eua D 3 TELNET Testaa e Er tnnt eee ORE ERE RR RR e BR Tete ee D 3 Troubleshooting 5 2 ee e lt t t e ret t gei Et rt eam ee tie PED S D 4 Running the Oracle HTTP Server on OpenVMS sees ee eee eee eee D 4 Starting and Stopping the Server sssssssssssssee eee eene e nennen nnne nennen D 4 Server Tog Pile eee ehe ete e ER ee ei eden te dte e pe te ne t eed D 4 Customizing the Server Environment sse eee eene nennen nennen D 8 How to Configure Apache siete netiis itae Sa SN ier tee Por anaes D 8 Modul s and Directives 2 ase e ee oit et Ere Er ERU He ERE TU t D 8 Supported and Unsupported Features D 14 FileFormat eee e eae e ir INE e D 19 File Naming ConyentioNS ensita eterne tenente tenere E a D 20 File Transfer Process and Access Control List sese D 20 Logical IN arn edet ee ime I eite tee t e ent eed tetti hen D 21 OpenVMS Cluster Considerations sese eee nennen D 23 Common Gateway Interface CGI sssssseeeeeeen eene nenne enne D 24 Security Information geteilt eri Hose ede herede coun dar tbt daga D 27 Process Model eet teet e er eed iet e ee d rede D 27 Privileged Imag s Ji eie e eit ee eL v e A Rd D 27 Privileges Required to Start and Stop the Server sss D 28 File Ownership and Protection sse eene nennen D 29 Server Extensions CGI
16. Database Administrator DBA account must be granted one or more process rights identifiers These identifiers provide the ability to issue the CONNECT AS SYSDBA command that is required to perform database administration functions The following table displays the combinations of adding and granting rights identifiers to this account Table 3 2 Adding and Granting Process Rights Identifiers Adding and Granting Allows Control of ORA DBA ORA DBA any database instance provided it does not also have an ORA sid DBA identifier defined for it ORA sid DBA ORA sid DBA database instance sid only ORA sid DBA ORA DBA all database instances except sid For example to grant the ORA sid DBA rights identifier to the Oracle9i account for an instance called TEST issue the following command UAF gt ADD IDENTIFIER ORA TEST DBA 3 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Installation Procedure Requirements Then grant the rights identifier to the Oracle9 account as follows UAF gt GRANT IDENTIFIER ORA TEST DBA ORACLE9i If you add the ORA TEST DBA rights identifier but grant only ORA DBA to ORACLESi then the account would have insufficient privileges to administer the instance TEST The third line of the table shows that you can add and grant different identifiers thereby restricting control
17. Executables eterne eee ie ee tee tee i Dov ogee 1 16 Oracle Net Linking Options tenine iisi iaee iaae laara aiaa avaa in rene 1 16 Silent Mode Installation e ern erected ed ve TO ee ec Yee eve ee ete 1 16 What Is a Silent Installation soena iia iaa iiei a i iis 1 16 What Isa Response File te oeutaeeetieele densae metet da t deer nds 1 18 Why Perform a Silent Installation ssrin 1 18 Modityirig a Resporse File nee ra heben nid et m Pci hide 1 18 Invoking the Installer ongs pis usce ate eet irre tree Eee Eo Re a Gon Tra ad 1 19 Release Information Product Set ino eit eiie ERE e lee i ten a 2 2 Changes and Enhancements sss eene nnne nnne nnne nnnnn 2 2 Initialization Parameters in Oracle9i Release 2 That Have Been Desupported 2 5 Initialization Parameters in Oracle9i Release 2 That Are Becoming Obsolete 2 5 Known Restrictions uiuere ceste cocto het cg eee bee dee ae cas aaa aaa t irea iaaa aaaeei igi 2 6 The following items are not supported sess eee eee enne nennen 2 6 CD ROM Pre installation Requirements HP OpenVMS and Installation Specific Issues and Restrictions 3 2 New ORAZ ROO Tag ee rere tene tente dete Se vis er pere reete reete cede y eee e eee Peete 3 2 Java Runtime Environment JRE eese ener enne ene ne tnenr ene enne ene 3 2 Character Mode iis Sela dente itn ees 3 2 Upgrading and Migrating
18. Oracle Advanced Security Oracle Wallet Manager 1 15 requirements 1 15 Wallet Manager defined A 22 Oracle Application Server Listener See Oracle HTTP Server Oracle Data Migration Assistant 3 3 and Oracle7 3 3 Oracle Database Configuration Assistant and Oracle interMedia 1 6 database creation methods selecting 1 5 database environments configured by 1 5 1 6 response file 1 19 Oracle Enterprise Manager Quick Tours defined A 15 Oracle HTTP Server defined A 15 Oracle Integration Server defined A 16 Oracle Intelligent Agent defined A 16 Oracle interMedia Locator described A 17 Oracle interMedia Image defined A 16 Oracle inventory JRElocations 3 2 logfiles 4 8 Oracle Java Database See Oracle JDBC Drivers Oracle Java Tools defined A 17 Oracle JDBC Drivers defined A 17 Oracle Locale Builder defined A 17 Oracle Locator described A 17 Oracle Management Server defined A 17 Oracle Names defined A 18 Oracle Net and Oracle Advanced Security 1 15 defined A 18 linking options 1 16 Oracle Protocol Support installation types available with A 4 A 6 pre installation tasks shutting down listeners 3 20 Oracle Net Server defined A 18 Oracle Options requirements 1 14 Oracle Parallel Server re installing 4 11 Oracle Partitioning defined A 19 Oracle PL SQL Gateway defined A 19 Oracle Precompilers post installation tasks 5 16 Oracle Real Application Clusters defined A 19 Oracle Real Application Cl
19. Server is a suite of installable components that Oracle Corporation designed to transform traditional businesses into e businesses It integrates and facilitates communication among the various applications including CRM ERP business to business internet marketplaces and auction sites that form an e business Oracle Integration Server consists of the following components a Advanced Replication Oracle Advanced Security Oracle9i database with Advanced Queuing and Oracle9i JVM Partitioning For information on Oracle Applications InterConnect OAI refer to the Oracle generic documentation 8 Oracle Intelligent Agent release 9 2 0 2 0 Oracle Intelligent Agent monitors targets on a managed node for registered events and scheduled jobs that are sent by the Console Oracle Intelligent Agent also collects statistical data for Capacity Planner and Performance Manager which are data collecting applications in the Oracle Diagnostics Pack For more information refer to Oracle Intelligent Agent User s Guide 9 Oracle interMedia Image release 9 2 0 2 0 Installed with Oracle interMedia formerly Oracle Image Cartridge Oracle interMedia Image provides for the storage retrieval and processing of two dimensional static bitmapped images Images are stored efficiently using popular compression schemes in industry standard desktop publishing image interchange formats For more information refer to Oracle9i interMedia Audio
20. a UIC group number that is less than MAXSYSGROUP then you must create a new account with a UIC group number higher than MAXSYSGROUP before you install Oracle9i Finding MAXSYSGROUP The following command gives the value of MAXSYSGROUP in decimal format WRITE SYSSOUTPUT FSGETSYI MAXSYSGROUP Adding a Record in the User Authorization File UAF Use the AUTHORIZE utility to create or modify records in the User Authorization File UAF 1 Torun AUTHORIZE enter 3 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Installation Procedure Requirements SET DEFAULT SYSSSYSTEM RUN AUTHORIZE 2 Atthe UAF prompt enter the ADD command to create the user account from which you will install the product software UAF gt ADD Oracle9i PASSWORD ORACLE UIC 277 100 DEVICE device DIRECTORY Oracle9i OWNER ORACLE DBA In this example the account name is Oracle9i Note that the UIC GROUP number is 277 The UIC GROUP number must be larger than MAXSYSGROUP After adding the account you must alter the account privileges and quotas Although this can be done in any order usually the account privileges are set before the account quotas For more information on using AUTHORIZE refer to the Hewlett Packard documentation CD ROM Pre installation Requirements 3 7 Installation Procedure Requirements Setting Account Privileges The following privileges are required as both authorized and defau
21. and then if failed a second attempt is made using case insensitive symbollookups This fallback behavior can be disabled with APACHES DL NO UPPERCASE FALLBACK OpenVMS Cluster Considerations An OpenVMS Cluster is a group of OpenVMS systems that work together as one virtual system The Oracle HTTP Server runs in an OpenVMS Cluster so you can take advantage of the resource sharing that increases the availability of services and data Keep the following points in mind The Oracle HTTP Server is supported on OpenVMS Alpha Version 7 1 2 or higher The Oracle HTTP Server runs in an Alpha or a mixed architecture cluster Individual System versus Clusterwide Definition To define clusterwide versus individual configuration files APACHESROOT uses the following concealed logical names APACHESCOMMON defines clusterwide files APACHESSPECIFIC defines system specific files When reading a file the server first looks for a system specific version of the file in APACHESSPECIFIC directory If it does not find one then it looks for a clusterwide file in APACHESCOMMON directory Apache Server Installation Configuration D 23 Running the Oracle HTTP Server on OpenVMS To avoid confusion always use the appropriate concealed logical name to specify the file that you want to edit For example to edit a clusterwide version of HTTPD CONF refer to EDIT APACHESCOMMON CONF HTTPD CONF If you referred to EDI
22. contained within a response file but the response file argument that is passed to the DBCA COM script on the command line with the responseFile keyword must be in VMS style syntax 5 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Database Configuration Assistant DBCA The following sample DBCA RSP file is included here for reference THHGHEHHBHHBHHDBHBHBHBHRBHHBHERHEHEHEBBRHERHHHHHHBHBEHBHHBBHBHBHRHRHEHBHERBERHEBHBHHEHE DBCA response file Copyright 1998 2001 Oracle Corporation All Rights Reserved Specify values for the variables listed below to customize Oracle Database Configuration installation Each variable is associated with a comment The comment identifies the variable type Please specify the values in the following format Type Example String lt value gt Boolean True or False Number numeric value StringList lt valuel gt lt value2 gt Examples 1 dbca progress only responseFile response file Display a progress bar depicitng progress of database creation process 2 dbca silent responseFile response file Creates database silently No user interface is displayed 3 dbca silent createDatabase cloneTemplate responseFile response file Creates database silently with clone template The template in reponsefile is a clone template THHEAHEEHHBEHHBHEH RHBREHBHBRHBHERHHBHEREHBHEHBHERRBHBRHBBRHH HHERIHBRERIBIEREHHERHHBRHEHBHE
23. database languages with an Oracle database For more information refer to SOL Plus User s Guide and Reference SQL Plus Worksheet release 9 0 1 Installed with Oracle Enterprise Manager SQL Plus Worksheet is a graphical user interface for manually entering SQL PL SQL and DBA commands or for running stored scripts For more information refer to Oracle Enterprise Manager Administrator s Guide TCP IP Protocol Support release 9 2 0 2 0 TCP IP Protocol Support enables client server conversation over a network using TCP IP and Oracle Net This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP IP if the Oracle database is running on a host system that supports network communication using TCP IP Multi Threaded Server MTS Support is available in TCP IP networks Connection Pooling is available only with MTS on TCP IP networks For more information refer to Oracle Net Administrator s Guide XML Development Kit an Oracle version release 9 2 0 2 0 XML Development Kit is required for integrating and running XML applications with the database No applicable reference is available Oracle9i Products A 25 Product Descriptions A 26 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i 64 bit Feature This appendix introduces the 64 bit feature or Very Large Memory VLM and makes setting and other recommendations for th
24. determine beforehand what results you expect from your changes If the expected changes do not occur then restore the old values before trying again 1 Runthe AUTOGEN utility with the SAVPARAMS parameter by entering the following command SYSSUPDATE AUTOGEN SAVPARAMS GETDATA This step saves current parameters to a file named AGENSFEEDBACK DAT 2 If you have not already done so then run AUTOGEN GETDATA to ensure that the file PARAMS DAT has been generated SYSSUPDATE AUTOGEN GETDATA 3 Examine the parameter settings in the current PARAMS DAT and if they are inappropriate then change them in the MODPARAMS DAT file by using the format MIN xparameter value as in the following commands MIN GBLSECTIONS 3000 MIN GBLPAGES 300000 The MIN prefix indicates that you are setting a lower limit for the specified parameter To use the MIN prefix identify the current value of the specified parameter using SYSGEN and the amount by which you want to increase the parameter The sum of these two values is used for the MIN parameter entry 4 Runthe AUTOGEN utility with the GENPARAMS and REBOOT parameters by entering the following command SYSSUPDATE AUTOGEN GENPARAMS REBOOT CD ROM Pre installation Requirements 3 15 HP OpenVMS Alpha System Configuration Warning The REBOOT parameter in this example will cause the system to automatically reboot when the SYSGEN is complete This step generates
25. does not need to be specified by the caller because the parent derives it it can be easily determined by default The following example deletes the environment and then recreates it Example diff mode cgi com APACHESDCL ENV d Define APACHESPREFIX DCL CGI SYMBOLS WWW 1 APACHESDCL ENV c Apache Server Installation Configuration D 25 Running the Oracle HTTP Server on OpenVMS Referencing Input CGI scripts that reference input to the Oracle HTTP Server must refer to APACHESINPUT Executing CGI On OpenVMS CGI images execute within a DCL process You cannot execute CGI images directly Logicals for Debugging CGI Scripts Use the following logicals to debug CGI scripts Logical Name Description APACHESDEBUG_DCL_CGI If defined this system logical name enables APACHES VERIFY DCL CGI and APACHE SHOW_CGI_SYMBOL APACHES VERIFY DCL CGI If defined this system logical name provides information for troubleshooting DCL command procedure CGls by forcing a SET VERIFY before executing any DCL CGI Enabled by APACHES DEBUG DCL CGI APACHESSHOW CGI SYMBOL If defined this system logical name provides information for troubleshooting the CGI environment by dumping all of the symbols and logicals job process for a given CGI Enabled by APACHESDEBUG DCL CGI Displaying Graphics with CGI Command Procedures To display a graphics file with a CGI command procedure use the APACHESDCL BIN foreign symbol in the following
26. format APACHESDCL BIN s bin size bin file where 8 bin size specifies the actual or approximate file size in bytes Bin size is automatically determined if the image file is larger than 32768 K default value If the image file is smaller than 32768 K then you can provide an approximate or actual size This will boost performance bin file Specifies the file to be displayed For example SAY WRITE SYSSOUTPUT D 26 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Security Information SAY Content type image gif SAY n APACHESDCL BIN APACHESROOT ICONS APACHE PB GIF EXIT Running the Oracle HTTP Server on OpenVMS 3119 Security Information The Oracle HTTP Server for OpenVMS is a non privileged user mode socket based network application TMPMBX and NETMBX are the only privilege requirements The server runs under its own unique UIC and user account ORACLE Process Model The Oracle HTTP Server runs as a single job which consists of A master process ORACLE and Several subprocesses Subprocesses are created to service incoming HTTP requests and to execute CGI scripts Because the server runs as a single job the OpenVMS security profile for each process is identical and no enhanced mechanism is required for these processes to communicate with one another Resource utilization is controlled by a single user account ORACLE where pooled quotas are defined Priv
27. of a particular instance while still granting control to other instances You can grant database maintenance privileges to accounts for example privileges to start up and shut down the database in addition to the Oracle9i account However with the Oracle9i account the user UIC GROUP number must be greater than MAXSYSGROUD By granting the ORA sid DBA identifier you can similarly restrict user privileges to an instance named sid Process Rights for SGA Protection Releases of the Oracle RDBMS on HP OpenVMS Alpha after Release 7 3 2 3 0 feature a change in the way that the software runs and accesses the SGA Previous to Release 7 3 2 3 2 the SGA was protected by allowing only processes that are running in supervisor mode to access it directly Starting with Release 7 3 2 3 2 the SGA is protected by an Access Control List to accommodate the kernel remaining in user mode Before bringing up a database add a rights identifier to the User Authorization File UAF Have your system manager adhere to the following directions At the UAF gt prompt type UAF ADD IDENTIFIER ATTRIBUTES SUBSYSTEM ORA SGA Warning DO NOT GRANT THE RIGHTS IDENTIFIER TO ANY USER Oracle manages the assignment of the rights identifier when it starts the database CD ROM Pre installation Requirements 3 11 Installation Procedure Requirements Process Rights for Intelligent Agent OEMAGENT To install the Intelligent A
28. reserved to System then Oracle Corporation recommends for security reasons that a separate account owner be set up for Apache Configure the Apache server to assign ownership of listener and module actions to this account It is not necessary for the Apache user account to have CD ROM Pre installation Requirements 3 17 Setup Tasks to Perform as the Oracle User privileges to run the Apache Server on a port 1023 Images that are linked with privileges during installation in the oracle account ensure that this can be done For details on how to configure the server to run as a user other than the oracle user refer to section Customizing the Server Environment on page D 8 The Apache account owner should have minimal user privileges and should not be a member of any groups whose files are not intended to be visible to the public The nobody account may serve as a model for the Apache account Setup Tasks to Perform as the Oracle User Log in to the Orac1e9 account and perform the following tasks as necessary Set Permissions for File Creation a Set Display Set Permissions for File Creation Set default file protections for the oracle9 account to ensure that group and world have read and execute permissions but not write permission on installed files 1 Enterthe SHOW PROTECTION command to check the current setting 2 Ifthe SHOW PROTECTION command does not show the expected protection then set protection in
29. the 1ogin comof the orac1e9 as follows SET PROTECTION s RWE o RWED g RE w RE default 3 18 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Setup Tasks for Oracle Products Set Display Before starting the Oracle Universal Installer set your display appropriately Enter SET DISPLAY CREATE TRANSPORT TCPIP NODE workstation name or IP address and verify that it is correct by using the following command RUN SYS SYSTEM DECWSCLOCK Refer to each logical entry in this section for instructions on setting the logical correctly Note If an Oracle server already exists on your system then its settings may have a bearing on the settings that you choose for the new environment Do not use the hostname or IP address of the system where the software is being installed unless you are performing the installation from the X Windows console of that system Use the machine name or IP address of your own workstation if you are installing from a remote system If you are not sure of the X server and screen settings then use 0 zero for both Setup Tasks for Oracle Products The following products require pre installation steps to be completed before you install Oracle9i software Precompilers and Tools Network and System Management Products Precompilers and Tools Complete pre installation tasks for the precompilers and tools that are required for hp OpenVMS Alpha Pro COBOL Rest
30. the DEC C RTL you might be required to use UNIX style syntax when interacting with the Oracle HTTP Server An example would be appending additional directories or a file name to a root The following examples illustrate mixed UNIX style and OpenVMS style file names that are not supported in HP OpenVMS Alpha Version 7 2 1 doc foo bar bar tmp foo bar b ar foo bar You can however modify the last example so that it will work as an OpenVMS extended file name that has a tilde as the first character Precede the leading tilde with the Extended File Specifications escape character For example foo bar For more information about using the tilde in OpenVMS extended file names see the OpenVMS Guide to Extended File Specifications at the following web site http caedmon zko dec com 72final 6536 6536pro html Mixed UNIX style and OpenVMS style file names will be supported in a future release of the DEC C RTL for HP OpenVMS Alpha File Transfer Process and Access Control List When performing a File Transfer Process FIP operation ensure that the Access Control List ACL for the target directory on the Oracle HTTP Server allows FIP access as follows When transferring new files D 20 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS SET SECURITY ACI L IDENTIFIER yourFTPname ACCESS READ WRITE directory When replacing existing fil
31. the default value to a value of 150 UAF gt MODIFY ORACLESi ENQLM 150 Account Quotas The following table lists the Oracle9i account quotas their minimum recommended values and their equivalent HP OpenVMS Alpha quota names as displayed by the DCL commands SHOW PROCESS QUOTA and SHOW WORKING SET Note These quotas depend on the number of log files the number of databases the number of network connections and other logicals on your system You might need to customize them Table 3 1 Oracle9i Account Quotas Account Quota Minimum Value Quota Name ASTLM 250 the default Asynchronous System Trap limit BYTLM 150 000 Buffered I O limit CHANNELCNT 31 Channel Count ENOLM 2000 the default Enqueue quota CD ROM Pre installation Requirements 3 9 Installation Procedure Requirements Table 3 1 Oracle9i Account Quotas Cont Account Quota Minimum Value Quota Name FILLM 100 Open file quota JTQUOTA 8192 Job table quota MAXDETACH 0 the default Max detached processes MAXJOBS 0 the default Max active jobs PGFLQUOTA 1 500 000 recommended Paging file quota WSDEFAULT 2048 Working set default WSEXTENT 8192 Working set extent WSQUOTA 4096 Working set quota Appendix B Oracle9i 64 bit Feature has additional information explaining the meanings of the quotas and how to determine their values Process Rights for Database Administrators The Oracle server
32. the following A 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Client Components Oracle JDBC Drivers which include the following a Oracle JDBC Thin Driver for JDK 1 1 a Oracle JDBC Thin Driver for JDK 1 2 Oracle JDBC OCI Driver for JDK 1 1 Oracle JDBC OCI Driver for JDK 1 2 Oracle Net Oracle SQLJ which includes the following a SQLJ Runtime a SQLJ Translator Oracle Universal Installer which includes the following a Oracle s Java Runtime Environment version Oracle Utilities which includes the following Export Import Recovery Manager a SOL Loader Oracle XML Developer s Kit Oracle XML SQL Utility PL SOL Pro C C Pro COBOL 1 8 75 Pro COBOL 9 0 1 Pro FORTRAN 1 8 75 SQL Module Ada SOL Plus Oracle9i Products A 13 Product Descriptions Product Descriptions The following list provides descriptions and release numbers for products that are available for installation Some of the described products are automatically installed with other products Refer to the release notes for your platform for updates on component availability The list format is as follows 1 Product and release Description For more information refer to Product Descriptions 1 Oracle Diagnostics Pack release 9 0 1 The Oracle Diagnostics Pack extends Oracle Enterprise Manager to enable the monitoring diagnosing and capacity planning of the multi tiered Oracle serv
33. the timer queue or the number of temporary common event flag clusters a user s process can have To change the quotas for the Oracle Account SYSUAF use the system manager account and run the AUTHORIZE utility For example SET DEFAULT SYS SYSTEM RUN AUTHORIZE UAF gt SHOW ORACLE D 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS Username ORACLE Owner APACHE WEBSERVER Maxjobs 0 Fillm 100 Bytlm 64000 Maxacctjobs 0 Shrfillm 0 Pbytlm 0 Prclm 8 DIOlm 150 WSdef 2000 UAF gt MODIFY ORACLE FILLM 300 PRCLM 20 SUAF I MDFYMSG user record s updated UAF gt EXIT Server Experiencing Medium to High Usage After you install the server and have been running it look in the log file for errors of the cannot open variety Errors of this type often indicate you need to modify system parameters Try the following Set FILLM to limit the number of files a user process can have open Set the SYSGEN parameter CHANNELCNT to 1024 unless it is already set to a higher value Note Whenever you change system parameters you must reboot the system to enable the new settings Global Pages and Global Sections If a browser installation stalls then this could be an indication that the number of global pages or global sections is too low Run AUTOGEN to evaluate the number of global pages and global sections that you need Some
34. to move data faster between memory and disk With VLM configurations system performance depends directly on the ability of the system to move database blocks into the SGA as efficiently as possible Without the benefits of improved data transfer performance can decline For a pure decision support system DSS application you may wish to choose a large value such as 32K for DB BLOCK SIZE For an OLTP type of application choose a lower value such as 2K or 4K The larger the DB_ BLOCK SIZE the more serious the impact on single row lookups 2 Configure the size of the Oracle buffer cache such that it will provide the best possible cache hit ratio without affecting memory requirements of other Oracle and system processes For example for a 3 GB buffer cache with DB BLOCK SIZE 8192 set DB_ BLOCK BUFFERS 400000 3 To enable Cost Based Optimizer CBO set optimizer mode choose To use CBO make sure all the tables and indexes are analyzed so that the statistics are up to date Use the SQL Plus commands analyze estimate for large tables and analyze index compute statistics for indexes Note When no statistics are gathered or available the Rule based Optimizer RBO is used Note Ensure the query does not use the rule hint rule Otherwise the CBO will be disabled 4 Setthe SORT AREA SIZE parameter with care SORT AREA SIZE is the space used in Program Global Area PGA for each s
35. will be created when a background process aborts If you do not want this feature enabled you can turn it off using the following commands define system ORA SID PROCESS NAME DMP FALSE start the instance and open the database Example define system ORA PROD LMDO0 DMP FALSE sqlplus nolog SOL connect as sysdba SOL startup Please note that this change has no effect on normal daily production behavior Oracle Corporation recommends that you do not define the dump logical 2 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Changes and Enhancements Oracle9i Release 2 Dependency on ODS 5 Disk Structure In general ODS 5 format allows VMS to support Microsoft Windows file naming formats Longer file names additional character support and the ability to have lowercase and mixed case file names are some of the features supported on ODS 5 disks The disks on which the Oracle code tree resides must be formatted in Files 11 On Disk Structure Level 5 ODS 5 format This is the disk to which the VMS logicals ora root ora rootdir and oracle home willpoint The directory that is referenced by these logicals is the parent directory for all Oracle RDBMS software such as APACHE CTX INSTALL NETCONFIG RDBMS UTIL and so forth The disks on which Oracle database files reside can be formatted as either ODS 2 or ODS 5 Caution Oracle Corporation STRONGLY urges you to read the OpenVM
36. window appears Enter a directory where the inventory of all installations will be kept Note This directory must be on an ODS 5 disk a If this is not the first time any Oracle9i products are installed on the current system then refer to the next step The File Locations Window appears Source You should not need to change the default This points to the installation files Destination Name Enter a name to refer to your ORACLE HOME Destination Path Enter the path of your ORACLE HOME Note ORACLE HOME must be on an ODS 5 disk a Click Next 4 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle Universal Installer 10 The Available Products window appears Choose Oracle9 Client Click Next to continue The Installation Types window appears Choose an installation type Custom Administrator or Runtime Click Next The Summary window appears This window displays all of the options that have been chosen Click Install to proceed with the installation or click Previous to change your selections The Install window appears a This window indicates installation progress Errors or warnings produce a dialog box where you can choose to fix and retry to ignore and continue or to abort From the End of Installation window you may exit or install additional products This window appears when your installation is com
37. with releases 8 1 x or 9 0 1 to install release 9 2 0 1 0 components Installation Option Installing Oracle9 from the Hard Drive You can avoid the need to mount and unmount CD ROMs during installation by copying the contents of each CD ROM to your system hard drive You must have a file system that is not in use by other applications You must also have at least 2 5 GB of disk space available 1 Copy the CD ROMs to your system hard drive Copy the contents of each CD ROM to a directory on a disk For example copy first CD disk disk1 cdrom copy second CD disk disk1 cdrom 2 Start the Oracle Universal Installer from the hard disk The Oracle Universal Installer automatically finds the contents of each CD ROM and does not prompt for the location of any CD ROM during the course of the installation 4 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle Universal Installer Oracle Universal Installer The following procedure describes the installation of products with the use of the Oracle Universal Installer OUT Installing an Oracle9 Database 1 Login as the Oracle user 2 Startthe Oracle Universal Installer from the CD ROM mount point directory at the SYSTEM directory level with the following command QG ddcn disk1 runInstaller If the default temp directory SYS SCRATCH is not ODS 5 then you will need to use the scratchPath flag to specify an alternate temp
38. AddModuleInfo MOD_LOG_CONFIG C CustomLog LogFormat TransferLog MOD_MIME C AddCharset AddEncoding AddHandler AddLanguage AddType DefaultLanguage ForceType RemoveHandler SetHandler TypesConfig MOD NEGOTIATION C CacheNegotiatedDocs LanguagePriority MOD_SETENVIE C BrowserMatch BrowserMatchNoCase SetEnvIf SetEnvIfNoCase MOD SO C LoadModule Apache Server Installation Configuration D 13 Running the Oracle HTTP Server on OpenVMS MOD STATUS C ExtendedStatus MOD_UNIQUE_ID C MOD_USERDIR C UserDir Supported and Unsupported Features The server documentation from the Apache Software Foundation at the following web site http www apache org docs provides most of the information needed to run your Oracle HTTP Server for OpenVMS Information specific to the OpenVMS operating system is provided below Modules Not Included The following modules are not included in this version of the Oracle HTTP Server for OpenVMS kit MOD AUTH ANON MOD AUTH DB MOD AUTH DBM MOD AUTH DIGEST MOD CERN META MOD DIGEST MOD EXAMPLE MOD EXPIRES MOD HEADERS MOD ISAPI MOD JSERVE MOD LOG AGENT MOD LOG REFERER D 14 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS MOD MIME MAGIC MOD MMAP STATIC MOD PEARL MOD PROXY MOD REWRITE MOD SPELING MOD 5SSL MOD USERTRACK MOD VHOST ALIAS Unsupported Directives The following directives ar
39. C For precompiler Pro C C the configuration fileis pcscfg cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pcscfg cfg file refer to Pro C C Precompiler Programmer s Guide Pro COBOL For precompiler Pro COBOL the configuration file is pcbcfg cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pcbcfg cfg file refer to Pro COBOL Precompiler Programmer s Guide Pro COBOL18 For precompiler Pro COBOLI18 the configuration fileis pcccob cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pcccob cfg file refer to Pro COBOL Precompiler Programmer s Guide Pro FORTRAN For precompiler Pro FORTRAN the configuration file is pccfor cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pccfor cfg file refer to the Pro FORTRAN Supplement to the Oracle Precompilers Guide SQL Modula Ada For precompiler SOL Modula Ada the configuration fileis pmscfg cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pmscfg cfg file refer to the SOL Module for Ada Programmer s Guide 5 16 Oracle9i I
40. COBOL DEC COBOL release 2 8 Pro FORTRAN DEC FORTRAN release 7 1 SQL Module DEC ADA 3 5a23 1 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Dependencies Product Dependencies Some Oracle products depend on other Oracle products to work properly Use the following tables to determine the product dependencies This section has the following subsections a Important Compatibility Issues Additional Product Specific Installation Requirements Important Compatibility Issues Warning If you are upgrading to Oracle9i from a previous version then ensure that you have no Oracle symbols and logicals defined prior to installing Oracle9i DO NOT runany orauser scripts as part of yourlogin sequence Failure to heed this warning will result in numerous problems including undefined symbols and overwriting of the previous code tree Review the compatibility issues given in this section Oracle9i Enterprise Edition must be installed in a location separate from all other previous Oracle server installations a Oracle products released for earlier versions of Oracle server such as release 9 0 1 x and release 8 1 7 x must not be linked against an Oracle9i installation Contact your Sales Representative concerning releases of these products that have been certified with Oracle9 Note To install National Language Support NLS build all Oracle products first Then install NLS The
41. Client installation types Oracle Net clients communicate with Oracle servers through net service names Oracle Net resolves net service names using the following naming methods Directory Names a Host Names Local Names a Oracle Names For more information refer to Oracle Net Administrator s Guide A 18 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Descriptions 18 19 20 Oracle Partitioning release 9 2 0 2 0 Oracle Partitioning provides more control in managing tables and indexes by directing all maintenance operations to individual partitions rather than to tables and index names Note This product requires a separate license For more information refer to Oracle9i Concepts and Oracle9i Data Warehousing Guide Oracle PL SOL Gateway release 9 2 0 2 0 The PL SQL Gateway provides support for building and deploying PL SQL based applications on the web PL SQL stored procedures retrieve data from database tables and generate HTTP responses You can deploy the gateway in the following manner mod plsqgl This configuration supports running in a stateless mode in which each HTTP request maps to a new database session This is the recommended configuration if you want to develop stateless PL SQL based web applications For more information refer to Oracle Internet Application Seroer Release Using mod plsgl and to Oracle9i Administrator s Reference Relea
42. Configuration Assistant on page 1 5 for more information on how to choose a database Many of the Oracle documents that are included in the Oracle9 Generic Documentation CD ROM provide information about database environments the effect that database environment settings have on performance and how your database can be tuned to maximize performance Database Configuration Assistant Database Configuration Assistant enables you to copy an Oracle9i preconfigured database or to create a fully customized database to match your selected environment and database configuration It starts automatically unless you selected software only after Oracle9i software has been installed during Oracle9i installation When installing Oracle9i software using any database configuration option other than the Custom and Software Only the Oracle Universal Installer OUI prompts for a global database name and System Identifier SID After Oracle9 installation is complete the Database Configuration Assistant uses this information to create the database OracleQi Installation Planning 1 5 Oracle9i Database Configurations The following list provides descriptions of database configurations General Purpose configuration If you select this option with an Enterprise Edition or Standard Edition installation then the Database Configuration Assistant creates a preconfigured ready to use multipurpose database with the following features a Default initi
43. E STRUCTURE 5 device name volume label Example INITIALIZE STRUCTURE 5 2 DKC100 TESTVOL Oracle9i Release 2 New Directory Structure Beginning with this release the directory structure of Oracle9i for HP OpenVMS closely resembles that of Oracle9i on UNIX systems Database Administrators will more quickly become familiar with Oracle9i as the platform by being able to make file locations more consistent and predictable 2 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Changes and Enhancements Initialization Parameters in Oracle9i Release 2 That Have Been Desupported ALWAYS ANTI JOIN ALWAYS SEMI JOIN JOB QUEUE INTERVAL OPTIMIZER PERCENT PARALLEL HASH MULTIBLOCK IO COUNT DB BLOCK LRU LATCHES DB BLOCK MAX DIRTY TARGET SORT MULTIBLOCK READ COUNT DB FILE DIRECT IO COUNT GC DEFER TIME GC RELEASABLE LOCKS GC ROLLBACK LOCKS LM LOCKS LM RESS USE INDIRECT DATA BUFFERS Initialization Parameters in Oracle9 Release 2 That Are Becoming Obsolete ROLLBACK SEGMENTS FAST START IO TARGET TRANSACTIONS PER ROLLBACK SEGMENT LOG CHECKPOINT INTERVAL DB BLOCK BUFFERS BUFFER POOL KEEP BUFFER POOL RECYCLE Release Information 2 5 Known Restrictions Known Restrictions RMAN Runs Only Over TCP IP The connection to both the catalog and the database must be a TCP IP connection OpenVMS OpenVMS always performs its I O asynchronously Several init ora parameters that mimic asynchronous behavior are n
44. HBHBHHBHHEHHE Post Installation 5 5 Database Configuration Assistant DBCA Name RESPONSEFILE VERSION Datatype String Description Version of the database to create Valid values 9 0 0 Default value None Mandatory Yes Name CREATE TYPE Datatype String Description Type of database creation Valid values createDatabase createTemplateFromDB V createCloneTemplate Default value None Mandatory Yes End of GENERAL section CREATEDATABASE section is used when CREATE TYPE is defined as createDatabase CREATEDATABASE Name GDBNAME Datatype String Description Global database name of the database Valid values db name db domain when database domain isn t NULL db name when database domain is NULL Default value None Mandatory Yes GDBNAME orcl9i us oracle com Name SID Datatype String Description System identifier SID of the database Valid values Check Oracle9i Administrator s Guide 5 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Database Configuration Assistant DBCA LH Default value db name specified in GDBNAM Mandatory No SID orcl9i Name TEMPLATENAME Datatype String Description Name of the template Valid values Template name as seen in DBCA Default value None Mandatory Y
45. Image and Video User s Guide and Reference A 16 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Descriptions 10 11 12 13 14 Oracle Java Database Connectivity JDBC Drivers release 9 2 0 2 0 Oracle JDBC Drivers are a standard set of Java classes specified by JavaSoft that provide vendor independent access to relational data For more information refer to Oracle9i JDBC Developer s Guide and Reference Oracle Java Tools release 9 2 0 2 0 Oracle Java Tools provides tools to build and deploy Java stored procedures with Oracle Java Virtual Machine For more information refer to Oracle9i SQL Developer s Guide and Reference Oracle Locale Builder release 9 0 1 Oracle Locale Builder simplifies manipulation of National Language Support locale data definitions It provides a graphical user interface for viewing modifying and defining locale specific data For more information refer to Oracle Globalization Support Guide Oracle Locator release 9 2 0 2 0 Installed with Oracle interMedia Oracle Locator enables Oracle9i to support online Internet based geocoding facilities for locator applications and proximity queries For more information refer to Oracle9i Spatial User s Guide and Reference Oracle Management Server release 9 0 1 Oracle Management Server is the middle tier of Oracle Enterprise Manager It provides centralized intelligence and distribution control between clie
46. Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Starter Database Contents Unlocking and Resetting Passwords Manually To manually change a password and unlock an account review the list of default administrative user names passwords and functions in Table 5 1 Default User Names and Passwords Select a user and then unlock and reset the password by using the following commands 1 Start SQL Plus and log in as SYSDBA by using the following commands sqlplus nolog SQL connect as sysdba 2 Change the password by using the following command SOL ALTER USER USERNAME IDENTIFIED BY PASSWORD ACCOUNT UNLOCK The alter statement will both reset the password and unlock the account Note If you want unauthenticated access to your data via HTTP then unlock the ANONYMOUS user account See Also Oracle9i Database Administrator s Guide for more information on unlocking passwords after installation and for information on Oracle security procedures and best security practices Oracle Enterprise Manager Administrator s Guide for more information on using Oracle Security Manager or Oracle DBA Studio to change passwords Reviewing User Names and Passwords All databases that are created by Database Configuration Assistant include the SYS SYSTEM and DBSNMP user names and passwords In addition Oracle Corporation provides several other administrative users Unlock users and reset passwords before using t
47. ORACLE Oracle9i Installation Guide Release 2 9 2 0 2 for hp OpenVMS Alpha Part No B10508 01 December 2002 Oracle9i Installation Guide Release 2 9 2 0 2 for hp OpenVMS Alpha Part No B10508 01 Copyright 2002 Oracle Corporation All rights reserved Primary Author Platform Technologies Division Contributors John Dewitt Grant Hayden Steve Holck Pierre Krabbendam Kevin O Rourke Sam Ravindhran David Robles Regina Rohr Kannan Vishwanathan The Programs which include both the software and documentation contain proprietary information of Oracle Corporation they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright patent and other intellectual and industrial property laws Reverse engineering disassembly or decompilation of the Programs except to the extent required to obtain interoperability with other independently created software or as specified by law is prohibited The information contained in this document is subject to change without notice If you find any problems in the documentation please report them to us in writing Oracle Corporation does not warrant that this document is error free Except as may be expressly permitted in your license agreement for these Programs no part of these Programs may be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose without the express written permission of Orac
48. Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Adding or Upgrading Products Names of the Oracle database users Privileges and roles granted to each user Names and definitions of schema objects including tables views snapshots indexes clusters synonyms sequences procedures functions and packages Integrity constraints Space allocation for database objects Auditing information such as who accessed or updated various objects See Also Oracle9i Concepts and Oracle9i Database Reference for more information about data dictionary Adding or Upgrading Products This section includes Preparing to Add a Product Adding a Product Summary Preparing to Add a Product Before you add or upgrade a product perform the following steps 1 2 3 Verify that your system has Oracle9 installed Log onto your HP OpenVMS Alpha machine Run the following ORAUSER file for your database set default Oracle Home orauser sid If you plan to upgrade any Oracle product tables change the Oracle SYSTEM password to MANAGER Note If you do not change the Oracle SYSTEM password to MANAGER your installation may fail Oracle installation scripts often assume that the password is MANAGER Alternatively you can check for hard coded user names and passwords in the Oracle scripts and change them to your own user names and passwords Post Installation 5 27 Adding or Upgrading Products
49. S 2 Release Information This chapter provides information specific to this release of Oracle9i for HP OpenVMS The following sections are included Product Set on page 2 2 Changes and Enhancements on page 2 2 Known Restrictions on page 2 6 Release Information 2 1 Product Set Product Set The following components are included on the product CD ROM Oracle9j Release 2 9 2 0 2 Oracle Net Release 2 9 2 0 2 Changes and Enhancements In order to take full advantage of the latest OpenVMS CPU and compiler optimizations in Oracle software products Oracle9i Release 2 9 2 0 2 and associated Oracle9i Release 2 based products will require HP OpenVMS AlphaServers with EV56 or later generation CPUs AlphaServers with earlier generation CPUs will see a performance degradation Refer to Note 181307 1 on MetaLink for a list of affected models and for instructions on how to identify the CPU model number The following changes and enhancements are unique to this release of Oracle9i for HP OpenVMS 2349006 CHANGE CALL TO SYS CREPRC TO HAVE PRC M_IMGDMP SET In releases prior to Oracle9i Release 2 9 2 0 2 when one of the background processes terminated abruptly with an access violation no useful information was readily available regarding the cause for termination For troubleshooting certain actions needed to be taken and the crash needed to be reproduced Starting with this release by default an image dump
50. S Guide to Extended File Specifications PRIOR to changing the structure of any disk This guide discusses ODS 2 and ODS 5 formats in much more detail and has important information that you must understand and follow Oracle Note 205630 1 can be viewed at Oracle MetaLink Alternatively use the search function and search for ODS 5 for more information Precautions a Do not change the format of any VMS disk without first making a backup of the disk a Conversion from ODS 2 to ODS 5 does not require you to restore files Conversion from ODS 5 to ODS 2 does require you to restore files Contact Hewlett Packard for more information on reverting back to ODS 2 format from ODS 5 format Release Information 2 3 Changes and Enhancements Checking Disk Format To check the current disk format use the following DCL command SHOW DEVICE FULL device name The Volume Status will display the current ODS level The default when initializing disks is ODS 2 Changing Disk Format If you plan to reformat an existing in use disk from ODS 2 to ODS 5 format then do the following 1 Make at least one VMS backup of the disk 2 Use the Set Volume command SET VOLUME STRUCTURE LEVEL 5 lt device name gt Example SET VOLUME STRUCTURE LEVEL 5 2 DKC100 Formatting a New Disk If you plan to use a new empty disk then use the Initialize command to format the new disk to ODS 5 format as follows INITIALIZ
51. S tablespace described 5 23 DSS B 2 E enterprise rsp files 1 19 environment requirements 3 19 F file systems requirements 3 3 files installActions log 4 8 Oracle Universal Installer log files 4 8 oralnstloc 3 2 permissions for creation 3 16 response files 4 11 setting permissions for creation 3 18 supported file systems 3 3 G general purpose database See database environments 1 4 GENPARAMS parameter 3 15 global database name defined 5 22 groups OSDBA and OSOPER 5 12 H hardware memory 1 8 requirements 1 8 home directory 3 17 identifiers process rights 3 10 images described 1 10 removing 5 29 INDX tablespace described 5 23 INDX01 DBF data file 5 23 tablespace contained in 5 23 initialization parameter file description 5 25 in database 5 25 init ora 5 25 initialization parameters desupported 2 5 obsolescent 2 5 Initialize command formatting a new disk to ODS 5 2 4 installActions log file 4 8 installation aborted 4 11 character mode 3 2 cleaning up 4 11 non interactive 3 2 4 11 described 4 11 response files 4 11 oracle software owner 3 16 post installation tasks 5 1 pre installation tasks 3 1 requirements environment 3 19 Optimal Flexible Architecture 3 3 installation types with Oracle9i A 2 with Oracle9i Client A 8 with Oracle9i Enterprise Edition A 2 with Oracle9i server A 2 installing procedure requirements 3 4 i
52. SYMBOL If defined this system logical name provides information for troubleshooting the CGI environment by dumping all of the symbols and logicals job process for a given CGI Use with APACHE DEBUG_DCL_CGI APACHESPREFIX DCL CGI SYMBOLS WWW If defined this system logical name prefixes all CGI environment logical symbols with WWW By default no prefix is used APACHESCREATE SYMBOLS GLOBAL If defined this system logical name causes CGI environment symbols to be defined globally They are defined locally by default D 22 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS Table D 2 Oracle HTTP Server Logical Names and Their Descriptions Logical Name Description APACHES CGI USE DCLCOM FOR IMAGES If defined this system logical name forces CGI images to execute within a DCL process The default is to execute CGI images directly Note Direct execution of CGI images in not currently supported APACHES DL NO UPPERCASE FALLBACK If defined to be true 1 T or Y this system logical name disables case insensitive symbol name lookups whenever case sensitive lookups fail See APACHES DL FORCE UPPERCASE APACHES DL FORCE UPPERCASE If defined to be true 1 T or Y this system logical name forces case sensitive dynamic image activation symbol lookups By default symbol lookups are first done in a case sensitive manner
53. Scripts sse eene nennen D 29 suEXEC Not Available for Protecting Script Execution sss D 29 Open Source Licerses oi a e ege tee male nei ome ime ndo vot mae D 29 Apache e RAS D 29 Index viii Send Us Your Comments Oracle9i Installation Guide Release 2 9 2 0 2 for hp OpenVMS Alpha Part No B10508 01 Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this publication Your input is an important part of the information used for revision Did you find any errors a Is the information clearly presented Do you need more information If so where Arethe examples correct Do you need more examples What features did you like most about this manual If you find any errors or have any other suggestions for improvement please indicate the chapter section and page number if available You can send comments to us at the following e mail address osdwrite_us oracle com If you would like a reply please provide your name address and telephone number If you have problems with the software please contact your local Oracle Support Services Purpose Audience Preface This guide and the Oracle9i Administrator s Reference Release 2 9 2 0 2 for hp OpenVMS Alpha provide instructions for installing and configuring Oracle9i Release 2 9 2 0 2 on hp OpenVMS Alpha systems Documentati
54. T APACHESROOT CONF HTTPD CONF then the server would open the clusterwide file but save it as a system specific version The latest version of HTTPD CONF would then be visible only to the individual node on which it was saved Within HTTPD CONF itself you should make this distinction whenever you refer to a path or to a filelocation This improves performance and ensures that the server will return a complete directory listing For example you should specify APACHESCOMMON or APACHESSPECIFIC instead of APACHE ROOT with Directory directives The following extract from the HTTPD CONF file refers to APACHESCOMMON because the content for the default web page is in the clusterwide directories DocumentRoot apache common htdocs Directory apache common htdocs Options Indexes FollowSymLinks Multiviews AllowOverride None Order allow deny Allow from all Directory If there were content for one specific node in a cluster the APACHESSPECIFIC logical name would be used Mixed Architecture Cluster In a mixed architecture cluster do not use a cluster alias IP address with the Oracle HTTP Server Because the VAX systems will not have the Oracle HTTP Server running they will not be able to service HTTP requests Common Gateway Interface CGI Common Gateway Interface CGI programs execute within the DCL shell on the Oracle HTTP Server for OpenVMS Please note the following OpenVMS specific information D 24 Oracle9i In
55. aded even in silent mode a silent installation still requires an X connection The following sections contain examples that illustrate the use of silent mode DBCA Silent Mode Example 1 Creating a Clone Database To create a clone database enter the following into SYS SCRATCH DBCA ARGS silent createDatabase templateName Transaction Processing dbc gdbname ora9i sid ora9i datafileJarLocation disk disk1 oracle9i ora9i assistants dbca templates datafileDestination disk disk1 oracle9i ora9i oradata responseFile NO VALUE characterset WE81S08859P1 Note Either VMS style arguments or UNIX style arguments may be used in the arguments that are contained in an argument file Then assuming that the ORACLE HOME environment is set up by executing lt ORACLE_HOME gt orauser invoke DBCA Log files are located in the same place as with an interactive install In this example Disk disk1 oracle9i ora9i admin ora9i create Also check the ORACLE HOME assistants dbca logs directory DBCA Silent Mode Example 2 Creating a Seed Template To create a seed template enter the following into SYS SCRATCH DBCA ARGS silent createCloneTemplate sourceDB ora9i sysDBAUserName sys sysDBAPassword change_on_install Post Installation 5 3 Database Configuration Assistant DBCA templateName copy of ora9i datafileJarLocation disk disk1 oracle9i ora9i assistants dbca templates Then as
56. al or external CD ROM drive 200 MB C 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS System Requirements for Oracle Transparent Gateway Table C 2 RMS Gateway Requirements Cont Hardware Software Requirements Operating System Operating System Patch Oracle Net Requirements Oracle Database Server Oracle Networking RMS HP OpenVMS 7 3 Use the latest patch kit from Hewlett Packard Hewlett Packard provides patch information at http www compaq com support Oracle Net on HP OpenVMS is developed and certified using Hewlett Packard TCP IP Services for OpenVMS UCX If you wish to use the TCP IP protocol adapter for Oracle Net then you should have version 5 1 ECO 4 or higher of TCP IP Services for HP OpenVMS Alpha installed TCP IP protocol stacks from other vendors may work with Oracle software but customers use these products at their own risk Any TCP IP problems that cannot be reproduced using TCP IP Services for HP OpenVMS Alpha will be referred to the TCP IP vendor Vendor provided protocol services are usually upward compatible so that existing applications will continue to work without modification Thus later releases of TCP IP are upward compatible with Oracle Net provided that the vendor specified Application Programming Interface APT does not change with new releases Oracle9i Enterprise Edition server release 2 9 2 0 2 0 Oracle database server can
57. alization parameters using server parameter file and Automatic Undo Management Automatic installation and configuration of Oracle Options and interMedia a Advanced Replication capabilities Database configuration of dedicated server mode Archiving mode of NOARCHIVELOG Transaction Processing option If you select this option then the Database Configuration Assistant creates a preconfigured ready to use OLTP database Data Warehouse option If you select this option then the Database Configuration Assistant creates a database that is fully enabled for data warehousing applications Customized installation option If you select this option then the Database Configuration Assistant guides you in creating a fully customized database You can choose to automatically or manually configure options Oracle Text components and advanced replication Select this option only if you are experienced with advanced database creation procedures You will need to customize some or all of the following settings or parameters Data control and redo log file settings a Tablespace and extent sizes Database memory parameters a Archiving modes formats and destinations a Trace file destinations a Character set values 1 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Installation With Existing Oracle Databases a Software Only option If you select this option then the Oracle Universal Installer OUI
58. an OUI installation is performed on a particular system The inventory is then detected and referenced during subsequent installation sessions The log file of the most recent installation is oralnventory location logslinstallActions log Previous installation log files use the following log file name format installActionsdate time log For example installActions2001 02 14 09 00 56 am log 4 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle Universal Installer Caution Do not delete or manually alter the oraInventory directory or its contents Doing so can prevent the Oracle Universal Installer from locating products that you install on your system The make 10g file in the ORA ROOT install directory contains a log of every make file action that is executed during the installation process The make 10g file also records any link errors during installation Do not delete or alter the make log file Installing Real Application Clusters Because the disk on which the Oracle software will be installed is mounted cluster wide and is therefore accessible from multiple nodes installing Real Application Clusters RAC on OpenVMS is no different than installing non RAC except for the screen in OUI Oracle Universal Installer on which you are presented the option For complete details about configuring RAC refer to the generic documentation The following steps are taken after the softwa
59. and Installation Specific Issues and Restrictions Installation Procedure Requirements HP OpenVMS Alpha SYSGEN Parameters HP OpenVMS Alpha System Configuration Setup Tasks to Perform as the SYSTEM User Setup Tasks to Perform as the Oracle User Setup Tasks for Oracle Products CD ROM Pre installation Requirements 3 1 HP OpenVMS and Installation Specific Issues and Restrictions HP OpenVMS and Installation Specific Issues and Restrictions The following issues and restrictions can affect the installation or use of Oracle9i on HP OpenVMS Alpha Re installing Oracle9 Release 2 9 2 0 2 If you re install Oracle9i server into an ORACLE HOME where Oracle9i server Release 2 9 2 0 2 is already installed then you must also re install any product options such as Oracle Partitioning that were enabled before you began the re installation New ORA ROOT Do not install Oracle9i Release 2 9 2 0 2 into the root directory of an existing Oracle installation containing any Oracle Software Oracle Corporation recommends that you install Oracle9i Release 2 9 2 0 2 products into a new ORA ROOT Java Runtime Environment JRE The JRE that is shipped with Oracle9i is used by Oracle Java applications such as the Oracle Universal Installer and is the only Java application that is supported to run with these applications Customers must not modify this JRE unless it is done through a patch provided by Oracle Support Services The invento
60. at the following web site http www oracle com support metalink Use your Support Access Code SAC number to register Products and Documentation For U S A customers Oracle Store is at the following web site http store oracle com Links to Stores in other countries are provided from this site XV xvi Product documentation can be found at the following web site http docs oracle com Customer Service Global Customer Service contacts are listed at the following web site http www oracle com support Education and Training Training information and worldwide schedules are available from the following web site http education oracle com Oracle Technology Network Register with the Oracle Technology Network OTN at the following web site http technet oracle com OTN delivers technical papers code samples product documentation self service developer support and Oracle key developer products to enable rapid development and deployment of applications built on Oracle technology Support for Hearing and Speech Impaired Customers Oracle Corporation provides dedicated Text Telephone TTY access to Oracle Support Services within the United States of America 24 hours a day 7 days a week Fortechnical questions call 1 800 446 2398 For non technical questions call 1 800 464 2330 1 Oracle9 Installation Planning This chapter describes the Oracle9 installation types and configurati
61. ation sese eee 4 11 Cleaning Up After a Failed Installation eesseeeeee eee ee nennen 4 11 Post Installation Database Configuration Assistant DBCA sssssssssseseeeeeeee enne nnne 5 2 Interactive Mode eee eee ee ee ee E e deemed ms 5 2 Non interactive Mode n dee aede tiec bee Lee i ERE Eae Ec Eee Ete de red 5 2 Using DBCA Response Piles iss it iieri pb rodar eese ete te iode eee dhs 5 4 Wiser Pass words cc enn AER UU quee eie RE VR et ME Ue 5 12 Configuration Tasks to Perform as the System User esses 5 12 Configuration Tasks to Perform as the Oracle User sess eee 5 13 Set Initialization Parameters issii rinira nre aoia i i ia a ASEE 5 13 Post Installation for Oracle Products essere eene 5 14 Oracle N t cc e e a egi ac e idc qd ted aqua eg 5 14 Oracle Options here terne tete tiem e Pen edens reete ede eth rene 5 15 SharediSeEtVer ac ie e e BR IRR or em Ree de 5 15 Oracle Precompilers 42 uertit tere tette inhaeret De irte ein re e n e 5 16 Oracle Supported Protocols cccccccescscsssessetesescecesesesesnansseseseeseseseseecenesesesesnaneneseeceneseseseaneney 5 17 Starter Database Contents ence sede e Re e Pe ERR EISE eee des 5 18 Unlocking and Resetting User Passwords sse eee 5 18 Reviewing User Names and Passwords eee eee 5 19 Identifying Databases tee entered eti edt teet npe re rd ete eere 5 22
62. base then the Configuration Tools window appears followed by the Database Configuration Assistant window c When configuration is complete the End of Installation window appears From the End of Installation window you may exit or install additional products This window appears when your installation is complete You may choose to exit OUIor to begin another installation a Click Exit to end this session with OUI b Click Next Install to begin another installation without stopping and restarting the Oracle Universal Installer Installation 4 5 Oracle Universal Installer Installing Oracle9 Client 1 2 Log in as the Oracle user Start the Oracle Universal Installer from the CD ROM mount point directory at the SYSTEM directory level with the following command lt dden gt diskl runInstaller If the default temp directory SYS SCRATCH is not ODS 5 then you will need to use the scratchPath flag to specify an alternate temporary directory For more information about the use of ODS 5 format refer to Oracle9i Release 2 Dependency on ODS 5 Disk Structure on page 2 3 G ddcn diskl runInstaller scratchPath ODS5 temp dir After the Oracle Universal Installer starts the Welcome window appears a Click Next to continue the installation The Inventory Location window appears a If this is the first time that any Oracle9i products are installed on the current system then the Inventory Location
63. base Configuration Assistant DBCA Name TEMPLATENAME Datatype String Description Name for the new template Default value None Mandatory Yes TEMPLATENAME My Copy TEMPLATE createCloneTemplate section is used when CREATE TYPE is defined as createCloneTemplate createCloneTemplate Name SOURCEDB Datatype String Description The source database is the SID from which to create the template This database must be local and on the same ORACLE HOME Default value none Mandatory YES Name SYSDBAUSERNAME Datatype String Description A user with DBA role Default value none Mandatory YES Name SYSDBAPASSWORD Datatype String Description The password of the DBA user You can also specify the password at the command prompt instead of here 5 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Database Configuration Assistant DBCA Default value none Mandatory YES Name TEMPLATENAME Datatype String Description Name for the new template Default value None Mandatory Yes TEMPLATENAME My Clone TEMPLATE Name DATAFILEJARLOCATION Datatype String Description Location of the data file jar Valid values Directory where the new compressed datafile jar will be placed Default value SORACLE HOME assistants dbca templates Mandatory NO DATAFILEJARLOCATION Post Installation 5 11 Us
64. browsers might need more Excessive File Build Up A large number of LOG and PID files can amass over time in the directories APACHESROOT 0000000 and APACHES ROOT LOGS Purging these files can become a burden on application or system managers System managers should manually use explicit SET DIRECTORY VERSION commands on these two directories Apache Server Installation Configuration D 7 Running the Oracle HTTP Server on OpenVMS Customizing the Server Environment The installation procedure creates a file named HTTPD CONF and places it in APACHESROOT CONF The HTTPD CONF file stores information that the Oracle HTTP Server uses to set up the server environment HTTPD CONF has been tailored to use OpenVMS syntax but its overall functionality is essentially identical to HTTPD CONF on the UNIX platform HTTPD CONF contains an explanation for each line that it can execute You can refer to these explanations when customizing the file for your environment You can also refer to any generally available Apache documentation on HTTPD CONF Note the following about HTTPD CONF on OpenVMS MOD OSUSCRIPT has been added to enable CGI scripts that were originally written for the OSU server a UNIX style path names are recognized by OpenVMS You can use either UNIX style or OpenVMS style path names in the configuration file However you cannot intermix the two styles within a specification a n an OpenVMS Cluster you can
65. che http www openvms compaq com openvms products ips apache apache license txt This product also includes software that is developed by Hewlett Packard D 30 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Numerics 64 bit feature B 1 A account creating the oracle account 3 17 account privileges setting 3 8 account quotas minimum values 3 9 ADA version 1 12 Administrator disk space requirements 1 10 response file 1 19 administrators 5 12 authentication methods Kerberos 1 15 Secure Socket Layer 1 15 AUTHORIZE utility 3 5 3 6 AUTOGEN 3 15 AUTOGEN utility 3 15 automating startup and shutdown 5 13 Big Oracle Blocks B 3 BOB B 3 C CATNSNMP SQL file capabilities 5 20 Index changes and enhancements 2 2 character mode issues and restrictions 3 2 clientadmin rsp file 1 19 clientcustom rsp file 1 19 clientprogmr rsp file 1 19 commands Isnrctl 3 20 runInstaller starting 4 3 4 6 umask 3 18 compatibility issues 1 13 configuration restrictions 1 15 control files CONTROLO1 CTL 5 26 CONTROLO2 CTL 5 26 CONTROLO3 CTL 5 26 CTXSYS user name database roles 5 20 described 5 20 password 5 20 D data dictionary described 5 26 data files defined 5 23 DRO1 DBF 5 23 INDX01 DBF 5 23 SYSTEMOI DBF 5 24 TEMP01 DBF 5 24 TOOLS01 DBF 5 24 USERSO1 DBF 5 24 Index 1 database creation methods selecting 1
66. compilers Pro COBOL Pro C C Pro FORTRAN Oracle Supported Protocols Configuring a complete Oracle network is beyond the scope of this manual and is covered in detail in the Oracle9i Net Services Administrator s Guide and the Oracle9i Net Services Reference Guide Verify and complete your initial configuration with the following steps 1 Following installation check the status of the listener by using the command lsnrctl status listener name The 2istener name field is required if the listener has a name other than the default which is 1istener If the listener is not running then start it with the following command lsnrctl start listener name Install and configure Oracle client software on a remote system if necessary then start SOL Plus to test the connection to the server sqlplus username password net service name Note 1521 is the default port 5 14 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Post Installation for Oracle Products If you can successfully connect to the server with SQL Plus then you have established network connectivity over TCP IP For more advanced network configuration refer to the Oracle9i Net Services Administrator s Guide Oracle Options Oracle interMedia Note There is no upgrade from previous releases of ConText Cartridge to Oracle interMedia Text However there is a migration that can be performed manually See the O
67. d installs Secure Socket Layer See Also For more information about Oracle Advanced Security and system management products see the Oracle Advanced Security Administrator s Guide Note No additional authentication protocol software is required to relink Oracle products However Oracle Corporation does not provide the third party authentication servers Kerberos for example The appropriate authentication server for these protocols must be installed and configured separately Secure Socket Layer is provided and is always installed with Oracle Advanced Security Configuration Restrictions This section lists current restrictions for HP OpenVMS Alpha OracleQi Installation Planning 1 15 Oracle Net Linking Options Copying Oracle Executables Moving executables from one OpenVMS machine to another is not recommended due to the usage of shared libraries and to the difficulty of ensuring valid referencing Oracle Corporation therefore recommends that you relink executables Oracle Net Linking Options Keep the following guidelines in mind when linking Oracle Net The Net Mailbox Adapter IPC is always installed It provides inter process communications through OpenVMS Mailboxes The Mailbox Adapter can be used to connect an Oracle tool and the Oracle server but only if the tool and the server are on the same OpenVMS system Oracle Net TCP IP configurations are available for both OpenVMS clients and servers
68. deployment This deployment extends from Oracle Applications specific Concurrent Processing down through the middle tier to the database and node For more information refer to Getting Started with the Oracle Management Pack for Oracle Applications Oracle Tuning Pack release 9 0 1 The Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas such as application SOL indexing strategies instance parameters controlling I O SGA performance and object sizing placement and reorganization The applications that are included in the Oracle Tuning Pack are Oracle SOL Analyze Oracle Expert Outline Editor Outline Management Oracle Index Tuning Wizard Reorg Wizard and the Tablespace Map For more information refer to Database Tuning with the Oracle Tuning Pack Oracle Enterprise Manager Quick Tours release 9 0 1 These quick tours are HTML based training tools for learning Oracle Enterprise Manager products For more information refer to Oracle Enterprise Manager Administrator s Guide Oracle HTTP Server Powered By Apache release 1 3 12 0 3a Oracle HTTP Server Powered by Apache provides a pre configured ready to use listener Note Oracle HTTP Server replaces Oracle Application Server Listener For more information refer to Apache documentation Oracle9i Products A 15 Product Descriptions 7 Oracle Integration Server release 9 2 0 2 0 Oracle Integration
69. des the following Oracle s Java Runtime Environment version Oracle Utilities which includes the following Export Migration Utility Recovery Manager SOL Loader Oracle XML Developer s Kit A 6 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Database Components Oracle XML SQL Utility Oracle9i JVM which includes the following Java Virtual Machine Oracle9i Server the Oracle9i database which includes the following a Oracle Database Demos a PL SQL PL SQL Gateway a SQL Plus Oracle9i Products A 7 Oracle9i Client Components Oracle9i Client Components The following sections provide information on the Oracle9i Client components Runtime Edition This section alphabetically lists the components that are available with each installation type of the Oracle9i Client Runtime top level component Refer to the release notes for your platform for updates on component availability Advanced Queuing Documentation for your HP OpenVMS Alpha Oracle Advanced Security which includes the following Encryption and Integrity Support including DES40 Encryption DES56 Encryption 8DES 112 Encryption 2 key option 3DES 168 Integrity 3 key option MD5Integrity RC4 40 Encryption RC4 56 Encryption RC4 128 Encryption RCA4 256 Integrity SHA 1Integrity A 8 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Clie
70. documentation may contain links to Web sites of other companies or organizations that Oracle Corporation does not own or control Oracle Corporation neither evaluates nor makes any representations regarding the accessibility of these Web sites Oracle9i Standard Edition and Oracle9 Enterprise Edition Unless noted otherwise features and functionality described in this document are common to both Oracle9i Standard Edition and Oracle9i Enterprise Edition For the Latest Information For the latest information about Oracle9i and related products see the README files in the Oracle product directories Xii Install Only Licensed Products You are entitled to install and use only those products for which you have a current Oracle license agreement Typographic Conventions monospace brackets italics UPPERCASE Command Syntax Monospace type indicates OpenVMS DCL commands directory names usernames pathnames and filenames Words enclosed in brackets indicate key names for example Press Return Note that brackets have a different meaning when used in command syntax Italic type indicates a logical including logicals portions of filenames It is also used for emphasis Uppercase letters indicate Structured Query Language SQL reserved words initialization parameters and environment logicals HP OpenVMS Alpha command syntax appears in monospace font The character at the beginning of command examples sho
71. e 5 20 of ORDPLUGINS user name 5 20 of ORDSYS user name 5 20 of OUTLN user name 5 20 of SCOTT user name 5 21 of SYS username 5 21 of SYSTEM user name 5 21 rollback segments starter database 5 26 root user post installation tasks 5 12 runinstaller command 4 3 4 6 S SAVPARAMS parameter 3 15 scalability B 2 SCOTT user name database roles 5 21 described 5 21 password 5 21 Secure Socket Layer post installation tasks 5 17 requirements 1 15 security issues 3 12 See AlsoApache seed database See database environments 1 5 SERVICE_NAMES parameter 5 22 Set Volume command changing a disk to ODS 5 2 4 setting account quotas 3 9 account privileges 3 8 SGA protection 3 11 shared CORE 1 10 images 1 10 UPISHR 1 10 Shared Server post installation tasks 5 15 shutdown and startup 5 13 silent install See installation non interactive SQL Module 1 12 SQL Module Ada described A 24 Index 7 SQL Plus described A 25 SQL Plus Worksheet described A 25 SOLJ described A 21 SOLJ Runtime described A 21 standard rsp files 1 19 starting instances 3 12 startup and shutdown 5 13 svrcustom rsp file 1 19 SYS account 3 6 SYS user name database roles of 5 21 described 5 21 password of 5 21 SYSGEN parameters 3 13 SYSMAN 3 13 SYSTEM account 3 6 system parameters 3 13 summary of requirements 3 16 System Global Area initorafile 5 13 system identifier multiple Oracle homes 5 23
72. e OEM MONITOR role This role is created when the database is installed The role is defined in the following SOL script ora root rdbms admin catsnmp sql In addition to being granted the OEM MONITOR role users must have sufficient default tablespace quota within the monitored database in order for OEM to run and to evaluate some advanced events Failure to allocate sufficient tablespace to users that are granted the OEM MONITOR role will result in an insufficient privilege message The passwords are necessary only when the user resets and unlocks the passwords manually They are not required when it is done automatically Identifying Databases The Oracle9i software identifies a database by its global database name A global database name consists of the database name and network domain The global database name uniquely distinguishes a database from any other database in the same network domain Enter a global database name when prompted in the Database Identification window during Oracle9i database installation Example of a Global Database Name sales us acme com In the preceding example sales is the name of the database The database name portion is a string of no more than 8 characters that can contain alphanumeric and additional characters The database name is also assigned to the DB NAME parameter in the init ora file Also in the preceding example us acme com is the network domain in which the database is locat
73. e Remove button To complete the clean up you might need to manually remove the ORA ROOT directory Installation 4 11 Oracle Universal Installer 4 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS 9 Post Installation After completing the Oracle Universal Installer session you must perform certain post installation steps and you must configure Oracle9i This chapter contains the following sections User Passwords on page 5 12 Configuration Tasks to Perform as the System User on page 5 12 Configuration Tasks to Perform as the Oracle User on page 5 13 Post Installation for Oracle Products on page 5 14 Starter Database Contents on page 5 18 Adding or Upgrading Products on page 5 27 Relinking the Oracle Code on page 5 29 Note This chapter describes basic configuration only Refer to the Oracle9i Administrator s Reference Release 2 9 2 0 2 for hp OpenVMS Alpha and to the product administration and tuning guides for more sophisticated configuration and tuning information Post Installation 5 1 Database Configuration Assistant DBCA Database Configuration Assistant DBCA Interactive Mode To invoke DBCA Database Configuration Assistant in the interactive mode perform the following 1 Setup the X Windows environment by using the following DCL command SET DISPLAY CREATE TRANSPORT TCPIP NODE workstation name or IP address 2 Invoke lt ORACLE_HOME g
74. e not supported AgentLog AllowCONNECT Anonymous Anonymous Authoritative Anonymous LogEmail Anonymous MustCiveEmail Anonymous NoUserID Anonymous VerifyEmail AuthDBAuthoritative AuthDBGroupFile AuthDBMAuthoritative AuthDBMGroupFile AuthDBUserFile AuthDBMUserFile AuthDigestFile CacheDefaultExpire Apache Server Installation Configuration D 15 Running the Oracle HTTP Server on OpenVMS CacheDirLength CachedirLevels CacheForceCompletion CacheGcInterval CacheLastModifiedFactor CacheMaxExpire CacheRoot CacheSize CheckSpelling CookieExpires CookieTracking Example ExpiresActive ExpiresByType ExpiresDefault Header Metadir MetaFiles MetaSuffix MimeMagicFile MMapFile NoCache ProxyBlock ProxyDomain ProxyPass ProxyPassReverse ProxyReceiveBufferSize ProxyRemote D 16 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS ProxyRequests ProxyVia RefererIgnore RefererLog RewriteBase RewriteCond RewriteEngine RewriteLock RewriteLog RewriteLogLevel RewriteMap RewriteOptions RewriteRule ScriptInterpreterSource VirtualDocumentRoot VirtualDocumentRootIP VirtualScriptAlias VirtualScriptAliasIP Command Line Options This section describes the HTTPD command line options supported on the Oracle HTTP Server Before you can use them you must first define HTTPD as a symbol as follows HTTPD APACHESROOT 000000 APACHE_HTTPD EXE_ALPHA Then y
75. e of reserved memory may require rebooting the system During instance startup Oracle server compares the size of the reserved memory if any with the size of the SGA If appropriate one of the following messages will be included in the Alert log CD ROM Pre installation Requirements 3 13 HP OpenVMS Alpha SYSGEN Parameters Reserved memory size size greater than created SGA size lt size gt Please reduce reserved memory size to avoid wasting memory Memory was not reserved for the SGA SGA size size There might be performance advantages to allocating memory for the SGA in the VMS reserved memory registry If memory is reserved for an SGA but not enough memory is reserved then the instance startup willfail In this case the amount of reserved memory must be adjusted AUTOGEN must be run and the system must be rebooted For example to expand the SGA to 6 5 GB for the TEST instance use the following commands MCR SYSMAN SYSMAN RESERVED MEMORY REMOVE ORA TEST SGA SYSMAN RESERVED MEMORY ADD ORA TEST SGA SIZE 6656 ALLOCATE ZERO PAGE SYSMAN EXIT Then run AUTOGEN and reboot the system To avoid rebooting the system SYSMAN can be used to free the memory reservation Then you may start the instance The risk is that the system may not have enough fluid pages to create the SGA Also the performance advantages of using reserved memory are not available Additional Information Fo
76. e selected then the Oracle Universal Installer will install the starter database The following sections provide database administrative information on the default starter database as well as basic information on Oracle database usernames passwords and file locations a Unlocking and Resetting User Passwords heviewing User Names and Passwords Identifying Databases Tablespaces and Data Files Locating the Initialization Parameter File Locating Redo Log Files Locating Control Files Using Rollback Segments Using the Data Dictionary Unlocking and Resetting User Passwords Passwords for all Oracle system administration roles and privileges except SYS SYSTEM and SCOTT are expired upon installation You are required to unlock user names and to reset passwords for all other administrative user names before using them You can do this through Database Configuration Assistant DBCA Unlocking and Resetting Passwords Automatically During installation click the Password Management button from the Database Configuration Assistant window to change passwords immediately after installation An alternative method is available to reset your passwords If you unlock the password but do not specify a new password then the database user account will be unlocked and the password will remain expired until the next time that you log in as that user SQL Plus will then prompt you for a new password 5 18 Oracle9i
77. e teda 3 14 HP OpenVMS Alpha System Configuration sees eee eee nennen 3 16 Setup Tasks to Perform as the SYSTEM User s sss eee eene enne 3 16 Create an OpenVMS Account to Own Oracle Software sss 3 17 Create an OpenVMS Account to Own the Apache Server sss 3 17 Setup Tasks to Perform as the Oracle User sss een nens 3 18 Set Permissions for File Creation nece eremo rete reme dete dre a ee pea 3 18 oet DISplay zi dus n et ber etia nte E adc ette tice tete eA erat 3 19 Setup Tasks for Oracle Products sss eee nene 3 19 Pr compilers and Pools 1 oet nne dene nn eq ete m Seven e p epi ER epe eoe rinde 3 19 Network and System Management Products sse 3 20 Installation Installation Mount Options sese eene enne nennen nnne nennen 4 2 Installation Option Installing Oracle9i from the Hard Drive sss 4 2 Oracle Universal Inst llet eee etre rre ende etre renta EXE v Fee sects eee eee poe 4 3 Installing an Oracle9 Database sse enne e enne 4 3 Installing Oracle9 Client 2n rettet et ee teo te tede ted 4 6 Reviewing a Log of an Installation Session sss 4 8 Installing Real Application Clusters eese eene nen enne 4 9 Completing Installation of Oracle9i Server Enterprise Edition sess 4 11 Non Interactive Installation and Configur
78. e9i Database plans for the same SOL statements OUTLN acts Performance Guide and as a role to centrally manage metadata associated Reference with stored outlines 5 20 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Starter Database Contents Table 5 1 Default User Names and Passwords Cont User Name Password Description See Also SYS CHANGE ON INSTALL SYS is used for performing database Oracle9i Database administration tasks SYS includes the following Administrator s Guide database roles AQ ADMINISTRATOR ROLE AQ USER ROLE CONNECT CTXAPP DBA DELETE CATALOG ROLE EXECUTE CATALOG ROLE EXP FULL DATABASE HS ADMIN ROLE IMP FULL DATABASE JAVA ADMIN JAVADEBUGPRIV JAVAIDPRIV JAVAUSERPRIV OEM MONITOR RECOVERY CATALOG OWNER RESOURCE SELECT CATALOG ROLE SNMPAGENT TIMESERIES DBA TIMESERIES DEVELOPER SYSTEM MANAGER You can use SYSTEM to perform database Oracle9i Database administration tasks SYSTEM includes the Administrator s Guide AQ ADMINISTRATOR ROLE and DBA database roles SCOTT TIGER SCOTT includes the CONNECT and RESOURCE v Oracle9i Database database roles Administrator s Guide Post Installation 5 21 Starter Database Contents Note Any database user can be granted limited SYS role database privileges to use the Oracle Enterprise Manager Diagnostics Pack Grant users access to these necessary SYS privileges by granting them th
79. ed Together the database name and the network domain make the global database name unique The domain portion is a string of no more than 128 characters that can contain alpha numeric period and additional characters The domain name is also assigned to the DB DOMAIN parameter in the init ora file 5 22 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Starter Database Contents The DB NAME parameter and the DB DOMAIN name parameter combine to create the global database name value that is assigned to the SERVICE NAMES parameter in the init ora file The System Identifier SID identifies a specific Oracle9i database instance The SID uniquely distinguishes a database from any other database on the same computer Multiple ORACLE HOME directories enable you to have multiple active Oracle databases on a single computer Each database requires a unique SID and database name The SID name comes from the value entered for the SID prefix in the Database Identification window The SID can be up to 8 alphanumeric characters in length For example if the SID and database name for an Oracle database are ORCL each database file is in the ora root oradata orcl directory and the initialization parameter file is in the ora root admin orcl pfile directory The ORCL directory is named after the DB NAME parameter value Tablespaces and Data Files An Oracle9i database is divided into smaller logical areas of space
80. ents to JDBC calls For more information refer to Oracle9i SQL Developer s Guide and Reference Oracle Text release 9 2 0 2 0 formerly Oracle interMedia Text Oracle Text uses standard SQL to index to search and to analyze text and documents that are stored in the Oracle database in files and on the Web Oracle Text analyzes document themes and gists and it searches text using various search strategies It also renders search results in several formats and it analyzes and indexes most document formats with over 150 document filters Oracle Text supports approximately 39 languages It bulk loads documents in the database with SOL Loader For more information refer to Oracle9i Text Reference and Oracle Text Application Developer s Guide Oracle Text Manager release 9 0 1 Installed with Oracle Enterprise Manager Integrated Applications OracleText Manager is an application for managing Oracle Text functionality For more information refer to Oracle Enterprise Manager Concepts Guide Oracle Universal Installer OUI release 2 0 1 4 0 Oracle Universal Installer is a Java based application that lets you quickly install update and remove Oracle products For more information refer to Oracle9i Installation Guide and Oracle Universal Installer Concepts Guide Oracle9i Products A 21 Product Descriptions 28 Oracle Utilities release 9 2 0 2 0 Oracle Utilities consists of the following products for database administration
81. er environment The Diagnostics Pack provides discovery and graphical representation of targets such as databases or nodes automated collection of performance and resource usage data and central monitoring and administration of remote systems using intelligent agents For more information refer to Getting Started with the Oracle Diagnostics Pack 2 Oracle Standard Management Pack release 9 0 1 The Oracle Standard Management Pack combines the diagnostic tuning and change management functions of the Oracle Enterprise Manager Management Packs into one pack for smaller business enterprises that use the standard edition of the database such as Oracle8i or Oracle9i This pack monitors and diagnoses problems tunes high impact indexes and tracks and compares changes in the Oracle software environment The Oracle Standard Management Pack includes the following applications Oracle Performance Manager Oracle Index Tuning Wizard Oracle Create Baseline Oracle Compare Database Objects and Oracle Advanced Database and Node Events For more information refer to Getting Started with the Oracle Standard Management Pack A 14 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Descriptions 3 Oracle Management Pack for Oracle Applications release 9 0 1 The Oracle Management Pack for Oracle Applications extends Oracle Enterprise Manager to enable administrators to correlate all tiers of their Oracle Applications
82. er Passwords User Passwords Oracle Corporation recommends that you change the password for user names immediately after installation To change a password 1 Start SQL Plus by using the following command sqlplus 2 Connect with the user name and password that you want to change by using the following command Enter user name username password 3 Change the password by using the following command SQL gt ALTER USER USERNAME IDENTIFIED BY PASSWORD Configuration Tasks to Perform as the System User Log in as the system user and perform the following tasks D Create Additional OpenVMS Accounts D Automate Database Startup and Shutdown Optional 1 Set Initialization Parameters Create Additional OpenVMS Accounts If necessary create additional OpenVMS accounts with the AUTHORIZE utility Each DBA user on the system must be granted the ORA_DBA or ORA_ lt sid gt _DBA Rights Identifier Query the data dictionary view using SQL Plus to list the accounts in the default database Accounts in the database are based upon the products chosen in the Oracle Universal Installer SQL gt SELECT username from dba_users You should delete accounts that you do not need 5 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Configuration Tasks to Perform as the Oracle User Automate Database Startup and Shutdown Optional You can configure your system to automatically start Oracle databases when y
83. er s Increase this value for a heavy load process can use CHANNELCNT 256 FILLM and CHANNELCNT should be increased to match each other Apache Server Installation Configuration D 5 Running the Oracle HTTP Server on OpenVMS Table D 1 Sample Values for the ORACLE Account Cont Parameter Default On Hewlett Packard Web Server DIOLM NonPooled 150 300 Number of outstanding direct You might also need to increase the I O operations permitted to a SYSGEN parameter CHANNELCNT user s process because it limits BIOLM DIOLM and FILLM ENGLM Pooled 2000 2000 Specifies the lock queue limit FILLM Pooled 100 300 Number of files a user s process Increase this value for a heavy load can have opened at one time You might also need to increase the Includes the number of network SYSGEN parameter CHANNELCNT logical links that can be active at because it limits BIOLM DIOLM and the same time FILLM JTQUOTA Pooled 4096 8192 Byte quota for the job wide logical name table PGFLQUO Pooled 50000 250000 Number of pages the user s If you increase PGFLQUO you should process can use in the system monitor the free size of the system page page file and swap files they may need to be increased PRNumber of subprocesses a 8 20 user s process can createCLM You should increase this value for a Pooled h eavy load TQELM Pooled 10 610 Number of entries a user s Or BIOLM DIOLM 10 process can have in
84. ers For instructions on calculating MIN GBLPAGES MIN GBLSECTIONS and MIN MAXBOBMEM refer to the READMEVMS DCC in the RDBMS directory Using the Reserved Memory Registry Through its interface within the SYSMAN utility the Reserved Memory Registry allows an HP OpenVMS Alpha system to be configured with large amounts of memory set aside for use within memory resident global sections The AUTOGEN utility considers the pre allocated reserved memory when it tunes the system The advantages to reserving memory for an SGA are as follows a You can be certain that the memory is available and that the system is correctly tuned a The memory is reserved at boot time as contiguous aligned physical pages This allows the system to optimize the mapping of the SGA The memory is pre allocated and zeroed This results in faster SGA mapping and faster instance startup To reserve memory for an SGA use the SYSMAN utility The size qualifier is specified in megabytes For example to reserve memory for a 6 GB SGA for the SID named TEST use the following commands MCR SYSMAN SYSMAN RESERVED MEMORY ADD ORA TEST SGA SIZE 6144 ALLOCATE ZERO PAGE SYSMAN EXIT Note 1GB 1024 MB Then run AUTOGEN and reboot the system to allow AUTOGEN to adjust other system parameters for the reduced amount of memory that is available to the rest of the system Memory for multiple SGAs may be reserved Any change to the name or size of a piec
85. ers of this database type perform large numbers of concurrent transactions in which each transaction is a relatively simple operation that is processing a small amount of data Transactions consist of reading writing and deleting data in database tables Billing databases such as those commonly found on Internet commerce sites are the most common example of this database configuration These databases are also known as Online Transaction Processing OLTP databases 1 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Database Configurations Customized This environment allows you to create a customized database configuration of Oracle products that meets specialized requirements Select this option only if you are prepared to provide detailed product and database environment choices Choosing this option requires a longer installation session than choosing a preconfigured database Software Only This choice allows you to install Oracle products It does not configure the listeners or the network infrastructure and it does not create a database Oracle Corporation recommends that you install at least one preconfigured database to serve as a template for database configuration See Also Oracle9i Concepts Oracle9i Database Performance Tuning Guide and Reference and Oracle9i Real Application Clusters Setup and Configuration for more information on database environment issues Refer to Database
86. es SET SECURITY ACI Logical Names L IDENTIFIER yourFTPname ACCESS READ WRITE directory The Oracle HTTP Server for OpenVMS creates the following logical names which are listed with their descriptions in table Table D 2 Table D 2 Oracle HTTP Server Logical Names and Their Descriptions Logical Name Description APACHE COMMON Concealed logical name that defines clusterwide files in APACHE ROOT device APACHE APACHESFIXBG System executive mode logical name pointing to installed shareable images Not intended to be modified by the user APACHESHTTIPD SHR System executive mode logical name pointing to installed shareable images Not intended to be modified by the user APACHESINPUT Used by CGI programs for PUT POST methods of reading the input stream APACHESPLV ENABLE username System executive mode logical name defined during startup and used to control access to the services provided by the APACHE PRIVILEGED image Not intended to be modified by the user APACHESPLV LOGICAL System executive mode logical name defined during startup and used to control access to the services provided by the APACHE PRIVILEGED image Not intended to be modified by the user APACHESPRIVILEGED System executive mode logical name pointing to installed shareable images Not intended to be modified by the user APACHE ROOT System executive mode logical name defined during sta
87. es TEMPLATENAME New Database Name DATAFILEJARLOCATION Datatype String Description Location of the data file jar Valid values Directory containing compressed datafile jar Default value None Mandatory Yes when the clone template is used for database creation DATAFILEJARLOCATION Name CHARACTERSET Datatype String Description Character set of the database Valid values Check Oracle9i National Language Support Guide Default value US7ASCII Mandatory NO Name NATIONALCHARACTERSET Datatype String Description National Character set of the database Valid values UTF8 or AL16UTF16 For details Language Support Guide check Oracle9i National Mandatory Default value AL16UTF16 No Post Installation 5 7 Database Configuration Assistant DBCA NATIONALCHARACTERSET UTF8 Name REGISTERWITHDIRSERVICE Datatype Boolean Description Specifies whether to register with Directory Service Valid values TRUE FALSE Default value FALSE Mandatory No Name DIRSERVICEUSERNAME Datatype String Description Specifies the name of the directory service user Mandatory YES if the value of registerWithDirService is TRUE Name DIRSERVICEPASSWORD Datatype String Description The password of the directory service user You can also specify the password at the command prompt instead of here Mandatory YES if the value of registerW
88. fectively accommodate requests for larger amounts of data The 64 bit feature can benefit both query intensive DSS and read write OLTP transactions For DSS the database feature provides particular advantage for index builds full table scans ad hoc queries and multi way joins For OLTP the feature provides the ability to support very large tables large amounts of data and large numbers of users Implementation of the Oracle 64 bit Feature on HP OpenVMS Alpha Starting with release 7 3 2 3 2 HP OpenVMS Alpha supported the Very Large Memory VLM 64 bit feature The HP OpenVMS Alpha operating system has native 64 bit memory addressing which allows Oracle9i to implement the 64 bit feature The need to estimate the maximum System Global Area SGA at installation time is now eliminated and process startup times are faster The Server no longer includes an SGAPAD By default SGA creation uses the support which first appeared in the HP OpenVMS Alpha version 7 1 operating system that allows the creation of global B 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Suggested Parameter Settings sections that are not backed by any file These global sections are not pageable and do not require a backing file Suggested Parameter Settings 1 Big Oracle Blocks BOB provide the ability to support larger I O transfers between memory and disk BOB complements large SGA configurations because BOB allows the system
89. gent you must add the ORA AGENT ID identifier to your system before starting the installation Use the following command UAF ADD IDENTIFIER ORA AGENT ID All users that will submit jobs to the Intelligent Agent must have ORA AGENT ID Use the following command UAF GRANT IDENTIFIER ORA AGENT ID user name Security Issues with Multiple Databases If your site has several databases managed by different DBAs then you might not want to grant the CMKRNL privilege to every DBA Oracle9i account This privilege allows a DBA to activate any process rights identifiers and to install shared images For security reasons Oracle Corporation recommends that the OpenVMS system administrator handle these tasks This person should be responsible for starting Oracle9i instances from a controlled account with a UIC group greater than MAXSYSGROUP If this is not possible then at least one Oracle9i database administrator must have the CMKRNL privilege Completing Account Setup Exit the AUTHORIZE utility If the user account that you modified was logged on at the time then this user must log out and log back in before the changes take effect Verifying Privileges Use the following command to verify that your account has the correct privileges and rights identifiers SHOW PROCESS PRIVILEGE 3 12 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS HP OpenVMS Alpha SYSGEN Parameters HP OpenVMS Alpha SYSGEN Paramet
90. guration assistants can encounter display problems when run through the emulator One display problem is the sudden truncation of the main window when clicking the Next button during the installation rendering the screen unreadable Another display problem is that the expansion of an installer window can display the dialog buttons off the screen so that they are not selectable with a mouse If one of these display problems occurs then exit the entire X Windows session and start a new session Display problems exist in the AQ Database Information dialog box of the Oracle Applications InterConnect installation The last text field on this dialog box which prompts for Consumer Name appears truncated when viewed through Exceed This dialog box displays as expected when viewed through native X Windows on OpenVMS To correct any problems with hidden dialog fields perform the following steps 1 Select the xconfig application under the Exceed Program Group from the Windows Start Menu 2 Select the Fonts applet 3 Select the Font Database button in the Font Settings dialog box 4 Deselect the Automatic Font Substitution option in the Font Database dialog box 5 Select the Add button The Add Font Directory dialog box is displayed 6 Select the Server radio button in the Add Font Directory dialog box 7 Enter the host name for your machine in the Host Name field in the Add Font Server dialog box 8 Leave all other entries at t
91. he result is a COBOL program that you can compile and use to build applications that access an Oracle database Note This product requires a separate license as a part of Oracle Programmer For more information refer to Pro COBOL Precompiler Programmer s Guide 36 Pro FORTRAN release 1 8 76 and release 9 0 1 Pro FORTRAN takes SQL statements that are embedded in a FORTRAN program and converts them to standard FORTRAN code When you precompile this code the result is a FORTRAN program that you can compile and use to build applications that access an Oracle database Note This product requires a separate license as a part of Oracle Programmer For more information refer to Pro Fortran Supplement to the Oracle Precompilers Guide 37 SOL Module Ada release 9 2 0 2 0 SQL Module Ada takes SQL statements that are embedded in an Ada program and converts them to standard Ada code When you precompile this code the result is an Ada program that you can compile and use to build applications that access an Oracle database Note This product requires a separate license as a part of Oracle Programmer For more information refer to SOL Module for Ada Programmer s Guide A 24 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Descriptions 38 39 40 41 SQL Plus release 9 2 0 2 0 SQL Plus is a command line interface that enables you to use SOL and PL SQL
92. he total real memory requirement for the concurrent use of the gateway depends on the following factors a The SQL statement issued by the user The number of cursors currently opened against RDB a The number of columns in the table being accessed An internal or external CD ROM drive 200 MB HP OpenVMS 7 3 Use the latest patch kit from Hewlett Packard Hewlett Packard provides patch information at http www compaq com support Oracle Net on HP OpenVMS is developed and certified using Hewlett Packard TCP IP Services for OpenVMS UCX If you wish to use the TCP IP protocol adapter for Oracle Net you should have version 5 1 ECO 4 or higher of TCP IP Services for HP OpenVMS Alpha installed TCP IP protocol stacks from other vendors may work with Oracle but customers use these products at their own risk Any TCP IP problems that cannot be reproduced using TCP IP Services for HP OpenVMS Alpha will be referred to the TCP IP vendor Vendor provided protocol services are usually upward compatible so that existing applications will continue to work without modification Thus later releases of TCP IP are upward compatible with Oracle Net provided that the vendor specified Application Programming Interface APT does not change with new releases Oracle9i Enterprise Edition server release 2 9 2 0 2 0 Oracle database server can reside on any supported platform Oracle Transparent Gateway C 3 System Requirements for Oracle T
93. heir default settings 9 Select OK 10 Select Close on all dialog boxes to save the settings Installation Procedure Requirements This section provides installation procedure requirements 3 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Installation Procedure Requirements Oracle Server Database Administrator Account Create an HP OpenVMS Alpha user account to administer the Oracle9i Enterprise Edition installation and maintenance or modify your existing Oracle user account to meet the account quotas and privileges that are specified in this guide Setting up an Oracle9i account is the same as setting up any other HP OpenVMS Alpha user account The following are the steps to set up an Oracle9i account 1 2 3 Decide which values that you will supply to create the account Run AUTHORIZE to add a record in the User Authorization File UAF Use AUTHORIZE to set the following account requirements a Account quotas a Account privileges Process rights identifiers Exit AUTHORIZE to complete the account setup Note The Oracle9i account use of HP OpenVMS Alpha resources affects other user processes Before setting up an Oracle9i account you must thoroughly understand the reasons for changing system resources at your site Additional Information See the Hewlett Packard documentation for more information about running the AUTHORIZE utility Deciding Account Informa
94. hese administrative accounts Note To unlock administrative user passwords after installation click the Password Management button in the Database Configuration Assistant window Post Installation 5 19 Starter Database Contents Table 5 1 describes the default user names and passwords Table 5 1 Default User Names and Passwords User Name Password Description See Also CTXSYS CTXSYS CTXSYS is the Oracle Text user name with Oracle9i Oracle Text CONNECT DBA and RESOURCE database roles Reference DBSNMP DBSNMP DBSNMP includes the CONNECT RESOURCE Oracle Intelligent Agent and SNMPAGENT database roles Run User s Guide catnsnmp sql if you want to delete this role and user MDSYS MDSYS MDSYS is the Oracle Spatial and Oracle interMedia Oracle Spatial User s Locator administrator user name Guide and Reference ORDPLUGINS ORDPLUGINS ORDPLUGINS is the Oracle interMedia Audio and Oracle9i interMedia User s Video user name with the CONNECT and Guide and Reference RESOURCE roles ORDPLUGINS allows non native plug in formats ORDSYS ORDSYS ORDSYS is the Oracle interMedia Audio Video Oracle9i interMedia User s and Image administrator user name with Guide and Reference CONNECT JAVAUSERPRIV and RESOURCE database roles OUTLN OUTLN OUTLN includes the CONNECT and RESOURCE Oracle9i Database database roles and supports plan stability Plan Concepts stability allows you to maintain the same execution Oracl
95. ient release 9 2 0 The requirements for RMS are RMS release xxxxx where xxxxx is the complete version of OpenVMS that is listed as the supported version for the gateway Use the installation worksheet that is provided for your configuration to ensure that you have all required information before beginning installation The following sections describe system requirements for gateway configuration and provide worksheets to use during the installation a RDB Gateway Requirements a RMS Gateway Requirements a Tested Gateway Configurations Gateway Installation Worksheets Reference Documents Oracle Transparent Gateway for Rdb Administrator s Guide Release 9 0 1 on Alpha OpenVMS Oracle Transparent Gateway for RMS Administrator s Guide Release 9 0 1 on Alpha OpenVMS C 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS System Requirements for Oracle Transparent Gateway RDB Gateway Requirements Table C 1 describes the hardware and software requirements for an RDB gateway Use it to ensure that your system meets requirements to create a gateway for RDB Table C 1 RDB Gateway Requirements Hardware Software Requirements Processor Memory CD ROM Drive Disk Space Operating System Operating System Patch Oracle Net Requirements Oracle Database Server A HP Alpha workstation running the required version of OpenVMS 26 MB of real memory is recommended to support the gateway T
96. iguration window appears Select a database that is suited to your needs Click Next 8 The Database Identification window appears The Software Only option will not install the starter database If you choose this option the next step will use the Enable Real Application Clusters window step 12 Click Next 9 The Database Identification window appears a Enter the Global Database Name for this database Enter the system identifier SID Click Next 4 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle Universal Installer 10 11 12 13 14 15 The Datafiles Location window appears Entera path for the location of the data files Click Next The Database Character Set window appears choose the desired character set a Click Next The Enable Real Application Clusters RAC window appears Select YES if you wish to enable RAC The Summary window appears This window displays all of the options that have been chosen Click Install to proceed with the installation or click Previous to change your selections The Install window appears This window indicates installation progress Errors or warnings produce a dialog box where you can choose to fix and retry to ignore and continue or to abort a If you chose to install Software Only then the End of Installation window appears next b Ifyou chose to install a starter data
97. ileged Images The Oracle HTTP Server performs three operations that require additional privilege Binding to a port below 1024 privileged ports By default the server binds to port 8080 HTTP Fetching path information for other users The server provides a replacement for the getpwnam C RIL routine to allow the server to fetch default path information for other users required by MOD UTIL and MOD USERDIRE Apache Server Installation Configuration D 27 Security Information Changing the carriage control attribute on socket BG devices The server also enables or disables or both the carriage control attribute on BG socket devices for certain stream operations Two protected shareable images are installed at startup to allow the server to perform these functions a APACHE PRIVILEGED EXE exec mode services a APACHESFIXBG EXE kernel mode services The APACHE PRIVILEGED EXE image provides exec mode services for binding to privileged sockets and fetching user default path information Access to these services is limited to processes running under the ORACLE username and is controlled by the APACHESPLV ENABLE APACHESWWW logical name This logical name is defined as APACHESPLV ENABLE APACHESWWW 3 80 1023 The 3 80 1023 string represents three parameters where The first parameter 3 is a bit mask which enables or disables the two services Bit 0 controls binding to privileged ports a Bit 1 control
98. ilent installation still requires an X connection A silent installation can also be performed in BATCH mode as long as the process has established an X connection via the SET DISPLAY command OracleQi Installation Planning 1 17 Silent Mode Installation What Is a Response File A response file contains answers to installation questions that otherwise would be provided by the user in an interactive installation session Each answer is stored as a value for a variable that is identified in the response file For example values for ORACLE HOMEOr Install Type can be set automatically within the response file Response file templates are generated by the installation developer The response file template for the installation of your product can be found on your ship set CD ROM number 1 under the device Disk1 stage Response directory You should be able to find one for your choice of install type for example oracle server EE rsp for an Enterprise Edition server installation oracle server SE rsp fora Standard Edition or oracle client Runtime rsp fora client runtime installation Why Perform a Silent Installation Silent installations can be useful if you need to install an Oracle product multiple times on multiple computers or if you prefer not to use the GUI because of performance reasons over a slow remote X connection If the options that you select while installing on each computer are always the same then you
99. installs only Oracle9i software Database Configuration Assistant does not start after installation and no preconfigured database is installed If a choice other than Software Only option is selected for database configuration then OUI will launch DBCA Database Configuration Assistant during the installation session If a Software Only installation is performed then DBCA can be run later from the command line For more information on running Database Configuration Assistant from the command line refer to Non interactive Mode on page 5 2 For more information on database character sets refer to Oracle9i Database Globalization Support Guide Release 2 9 2 Installation With Existing Oracle Databases You can access different versions of Oracle on the same computer system at the same time using Oracle Net Services You can only access Oracle8i and Oracle9i databases separately You cannot submit a single query to access the databases simultaneously See Also Oracle9i Database Migration and Oracle9i Database Administrator s Guide for more information on compatibility and interoperability issues and on connecting different client versions to the database OracleQi Installation Planning 1 7 System Installation Requirements System Installation Requirements Verify that your system meets the requirements that are described in the following sections before you install Oracle9i products Note You will not be able to co
100. is feature Topics covered in this appendix are Introduction to the Oracle9i 64 bit Feature Suggested Parameter Settings a Other Recommendations Attention The 64 bit feature is a standard feature of Oracle9i for HP OpenVMS Alpha and cannot be de installed 64 bit feature tuning is under constant revision Therefore this information will be updated as further tuning suggestions are realized Oracle9i 64 bit Feature B 1 Introduction to the Oracle9i 64 bit Feature Introduction to the Oracle9 64 bit Feature This section includes the following information a Introducing the Oracle9i 64 bit Feature Benefits of the Oracle9i 64 bit Feature Implementation of the Oracle 64 bit Feature on HP OpenVMS Alpha Introducing the Oracle9 64 bit Feature The Oracle 64 bit feature provides the ability to support Very Large Memory VLM system configurations with large amounts of RAM Benefits of the Oracle9 64 bit Feature The primary benefit of the 64 bit feature is performance because many operations can now run at memory speed instead of disk speed With larger amounts of data in memory the database issues fewer calls to disk thus eliminating the delay of disk I O Oracle s 64 bit feature also provides the advantage of scalability to support larger number of users and larger amounts of data The system does not need to swap data in and out of memory to process all of the transaction requests and can more ef
101. ithDirService is TRUE Name LISTENERS Datatype String Description Specifies list of listeners to register the database with By default the database is configured for all the listeners specified in the SORACLE HOME network admin listener ora Valid values The list should be space separated names like listenerl listener2 Mandatory NO 5 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Database Configuration Assistant DBCA Name VARIABLESFILE Datatype String Description Location of the file containing variable value pair Valid values A valid file system file The variable value pair format in this file is variable value Each pair should be in a new line Default value None Mandatory NO createTemplateFromDB section is used when CREATE TYPE is defined as createTemplateFromDB createTemplateFromDB Name SOURCEDB Datatype String Description The source database from which to create the template Valid values The format is host port sid Default value none Mandatory YES Name SYSDBAUSERNAME Datatype String Description A user with DBA role Default value none Mandatory YES Name SYSDBAPASSWORD Datatype String Description The password of the DBA user You can also specify the password at the command prompt instead of here Default value none Mandatory YES Post Installation 5 9 Data
102. known as tablespaces Each tablespace corresponds to one or more physical data files Data files contain the contents of logical database structures such as tables and indexes You can associate each data file with only one tablespace and database Note Unless you specify different names with Database Configuration Assistant the tablespaces and data files that are described in the following table are automatically included in the Custom database Table 5 2 describes the tablespaces in the Oracle9i database that is located in the ora root oradata db name directory Table 5 2 Tablespaces and Data Files Tablespace Data File Contains EXAMPLE example01 dbf Example Schema DRSYS drsys01 dbf Oracle Text related schema objects INDX indx01 dbf Indexes associated with the data in the USERS tablespace Post Installation 5 23 Starter Database Contents Table 5 2 Tablespaces and Data Files Cont Tablespace Data File Contains SYSTEM system01 dbf The data dictionary This includes definitions of tables views and stored procedures needed by the Oracle database Note The database maintains information in this area automatically The SYSTEM tablespace is present in all Oracle databases TEMP temp01 dbf Temporary tables and or indexes created during the processing of your SQL statement Note You might need to expand this tablespace if you are executing a SQL statement that involves a lo
103. le Corporation If the Programs are delivered to the U S Government or anyone licensing or using the programs on behalf of the U S Government the following notice is applicable Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are commercial computer software and use duplication and disclosure of the Programs including documentation shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement Otherwise Programs delivered subject to the Federal Acquisition Regulations are restricted computer software and use duplication and disclosure of the Programs shall be subject to the restrictions in FAR 52 227 19 Commercial Computer Software Restricted Rights June 1987 Oracle Corporation 500 Oracle Parkway Redwood City CA 94065 The Programs are not intended for use in any nuclear aviation mass transit medical or other inherently dangerous applications It shall be the licensee s responsibility to take all appropriate fail safe backup redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes and Oracle Corporation disclaims liability for any damages caused by such use of the Programs Oracle is a registered trademark and PL SQL Pro C Pro C C Pro COBOL Pro FORTRAN Oracle7 Oracle8 Oracle8i Oracle9i Oracle Transparent Gateway and SQL Plus are trademarks or registered trademarks of Oracle Corpora
104. le JDBC Thin Driver for JDK 1 1 Oracle JDBC Thin Driver for JDK 1 2 Oracle JDBC OCI Driver for JDK 1 1 Oracle JDBC OCI Driver for JDK 1 2 Oracle Locale Builder Oracle Locator Oracle9i Products A 3 Oracle9i Database Components Oracle Net which includes the following a Oracle Net Listener Oracle Protocol Support Note When Oracle Net Client is installed by using the Enterprise Edition or Standard Edition installation type the Oracle Universal Installer installs Oracle Protocol Support for the networking protocols that it detects Oracle Partitioning Oracle Real Application Clusters Oracle Spatial a Oracle SQLJ which includes the following a SQLJ Runtime a SQLJ Translator a Oracle Text Oracle Trace Oracle Universal Installer which includes the following a Oracle s Java Runtime Environment version Oracle Utilities which includes the following Export Migration Utility Recovery Manager SQL Loader a Oracle XML Developer s Kit Oracle XML SQL Utility a Oracle9i Advanced Analytic Services Data Mining A 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Database Components SE List a Oracle9i JVM which includes the following Java Virtual Machine a Oracle9i Server the Oracle9i database which includes the following Oracle Database Demos PL SQL a PL SQL Gateway a SQL Plus This section alphabetically list
105. ler is run must have appropriate privileges to create a root level directory if the directory that was specified for ORACLE HOME does not already exist Note FROM LOCATION must be in UNIX style syntax Note ORACLE HOME must be on an ODS 5 disk To modify the response file 1 Make a copy of the response file for your product and open it in a text editor 2 Search for the three items that are listed above or for the string OPENVMS VALUE REQUIRED and provide values for those items 3 Modify other fields as applicable refer to comments within the response file that you are modifying List of Response File Names File Name Description enterprise rsp Enterprise Edition Installation of Oracle9i Server standard rsp Standard Edition Installation of Oracle9i Server custom rsp Custom Edition Installation of Oracle9i Server clientadmin rsp Administrator installation of Oracle9i Client clientruntime rsp Runtime installation of Oracle9i Client clientcustom rsp Custom installation of Oracle9i Client dbca rsp Database Configuration Assistant Invoking the Installer Setup the X Windows environment by using the following DCL command SET DISPLAY CREATE TRANSPORT TCPIP NODE workstation name or IP address lt path gt runiInstaller responseFile response file OracleQi Installation Planning 1 19 Silent Mode Installation 1 20 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVM
106. lt privileges for the Oracle9i database administrator account Note Anexception is explained in Security Issues with Multiple Databases on page 3 12 a CMKRNL a GROUP a GRPNAM a IMPERSONATE a LOG IO a NETMBX a OPER a PFNMAP a PRMGBL a PRMMBX a SHARE a SYSGBL a SYSLCK a SYSNAM a SYSPRV a TMPMBX a WORLD Note Appendix B Oracle9i 64 bit Feature has additional information that explains the meanings of the privileges Use the AUTHORIZE utility to set the account privileges for the Oracle9i database administrator account 3 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Installation Procedure Requirements At the UAF prompt use the MODIFY command to add the required default and authorized privileges as follows UAF gt MODIFY ORACLE9 PRIVILEGE CMKRNL NETMBX OPER PFNMAP PRMGBL PRMMBX SHARE SYSGBL SYSNAM TMPMBX GROUP GRPNAM IMPERSONATE LOG IO WORLD SYSLCK SYSPRV DEFPRIVILEGE CMKRNL NETMBX OPER PFNMAP PRMGBL PRMMBX SHARE SYSGBL SYSNAM TMPMBX GROUP GRPNAM IMPERSONATE LOG IO WORLD SYSLCK SYSPRV Setting Account Quotas Use the AUTHORIZE utility to change account quotas to accommodate the requirements of your Oracle9i installation Modifying the Default Quotas After adding a record with the default quotas use the MODIFY command to alter the default values The following example changes the Enqueue quota ENOLM from
107. mplete an installation if your system does not meet the minimum requirements for the Oracle products that you select lime Requirements Hardware Requirements Disk Space Requirements Images Operating System Software Requirements Additional Product Specific Installation Requirements Time Requirements Installation time varies depending on the number of products installed and the type of hardware used Duration of a typical installation takes approximately 1 to 3 hours Hardware Requirements Software needs to be installed on an ODS 5 formatted disk Refer to Oracle9i Release 2 Dependency on ODS 5 Disk Structure on page 2 3 for details Minimum Hardware Requirements Following is a list of the minimum hardware requirements to install Oracle9i products on an HP OpenVMS Alpha system Memory A minimum of 256 MB RAM is required to install Oracle9i products Oracle9i Client products require 192 MB of RAM 1 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS System Installation Requirements Minimum global pages sections an amount of disk space equal to twice the amount of RAM for most systems CD ROM Device A CD ROM drive supported by HP OpenVMS is required Oracle uses ODS 5 format CD ROM disks File System ODS 5 is required for the software Refer to Chapter 2 Release Information for details To determine the amount of random access memory RAM installed on your
108. mponents in the Oracle9i Client Runtime and also the following components which are listed alphabetically Refer to the release notes for your platform for updates on component availability a Advanced Queuing Documentation for your HP OpenVMS Alpha a Object Type Translator a Oracle Advanced Security which includes the following Encryption and Integrity Support including DES40 Encryption DES56 Encryption 3DES_112 Encryption 2 key option 3DES_168 Integrity 3 key option MD5 Integrity RC4 40 Encryption RC4 56 Encryption RC4 128 Encryption RC4 256 Integrity SHA 1 Integrity Oracle9i Products A 11 Oracle9i Client Components Thin JDBC Java based Encryption Support including DES40 Encryption DES56 Encryption MD5Integrity RC4 40 Encryption RC4 56 Encryption RC4 128 Encryption RC4 256 Integrity SHA 1 Integrity Authentication Support including Kerberos with SSO support SSL with X 509 version 3 with SSO support Note Kerberos is installable through the Custom installation Authentication Methods window Enterprise User Security including Oracle Wallet Manager Note Oracle Wallet Manager is a feature of Oracle Advanced Security You can only use it if you purchase an Oracle Advanced Security license a Oracle Call Interface Oracle Dynamic Services Server Oracle Enterprise Manager which includes
109. new SYSGEN parameters in a file named SETPARAMS DAT and runs the SYSGEN utility to set these parameter values as specified in that file See Also For more information about using the AUTOGEN utility see the OpenVMS System Management Utilities Reference HP OpenVMS Alpha System Configuration If your system fails to satisfy any listed requirement then perform the tasks listed in the next section as necessary to configure your system to meet these requirements Table 3 3 lists the requirements for installing Oracle9i on your HP OpenVMS system Table 3 3 HP OpenVMS Alpha System Configuration Summary System Factors Requirement for Oracle9 HP OpenVMS Alpha Parameters Minimum Global Pages Verify that the values for MIN GBLPAGES and Sections MIN GBLSECTIONS are greater than or equal to the values that were calculated for these parameters as documented in READMEVMS DOC OpenVMS Accounts You need an OpenVMS account that is dedicated solely to installing and upgrading Oracle products The instructions in this book are provided with the assumption that the account is called oracie9 Permissions for File Default Protections Creation Setup Tasks to Perform as the SYSTEM User Log inas the system user and perform the following tasks to set up your environment for Oracle9i 3 16 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Setup Tasks to Perform as the SYSTEM User C
110. ng any protocol verify that the underlying network is functioning and is configured properly To verify that the network is functioning properly transfer and retrieve a test file using the ftp utility by entering the following commands ftp remote server name ftp put test filename ftp get test filename 3 20 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS 4 Installation This chapter describes how to start the Oracle Universal Installer and how to install Oracle9i products on your system Review and complete the tasks that are listed in Chapter 1 Oracle9i Installation Planning and Chapter 3 CD ROM Pre installation Requirements before beginning the installation This chapter contains the following sections Installation Mount Options on page 4 2 Installation Option Installing Oracle9i from the Hard Drive on page 4 2 Oracle Universal Installer on page 4 3 Installation 4 1 Installation Mount Options Installation Mount Options Mount and Unmount the Oracle9i CD ROM If you run the Oracle Universal Installer while the current working directory is in the CD ROM then perform the following steps to mount the next CD ROM Mount the Oracle9i CD ROM device For example MOUNT OVERRIDE IDENTIFICATION lt ddcn gt where lt ddcn gt is a valid CD ROM device Note Oracle Corporation does not support using the Oracle Universal Installer that is shipped
111. noted previously refer to Oracle9i Release 2 Dependency on ODS 5 Disk Structure on page 2 3 the Oracle9i release 2 software must be installed on an ODS 5 formatted disk The datafiles and redolog files however can be placed on ODS 2 formatted disks as well Oracle9i server must be able to verify that files have been written to disk File systems that do not support this verification are not supported for use with Oracle databases although Oracle software can be installed on them Note Because of this requirement for verification third party software that creates one or more virtual disks in memory MUST NOT BE USED for datafiles Optimal Flexible Architecture Optimal Flexible Architecture OFA the Oracle standard set of configuration guidelines for Oracle databases is not supported on HP OpenVMS Alpha Using Hummingbird Exceed If you use the Hummingbird Exceed X Windows emulator while installing and using Oracle9i then set the window manager to run in Native mode so that Microsoft Windows functions as the window manager Refer to your Exceed documentation for instructions on configuring the window manager Following are common problems with the Hummingbird Exceed X Windows emulator CD ROM Pre installation Requirements 3 3 Installation Procedure Requirements Exceed does not handle screen coordinates correctly The Oracle Universal Installer window and related Oracle Universal Installer dialogs or confi
112. nstallation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Post Installation for Oracle Products PROTOTYPE INFO For precompiler PROTOTYPE INFO the configuration fileis xxxcfg cfg This file installs without content Use any text editor to customize it to your site requirements For more information on configuring the pmscfg cfg file refer to the SOL Module for Ada Programmer s Guide Note You cannot use Oracle Precompilers independently of Oracle9i to convert embedded PL SQL Oracle Supported Protocols All Supported Protocols Perform the following steps after installing any protocol 1 Verify that you have created and installed the necessary configuration files for the network 2 Start the listener on the server lsnrctl start lt listener name gt 3 Check the listener process lsnrctl status listener name 4 Asthe oracle user start SOL Plus to test the connection sqlplus username passworde service name Configuring the Secure Socket Layer For details on Secure Socket Layer refer to the Configuring Secure Socket Layer Authentication in the Oracle Advanced Security Administrator s Guide in the generic documentation set Post Installation 5 17 Starter Database Contents Starter Database Contents The starter database is a seed database that is shipped with the Oracle9i software It contains all that is needed in a general purpose environment If the starter database files ar
113. nstances account required to start 3 12 interMedia requirements 1 14 SYSTEM tablespace 5 15 interMedia Text data dictionary space requirements 1 14 5 15 issues and restrictions port specific 3 2 J Java Runtime Environment modifying cautions about 3 20 requirements 1 14 3 2 requirements for 3 20 JRE See Java Runtime Environment K Kerberos authentication requirements 1 15 L linking Oracle Net 1 16 LRS See Log roll forward server LRS B 1 Isnrctl command 3 20 Index 3 MAXSYSGROUP 3 6 MDSYS user name database roles 5 20 password 5 20 migrating existing Oracle databases 1 7 migration Oracle Data Migration Assistant 3 3 modifying system parameters 3 13 MRU B 4 multiple databases 3 12 multiple Oracle homes system identifier 5 23 N Net8 Configuration Assistant 5 14 non interactive installation 3 2 noninteractive installation See installation non interactive O OEM_MONITOR 5 22 OEMAGENT process rights 3 12 OLTP See transaction processing OLTP transactions B 2 OpenVMS system parameters 3 13 operating system configuration 3 16 requirements 1 11 Optimal Flexible Architecture installation issues and restrictions 3 3 Oracle Server DBA account 3 5 tools adding or upgrading 5 27 oracle account home directory 3 17 how to create how to create 3 17 post installation tasks 5 13 pre installation tasks 3 18 requirements 3 17 Index 4
114. nt Components Thin JDBC Java based Encryption Support including DES40 Encryption DES56 Encryption MD5Integrity RC4 40 Encryption RC4 56 Encryption RCA 128 Encryption RC4 256 Integrity SHA 1Integrity Authentication Support including Kerberos with SSO support SSL with X 509 version 3 with SSO support Note Kerberos is installable through the Custom installation Authentication Methods window Enterprise User Security including Oracle Wallet Manager Note Oracle Wallet Manager is a feature of Oracle Advanced Security You can only use it if you purchase an Oracle Advanced Security license Oracle Dynamic Services Server Oracle JDBC Drivers which include the following Oracle JDBC Thin Driver for JDK 1 1 Oracle JDBC Thin Driver for JDK 1 2 Oracle JDBC OCI Driver for JDK 1 1 Oracle JDBC OCI Driver for JDK 1 2 Oracle Net Oracle9i Products A 9 Oracle9i Client Components Oracle SQLJ which includes the following a SQLJ Runtime a SQLJ Translator a Oracle Universal Installer which includes the following a Oracle Java Runtime Environment version Oracle Utilities which includes the following Export Import Recovery Manager a SOL Loader a PL SQL A 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Client Components Administrator Edition Oracle9i Client Administrator includes the co
115. nts and managed nodes The Oracle Management Server relies on a database repository that maintains system data application data and the state of the managed targets that are distributed throughout the environment For more information refer to Oracle Enterprise Manager Administrator s Guide Oracle9i Products A 17 Product Descriptions 15 Oracle Names release 9 2 0 2 0 Oracle Names is a distributed naming service developed for Oracle environments to help simplify the setup and administration of global client server computing networks It establishes and maintains an integrated system of Names servers Oracle Names servers work like a directory service storing addresses for all the database services on a network and making them available to clients that want to make a connection For more information refer to Oracle Net Administrator s Guide 16 Oracle Net release 9 2 0 2 0 Oracle Net provides products that enable client connections to databases across anetwork A client side application sends a request to Oracle Net to be transported across the network to the server Oracle Net not Oracle Universal Installer installs TCP IP and Named Pipes For more information refer to Oracle Net Administrator s Guide 17 Oracle Net Listener release 9 2 0 2 0 Oracle Net Listener accepts connections through a protocol from client applications on the network Note Oracle Net Listener is not installable through any Oracle9i
116. oices of installation for different systems and environments Oracle9i Products for Installation During installation you are asked to choose one of two products These products are Oracle9i Database Oracle9i Client 1 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Installation Overview Oracle9i Database The Oracle9i Database is an object oriented relational database management system that consists of an Oracle database and an Oracle instance It may be installed in one of three installation types Enterprise Edition Standard Edition or Custom installation Enterprise Edition If you select this type then the Oracle Universal Installer installs a preconfigured starter database licensable Oracle options networking services and Oracle utilities The Enterprise Edition contains the set of products that are most commonly used for database environments Standard Edition If you select this type then the Oracle Universal Installer installs a preconfigured starter database networking services and Oracle utilities Custom If you select this type then the Oracle Universal Installer installs the products that you select from the Enterprise Edition and from the Standard Edition options Oracle9i Client The Oracle9 Client is a front end database application that connects to the database through one or more application servers Three client installation types are available Administrator R
117. omponents in the Standard Edition with the exception of the Oracle Enterprise Manager Standard Management Pack Refer to the release notes for your platform for updates on component availability Advanced Queuing Advanced Replication Character Set Scanner Common Schema Demos Object Type Translator which includes the following Oracle INTYPE File Assistant Oracle Advanced Security which includes the following Encryption and Integrity Support including DES40 Encryption DES56 Encryption 8DES 112 Encryption 2 key option S3DES 168 Integrity 3 key option MD5Integrity RC4 40 Encryption RC4 56 Encryption RC4 128 Encryption RCA 256 Integrity SHA 1Integrity A 2 Oracle89i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle9i Database Components Thin JDBC Java based Encryption Support including DES40 Encryption MD5Integrity RC4 40 Encryption RC4 56 Encryption RCA4 128 Encryption RC4 256 Integrity SHA 1 Integrity Authentication Support including Kerberos with SSO support SSL with X 509 version 3 with SSO support Enterprise User Security including Oracle Wallet Manager Note Oracle Wallet Manager is a feature of Oracle Advanced Security You can use it only if you purchase an Oracle Advanced Security license Oracle Call Interface Oracle Dynamic Services Oracle JDBC Drivers which include the following Orac
118. on for the products that are included with this software is in the Oracle9i generic documentation set Refer to important release information in Chapter 2 Release Information This document is intended for anyone responsible for installing Oracle9i Release 2 9 2 0 2 on OpenVMS Alpha systems Xi Documentation Accessibility Our goal is to make Oracle products services and supporting documentation accessible with good usability to the disabled community To that end our documentation includes features that make information available to users of assistive technology This documentation is available in HTML format and contains markup to facilitate access by the disabled community Standards will continue to evolve over time and Oracle Corporation is actively engaged with other market leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers For additional information visit the Oracle Accessibility Program Web site at http www oracle com accessibility Accessibility of Code Examples in Documentation JAWS a Windows screen reader may not always correctly read the code examples in this document The conventions for writing code require that closing braces should appear on an otherwise empty line however JAWS may not always read a line of text that consists solely of a bracket or brace Accessibility of Links to External Web Sites in Documentation This
119. one of the following tables that is appropriate for your system Use the values that you enter as a reference during the configuration process a RDB Gateway Worksheet a RMS Gateway Worksheet C 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS System Requirements for Oracle Transparent Gateway RDB Gateway Worksheet Enter your system values in the following Table C 3 to prepare for an RDB gateway configuration Table C 3 RDB Gateway Installation Worksheet Description Value Oracle database server machine name Oracle database server platform OS and its version number SORACLE HOME of Oracle database server full path name Gateway machine name Gateway machine platform OS and its version number SORACLE HOME of the gateway full path name Location of RDB database to which the gateway will connect RMS Gateway Worksheet Enter your system values in the following Table C 4 to prepare for an RMS gateway configuration Table C 4 RMS Gateway Installation Worksheet Description Value Oracle database server machine name Oracle database server platform OS and its version number SORACLE HOME of Oracle database server full path name Gateway machine name Gateway machine platform OS and its version number SORACLE HOME of the gateway full path name Oracle Transparent Gateway C 7 Ins
120. ons The following topics are included Oracle9i Installation Overview System Installation Requirements Product Dependencies Configuration Restrictions Oracle Net Linking Options OracleQi Installation Planning 1 1 Oracle9i Installation Overview Oracle9i Installation Overview The installation of Oracle9i products has five stages 1 Planning your installation Use this chapter to help you plan and prepare for your installation This chapter provides information about products installation types database configurations and concepts that you should be aware of during planning and installation Completing pre installation tasks Refer to the release notes for your platform and see Chapter 3 CD ROM Pre installation Requirements in this guide to complete pre installation tasks Installing software Use the Oracle Universal Installer that is provided on your CD ROM to install Oracle products requires DECWindows Motif Refer to Chapter 4 Installation Completing the post installation tasks Create database objects establish the user environment and configure the installed Oracle products for the local system Refer to Chapter 5 Post Installation Installing the clients If you want to install client tools applications and client interfaces that are not included on the Oracle9i CD ROM then check the requirements and instructions in the documentation for those products The following sections describe the ch
121. ons in section Completing RDB Gateway Installation on page C 9 Completing RDB Gateway Installation When the Summary screen appears click Install Verify that the installation was successful after the Oracle Universal Installer confirms that the installation has been completed Check the contents of the installActions log file located in the orainventory location logs directory Installation Prompts for RMS Gateway There are no installation prompts for the RMS gateway Removing Oracle Transparent Gateway Remove the gateway as follows 1 Start the Oracle Universal Installer 2 Click the De install Products button on the Welcome window or the Installed Products button that is available on any Oracle Universal Installer window The Inventory window appears and displays a list of installed products 3 Click to select the gateway product in the Inventory window and click Remove Only the files that were copied into the ORACLE HOME directory during the gateway installation are automatically removed You must manually remove all other related files Oracle Transparent Gateway C 9 Removing Oracle Transparent Gateway C 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS D Apache Server Installation Configuration This appendix lists the procedure and steps to install and configure Apache Server for HP OpenVMS Alpha The following topics are included Post Installation Checklist on page D 2
122. or HP Alpha OpenVMS C Oracle Transparent Gateway This chapter describes how to install the gateway software from the distribution CD ROM The following topics are included a System Requirements for Oracle Transparent Gateway Installing Oracle Transparent Gateway Removing Oracle Transparent Gateway Oracle Transparent Gateway C 1 System Requirements for Oracle Transparent Gateway System Requirements for Oracle Transparent Gateway Review your system hardware and software to ensure that it meets requirements and then determine gateway configuration before you install the gateway Gateway components can be located on one platform or distributed over several platforms Oracle Corporation supports the software configurations that are described in this section as long as the underlying system software products are supported by their respective vendors Verify the latest support status with your system software vendors These gateways are shippped on the server CD ROM and are built with Oracle libraries The operating system requirements for the gateways are therefore the same as that for the Oracle database Refer to Chapter 1 Oracle9i Installation Planning and Chapter 2 Release Information for the database requirements The requirements for Oracle networking on the gateway computer are Oracle Net Server release 9 2 0 The requirements for Oracle networking on the Oracle database server computer are Oracle Net Cl
123. orary directory For more information about ODS 5 format requirements refer to Oracle9i Release 2 Dependency on ODS 5 Disk Structure on page 2 3 lt ddcn gt diskl runInstaller scratchPath ODS5 temp dir a After the Oracle Universal Installer starts the Welcome window appears a Click Next to continue the installation 3 The Inventory Location window appears a If this is the first time that any Oracle9i products are installed on the current system then the Inventory Location window appears Enter a directory where the inventory of all installations will be kept Note This directory must be on an ODS 5 disk If this is not the first time any Oracle9i products are installed on the current system then go to the next step a Click Next to continue the installation Installation 4 3 Oracle Universal Installer 4 The File Locations Window appears Source You should not need to change the default This points to the installation files a Destination Name Enter a name to refer to your ORACLE HOME a Destination Path Enter the path of your ORACLE HOME Note ORACLE HOME must be on an ODS 5 disk Click Next 5 The Available Products window appears Choose Oracle9i Database Click Next to continue 6 The Installation Types window appears Choose an installation type Enterprise Edition Standard Edition or Custom Click Next 7 The Database Conf
124. oring functions are accessible through a Java based API Data Mining enables e businesses to incorporate predictions and classifications throughout all customer interactions and business processes For more information refer to Oracle9i Advanced Analytic Services Data Mining Administrator s Guide and Oracle9i Advanced Analytic Services Data Mining Concepts Oracle9i JVM Enterprise Edition release 9 2 0 2 0 The Oracle9i JVM includes Oracle Java Virtual Machine CORBA 2 0 Object Request Broker Machine embedded JDBC drivers SOLJ translator For more information refer to Oracle9i Java Developer s Guide Oracle9i Server release 9 2 0 2 0 Oracle9i Server is the database component of Oracle9i For more information refer to Getting to K Now Oracle9i Pro C C release 9 2 0 2 0 Pro C C takes SQL statements that are embedded in C and C programs and converts them to standard C code When you precompile this code the result is a C or C program that you can compile and use to build applications that access an Oracle database Note This product requires a separate license as a part of Oracle Programmer For more information refer to Pro C C Precompiler Programmer s Guide Oracle9i Products A 23 Product Descriptions 35 Pro COBOL release 1 8 76 and release 9 0 1 Pro COBOL takes SQL statements that are embedded in a COBOL program and converts them to standard COBOL code When you precompile this code t
125. ormation refer to Oracle9i Spatial User s Guide and Reference 23 Oracle Spatial Index Advisor release 9 0 1 installed with Oracle Enterprise Manager Integrated Applications This component helps to analyze and tune spatial indexes on data Use it to determine if indexes are properly defined for optimum query performance You can also use it to visually inspect the distribution of the data For more information refer to Oracle Enterprise Manager Concepts Guide A 20 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Product Descriptions 24 25 26 27 Oracle SQLJ release 9 2 0 2 0 Oracle SQLJ provides a standard method to embed SQL statements in Java programs Oracle SOLJ consists of the following components a Oracle SQLJ Runtime release 9 2 0 2 0 Installed with SQLJ Oracle SQLJ Runtime is a thin layer of pure Java code that runs above the JDBC driver When Oracle SQLJ translates your SQLJ source code using standard SQLJ code generation embedded SOL commands in your Java application are replaced by calls to the SOLJ runtime When you run the application the SQL runtime acts as an intermediary reading information about your SQL operations from your profile and passing instructions along to the JDBC driver b Oracle SQLJ Translator release 9 0 1 Installed with SOLJ Oracle SOL Translator is a preprocessor for Java programs that contain embedded SQL statements It converts the SOL statem
126. ort executed by each Oracle process If the value is too high the PGA will use excessive memory when sorting The default value 512 K is usually sufficient Oracle9i 64 bit Feature B 3 Other Recommendations Check statistics such as V SYSSTAT to see if the number of sorts to disk is high compared to in memory sorts If it is then increase the value of SORT AREA SIZE Other Recommendations Check the size in number of rows of the tables involved in the query and translate this size into total number of blocks Based on the query try to fit as many of the hard hit table blocks in DB BLOCK BUFFERS For example if there are four tables involved in the query but columns from one of the tables are used repeatedly in the where clause in joins in etc try to fit as many blocks from this table as possible into the cache to see if DB BLOCK BUFFERS can be increased To ensure the hard hit tables are cached and stay in the most recently used MRU end of the cache perform either of the following steps a Type using SOLPLUS alter table tablename cache Or a Atthe time of creation create table tablename cache If there are enough buffers to accommodate all blocks from all tables involved in the query use the alter command to cache all the blocks The purpose is to cache most blocks into memory to ensure that I O to disks is eliminated or remains low B 4 Oracle9i Installation Guide Release 2 9 2 0 2 f
127. ot needed on OpenVMS Refer to the Oracle9i Administrator s Guide section 1 5 3 for the list of parameters that are not supported on OpenVMS PORTAL With some limitations Oracle9i for HP OpenVMS with iAS mid tier with VMS back end database configuration is supported For information about iAS support contact http infodec_us oracle com The following items are not supported RAC Guard and RAC High Availability Extensions RAC Guard and RAC High Availability Extensions are not supported in this release due to the lack of cluster failover in the Operating System RAC Management Pack RAC Management Pack is not supported in this release LDAP LDAP OID is currently not supported This feature is a candidate for support in future releases iFS and Ultra Search iFS and Ultra Search are not supported due to the lack of third party software called INSO filter 2 6 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Known Restrictions EJB BEANS Oracle9i for HP OpenVMS does not support EJB on the server If customers have iAS in mid tier however they can still use the database on OpenVMS in order to use EJB Release Information 2 7 Known Restrictions 2 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS 3 CD ROM Pre installation Requirements This chapter describes the pre installation steps required for an Oracle9i software installation HP OpenVMS
128. ou can use the following format to enter a command line option HTTPD option where option is one of the following command line options v Displays the HTTPD version and its build date Apache Server Installation Configuration D 17 Running the Oracle HTTP Server on OpenVMS UY Displays the HTTPD base version its build date and a list of compile settings that influence the behavior and performance of the server h Displays a list of the HTTPD options 1 Displays a list of all modules compiled into the server LU Displays a list of directives with expected arguments and places where the directive is valid The following example shows how to enter the L option to list the available configuration directives HTTPD L Virtual Host Support The term virtual host refers to the practice of maintaining a single server to serve pages for multiple virtual hosts Both IP based and name based virtual host support are available on the Oracle HTTP Server for OpenVMS Note On OpenVMS the security profile of the running server is the same on all virtual hosts For more information see the Apache Software Foundation documentation at the following web site http www apache org docs vhosts index html Dynamic Shared Object Support Dynamic shared object support provides a method to format code so that it will load into the address space of an executable program at run time This functionality is suppo
129. our system starts up and to shut down Oracle databases when your system shuts down Automating database startup is optional but automatic shutdown is recommended because it guards against improper shutdown of the database Configuration Tasks to Perform as the Oracle User Perform the following task as the oracle user Set Initialization Parameters Modify init ora Parameters When you create a database your initsid ora parameters are automatically set You can manually modify the initialization parameters in the initsid ora with an OpenVMS editor Activate the modified initsid ora file by shutting down and restarting the database Do not use logicals in parameter files unless they are defined at an appropriate high level in other words at a group level or system level See Also Oracle9i Administrator s Reference Release 2 9 2 0 2 for hp OpenVMS Alpha for information on init ora parameters Post Installation 5 13 Post Installation for Oracle Products Post Installation for Oracle Products Perform the product specific steps as necessary for your installation Not all products require post installation setup It is not necessary to read product documentation before completing the configuration tasks in this manual but more sophisticated tuning requires information that is located in the product documentation The following products have post installation steps Oracle Net Oracle Net Oracle Options Oracle Pre
130. plete You may choose to exit OUIor to begin another installation a Click Exit to end this session with OUI b Click Next Install to begin another installation without stopping and restarting the Oracle Universal Installer Installation 4 7 Oracle Universal Installer Oracle9i Database Custom Installation When you select Custom Installation the Available Product Components window appears It displays all products and components that are available for installation A typical Custom installation configuration is selected Some actions that may differ from a standard installation are 1 Select the products that you want to install or deselect products want to install and click Next 2 Provide responses to any window prompts that appear by default that you do not With custom selection of products you may want to change default values for items such as port numbers product specific directory names or Rdb gateway attributes The Summary window appears Reviewing a Log of an Installation Session The Oracle Universal Installer creates the oraInventory directory the first time that it is run in order to keep an inventory of products that it installs as well as an inventory of other installation information The location of the OraInventory directory is defined in the Oral on your system Inst loc file which is located in the directory where OUI is run An inventory is created the first time that
131. prior experience tuning the performance of the OpenVMS operating system For general information on OpenVMS performance see the OpenVMS Performance Management Manual at the following URL http www openvms compaq com 8000 73 inal 6491 6491pro html Recommendations for improving performance on a Oracle HTTP Server are provided below and in the Release Notes Limits and Quotas The following table shows sample values for the ORACLE Account from a working and exercised Oracle HTTP Server with a light to moderate load These values are presented as an example of a system performing well within its context If you should experience performance difficulties refer to this table for guidelines in making adjustments For heavier loads we point out which values in our experience need to be increased as load increases Keep in mind that no one set of values will be appropriate for all situations Table D 1 Sample Values for the ORACLE Account Parameter Default On Hewlett Packard Web Server ASTLM NonPooled 250 610 Total number of asynchronous Or BIOLM DIOLM 10 system trap AST operations and scheduled wake up requests the user can have queued at one time BIOLM NonPooled 150 300 Number of outstanding buffered You might also need to increase the I O operations permitted for a SYSGEN parameter CHANNELCNT user s process because it limits BIOLM DIOLM and FILLM BYTLM Pooled 64000 200000 Amount of buffer space a us
132. product directories must exist before NLS message files can be copied into them Additional Product Specific Installation Requirements This section provides additional product specific information For descriptions of these products see Appendix A Oracle9i Products OracleQi Installation Planning 1 13 Product Dependencies List of the Restrictions and Requirements for Oracle9 and Options Product Name Restrictions and Requirements Oracle interMedia 9 2 0 2 0 You must have at least 10 MB of disk space available for the interMedia Text data dictionary Oracle Visual Information Retrieval 9 2 0 2 0 Requires Oracle interMedia 9 2 0 2 0 List of the Restrictions and Requirements for Tools and Precompilers Product Name Restrictions and Requirements Java Runtime Environment JRE JRE 1 1 8 5 Oracle9i JVM 9 2 0 2 0 This product includes Java Virtual Machine JVM and Java utilities See the Java README file on the Oracle9 CD ROM for restrictions and requirements Pro C C 9 2 0 2 0 C release 6 4 008 C release 6 3 020 Pro COBOL 1 8 75 DEC COBOL release 2 8 Pro COBOL 9 2 0 2 0 DEC COBOL release 2 8 Pro FORTRAN 1 8 75 DEC FORTRAN release 7 1 SQL Module Ada DEC Ada 3 5a23 Networking and System Management Products All network products require the underlying software and operating system libraries for the supported network The network software must be installed and running prior
133. questFields LimitRequestLine Listen ListenBacklog Location lt LocationMatch gt LogLevel MaxClients MaxKeepAliveRequests MaxRequestPerChild MaxSpareServers MinSpareServers NameVirtualHost Options PidFile Port Require ResourceConfig RLimitCPU RLimitMEM RLimitNPROC Satisfy SendBufferSize ServerAdmin ServerAlias ServerName ServerPath ServerRoot D 10 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS ServerSignature ServerTokens ServerTIype StartServers TimeOut UseCanonicalName User VirtualHost MOD ACCESS C allow deny order MOD ACTIONS C Action Script MOD ALIAS C Alias AliasMatch Redirect RedirectMatch RedirectTemp RedirectPermanent ScriptAlias ScriptAliasMatch MOD ASIS C MOD AUTH C AuthGroupFile AuthUserFile Apache Server Installation Configuration D 11 Running the Oracle HTTP Server on OpenVMS MOD AUTOINDEX C AddAlt AddAltByEncoding AddAltyByType AddDescription Addlcon AddIconByEncoding AddIconByType DefaultIcon FancyIndexing HeaderName IndexIgnore IndexOptions IndexOrderDefault ReadmeName MOD CGL C ScriptLog ScriptLogBuffer ScriptLogLength MOD DIR C DirectoryIndex MOD ENV C SetEnv UnsetEnv MOD IMAP C ImapBase ImapDefault ImapMenu D 12 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS MOD INCLUDE C MOD INFO C
134. r IDs different from the user ID of the calling web server This is not supported by the Oracle HTTP Server for OpenVMS All file formats are supported However the Web browser status bar will not show page loading progress for logical or VFC format files larger than 8 K Page loading progress relies on an accurate byte count Accurate byte count is not readily available for files in logical or VFC format For files in these formats the Oracle HTTP Server must count the bytes as the files load The counting process can slow performance so it has been turned off in this situation Apache Server Installation Configuration D 19 Running the Oracle HTTP Server on OpenVMS File Naming Conventions In general users who 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 style file names The ODS 5 volume structure introduced in HP OpenVMS Alpha Version 7 2 1 supports long file names allows the use of a wider range of characters within file names and preserves case within file names However the DEC C RTL that is shipped with HP OpenVMS Alpha Version 7 2 1 does not provide full support for extended file names on ODS 5 devices This lack of full support imposes certain restrictions on users running the Oracle HTTP Server for HP OpenVMS Alpha Because mixed UNIX style and Open VMS style extended file names are not yet supported by
135. r more information about the reserved memory registry refer to the Hewlett Packard documentation To review memory reservations on your node run the following command show memory reserved System Memory Resources on 13 JUL 2001 09 57 11 72 Memory Reservations Pages Group Reserved In Use Type ORA PROD SGA SYSGBL 5120 0 Allocated ORA PROD SGA SYSGBL 5 0 Page Table Total 40 04 Mbytes reserved 5120 0 Please consult Hewlett Packard if you need more information about reserving memory Using AUTOGEN Because SYSGEN parameters affect the entire operating system your system administrator is the only person who should modify them Of course at some sites 3 14 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS HP OpenVMS Alpha SYSGEN Parameters the DBA and system administrator may be the same person The instructions in this section are directed to the system administrator For setting or modifying SYSGEN parameters OpenVMS provides the AUTOGEN utility You can also use SYSGEN but this is an older utility and its use is discouraged except perhaps for checking current values You must have SYSPRV or BYPASS privilege to run these utilities AUTOGEN provides a permanent method for setting parameters and it documents all changes AUTOGEN also lets you recalculate any parameters that depend on other parameters that you might have changed Remember to record parameter values before changing them and
136. ra root rdbms admin catclust Node2 16 Set up your environment orauser sidB 17 SQL gt connect as sysdba 18 SOL startup 4 10 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Oracle Universal Installer List Of Parameters The following parameters need to be defined before starting an instance that will participate in RAC cluster database true undo tablespace UNDOTBS1 or UNDOTBS2 service names sidA or sidB instance name sidA or sidB instance number 1 or 2 thread dor 2 cluster_database_instances 4 optional Completing Installation of Oracle9i Server Enterprise Edition If no errors occurred during installation then your installation is complete To create a database and instance use the DBCA tool refer to Database Configuration Assistant DBCA on page 5 2 Non Interactive Installation and Configuration For non interactive installations use the Silent Mode Installation which is described in Chapter 1 Oracle9i Installation Planning on page 1 16 Cleaning Up After a Failed Installation If an installation fails then before you attempt another installation you might need to remove files that the Oracle Universal Installer created during the last session To clean up after a failed installation 1 Start the Oracle Universal Installer 2 Click the De install Products button and select any products that were left after the failed installation 3 Click th
137. racle9i ConText to interMedia Text Migration Guide for documentation of this process If you intend to install Oracle interMedia Text after your initial server installation then ensure that you have at least 10 MB of disk space for the data dictionary Your database must include tablespaces that are specific to interMedia Text data Verify that tablespaces exist to serve as default and temporary tablespaces for Oracle interMedia Text Oracle interMedia Text uses the DRSYS tablespace for its default and temporary tablespaces If tablespaces for Oracle interMedia Text do not exist or if you do not want to use the DRSYS tablespace then create additional tablespaces before proceeding See Also Oracle9i SQL Reference for information on creating tablespaces Shared Server Oracle servers that are configured with Shared Server require a higher setting for the initialization parameter SHARED POOL SIZE or a custom configuration that uses LARGE POOL SIZE If you created a database manually then you should raise SHARED POOL SIZE in the initsid orafile Typically you should add 1 KB for each anticipated concurrent user Refer to Oracle9i Database Performance Tuning Guide and Reference for further information on configuring Shared Server Post Installation 5 15 Post Installation for Oracle Products Oracle Precompilers The following list provides references and configuration files that are associated with Oracle precompilers Pro C
138. racter is 2 Press ENTER and enter the following HTTP command HEAD HTTP 1 0 3 Press ENTER twice Text similar to the following is displayed Apache Server Installation Configuration D 3 Running the Oracle HTTP Server on OpenVMS HTTP 1 1 200 OK Date Tue 23 May 2000 17 05 05 GMT Server Apache 1 3 12 OpenVMS Last Modified Mon 22 May 2000 15 33 27 GMT ETag 33dfec 681 39295347 Accept Ranges bytes Content Length 1665 Connection close Content Type text html TELNET S REMCLOSED Remote connection closed TELNET I SESSION Session 01 host localhost port 80 Troubleshooting If you do not receive a response from the Oracle HTTP Server check the following Look in your SYLOGIN COM file and make sure there is no SET TERMINAL INQUIRE statement for NETWORK processes a Look for the following files APACHESROOT 000000 APACHES SERVER LOG APACHESROOT LOGS ERROR LOG Running the Oracle HTTP Server on OpenVMS Starting and Stopping the Server To startup the Oracle HTTP Server enter the following command APACHECTL startup To stop the Oracle HTTP Server enter the following command APACHECTL stop Server Log File The server log file for APACHE WWW is written to APACHESSPECIFIC 000000 APACHESSERVER LOG D 4 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS Performance Considerations You should have
139. ransparent Gateway Table C 1 RDB Gateway Requirements Cont Hardware Software Requirements Oracle Networking RDB On gateway machine a Oracle Net Server release 9 2 Oracle Adapter for Named Pipes or TCP IP The following are required on the Oracle database server machine a Oracle Net Client release 9 2 Oracle Adapter for Named Pipes or TCP IP Oracle Net products are included on the distribution CD ROM Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed RDB release 9 2 0 2 0 RMS Gateway Requirements Table C 2 describes the hardware and software requirements for an RMS gateway Use it to ensure that your system meets requirements to create a gateway for the Oracle Transparent Gateway for RMS Table C 2 RMS Gateway Requirements Hardware Software Requirements Processor Memory CD ROM Drive Disk Space A HP Alpha workstation running the required version of OpenVMS 26 MB of real memory is recommended to support the gateway The total real memory requirement for the concurrent use of the gateway depends on the following factors a The SQL statement issued by the user a The number of cursors currently opened against RMS The number of columns in the table that is being accessed An intern
140. re has been installed and a database has been created Note The following steps are provided here with the assumption that the instance on nodel is sidA and that the instance on node2 is sidB Node1 1 Set up your environment orauser sidA 2 set default ora_root network 3 Create the DCL script needed for bequeath connections create_orasrv_beq lt ora_db gt lt sidB gt lt db_name gt for example create_orasrv_beq DISK DISK1 Oracle9i Homel ORADATA DB92 sidB DB92 4 set default ora root dbs Installation 4 9 Oracle Universal Installer 5 Create a copy of the Password file copy orapwsidA orapwsidB 6 Create a copy of the instance specific parameter file copy initsidA ora initsidB ora 7 Create a copy of the properties file copy sid sidA properties sid sidB properties 8 Editthe files that were created in step 6 and step 7 Before starting the instance refer to the List Of Parameters following these numbered steps 9 Ensure that parameter remote login passwordfile is set to SHARED default EXCLUSIVE 10 SOL connect as sysdba 11 SQL gt startup 12 SOL alter database add logfile thread 2 group 4 ora db redo04 rdo size 100m group 5 ora db redo05 rdo size 100m group 6 ora db redo06 rdo size 100m 13 SOL alter database enable public thread 2 14 SOL create undo tablespace UNDOTBS2 datafile filespec size size 15 SOL Go
141. reate an OpenVMS Account to Own Oracle Software Create an OpenVMS Account to Own the Apache Server Create an OpenVMS Account to Own Oracle Software The oracle account is the OpenVMS user account that owns the Oracle9i software after installation Run Oracle Universal Installer with this user account Use the AUTHORIZE utility to create an oracle account with the following properties Table 3 4 lists the properties of Oracle9i accounts Table 3 4 Properties of the Oracle9i Account Login Name Any name but this document refers to it as the orac1e9 account UIC The group UIC number which is greater than MAXSYSGROUP Home Directory Choose a home directory consistent with other user home directories The home directory of the oracle9 account does not need to be the same as the ORA ROOT directory Caution Use the oracle9 account only for installing and maintaining Oracle software Never use it for purposes unrelated to the Oracle9i server Do not use SYSTEM as the orac1e9 account Sites with multiple ORA ROOT directories on one system may install Oracle software with the same oracle9 account or separate accounts Each oracle9 account must have the same group UIC Create an OpenVMS Account to Own the Apache Server The Apache account is an OpenVMS user account that owns the Apache server after installation If you use a default Apache configuration one that listens to ports lower than 1024 which are
142. reside on any supported platform On gateway machine a Oracle Net Server release 9 2 Oracle Adapter for Named Pipes or TCP IP The following are required on the Oracle database server machine a Oracle Net Client release 9 2 Oracle Adapter for Named Pipes or TCP IP Oracle Net products are included on the distribution CD ROM Oracle Net or Oracle Net Client and the Oracle Adapter must be installed on the machine where the Oracle database server is installed Oracle Net Server and the Oracle Adapter must be installed on the machine where the gateway is installed RMS release 9 2 0 2 0 Oracle Transparent Gateway C 5 System Requirements for Oracle Transparent Gateway Tested Gateway Configurations The following gateway configurations have been tested by Oracle Corporation at the time of this document release Oracle Corporation continues to provide support for the most recent releases of Oracle and non Oracle systems in a timely manner Format Database Gateway and Operating System RDB release 9 2 0 2 0 tg4rdb release 9 2 running on HP OpenVMS Alpha RMS release 9 2 0 2 0 tg4rms release 9 2 running on HP OpenVMS Alpha See Also Oracle Corporation continually updates supported gateway configurations For the latest supported configuration information either contact Oracle Support Services or visit the following web site http www oracle com gateways Gateway Installation Worksheets Select the worksheet in
143. riction The use of incorrectly aligned binary data such as COMP 1 in Pro COBOL applications will generate unaligned access warnings that will prevent optimum compiler performance but will not affect the application results CD ROM Pre installation Requirements 3 19 Setup Tasks for Oracle Products Java Runtime Environment The Java Runtime Environment JRE that is certified for use with Oracle9i software is used by Oracle Java applications such as the Oracle Universal Installer and is the only Java application supported to run with these applications Do not modify this JRE unless you use a patch that is provided by Oracle Support Services Network and System Management Products This section describes tasks that need to be completed prior to installation if you have existing network and system management products Setup Tasks for Oracle Net Services If you have an existing installation of Oracle Net8 server then shut down all listeners before installing Oracle Net To determine if any listeners are running enter the following command lsnrctl status listener name The 2istener name field is required if the listener has a name other than the default name listener To shut down a running listener enter the following command lsnrctl stop listener name Verify Oracle Supported Protocols Oracle Universal Installer automatically installs the TCP IP protocol with all Oracle9i database installations Before installi
144. root directories that are pointed to by the APACHE ROOT logical name During installation file protection is set to S RWED O RWED G W During configuration all files are set to be owned by ORACLE Server Extensions CGI Scripts Server extensions such as CGI scripts run within the context of the Oracle HTTP Server process or its subprocesses These extensions have complete control over the server environment You can configure the server to allow execution of arbitrary user scripts but standard practice is to limit such activity to scripts that are written by completely trusted users The Oracle HTTP Server includes directives that allow a web administrator to control script execution and client access The use of these directives is described in numerous books and is not duplicated here SuEXEC Not Available for Protecting Script Execution The Oracle HTTP Server for OpenVMS does not currently support the suEXEC method of executing scripts under the username that owns the script Many sites use this feature to allow execution of arbitrary user written scripts without the fear of compromising the server environment Open Source Licenses This section provides open source license acknowledgments and license references Apache This product includes software developed by the Apache Software Foundation http www apache org You can view the license at the following web site Apache Server Installation Configuration D 29 Apa
145. rted on OpenVMS For more information see the Apache Software Foundation documentation at the following web site http www apache org docs dso html File Handlers The Oracle HTTP Server for OpenVMS supports the ability to use file handlers explicitly For more information see the Apache Software Foundation documentation at the following web site D 18 Oracle9 Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS File Formats http www apache org docs handler html Content Negotiation The MOD NEGOTIATION module provides content negotiation This module lets you specify language variants of HTML files To specify language variants on OpenVMS use an underscore instead of a period before the language extension For example a On UNIX filename html fr is the French variant of ilename html OnOpenVMS filename html fr is the French variant of filename html For more information see the Apache Software Foundation documentation at the following web site http www apache org docs content negotiation html Apache API You can use the standard Apache API to write your own modules that will run on the Oracle HTTP Server for OpenVMS For more information see the Apache Software Foundation documentation at the following web site http www apache org docs misc API html SuEXEC Support The suEXEC feature provides the ability to run CGI programs under use
146. rtup that points to the top level directory device APACHE device APACHE SPECIFIC node name Apache Server Installation Configuration D 21 Running the Oracle HTTP Server on OpenVMS Table D 2 Oracle HTTP Server Logical Names and Their Descriptions Logical Name Description APACHESSPECIFIC Concealed logical name that defines system specific files in APACHESROOT device APACHE SPECIFIC node name APACHE CGI MODE System logical name that controls how CGI environment logicals are defined in the executing CGI process There are three different options Note that only one option is available at a time 0 Default Environment logicals are defined as local symbols and are truncated at 970 limitable with DEC C 1 Environment logicals are defined as local symbols unless they are greater than 970 characters If the environment value is greater than 970 characters it is defined as a multi item logical 2 Environment logicals are defined aslogicals If the environment value is greater than 512 characters it is defined as a multi item logical APACHESDEBUG DCL CGI If defined this system logical name enables APACHESVERIFY DCL CGI and APACHE SHOW CGI SYMBOL APACHESVERIFY DCL CGI If defined this system logical name provides information for troubleshooting DCL command procedure CGIs by forcing a SET VERIFY before executing any DCL CGI Use with APACHE DEBUG_DCL_CGI APACHES SHOW CGI
147. ry can contain multiple versions of the JRE each of which can be used by one or more products or releases The Oracle Universal Installer creates the oraInventory directory the first time that it is run in order to keep an inventory of products that it installs as well as other installation information on your system Character Mode Installation cannot be performed using character mode with the Oracle Universal Installer OUI For non interactive installations use the Silent Mode Installation which is described in Chapter 1 Oracle9i Installation Planning on page 1 16 The Oracle Universal Installer can be run in the interactive mode directly from your system X Windows console or via an X Terminal or PC X Terminal on a remote system 3 2 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS HP OpenVMS and Installation Specific Issues and Restrictions Upgrading and Migrating File Systems If you are upgrading an existing system then some issues may exist that exceed the scope of this manual It is possible to migrate Oracle8i Release 2 8 1 6 and Oracle8i Release 3 8 1 7 and Oracle9i Release 1 9 0 1 to Oracle9i Release 2 9 2 0 2 To migrate from an Oracle database earlier than these releases you must first upgrade to an Oracle8i Release 2 or Release 3 or to an Oracle9i Release 1 and then follow the steps outlined in the document ora rdbms readmemigums doc to migrate to Oracle9i Release 2 9 2 0 2 As
148. s The starter database and the custom database each contain three redo log files that are located in the ora root oradata db name directory Table 5 3 describes the redo log files Table 5 3 Redo Log files Redolog Files Disk Size Description redo01 rdo 100 MB Redo log files hold a record of all changes redo02 rdo 100 MB that are made to data in the database buffer cache If an instance failure occurs redo03 rdo 100 MB then Oracle9 uses the redo log files to recover the modified data in memory Oracle9i uses redo log files in a cyclical fashion For example if three files constitute the online redo log then Oracle9i fills the first file then fills the second file and then fills the third file In the next cycle it reuses and fills the first file the second file and so on See Also Oracle9i Backup and Recovery Concepts for more information on redo log files Post Installation 5 25 Starter Database Contents Locating Control Files The starter database contains three control files These files are located in the ora root oradata db name directory The files control01 ctl control102 ctl and contro103 ct1 are automatically included in the Custom database Oracle Corporation recommends that you keep at least three control files on separate physical drives for each database and set the CONTROL FILES initialization parameter to list each control file Table 5 4 describes the database control files
149. s fetching user default path information The second and third parameters are the minimum and maximum port that is allowed to be bound When a call to either service is made the service code 1 Temporarily enables the privileges SYSPRV OPER SYSNAM and NETMBX 2 Performs the function 3 Restores the process original privileges The APACHE FIXBG EXE_ALPHA image provides a kernel mode service for manipulating the carriage control attribute for BG devices that are owned by the calling process No special access control exists on this service This function can also be performed using a setsocketopt C RTL run time call but it is not supported by all TCP IP stack vendors which is the reason this service exists This service does not enable privileges but executes in kernel mode Privileges Required to Start and Stop the Server The Oracle HTTP Server runs under the ORACLE username and UIC and is started as a detached network process During startup protected images are installed and D 28 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Apache logical names are placed in the system logical name table Shutdown is accomplished by sending a KILL signal to the master process and its subprocess These actions require enhanced privileges DETACH SYSNAM WORLD and so forth and are usually performed from a suitably privileged account File Ownership and Protection All of the server files reside under its
150. s the components that are available with each installation type of the Oracle9i server Standard Edition top level component Refer to the release notes for your platform for updates on component availability Advanced Queuing Advanced Replication a Character Set Scanner Common Schema Demos Object Type Translator which includes the following Oracle INTYPE File Assistant Enterprise User Security including Oracle Wallet Manager Note Oracle Wallet Manager is a feature of Oracle Advanced Security You can use it only if you purchase an Oracle Advanced Security license a Oracle Call Interface Oracle Dynamic Services Oracle9i Products A 5 Oracle9i Database Components Oracle JDBC Drivers which include the following Oracle JDBC Thin Driver for JDK 1 1 Oracle JDBC Thin Driver for JDK 1 2 Oracle JDBC OCI Driver for JDK 1 1 Oracle JDBC OCI Driver for JDK 1 2 a Oracle Locale Builder a Oracle Locator Oracle Net which includes the following Oracle Net Listener Oracle Protocol Support Note When Oracle Net Client is installed by using the Enterprise Edition or Standard Edition installation type the Oracle Universal Installer installs Oracle Protocol Support for the networking protocols that it detects Oracle SOLJ which includes the following SOLJ Runtime SOLJ Translator a Oracle Text a Oracle Trace Oracle Universal Installer which inclu
151. save the time of reviewing each installation screen and selecting the various installation options Silent installations can also ensure that multiple users in your organization use the same installation options when they install your Oracle products You can therefore more easily support those users because you already know what components and options have been installed on each computer Before you perform a silent installation you should review the settings in the response file template that is provided with your Oracle product Modifying a Response File If your product installation includes a response file template then you can find it on your ship set CD ROM under the device Disk1 stage Response directory For a list of response files refer to List of Response File Names on page 1 19 Mandatory items have the following comment just before the definition OPENVMS VALUE REQUIRED Three values must be provided a FROM LOCATION a ORACLE HOME a ORACLE HOME NAME 1 18 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Silent Mode Installation FROM LOCATION is the complete path of the source of the products to be installed in other words to the Disk1 stagelproducts jar file from CD number 1 If contents of CDs were copied to a local file system then specify that path ORACLE HOME is the directory into which the Oracle software will be installed The account from which the Oracle Universal Instal
152. se 2 9 2 0 2 for HP OpenVMS Alpha Oracle Real Application Clusters release 9 0 1 Oracle Real Application Clusters is an option that enables the database to run in clustered systems Oracle instances in the nodes of the cluster provide shared access to the single database A clustered database enhances scalability and high availability for all types of applications Note This product requires a separate license For more information refer to Oracle9i Real Application Clusters Installation and Configuration Oracle9i Products A 19 Product Descriptions 21 Oracle Real Application Clusters Guard release 9 0 1 Oracle Real Application Clusters Guard is an optional feature that provides enhanced high availability for clusters Oracle Real Applications Clusters Guard supports a primary or secondary configuration with rapid failover and minimal overhead For more information refer to Oracle Real Application Clusters Guard Administration and Reference Guide 22 Oracle Spatial release 9 2 0 2 0 Oracle Spatial provides data management for location data including information regarding addresses road networks and sales territories Oracle Spatial provides powerful spatial type management indexing methods and spatial operators for the deployment of location based services and it extends the capabilities of existing Oracle based applications Note This product requires a separate license For more inf
153. specify either clusterwide or system specific files How to Configure Apache Perform the following steps to configure Apache to run while using an account other than the oracle account 1 Modify the configuration file HTTPD CONF to include the following line User username 2 Modify APACHEUSER COM to define logical APACHE USERNAME to the required username Make sure that the username is exactly the same as the entry in the httpd conf file 3 Restart the Apache Server if it is already running Modules and Directives Following is a list of the modules included in the Oracle HTTP Server for OpenVMS distribution kit The list shows the directives supported in each module All supported modules and directives function as documented by the Apache Software Foundation at the following web site D 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS http www apache org docs HTTP CORE C AccessConfig AccessFileName AllowOverride AuthName AuthType BindAddress CoreDumpbDirectory DefaultType Directory lt DirectoryMatch gt DocumentRoot ErrorDocument ErrorLog lt Files gt lt FilesMatch gt HostnameLookups IdentityCheck lt IfDefine gt lt IfModule gt Include KeepAlive KeepAliveTimeout lt Limit gt lt LimitExcept gt LimitRequestBody Apache Server Installation Configuration D 9 Running the Oracle HTTP Server on OpenVMS LimitRe
154. stallation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Running the Oracle HTTP Server on OpenVMS CGI Environment Logical By default an environment logical symbol takes the form that is designated by the name of the environment logical You can determine how environment logicals are set when the server executes a CGI program You can define the APACHES PREFIX DCL CGI SYMOBLS WWW logical name to prefix all environment logical symbols with www By default no prefix is used The APACHE CGI MODE logical name controls how CGI environment logicals are defined in the executing CGI program as follows APACHESCGI MODE option where option can have one of the following values at a time 0 Default Environment logicals are defined as local symbols and are truncated at 970 limitable with DEC C 1 Environment logicals are defined as local symbols unless they are greater than 970 characters If the environment value is greater than 970 characters it is defined as a multi item logical 2 Environment logicals are defined as logicals If the environment value is greater than 512 characters it is defined as a multi item logical APACHE DCL ENV isa foreign symbol that lets you define CGI environment logical as follows APACHESDCL ENV c d e env file where c Default Indicates create environment logicals d Indicates delete environment logicals e env file Specifies an alternate environment file The environment file
155. stem prompt REMORACLE Note Generally no response is returned except for the return of the DCL prompt Step 3 Invoke the Oracle Installation Utility 1 Typeatthe DCL prompt ora root bin relink product all 2 Select option 4 Build Selected Licensed Products Post Installation 5 29 Relinking the Oracle Code 5 30 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS A Oracle9 Products This appendix describes the products that are included with Oracle9 Oracle9i Database Components on page A 2 a Oracle9i Client Components on page A 8 Product Descriptions on page A 2 Note The Custom installation type is not listed for any of the three top level components because it allows you to install all components in the current top level component category Some components can be installed only through a Custom installation Such components have an availability of No listed in this appendix for other installation types Oracle9i Products A 1 Oracle9i Database Components Oracle9i Database Components The following sections contain alphabetical lists of the components that are available with each installation type of the Oracle9i server top level component Enterprise Edition This section alphabetically lists additional components available with each installation type of the Oracle9i server Enterprise Edition Enterprise Edition includes all the c
156. suming that the ORACLE HOME environment is set up by executing the orauser script invoke DBCA Log files for creating a seed template are located in the ORACLE HOME assistants dbca logs directory Using DBCA Response Files An alternative to creating an argument file to pass command line options to DBCA is to use a response file A sample response file dbca rsp is provided in the ORACLE HOME assistants dbca directory Make a copy of this file and customize it as necessary Follow the instructions that are contained in comments The value that is specified for the CREATE TYPE field determines which of the other sections are applicable Each field has a comment header block with the following entries Name Datatype Description Valid values Default value and Mandatory Yes No descriptions For example Name CREATE TYPE Datatype String Description Type of database creation Valid values createDatabase createTemplateFromDB V createCloneTemplate Default value None Mandatory Yes CREATE TYPE createDatabase All mandatory values must be provided but only for the applicable sections as indicated by the CREATE TYPE value After customizing the response file invoke DBCA passing the name of the response file on the command line as follows dbca silent responseFile full response file name Note Either VMS style arguments or UNIX style arguments may be used in fields that are
157. system as well as the amount of paging currently configured on your system enter the following command SHOW MEMORY To review memory reservations on your node run the following command show memory reserved System Memory Resources on 13 JUL 2002 09 57 11 72 Memory Reservations pages Group Reserved In Use Type ORA PROD SGA SYSGBL 5120 0 Allocated ORA PROD SGA SYSGBL 5 0 Page Table Total 40 04 Mbytes reserved 5125 0 Please consult Hewlett Packard documentation if you require more information about reserving memory Disk Space Requirements The Oracle Universal Installer OUI allows you to choose your installation category andtype Your choices will determine how much disk space that you will need The disk space requirements do not include the size of your database A production Oracle database server that is supporting many users requires significant disk space and memory Table 1 1 lists the disk space requirements for Oracle9i Server OracleQi Installation Planning 1 9 System Installation Requirements Images Table 1 1 Disk Space Requirements for Oracle9i Server Installation Type Required Disk Space Enterprise Edition 3 3 GB Standard Edition 3 3 GB Custom depends upon the components selected but a minimum of 2 GB From a staging area on disk 1 GB Table 1 2 lists the disk space requirements for Oracle9i Client Table 1 2 Disk Space Requirements for Oracle9i Client
158. t of sorting such as ANALYZE COMPUTE STATISTICS on a very large table or the constructs GROUP BY ORDER BY or DISTINCT TOOLS tools01 dbf The Installer creates this data file when the user wants to install any third party or Oracle tools products USERS users01 dbf As you generate and enter data into tables you fill this space with your data See Also Oracle9i Database Concepts and Oracle9i Database Administrator s Guide for more information on tablespaces and data files 5 24 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Starter Database Contents Locating the Initialization Parameter File The database initialization parameter file init ora is generated when a database is created The init ora file is used to bring up the instance and to create the database and the data dictionary When the database is complete the instance is shutdown and the init ora file is saved to ora root dbs init lt SID gt ora The logical ORA PARAMS points to ora root dbs init SID ora The init ora fileis a text file that contains a list of preconfigured instance configuration parameters and that must exist for an instance to start No edits are required to this file in order to use the starter database See Also Oracle9i Database Administrator s Guide and Oracle9i Database Reference for more information on database specific initialization parameters and their default values Locating Redo Log File
159. t orauser com 3 Invoke dbca com The DBCA GUI appears Non interactive Mode Silent mode does not have any user interface other than what you provide in an argument or response file or user interaction It displays all messages including information errors and warnings into a log file From the command line enter the following command to see all of the DBCA options that are available when using silent mode dbca help Note Because of the DCL limit of eight command line parameters on OpenVMS it is not possible to specify directly on the command line all of the required parameters to create a database Therefore as a workaround DBCA command line arguments may be placed into a file called SYS SCRATCH DBCA ARGS The DBCA COM script looks for this file and if present passes the specified arguments to the DBCA Java application DBCA COM will ignore all arguments that are passed on the command line except silent responseFile response file and help In order to avoid inadvertently applying the same arguments to the next invocation of DBCA when DBCA ARCS exits if an arguments file was used then it is renamed to SYS SCRATCH DBCA ARGS OLD 5 2 Oracle89i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Database Configuration Assistant DBCA Note Because the DBCA design in a similar manner to that of the Oracle Universal Installer causes GUI classes to be lo
160. talling Oracle Transparent Gateway Installing Oracle Transparent Gateway Use the following procedures and tables to install Oracle Transparent Gateway Mounting Transparent Gateway from the CD ROM Install the gateway software from the CD ROM as follows 1 Start the Oracle Universal Installer Note Complete instructions for mounting and running the Oracle Universal Installer are not presented here Review Chapter 4 Installation to find complete mounting and starting instructions for your platform 2 Install the gateway by responding to installation prompts as indicated for your platform in Installation Prompts for Transparent Gateway Installation Prompts for Transparent Gateway The Oracle Universal Installer screens and the sequence in which they appear depend on your platform Select the installation prompt section that corresponds to the gateway that you wish to install Installation Prompts for RDB Gateway Installation Prompts for RMS Gateway C 8 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Removing Oracle Transparent Gateway Installation Prompts for RDB Gateway Use the following pattern Screen Response as a guide during your gateway installation Location of RDB database Enter the complete path for RDB database Follow the instructions in the Response column for each entry in the Screen column When you have completed the responses follow the instructi
161. that existing applications will continue to work without modification Thus later releases of TCP IP are upward compatible with Oracle Net provided that the vendor specified Application Programming Interface API does not change with new releases Window Manager X Windows must be installed on the system from which the Oracle Universal Installer is run Use any Hewlett Packard supported X Windows server for example Excursion dtwm twm mwm that supports Motif To determine your current operating system information enter the following command SHOW SYSTEM NOPROCESS FULL To see information about all nodes in a cluster add the CLUSTER qualifier to the above command To determine if your X Windows system is working properly on your local system enter the following command RUN SYSS SYSTEM DECWSCLOCK OracleQi Installation Planning 1 11 System Installation Requirements If a clock is not displayed on your screen then X Windows is not configured correctly See Set Display on page 3 19 for instructions on configuring X Windows Oracle Net VMS Mailbox Driver The Oracle Net VMS Mailbox driver protocol IPC is included in NETWORK You do not need an Oracle Net license to use the VMS Mailbox driver Programmatic Interface Support The following DEC compilers were used to certify the programmatic interfaces Programmatic Interface Certification Release Pro C C release 6 4 008 C release 6 3 020 Pro
162. tion To add an account you must supply the following information Account name Account password USER and GROUP numbers for the UIC octal values Login device and directory Owner CD ROM Pre installation Requirements 3 5 Installation Procedure Requirements Although this guide refers to this account as the Oracle9i account you can assign any name or number to the account with the UIC restrictions noted below The Oracle9i account will own the runtime libraries and executable images for every Oracle product Therefore the database administrator DBA should manage this account and install all Oracle products from it Oracle9i Account is NOT the SYS or SYSTEM Account In the Oracle9i Administrator s Guide the Oracle9i account is sometimes referred to as the DBA account The Oracle9i account is not the same as the SYS or SYSTEM database usernames that are created for every database It is an OpenVMS account name Oracle9i Account UIC Must Be Greater than MAXSYSGROUP The UIC GROUP number of the Oracle9i account must be greater than the system parameter MAXSYSGROUP which defaults to octal 10 GROUP numbers 1 through MAXSYSGROUP are reserved for use by the OpenVMS operating system itself If the UIC GROUP number is not greater than the system parameter MAXSYSGROUD then the Oracle9i account cannot issue the following commands a STARTUP a CREATE DATABASE TABLESPACE a ALTER DATABASE TABLESPACE If your Oracle9i account has
163. tion Other names may be trademarks of their respective owners Contents Send US Your Comments 1 71 7 sette tette tette terrere testet pas ix Preface coe ULIS MOM P m M Rmi c TEC xi Oracle9i Installation Planning Oracle9i Installation Overview eseessesesseeeeeeeeeen nennen nnne nnne nne 1 2 Oracle9i Products for Installation essen nennen eene tenerent 1 2 Oracle9i Database Configurations esses eene eene e enn nnns 1 4 Environment Descriptions esses enne een nnn e nnne e nennen ens 1 4 Database Configuration Assistant eee 1 5 Installation With Existing Oracle Databases eene 1 7 System Installation Requirements 7cosssseeeeeeeeeeeee eene enne 1 8 Tune Requirements micas d ee ito e euet e Ee iE GER MER Sp E FE Feed road 1 8 Hardware Requirements sees eee ener enne nennen nennen 1 8 Minimum Hardware Requirements sse eene nnne 1 8 Disk Space Req iremehts itee eee dene era rere etie eei ere ree 1 9 IMASE Sgin en eoe d HU DO ARE ROT T ER DER TREO Nn vds 1 10 Operating System Software Requirements 1 11 Product Dependencies enero Rep qe hmm ue ain eae rena 1 13 Important Compatibility Issues sse eene nnne 1 13 Additional Product Specific Installation Requirements sse 1 13 Configuration Restrictions peiiini eee enne nennen nennen nennen 1 15 Copying Oracle
164. to installing the Oracle Net products List of the Restrictions and Requirements for Networking and System Management Products Product Name Restrictions and Requirements 1 14 Oracle9i Installation Guide Release 2 9 2 0 2 for HP Alpha OpenVMS Configuration Restrictions Oracle Advanced Security 9 2 0 2 0 Refer to Oracle Advanced Security on page 1 15 for information about Oracle Advanced Security authentication support requirements Oracle TCP IP with SSL Protocol Support 9 2 0 2 0 SSL 3 0 or later Oracle Advanced Security Oracle Advanced Security is an add on product that will be added to the standard Oracle Net Server or Oracle Net Client If you purchase it then install it on both the server and the client Oracle Advanced Security release 9 2 0 2 0 requires Oracle Net release 9 2 0 2 0 and supports Oracle9i server Kerberos and Secure Socket Layer SSL have requirements for authentication protocols that are supported by Oracle Advanced Security No additional authentication protocol software is required to relink Oracle products Kerberos requires MIT Kerberos Version 5 release 1 1 The Kerberos authentication server must be installed on a physically secure machine Secure Socket Layer SSL requires a wallet that is compatible with the Oracle Wallet Manager version 2 1 Wallets that were created in earlier releases of the Oracle Wallet Manager are not forward compatible Oracle Advanced Security provides an
165. uirements 1 10 Oracle9i Enterprise Edition top level component installation types available with A 2 Oracle9i JVM Index 5 enterprise edition defined A 23 requirements 1 14 Oracle9i Server defined A 23 Oracle9i installation types available with A 2 oralnst loc file 3 2 oralnventory directory 4 8 ORDPLUGIN user name database roles 5 20 ORDPLUGINS user name and password 5 20 ORDSYS database roles 5 20 user name and password 5 20 OSDBA and OSOPER groups 5 12 OUTLN user name database roles of 5 20 described 5 20 password of 5 20 P parameters GENPARAMS 3 15 initialization 5 13 init ora file 5 13 SAVPARAMS 3 15 SYSGEN 3 13 passwords changing 5 12 for CTXSYS user name 5 20 for DBSNMP user name 5 20 for MDSYS user name 5 20 for ORDPLUGINS user name 5 20 for ORDSYS user name 5 20 for OUTLN user name 5 20 for SCOTT user name 5 21 for SYS user name 5 21 for SYSTEM user name 5 21 performance B 2 permissions file creation 3 16 setting with umask 3 18 PGA B 3 post installation tasks Oracle Precompilers 5 16 Index 6 product specific 5 14 Secure Socket Layer 5 17 Shared Server 5 15 precompilers requirements 1 14 pre installation tasks as the System user 3 16 Oracle Net 3 20 shutting down listeners 3 20 Pro C 1 12 Pro C C described A 23 requirements 1 14 Pro COBOL 1 12 described A 24 requirements 1 14 Pro FORTRAN 1 12 described A 24 requirements
166. uld not be entered at the prompt hyphen braces brackets A hyphen indicates a command that is too long to fit on a single line Enter the line as printed or enter it as a single line without a hyphen copy disk server25 oracle920 rdbms admin sql disk server2 oracle rdbms admin Braces indicate required items DEFINE macro1 Brackets indicate optional items cvtcrt termname outfile Note that brackets have a different meaning when used in regular text xiii ellipses Ellipses indicate an arbitrary number of similar items CHKVAL fieldname valuel value2 valueN italics Italic type indicates a variable Substitute a value for the logical library_name vertical line A vertical line indicates a choice within braces or brackets SIZE filesize K M Related Documentation Information about system administration and tuning for a production database system is provided in the following documents xiv Oracle9i Administrator s Reference Release 2 9 2 0 2 for hp OpenVMS Alpha Oracle9i Database Administrator s Guide Oracle9i Net Services Administrator s Guide Oracle9i Net Services Reference Guide Oracle9i Database Performance Tuning Guide and Reference Information about migrating from a previous version of Oracle Server is provided in Oracle9i Database Migration Oracle Services and Support The Oracle corporate web page is located at the following web site http w
167. untime and Custom Administrator If you select this type then the Oracle Universal Installer installs networking services utilities and basic client software Runtime If you select this type then the Oracle Universal Installer installs networking services and support files Custom If you select this type then the Oracle Universal Installer prompts you to select individual components to install from the components that are available with Administrator and Runtime OracleQi Installation Planning 1 3 Oracle9i Database Configurations Oracle9i Database Configurations When you install the Oracle9i database product you are prompted to select a database configuration that is suited to your needs Select from one of five Oracle9i database configurations 1 General Purpose Online Transaction Processing Data Warehouse Customized m B YP NM Software Only Options one through three are preconfigured databases that you can use for your Oracle9i database Each preconfigured database is designed to provide optimal support for particular database needs Options four and five are configurations for special needs The following section describes some of these configurations Environment Descriptions General Purpose Users of this database type perform a variety of database tasks ranging from simple transactions to complex queries Select this database environment for general purpose use Online Transaction Processing Us
168. usters Guard defined A 20 Oracle Server automating startup and shutdown 5 13 oracle software owner See oracle account Oracle Spatial defined A 20 Oracle Spatial Data Cartridge See Oracle Spatial Oracle Spatial Index Advisor defined A 20 Oracle Text defined A 21 Oracle Text Manager defined A 21 Oracle Transparent Gateway Informix hardware requirements for C 3 Ingres installation prompts for C 9 installation prompts for C 8 installation worksheets for C 6 RDB installation worksheet for C 7 rdb installation prompts for C 9 removing C 9 rms installation worksheet for C 7 Oracle Universal Installer and migrating data 1 7 and upgrading software 1 7 database creation methods 1 5 defined A 21 inventory 3 2 4 8 logfiles 4 8 response files listof 1 19 Oracle Utilities defined A 22 Oracle Visual Information Retrieval requirements 1 14 Oracle Wallet Manager and Secure Socket Layer 1 15 defined A 22 Oracle XML Developer s Kit defined A 22 ORACLE HOME logical oracle account home directory 3 17 requirements 3 2 Oracle7 migration 3 3 Oracle8 creating account 3 6 MAXSYSGROUP requirement 3 6 quotas required 3 9 relinking 5 29 setting system parameters 3 15 Oracle9i 64 bit feature B 1 Oracle9i Client disk space requirements 1 10 memory requirements 1 8 response file 1 19 Oracle9i Client top level component installation types available with A 8 Oracle9i Enterprise Edition disk space req
169. ww oracle com Oracle Corporation offers a wide range of services to help facilitate corporate system solutions including Oracle Education courses Oracle Consulting services and Oracle Support Services from the website In addition Oracle Corporation provides free trial software updates on Oracle products and service and technical brochures and data sheets Oracle Support Services Technical Support contact information worldwide is listed at the following web site http www oracle com support Templates are provided to help you prepare information about your problem before you call You will also need your CSI number if applicable or complete contact details including any special project information Oracle MetaLink Oracle MetaLink is the Oracle Corporation web service for technical information Members of Oracle MetaLink can search for updates alerts patches and other information about products releases and operating systems and can set preferences to be notified automatically of new information MetaLink offers a variety of services to assist in setting up and administering Oracle products including procedures scripts commentary and tuning and configuration best practices bulletins In addition it offers forums for information sharing among Oracle customers and direct communication with Oracle Support Oracle MetaLink is available to Product Support Customers at no extra cost Sign up for free membership for this service

Oracle Audio Technologies ORACLE9I B10508-01 User's Manual

Contents

Download Pdf Manuals

Related Search

Related Contents