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
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 referencingCommand 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.