oracle resource fails to start with Oracle 12c and Oracle 11 database with "ORA-47400: Command Rule violation for CREATE PROFILE on OCFMONPROFILE" in a RHEL 7 High Availability cluster

Solution Verified - Updated -

Issue

  • If Oracle 12c DB is configured as standard configuration, resource agent has trouble creating monitoring user when starting DB
  • My oracle resource fails to start referencing Command Rule violation for CREATE PROFILE on MPROFILE
Apr  4 12:06:12 rhelnode1 oracle(QLASDBRSR)[19092]: ERROR: could not create MPROFILE oracle profile
Apr  4 12:06:12 rhelnode1 oracle(QLASDBRSR)[19092]: ERROR: sqlplus output: Login    Name                 TTY      Idle   When             Where#012root     root                 tty1     00:40  2017-04-04 11:25#012root     root                 pts/0           2017-04-04 11:22 dohqdkvm19.qr.qrgrp.local#012create profile "MPROFILE" limit FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED#012*#012ERROR at line 1:#012ORA-47400: Command Rule violation for CREATE PROFILE on MPROFILE
Apr  4 12:06:12 sldohd5sdbc0501 crmd[3993]:  notice: Result of start operation for QLASDBRSR on sldohd5sdbc0501.qr.qrgrp.local: 1 (unknown error)
  • Why do we need to create OCFMONPROFILE MPROFILE profiles in database ?
  • Why do we need to create ocfmon user in the database ?

Environment

  • Red Hat Enterprise Linux (RHEL) 6 or 7 with the High Availability Add-On
  • pacemaker
  • One or more oracle resources in the CIB
  • Standard configuration database Oracle 12c
    • Monitoring profile uses non-default username other than "MONPROFILE"
  • Oracle 11 database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content