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.
- Open a command window.
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:
- Create a BCAN data tablespace with a default data file size of 500 MB, and set the Auto extend option to on.
- 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.
To execute the following commands, you must log on to SQL*Plus 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";