Connecting to database says "Connected to an idle instance" while database is running.
Issue
- Oracle database server crash during the night after system upgrade
- connecting to database says "Connected to an idle instance" while database is running
- Any sql executed or statedump fails with Oracle errors:
ORA-01034, ORA-27123, Linux errno 22 - Orcale logs contains error messages like
ORA-27123: unable to attach to shared memory segment
kkjcre1p: unable to spawn jobq slave process
- sysrev shows "instance not alive"
Environment
- Red Hat Enterprise Linux 6
- Red Hat Enterprise Linux 7
- Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
- Large Oracle Shared Global Area (SGA) - mostly above 207 GB
- prelink is enabled
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.