Oracle9i account is not the sys or system account, Finding maxsysgroup, Oracle9 i – Oracle Audio Technologies ORACLE9I B10508-01 User Manual

Page 50: Oracle9 i account is not the sys or system account

Advertising
background image

Installation Procedure Requirements

3-6

Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

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

MAXSYSGROUP, then the Oracle9i account cannot issue the following commands:

STARTUP

CREATE DATABASE/TABLESPACE

ALTER DATABASE/TABLESPACE

If your Oracle9i account has 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 SYS$OUTPUT F$GETSYI("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.

To run AUTHORIZE, enter:

Advertising