Manually creating a tablespace and a user for BMC Network Automation on Linux

The BMC Cloud Lifecycle Management Installer helps you automatically create the user and the database during the BMC Network Automation installation. As an alternative, you can perform this task manually if do not want the installer to create the user and the database for the the BMC Network Automation product or if any issues occurred with the user and database that the installer previously created. 

If you do not want to use the installer to create the user and database, you must perform the following manual steps on the BMC Network Automation host in a Linux environment:

To manually create a user for the BMC Network Automation installation

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

1. Open a command window.

2. At the prompt, enter the following commands:

   adduser <userName>
   passwd <userName>
   

To manually 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 to 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 following sample database script further explains the steps.

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";