Configuring oracle database users accounts, Configuring user accounts on hp openvms, 39 configuring user accounts on hp openvms – HP A.06.11 User Manual

Page 39: Oracle database user accounts

Advertising
background image

Configuring Oracle database users accounts

Identify or create the following Oracle database user accounts. You need to provide
these user accounts when you configure the Oracle database as described in

Configuring Oracle databases

” on page 41.

Table 3 Oracle database user accounts

Description

User

Required to log in to the primary database.

Primary database
user

The owner of the recovery catalog (for example, rman). Required
to log in to the catalog database. Needed if you use the recovery
catalog.

Recovery catalog
user

Required to log in to the standby database. Applicable only in
Oracle Data Guard environments. Needed to back up the standby
database.

Standby database
user

Configuring user accounts on HP OpenVMS

To configure an Oracle user on HP OpenVMS, proceed as follows:

1.

Modify the location of ORAUSER.COM and ORATAB files as instructed in
OMNI$ROOT:[LOG]LOGIN.COM

based on the Oracle version used.

For example:

• $PIPE@DKA0:[ORACLE]ORAUSER.COM > NLA0:

Suppose ORAUSER.COM is located in DKC0:[ORACLE9i], then change
and uncomment the above statement to
$PIPE@DKC0:[ORACLE9i]ORAUSER.COM > NLA0:

.

• $DEFINE/NOLOG/JOB ORATAB_LOC DKA0:[ORACLE]ORATAB

Suppose ORATAB is located in DKC0:[ORACLE9i], then change and
uncomment the above statement to $DEFINE/NOLOG/JOB ORATAB_LOC
DKCF0:[ORACLE9i]ORATAB

.

Integration guide for Oracle and SAP

39

Advertising