Skip to Content

Creating a tablespace and a user for BMC Network Automation installation (Linux)

Before installing BMC Network Automation, you must complete the following tasks on the target host:

To create a user for the BMC Network Automation installation (Linux)

You must create an operating system user account (for example, bcan) when installing the BMC Network Automation product. For example:

  1. Open a command window.

  2. At the prompt, enter the following commands: 


    adduser <userName>
    passwd <userName>

To create a tablespace and user for Oracle

As a database administrator user (for example, system) perform the following steps:

  1. Create a BCAN data tablespace with a default data file size of 500 MB and set the Auto extend option on.
  2. Create an Oracle database user (for example, bbna_8100) and grant the following privileges :
    • create/alter/drop tables/indices/constraints/views
    • insert/update/delete rows

The sample database script below further explains the steps.

Warning

Note

To execute the following commands, you must log in to SQLPlus as a user with Oracle DBA privileges.


CREATE SMALLFILE TABLESPACE "BCAN" LOGGING DATAFILE '/data1/oracle/oradata/ora11db/bcan.dbf'

SIZE 500 M REUSE AUTOEXTEND ON NEXT 512M MAXSIZE 30720 M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 56K

SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER "BCAN"  PROFILE "DEFAULT" IDENTIFIED BY bcan123 DEFAULT TABLESPACE "BCAN" QUOTA

UNLIMITED ON "BCAN";

GRANT CONNECT, RESOURCE TO "BCAN";

 

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

BMC Cloud Lifecycle Management 2.1.00