Checking the connection, Checking the, Connection – HP A.06.11 User Manual

Page 169

Advertising
background image

Operating system user account that is added to the following user
groups:

UNIX systems:

dba

and sapsys

Windows systems:

ORA_DBA

and ORA_SID_DBA local groups

For example, user oraSID.

UNIX systems only:

Ensure that this user is the owner of the filesystem

or of the raw logical volume on which the database is mounted. The
minimum permissions should be 740.

Oracle operating
system user account

Default operating system administrator's user account added to the
dba

user group.

User account root
(UNIX systems only)

Database user account granted at least the following Oracle roles:

sysdba

sysoper

For example, user system.

Oracle database
user account

Add the following user accounts to the Data Protector admin or operator user
group:

Oracle operating system user account

UNIX systems only:

User account root

In cluster environments, add these user accounts to the Data Protector admin or
operator

user group for the following clients:

virtual server

every node in the cluster

For information on adding Data Protector users, see the online Help index: “adding
users”.

Checking the connection

To check the connection to the Oracle instance:

1.

Log in to the SAP R/3 client as the Oracle OS user.

2.

Export/set the ORACLE_HOME and ORACLE_SID variables.

3.

Start sqlplus.

4.

Connect to the Oracle target database as the Oracle database user, first with
the sysdba role and then with the sysoper role.

Integration guide for Oracle and SAP

169

Advertising