oracle resource fails to start with multi-tenant container Oracle 12c and Oracle 11 database with "ORA-65140: invalid common profile name" in a RHEL 7 High Availability cluster

Solution Verified - Updated -

Issue

  • If Oracle 12c DB is configured as multi-tenant container database, resource agent has trouble creating monitoring user when starting DB
  • My oracle resource fails to start referencing a monitoring profile OCFMONPROFILE that is not valid for my environment
Feb 24 13:13:28 rhelnode1 oracle(oracle12_baza)[5032]: ERROR: could not create OCFMONPROFILE oracle profile
Feb 24 13:13:28 rhelnode1 oracle(oracle12_baza)[5032]: ERROR: sqlplus output: create profile OCFMONPROFILE limit FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED#012               *#012ERROR at line 1:#012ORA-65140: invalid common profile name
  • If I set monprofile on my oracle resource, it still seems to try to use the value OCFMONPROFILE and fails to start

Environment

  • Red Hat Enterprise Linux (RHEL) 6 or 7 with the High Availability Add-On
  • pacemaker
  • One or more oracle resources in the CIB
  • Multi-tenant container 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