KNOWLEDGE BASE

ORA-01034: ORACLE Not Available


Published: 13 Jul 2017
Last Modified Date: 09 Aug 2017

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 10.0.0
  • 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?