Unable to start Oracle 12 database using High Availability Extension resource agent for Oracle
This document (7018429) is provided subject to the disclaimer at the end of this document.
SUSE Linux Enterprise High Availability Extension 11 Service Pack 4
SUSE Linux Enterprise Server 12 Service Pack 1 (SLES 12 SP1)
SUSE Linux Enterprise Server 12 Service Pack 2 (SLES 12 SP2)
SUSE Linux Enterprise Server 11 Service Pack 4 (SLES 11 SP4)
When trying to start an Oracle database via the the Oracle resource agent, one or more of the following errors is seen in /var/log/messages.
ERROR: could not create OCFMONPROFILE oracle profile
ERROR: sqlplus output: create profile OCFMONPROFILE limit FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED
* ERROR at line 1: ORA-65140: invalid common profile name
ERROR: monprofile must start with C## for container databases
ERROR: monuser must start with C## for container databases
Instance attributes: sid orcl
Note: The monitor profile entry should be auto-created if it does not already exists.
Remember to edit the /etc/oratab file (if it exists) and set the database Y/N start field to 'N' so that the HAE Oracle resource agent can be responsible for the start/stop of the database.
Note: Always use the latest resource agents available for the version of SUSE Linux Enterprise High Availability Extension being used (search for 'resource-agents' under the appropriate product/version on patch finder).
This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7018429
- Creation Date: 31-Dec-2016
- Modified Date:03-Mar-2020
- SUSE Linux Enterprise High Availability Extension
- SUSE Linux Enterprise Server
For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com