Oracle resource failing to get started

Solution Verified - Updated -

Issue

  • Oracle resource is not getting started in a RHEL 7 pacemaker cluster
oracle(oracle_resource): ERROR: could not create EXCEPTION_PROF oracle profile
oracle(oracle_resource): ERROR: sqlplus output: create profile "EXCEPTION_PROF" limit FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED#012*#012ERROR at line 1:#012ORA-01109: database not open#012#012#012select PROFILE from dba_profiles where PROFILE='EXCEPTION_PROF'#012                    *#012ERROR at line 1:#012ORA-01219: database or pluggable database not open: queries allowed on fixed#012tables or views only
lrmd:  notice: oracle_resource_start_0:18135:stderr [ ocf-exit-reason:could not create EXCEPTION_PROF oracle profile ]
crmd:  notice: Result of start operation for oracle_resource on node_1: 1 (unknown error)

Environment

  • Red Hat Enterprise Linux 7
  • Pacemaker

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