Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Pre-creating an Oracle database for BMC AR System Server – Cloud Portal and Database

Optionally, if you want to pre-create an Oracle database on Linux for BMC AR System Server – Cloud Portal and Database, use the following lines of code:

Note

You must name the tablespace as "ARSystem". Otherwise, your product installation might fail.

Create temporary tablespace MYARTEMP
  TempFile '/data1/oracle/oradata/ora11db/mytemp01.tmp' SIZE 1024M      
  Extent management local uniform SIZE 16M;

create tablespace ARSystem
  datafile '/data1/oracle/oradata/ora11db/ARSys.dbf'
  size 7000M reuse;

create user ARAdmin identified by AR#Admin#
  default tablespace  ARSystem temporary tablespace MYARTEMP
  quota unlimited on ARSystem;

create role ARole_arsys not identified;

grant alter session, create cluster, create database link, create  sequence,
  create session, create synonym, create table, create view, create procedure,
  create trigger, query rewrite to ARole_arsys;

grant ARole_arsys to ARAdmin;

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments