ORA-27101: shared memory realm does not exist

sql oracle ubuntu oracle-xe
Gnaniyar Zubair picture Gnaniyar Zubair · Jul 21, 2010 · Viewed 28.6k times · Source

i am facing this error when i start the oracle. I checked Oracle Home and SID. everything is set properly.

ORA-27101: shared memory realm does not exist

please help me to find out the solution. Thanks in advance

Answer

Adam Musch picture Adam Musch · Jul 21, 2010

That error generally means there's no Oracle instance (the processes) to connect to. Someone needs to log in and start the instance.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x 123 2 y 345 In oracle SQL, how do I run an sql update query that can update Table 1 with Table 2's name and desc using …

Read More