Skip to Content
Information
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 Remedy AR System and BMC Remedy ITSM Suite

To pre-create an Oracle database on Linux for the BMC Remedy AR System and BMC Remedy IT Service Management Suite product, use the following lines of code:

Warning

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;

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Cloud Lifecycle Management 3.1