Creating BMC Client Management database


  1. Log on as the Oracle user.

    su – oracle
  2. Run the following command.

    /dbca
  3. In step 4 (Database Identification), provide a global database name and SID and click Next.

    dbca4.png

  4. In step 5 (Storage Options), select a storage option and click Next. See Oracle-recommendations for the recommended disk layout.
    dbca5.png
  5. In step 6 (Fast Recovery Options), select the recovery options for the database and click Next.
    dbca6.png
  6. In step 7 (Network Configuration), select Create a new listener and click Next.
    dbca7.png
  7. In step 8 (Database Options), clear the unnecessary options for BCM database and click Next.
    dbca8.png
  8. In step 9 (Configuration Options), select the Use Automatic Shared Memory Management option and click Next. See Oracle-recommendations for the recommended memory size.
    dbca9_1.png
  9. Go to the Sizing tab and configure the block size and number of backgrounds processes. Click Next.
    dbca9_2.png
  10. Go to the Character sets tab and configure the database character set. Click Next.
    dbca9_3.png
  11. Go to the Connection mode tab and select the connection mode. Click Next.
    dbca9_4.png
  12. Go to the Sample schemas tab and clear this option. Click Next.
    dbca9_5.png
  13. In step 10 (Management Options), specify the management options and click Next.
    dbca10.png
  14. In step 11 (User Credentials), specify the passwords and click Next.
    dbca11.png
  15. In step 12 (Creation Option), select Create database and click All Initialization Parameters

    A table with all initialization parameters and their properties is displayed in a new window.

  16. Click Advanced Parameters to display the complete list.
  17. Modify the values of the parameters as explained in Oracle-recommendations.
  18. Click Close and click Next.
    dbca12.png
  19. In step 13 (Summary), click Finish if all configuration values are correct.

    dbca13.png

  20. In step 14 (Progress Page), wait for the database creation process to finish.
    dbca14.png
  21. In step 15 (Finish), click Close.

    dbca15.png
    Database creation is complete.

 

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

BMC Client Management 21.02.02