Create Oracle database and user for the Automation Engine.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Create an Oracle database user:

create user <user> identified by <password>;

Assign privileges to the Oracle user:

GRANT create table, create sequence, create session, create procedure, execute any procedure, create public synonym, drop public synonym, create view, alter session, select any dictionary TO <user>;

Since version 21.0.4 also the grant create trigger is needed:

GRANT create table, create sequence, create session, create procedure, create trigger, execute any procedure, create public synonym, drop public synonym, create view, alter session, select any dictionary TO <user>;

GRANT execute ON dbms_lock TO <user>;
GRANT unlimited tablespace TO <user>;

Create the two tablespaces for data and index:

CREATE TABLESPACE UC4_DATA

DATAFILE '/u01/app/oracle/oradata/orcl/orclpdb/uc4_data.ora'

SIZE 1024M

AUTOEXTEND ON NEXT 1024M MAXSIZE 30000M

DEFAULT STORAGE (INITIAL 512K NEXT 2048K MAXEXTENTS UNLIMITED);

 

CREATE TABLESPACE UC4_INDEX

DATAFILE '/u01/app/oracle/oradata/orcl/orclpdb/uc4_index.ora'

SIZE 512M

AUTOEXTEND ON NEXT 512M MAXSIZE 30000M

DEFAULT STORAGE (INITIAL 512K NEXT 512K MAXEXTENTS UNLIMITED);

These two steps are optional:

alter user <user> default tablespace UC4_DATA;

create profile <profile> limit password_life_time unlimited;
alter user <user> profile <profile>;

Resolution

Further information for Oracle can be found in our documentation:

Preparing the AE Database - Oracle