Use of r3trans-d

[Former Member]

Hi all,

I am new to BASIS, i want to know what's is the USE of "r3trans-d" ? what is the difference if you logon to Oracle database with SIDADM OR ORAADM? What are the scenarios?

[Former Member]

Hi Kittu,

OS users and user groups in

UNIX

ora<dbsid> dba.......Full admnin of all instances

oper......Restricted admin of all instances

<sapsid>adm dba.......Full admnin of all instances

oper......Restricted admin of all instances

WINDOWS

<sapsid>adm ora_<dbsid>_dba Full admnin of all <dbsid>

ora_<dbsid>_oper Restricted admnin of all <dbsid>

ora_dba Full admnin of all instances

sapservices<sapsid> ora_<dbsid>_dba Full admnin of all <dbsid>

ora_<dbsid>_oper Restricted admnin of all <dbsid>

ora_dba Full admnin of all instances

Members of operating system group dba (UNIX) or ORA_DBA or

ORA_<DBSID>_DBA (Windows) can connect to the Oracle instance with

system privilege SYSDBA and perform administrative work there.

Members of operating system group oper (UNIX) or ORA_<DBSID>_OPER

(Windows) can connect to the Oracle instance with system privilege

SYSOPER and perform corresponding administrative work there.

A member of the Windows local group ORA_<DBSID>_DBA can connect to

and administer the instance <DBSID>, a member of

ORA_DBA is able to do this in any Oracle instance installed on the

corresponding host.

So far as oracle db is concerned apart from SYS ans SYSTEM user the

following oracle users are also creted in sap

SAP<SCHEMA-ID> (or SAPR3 up to SAP Basis4.6D).SCHEMA-ID

is, in most cases, identical with SAP SID. All tables and indexes of the

corresponding SAP system belong to the schema of this database user. However,

SAP<SCHEMA-ID> does not have privileges to perform administrative actions

on the database; it is not assigned the database roles DBA or SAPDBA.

OPS$<USERNAME> make use of an Oracle feature called operating system authentication.

If the user OPS$<USERNAME> is defined as identified externally at the database level,

it has no password and the operating system user <USERNAME> can connect to the database

without authentication, provided the following two Oracle parameters are set:

REMOTE_OS_AUTHENT=TRUE

OS_AUTHENT_PREFIX=OPS$

I dont think there is a user ORAADMIN.

Pl award suitably if resolved.

Regards

[madhukara_shenoy]

Hello,

R3trans –d Check if connect to database is possible and if the ABAP Dictionary is available.

Login to the database with ora<SID> and <SID>adm could be same as long as OS user has belongs to the same OS groups (oradba and oraoper). But it makes difference with which database user you connects to the database?

Regards,

Madhukar