KNOWLEDGE BASE

ORA-01034: ORACLE Not Available


Published: 13 Jul 2017
Last Modified Date: 02 Dec 2019

Issue

When connecting to an Oracle data source, the following error occurs:
ORA-01034: ORACLE not available ORACLE 27101: shared memory realm does not exist Linux-x86 Error: 2: No such file or directory

Environment

  • Tableau Desktop
  • Mac OS
  • Oracle

Resolution

Work with your DBA to initialize the Oracle database. Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages.
If Oracle has been initialized, verify that Oracle was linked correctly. 

Cause

Oracle was not started up. Possible causes include the following:
  • The SGA requires more space than was allocated for it.
  • The operating-system variable pointing to the instance is improperly defined.
Did this article resolve the issue?