Creating a service user account in Oracle

To collect data from the Oracle database, Turbonomic requires a service account that has privileges to access the V$ Dynamic Performance view. To create this account:

  • Open a secure shell session (ssh) on the database host as a system user or a user with the sysdba role

  • In the shell session enter the following commands:

    sqlplus /nolog

    connect /as sysdba

    CREATE USER My_Username IDENTIFIED BY My_Password container=all;

    GRANT CONNECT TO My_Username container=all;

    GRANT sysdba TO My_Username container=all;

    This creates a user account named My_Username with full privileges to access the V$ Dynamic Performance view.

Note:

The preceding example uses a fictitious username. To comply with Oracle 12C norms, the username should include a prefix of c##.

Some enterprises don’t allow accounts with sysdba access. IBM recommends using sysdba, according to the Oracle documentation. However, you can work with your Oracle DBA staff to provide read access to the following views, which are the ones that Turbonomic needs:

  • V$INSTANCE

  • V$LOG

  • V$LOGFILE

  • V$PARAMETER

  • V$PGASTAT

  • V$RESOURCE_LIMIT

  • V$SGASTAT

  • V$SYS_TIME_MODEL

  • V$SYSMETRIC

  • V$SYSSTAT