Customise Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorised as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

ORA-27101: shared memory realm does not exist

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 08 Nov, 2021
  • 0 Comments
  • 1 Min Read

ORA-27101: shared memory realm does not exist

ORA-27101: shared memory realm does not exist

Cause: Unable to locate shared memory realm

Action: Verify that the realm is accessible

There may be 2 scenarios, which may lead you to encounter ORA-27101

1) Invalid ORACLE_HOME and ORACLE_SID

2) Database is down

1
2
3
4
5
6
7
[oracle@192 ~]$ sqlplus scott/tiger
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 22 16:48:05 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Scenario 1: Invalid ORACLE_HOME and ORACLE_SID:

ORA-27101 is usually due to the invalid ORACLE_HOME and ORACLE_SID parameters at OS level. You should investigate that ORACLE_HOME and ORACLE_SID are set correctly, and ORACLE_HOME should be without trailing slash.

1
2
3
4
5
[oracle@192 ~]$ echo $ORACLE_HOME
/data/app/oracle/product/10.2.0/db_1
 
[oracle@192 ~]$ echo $ORACLE_SID
testdb

In our case ORACLE_SID was not correct, we need to export ORACLE_SID to the valid one which is ora19c

1
2
3
4
5
6
7
[oracle@192 ~]$ export ORACLE_SID=ora10g
[oracle@192 ~]$ sqlplus scott/tiger
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 22 16:52:11 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Scenario 2: Database is down:

You may also face it when the database is down, to solve ORA-27101 you may have to start the database only

1
2
3
4
5
6
7
8
9
10
11
12
13
14
[oracle@192 ~]$ sqlplus sys/sys as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 22 17:07:38 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size                  1219112 bytes
Variable Size             167773656 bytes
Database Buffers         1040187392 bytes
Redo Buffers               15556608 bytes
Database mounted.
Database opened.