Oracle Connect String for Oracle RAC Instances

The Oracle connect string is a user account that has database administrator privileges that you use to access the standard and recovery catalog databases.

Note: If you want to use a user account other than ‘sys’, you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or more recent versions) privilege to the user account.

The account information is provided as a connect string with the following information:

  • The Oracle database user ID

  • The password for the user ID

  • The Oracle service name

You can use separate accounts to access the standard database and the recovery catalog database. The recovery catalog database user account must have recovery catalog owner privileges.

By default, the user account for the standard database has administration privileges. If you want to use a different account, use the following table for the user account requirements to access the database:

Account type

The user account must have:

Administrator

  • Oracle database administration privileges

  • SYSDBA or SYSBACKUP (in Oracle version 12 or more recent versions), ALTER SYSTEM, and SELECT ANY TABLE system privileges.

Non-administrator

Access to specific objects (as opposed to the admin account with the SELECT ANY TABLE privilege)

For example:

  • SELECT ON "SYS"."V_$DATABASE"

  • SELECT ON "SYS"."V_$DATAFILE"

  • SELECT ON "SYS"."V_$SESSION"

  • SELECT ON "SYS"."DBA_TABLESPACES"

  • GRANT SELECT ON "SYS"."V_$ARCHIVE_DEST" TO "USER_NAME

The Oracle database administrator can establish all other accounts except an Impersonate User account.

Modifying the Oracle Connect String for Oracle RAC Instances

Loading...