ORA-01034: ORACLE Not Available

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


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


  • Tableau Desktop
  • Mac OS
  • Oracle


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. 


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?