Oracle error
ORA-01034
ORA-01034: ORACLE not available
What usually causes it
The instance isn't running, or ORACLE_SID or ORACLE_HOME points at a different instance. Often paired with ORA-27101.
What to check first
Check your environment variables and the instance status, then the alert log for why it stopped.
Scripts that help
- Instance status on every nodeHost, instance, version, status, whether logins are allowed, startup time and archiver state for every instance. A quick RAC-wide check after a…
- Cluster status commands (srvctl and crsctl)The Clusterware commands for checking a RAC database, its services and every cluster resource.
- Where the alert log and trace files areThe ADR home, alert log directory, trace directory and this session's own trace file.