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
oracleresource 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
OCFMONPROFILEMPROFILEprofiles in database ? - Why do we need to create
ocfmonuser in the database ?
Environment
- Red Hat Enterprise Linux (RHEL) 6 or 7 with the High Availability Add-On
pacemaker- One or more
oracleresources in the CIB Standard configurationdatabase 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
