This chapter describes the tasks that you must complete before you start Oracle Universal Installer. It includes information about the following tasks:
Note:Oracle Database 11g Release 2 (11.2) must be installed on an ODS-5 formatted disk. See Section 1.2, "Changes and Enhancements" for more information.
The following sections list the minimum hardware requirements for installing Oracle Database products on an HP OpenVMS system:
The following are the minimum hardware requirements for installing Oracle Database 11g Release 2 (11.2):
A minimum of 2 GB RAM is required to install Oracle Database products. However, Oracle Corporation suggests having at least 4 GB RAM. Oracle Database Client products require 1 GB RAM. Also, consider the associated applications used on your system when calculating RAM.
$ SHOW MEMORY
To review memory reservations on the 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
Section 2.5.1, "Reserved Memory Registry" for more information.
Hewlett-Packard documentation for more information about reserving memory.
All HP OpenVMS Itanium chip sets are supported.
This product is available for download and an optional DVD disk is provided upon request. Please ensure that you have a DVD drive that is supported by HP OpenVMS. Oracle uses ODS-5 format installation media.
Oracle Database Enterprise Edition is installed with three default images, namely,
LIBCLNTSH.SO is linked with Oracle Database Client images, reduces their size by removing direct references to Oracle Net Services and other common routines.
ORACLE.EXE is the Oracle server image and will not be present in a Client-only installation.
ORA_JAVA_VMS_SHR.EXE is the Oracle Java VM shared image.
In addition, HP OpenVMS 11g Release 2 (11.2) has the following four shareable images used by the server: LIBCORENLS11.SO, LIBORASHR11.SO, LIBSKGXN2.SO, and LIBSKGXP11.SO.
Oracle Universal Installer enables you to select an installation category and type. Your choices determine how much disk space is required. The disk space requirements do not include the size of the database. A production Oracle Database that supports many users requires significant disk space and memory.
Oracle Advanced Security is an add-on product that is added to the standard Oracle Net Services Server or Oracle Net Services Client. If you purchase it, then install it on both the server and the client.
The SSL version compatibility is SSL3.0 or later.Kerberos and Secure Sockets 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. The requirements for Kerberos and SSL are as follows:
Requires a wallet that is compatible with the Oracle Wallet Manager version 11.2. Wallets that were created by using earlier releases of the Oracle Wallet Manager are not upward-compatible. Oracle Advanced Security provides and installs SSL.
See Also:For more information about Oracle Advanced Security and system management products, see Oracle Database Advanced Security Administrator's Guide
Note:No additional authentication protocol software is required to relink Oracle products. However, Oracle does not provide third-party authentication servers (for example, Kerberos). The appropriate authentication server for these protocols must be installed and configured separately.
SSL is provided and is always installed with Oracle Advanced Security.
This section provides information about checking the software requirements.
Depending on the products that you intend to install, verify that the following software is installed on the system. The procedure following the table describes how to check these requirements.
|Operating system||HP OpenVMS Itanium versions 8.4 and 8.4-1H1|
|Oracle Universal Installer||X Window and X/Motif software:|
|Oracle Messaging Gateways||Download the SupportPac MA88 from|
|Pro*C/C++, Oracle XML Developer's Kit (XDK)||
|Oracle Net Services Requirements||Oracle Net Services on HP OpenVMS is developed and certified using TCP/IP Services for HP OpenVMS (UCX).
If you want to use the TCP/IP protocol adapter for Oracle Net Services, then install version 5.7 ECO 4 or later of TCP/IP Services on HP OpenVMS Itanium.
Caution: TCP/IP protocol stacks from other vendors may work with Oracle, but this is not guaranteed by Oracle. Any TCP/IP problems that cannot be reproduced using TCP/IP Services for HP OpenVMS should be referred to the TCP/IP vendor.
Vendor-provided protocol services are usually upward-compatible, so existing applications continue to work without modification. Therefore, later releases of TCP/IP are upward-compatible with Oracle Net Services, if the vendor-specified application programming interface (API) does not change with new releases.
|Oracle JDBC/OCI Drivers||You can use HP JDK 1.5.0 version with the Oracle JDBC/OCI drivers.
However, they are not required for the installation.
Note: HP JDK version 1.5.0 is installed as part of a standard Oracle software installation. HP JDK version 1.6.0 is supported if it is installed with the operating system.
|Pro*COBOL||HP COBOL 3.0-0002|
|Pro*FORTRAN||HP FORTRAN 8.2-104939-50H96|
To ensure that the system meets these requirements:
$ WRITE SYS$OUTPUT F$GETSYI("VERSION") V8.4
If necessary, see the operating system documentation for information about upgrading the operating system.
$ SHOW SYSTEM /NOPROCESS /FULL
To view information about all nodes in a cluster, add the
/CLUSTER qualifier to this command.
If you require a Corrective Services Deliverable (CSD) for MQSeries, refer to the following website for download and installation information:
To determine the version of TCP/IP installed, enter the following command:
$ tcpip show version HP TCP/IP Services for OpenVMS Industry Standard 64 Version V5.7 - ECO 4 on an HP BL860c i2 (1.33GHz/4.0MB) running OpenVMS V8.4
The Oracle Net Services HP OpenVMS Mailbox driver (protocol IPC) is included in
NETWORK. You do not need an Oracle Net Services license to use the HP OpenVMS Mailbox driver.
You must ensure that the patches described in the following table are installed on the system.
|Installation Type or Product||Minimum Requirement|
|All installations||The following patches, or their later versions, are required:|
|IBM Messaging Gateway||IBM AXPVMS MQ CLIENT V5.30|
|Oracle Messaging Gateway||Corrective service diskette (CSD) for MQSeries:|
Note:In some cases, later patch sets would cumulatively include earlier patches and therefore, the preceding command would not explicitly indicate the required patch sets. In such cases, check the Patch Distribution website of Hewlett-Packard for the contents of the patches that are displayed to verify if the required patches are included or not.
$ PRODUCT SHOW HISTORY
The output of this command is a list of all software patches or products (or both) that are installed on the system. Verify that you meet the minimum requirements to install and run Oracle Database.
In addition to this document, see My Oracle Support Document 2000927.1 and Index of install related notes for Oracle Database 11g Release 2 (11.2) on HP OpenVMS, for an updated list of the following:
ECO level check scripts
Preinstallation check scripts
Quota check scripts
My Oracle Support is available at
The following factors can affect the installation or use of Oracle Database:
Do not install Oracle Database into the root directory of an existing Oracle installation containing any Oracle Software. Oracle recommends that you install Oracle Database products into a new Oracle Home.
Oracle Database 11g Release 2 (11.2) has two separate logical names that specify the top-level directory of the installation.
ORA_ROOT is a concealed logical name used in earlier releases, and
ORACLE_HOME is a nonconcealed logical name. You can use both logical names with the following restriction:
If the top-level directory is
DISK$DISK1:[ORACLE11204], then the logical names are defined as follows:
$ SHOW LOGICAL ORA_ROOT DISK$DISK1:[ORACLE11204.]
$ SHOW LOGICAL ORACLE_HOME DISK$DISK1:[ORACLE11204.]
Therefore, the following command is invalid:
$ SET DEFAULT ORA_ROOT
The following commands are valid:
$ SET DEFAULT ORA_ROOT: $ SET DEFAULT ORACLE_HOME
The JDK release that is shipped with Oracle Database is used by Oracle Java applications such as Oracle Universal Installer and is the only JDK that is supported to run with these applications. You must not modify this JDK, unless it is done through a patch provided by Oracle Support Services.
With Oracle 11g Release 2 (11.2), all file systems must reside on ODS-5 (On-Disk Structure Level 5) formatted disks. This includes the installation location, login directory, database files, and redo log files. This is required for mixed case file name support.
Oracle Database server must be able to verify that files have been written to disk. Devices that do not support this verification are not supported for use with Oracle Databases, although Oracle software can be installed on them. Datafiles always must reside on volumes with write through cache enabled.
Note:Because of this requirement for verification, third-party software that creates one or more virtual disks in memory must not be used for data files.
Create an HP OpenVMS user account to administer and maintain the Oracle installation. Setting up an Oracle Database account is the same as setting up any other HP OpenVMS user account.
To set up an Oracle Database account:
Determine the values that you want to enter to create the account.
AUTHORIZE to set the following account requirements:
Process rights identifiers
AUTHORIZE to complete the account setup.
See Also:The Hewlett-Packard documentation for more information about running the
To add an account, you must enter the following information:
Login device and directory
Although this guide refers to this account as the Oracle Database account or Oracle account, you can assign any name or number to the account after taking into account UIC restrictions. The Oracle Database account owns the run-time libraries and executable images for every Oracle product. Therefore, the database administrator (DBA) must manage this account and install all Oracle products from it.
Note:In Oracle Database Administrator's Guide, the Oracle Database account is sometimes referred to as the DBA account. The Oracle Database account is not the same as the
SYSTEMdatabase user names that are created for every database. It is an HP OpenVMS account name.
The UIC group number of the Oracle Database account must be greater than the system parameter
MAXSYSGROUP (which defaults to octal
10). Group numbers 1 through the value of
MAXSYSGROUP are reserved for use by the HP OpenVMS operating system.If the UIC group number is not greater than the value of
MAXSYSGROUP, then all Oracle Database account commands are not supported. For example:
The following command gives the value of
MAXSYSGROUP (in decimal format):
$ WRITE SYS$OUTPUT F$GETSYI("MAXSYSGROUP")
To run the
AUTHORIZE utility, enter the following commands:
$ SET DEFAULT SYS$SYSTEM $ RUN AUTHORIZE
At the UAF prompt, enter the
ADD command to create the user account from which you install the product software:
UAF> ADD /ACCOUNT=ORACLE11G /PASSWORD=ORACLE/UIC=[277,100]- /DEVICE=device/DIRECTORY=[ORACLE11G]/OWNER="ORACLE DBA"
In this example, the account name is
ORACLE11G. Ensure that the UIC group number is
277. The UIC group number must be greater than
After adding the account, you must alter the account privileges and quotas. This can be done in any order. However, in most cases, the account privileges are set before the account quotas.
See Also:The Hewlett-Packard documentation for more information about using the
The following privileges are required as both authorized and default privileges for the Oracle Database DBA account:
Note:Section 2.4.7, "Security Issues with Multiple Databases" explains an exception.
AUTHORIZE utility to set the account privileges for the Oracle Database DBA account. At the UAF prompt, use the
MODIFY command to add the required default and authorized privileges as follows:
UAF> MODIFY ORACLE11G - /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)
Table 2-2 lists the Oracle Database account quotas, their minimum recommended values, and their equivalent HP OpenVMS quota names as displayed by the
WORKING_SET DCL commands.
Note:These quotas depend on the number of log files, databases, network connections, and other logicals on the system. You may need to customize these values.
|Account Quota||Minimum Value||Quota Name|
250 (the default)
Asynchronous system trap limit
Buffered I/O limit
2000 (the default)
Open file quota
Job table quota
0 (the default)
Max detached processes
0 (the default)
Max active jobs
2 million (recommended)
Paging file quota
Working set default
Working set extent
Working set quota
After adding a record with the default quotas, use the
MODIFY command to alter the default values. The following example changes the enqueue quota (
ENQLM) from the default value to a value of 150:
UAF> MODIFY ORACLE11G/ENQLM=150
The Oracle Database DBA account must be granted one or more process rights identifiers. These identifiers enable you to run the
SYSDBA command that is required to perform database administration functions. Table 2-3 displays the combinations of adding and granting rights identifiers to this account:
|Adding...||And Granting...||Enables Control of...|
Any database instance, provided it does not also have an
All database instances except
For example, to grant the
_DBA rights identifier to the Oracle Database account for an instance called
TEST, enter the following command:
UAF> ADD/IDENTIFIER ORA_TEST_DBA
Then, grant the rights identifier to the Oracle Database account as follows:
UAF> GRANT/IDENTIFIER ORA_TEST_DBA ORACLE11G
If you add the
ORA_TEST_DBA rights identifier, but grant only
ORA_DBA to the
ORACLE11G account, then the account would have insufficient privileges to administer the
The third row of the table shows that you can add and grant different identifiers, which restricts control of a particular instance while it grants control to other instances.
You can also grant database maintenance privileges to accounts (for example, privileges to start and shut down the database) other than the Oracle Database account. However, with the Oracle Database account, the user UIC group number must be greater than
MAXSYSGROUP. By granting the
_DBA identifier, you can similarly restrict user privileges to an instance named
The SGA is protected by an access control list (ACL) that grants access to the identifier ORA_SGA. Before you start a database, add this rights identifier to the UAF, if it does not exist. To do this, the system manager must enter the following command:
UAF > ADD/IDENTIFIER/ATTRIBUTES=SUBSYSTEM ORA_SGA
If a site has several databases managed by different DBAs, then you may not want to grant the
CMKRNL privilege to every DBA Oracle Database account. This privilege enables a DBA to activate any process rights identifiers and to install shared images.
For security reasons, Oracle recommends that the HP OpenVMS system administrator handle these tasks. This person should be responsible for starting Oracle Database instances from a controlled account with a UIC group number that is greater than the value of
MAXSYSGROUP. If this is not possible, then at least one Oracle Database account must have the
AUTHORIZE utility. If the user account that you modified is logged on at the time you exit this utility, then this user must log out and log in again before the changes take effect.
Enter the following command to verify that your account has the correct privileges and rights identifiers:
$ SHOW PROCESS/PRIVILEGE
Set default file protections for the
ORACLE11G account to ensure that
EXECUTE permissions, but not
WRITE permission on installed files.
$ SHOW PROTECTION command to check the current setting.
$ SHOW PROTECTION command does not show the expected protection, then set protection in the
LOGIN.COM of the
ORACLE11G account as follows:
$ SET PROTECTION=(s:RWE, o:RWED, g:RE, w:RE)/default
RDBMSdirectory for instructions on calculating
You can create and use reserved memory on an HP OpenVMS system. The following sections describe the utilities that you can use to set the values of the various SYSGEN parameters:
Through its interface within the
SYSMAN utility, the reserved memory registry enables you to configure an HP OpenVMS system with large amounts of memory set aside for use within memory-resident global sections. The
AUTOGEN utility considers the preallocated reserved memory when it tunes the system.
Oracle recommends that you do not use reserved memory until the instance SGA size is stable. In most cases, this is a few weeks after the database is performing well.
You can be certain that the memory is available and that the system is correctly tuned.
The memory is reserved at startup time as contiguous aligned physical pages. This enables the system to optimize the mapping of the SGA.
The memory is preallocated and zeroed. This results in faster SGA mapping and faster instance startup.
$ MCR SYSMAN SYSMAN> RESERVED_MEMORY ADD ORA_TEST_SGA/SIZE=6144/ALLOCATE/ZERO/PAGE SYSMAN> EXIT
AUTOGEN and restart 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 piece of reserved memory may require restarting the system. During instance startup, Oracle Database compares the size of the reserved memory, if any, with the size of the SGA. If appropriate, one of the following messages is included in the alert log:
** Reserved memory size = size greater than created SGA size = size** ** 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 the memory reserved for an SGA is insufficient, then the instance startup fails. In this case, you must adjust the amount of reserved memory, run
AUTOGEN, and restart the system. For example, to expand the SGA to 6.5 GB for the
TEST instance, enter 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
AUTOGEN and save it permanently using the
SAVEPARAMS parameter. This saves the change in the
If you do not want to save permanently then, instead of running
SYSMAN to free the memory reservation and proceed with starting the Oracle instance without reserved memory. The risk involved with this is that the system may not have enough fluid pages to create the SGA. In addition, the performance advantages of using reserved memory are not available.
See Also:The Hewlett-Packard documentation for more information about the reserved memory registry
To review memory reservations on the 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
SYSGEN parameters affect the entire operating system, the system administrator is the only person who should modify them. At some sites, 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, HP 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 the
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 may have changed. Remember to record parameter values before changing them, and determine in advance what results you expect from the changes you make. If the expected changes do not occur, then restore the old values before trying again.
The procedure is as follows:
$ @SYS$UPDATE:AUTOGEN SAVPARAMS GETDATA
This step saves current parameters to a file named
If you have not already done so, run
GETDATA to ensure that the file
PARAMS.DAT has been generated.
$ @SYS$UPDATE:AUTOGEN GETDATA
Examine the parameter settings in the current
PARAMS.DAT, and if they are correct, then change them in the
MODPARAMS.DAT file by using the
parameter=value format as follows:
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
$ @SYS$UPDATE:AUTOGEN GENPARAMS REBOOT
REBOOTparameter in this example causes the system to automatically restart when the
This step generates new
SYSGEN parameters in a file named
SETPARAMS.DAT and runs the
SYSGEN utility to set these parameter values as specified in the file.
See Also:HP OpenVMS System Management Utilities Reference for more information about using the
Table 2-4 lists the requirements for installing Oracle Database.
|System Factors||Requirements for Oracle Database|
HP OpenVMS Parameters:
Minimum Global Pages or Sections
Verify that the values for
HP OpenVMS Accounts
You need an HP 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
Log in as the
SYSTEM user and perform the following tasks to set up the environment for Oracle Database:
The Oracle Database account is the HP OpenVMS user account that owns Oracle Database software after installation. Run Oracle Universal Installer with this user account.
Details of creating this account are covered in Section 2.4, "Creating a User Account"
AUTHORIZE utility to create an
oracle account with the properties listed in Table 2-5.
Any name, but this document refers to it as the Oracle Database installation owner. For example,
The group UIC number, which must be greater than
Select a login directory consistent with other users' login directories. The login directory of the
Sites with multiple
ORA_ROOT directories on one system may install Oracle software with the same
ORACLE11G account, or separate accounts. Each
ORACLE11G account must have the same group UIC.
The Apache account is an HP 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 reserved for the system), then Oracle recommends, for security reasons, that a separate account owner be set up for Apache. Configure the Apache server to assign the ownership of listener and module actions to this account. It is not necessary for the Apache user account to have privileges to run the Apache Server on port numbers that are lower than 1023. Images that are installed with privileges during installation in the
oracle account ensure that this can be done.
See Section G.3.3, "Customizing the Server Environment" for information about how to configure the server to run as a user other than the 'oracle' user.
The Apache account owner should have minimal user privileges, and should not be a member of any groups where files are not intended to be visible to the public.
Before starting Oracle Universal Installer, set the display by using the following command:
$ SET DISPLAY/CREATE/TRANSPORT=TCPIP/NODE=workstation_name or IP_address
Verify that you have set the display correctly by using the following command:
$ RUN SYS$SYSTEM:DECW$CLOCK
Do not use the host name or IP address of the system where you install the software unless you perform the installation from the X Window console of that system. Use the computer name or IP address of the 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.
In this release, the architecture and implementation of the Oracle Enterprise Manager Agent has undergone a major revision. The new agent is based on an HTTP listener that communicates with the Management Server using XML and that uses Perl to perform a number of tasks. This has been implemented to run in a batch queue instead of running as detached processes. The Oracle Enterprise Manager Agent runs a main process. To support monitoring of both internal (using the same Oracle home) and external databases and listeners, the Enterprise Manager Agent submits additional batch jobs.
From the operational and management perspective, this has been implemented to run under a batch queue to get a better collective view of all processes related to the Enterprise Manager Agent running at any given time. This makes it easy to monitor and control all processes spawned by the Enterprise Manager Agent. In addition, it may be possible to delete batch jobs or processes that can potentially fail when trying to connect to databases or listeners that are not running.
Note:Although the Enterprise Manager Agent is no longer installed as part of a database installation, it is available as part of the separate Enterprise Manager Grid Control release.
For High-Availability Services (HAS), OCSSD, EVMD, and CRSD, are collectively run as batch process. The Enterprise Manager Agent and HAS use the following method to determine the name of the batch queue on which to submit jobs:
hostname logical name is defined, then the value of this logical is used.
hostname logical is itself a valid queue name, then it is used.
hostname logical name need not always be defined. It is sufficient that it is defined at least once during installation. Alternatively, you can define it before running
ORAUSER.COM at any time after the installation. Ensure that the Enterprise Manager Agent and HAS services can only be started up after setting up this batch queue logical name and running
The two components record the batch queue name in the installation, and use that as a reference for subsequent calls to the services. The default batch queue
SYS$BATCH generally points to a batch queue that runs under a lower priority (usually, 2) than the priority of a normal user (usually, 4). Therefore, it is inappropriate to use the default queue for the two services. This would result in poor and, in some cases, defective performance of the two services.
Note:Oracle recommends to use a dedicated batch queue.
The number of jobs submitted for the Enterprise Manager Agent batch queue depends on the number of monitoring targets which include databases and listeners. An approximation of two to five monitoring targets would be a good number for the
job_limit. In the case of HAS, a
job_limit of about 10 would be sufficient. The batch queue priority should be the same as all other Oracle processes, which is typically 4 on a standard VMS system.
The following products require preinstallation steps to be completed before you install Oracle Database software:
The following sections list the preinstallation tasks for the precompilers and tools that are required for HP OpenVMS.
This section describes tasks that need to be completed prior to installation if you have existing network and system management products.
If you have an existing installation of Oracle Net Services running on the same TCP ports, then shut down all listeners before installing it. To determine if the TCP port is in use, enter the following command:
$ TCPIP SHOW DEVICE/PORT=port_number
If the port is in use, a device name will be displayed. Issue the following command:
$ SHOW DEVICE/FULL device_name
The output of this command will contain a process ID. Issue the following command:
$ SHOW PROCESS/CONTINUOUS/ID=pid
The full path to the program that is running and which is using the port will be indicated in this display. This path includes the Oracle home from which you should stop the Listener.
You must identify three directories for the Oracle software as described in the following sections:
The following subsections describe the requirements for these directories.
The Oracle inventory directory (
ORAINVENTORY) stores an inventory of all Oracle software installed on the system. It is required by, and shared by, all Oracle software installations on a single system.
The Installer creates this directory if it does not exist and sets the correct owner, group, and permissions on it.
Note:Oracle recommends that you specify the inventory location by creating the
locfile in the
node_name] directory. Create this directory if it does not exist. The contents of the
locfile is as follows:
VMS1 is the UIC group of the account used to install Oracle. All Oracle software installations depend on this directory. Ensure that you back it up regularly. Do not delete this directory unless you have completely removed all Oracle software from the system.
The Oracle base directory is a top-level directory for Oracle software installations. On HP OpenVMS, a typical Oracle base directory is similar to the following example:
The Oracle home directory is the directory where you choose to install the software for a particular Oracle product. You must install different Oracle products, or different releases of the same Oracle product, in separate Oracle home directories. When you run Oracle Universal Installer, it prompts you to specify the path to this directory, and a name that identifies it.
Oracle Universal Installer creates the directory path that you specify. It also sets the correct ownership and permissions. You do not need to create this directory.
Oracle Universal Installer can use either one of the following format examples:
Note:You must select a location for the recovery files only if you enable automated backups during the installation.
Use the following guidelines to place Oracle Database or recovery files:
To prevent disk failure from making both the database files and the recovery files unavailable, place the recovery files on a different physical disk from the database files.
The disk that you select must have at least 2 GB of free space.
The disk space requirement is the default disk quota configured for the flash recovery area. The default disk quota is specified by the
DB_RECOVERY_FILE_DEST_SIZE initialization parameter. If you select the Custom installation type, then you can specify a different disk quota value. After you create the database, you can also use Oracle Enterprise Manager Grid Control to specify a different value.
See Also:Oracle Database Backup and Recovery Basics for more information about sizing the flash recovery area
The Oracle Database account must have write protection to create the files in the specified path.
If you want to use a single device, then choose a device on a physical device that is dedicated to the database.
For performance and reliability, choose a redundant array of independent disks (RAID) device or a logical volume on more than one physical device and implement the stripe-and-mirror-everything (SAME) methodology.
If you want to use more than one device, then choose devices that are dedicated to the database.
This method enables you to distribute physical I/O and create separate control files on different devices for increased reliability. You must choose either the Advanced database creation option or the Custom installation type during the installation to implement this method.
If you intend to create a preconfigured database during the installation, the device (or devices) that you choose must have at least 1.2 GB of free disk space.
For optimum performance, the devices that you choose should be used only by the database.
The Oracle Database account must have write permissions to create the files in the path that you specify.
Note:You must complete this procedure only if you want to place Oracle Database or recovery files on a separate device instead of placing them in the Oracle base directory.
To create directories for Oracle Database or the recovery files on separate devices:
device_name command to determine the free disk space on each mounted device.
From the display, identify the devices to use. Table 2-6 lists the device requirements for recovery files.
|File Type||Device Requirements|
Choose a device with at least 2 GB of free disk space.
If you are using the same device for more than one type of file, then add the disk space requirements for each type to determine the total disk space requirement.
Note the names of the root device directories for the devices that you identified.
If you choose to create a database during the installation, then most installation types configure and start a default Oracle Net Services listener using TCP/IP port 1521 and the IPC key value
EXTPROC. However, if an existing Oracle Net Services listener process uses the same port or key value, Oracle Universal Installer can only configure the new listener, but it cannot start it. To ensure that the new listener process starts during the installation, you must shut down any existing listeners before starting Oracle Universal Installer.
To determine if an existing listener process is running, and to shut it down if necessary:
Log in as the Oracle Database account user.
$ PIPE SHOW SYSTEM/OWN=ORACLE | SEARCH SYS$INPUT last_8_chars_of_listener_name
This command displays the Oracle processes that are running in the
oracle account. Run the following command to identify the Oracle processes that run as listener processes:
$ WRITE SYS$OUTPUT F$GETJPI(pid,"IMAGNAME")
For each process that is running as a listener process, run the following command to determine the Oracle home in which it is running:
$ SHOW PROCESS/CONTINUOUS process_name
In this example,
process_name is the name of the listener process that is indicated by the command that you just entered.
Note:If no Oracle Net Services listeners are running, then refer to Section 2.14, "Configuring Oracle User's Environment" to continue.
Set up the Oracle environment for the Oracle home area where the listener is running as follows:
$ SET DEFAULT Oracle_home_dir $ @ORAUSER
Enter the following command to identify the TCP/IP port number and IPC key value that the listener is using:
LSNRCTL STATUS listenername
Note:If the listener uses the default name
LISTENER, you do not have to specify the listener name in this command.
LSNRCTL STOP listenername
Repeat this procedure to stop all listeners running on this system.
Appendix H for a list of commands and that you can use when performing this procedure
Oracle Database Administrator's Reference for HP OpenVMS Itanium for information about stopping existing Oracle processes on Oracle RAC
Before you start Oracle Universal Installer, you must configure the Oracle Database installation owner environment.
To achieve this, perform the following steps:
Start a new terminal session.
Set up the display using the
SET DISPLAY command.
Set up the inventory directory, and create the
ORAINST.LOC file. This step is optional but recommended. If you do not create the inventory directory, then an ORAINST.LOC file is created under the
sys$login:node_name directory. The default inventory location is the directory
INVENTORY_node_name created as the top-level directory of
Define the logical name
nodename to point to an existing batch queue. Oracle recommends that you use a dedicated Batch Queue.
See Also:Appendix C, "Installing, Configuring, and Running Enterprise Manager Agent" for more information about batch queues
Create a file,
CLUSTER_NODES.DAT (if you are installing Oracle Clusterware), in the
SYS$LOGIN directory with the list of nodes that are to comprise the Oracle RAC cluster. This file displays each node on a separate line with the primary node listed first.
$ SET NOVERIFY command.
$ SET PROCESS/PRIV=ALL command.
To start the
RUNINSTALLER refer to Section 3.3, "Installing Oracle Database Software"
ORATAB file contains information about all Oracle installations and databases installed on the node. This information is used to discover Oracle product installations. When an Oracle product is installed, this file is updated with information about the new Oracle home. If this file is not found, then a new
ORATAB file is created.
To check if the
ORATAB file exists:
Check for the
ORATAB file in the
hostname subdirectory of
SYS$LOGIN. For example:
ORATAB file is not found at the location described in Step 1, then use the file in the
SYS$LOGIN directory. For example:
ORATAB file is not found in any of the locations mentioned in the previous steps, then it means there is no