oracledb resource fails to start when Oracle reports "ORA-32004: obsolete or deprecated parameter(s) specified" in a RHEL 6 High Availability cluster with rgmanager
Issue
- An
oracledbresource is failing on start even though the database actually starts successfully. oracledbseems to fail if the database reports that there is a deprecated parameter in use
Dec 23 12:43:18 example root[3392]: [gisd] [0] got ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance#012ORACLE instance started.#012#012Total System Global Area 6797832192 bytes#012Fixed Size#011#011 2266144 bytes#012Variable Size#011#011 4278193120 bytes#012Database Buffers#011 2499805184 bytes#012Redo Buffers#011#011 17567744 bytes#012Database mounted.#012Database opened.
- After having applied OS updates on the first node and rebooted it an
oraceldbresource failed to start. It starts fine on the second node which hasn't been updated.
Sep 30 18:55:58 rgmanager [oralistener] Validating configuration for LISTENER
Sep 30 18:56:00 rgmanager [orainstance] Validating configuration for oracle
Sep 30 18:56:09 rgmanager start on orainstance "oracle" returned 1 (generic error)
Sep 30 18:56:10 rgmanager #68: Failed to start service:prd; return value: 1
Sep 30 18:56:10 rgmanager Stopping service service:prd
Environment
- Red Hat Enterprise Linux (RHEL) 6 with the High Availability Add On
rgmanager- One or more
oracledbresources in/etc/cluster/cluster.conf
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.
