CODEWITHSUNDEEP
sqloracle-databaseubuntuoracle-xe
Gnaniyar Zubair
Gnaniyar Zubair

Reputation: 8176

ORA-27101: shared memory realm does not exist

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

Upvotes: 10

Views: 34365

Answers (2)

mikevdg
mikevdg

Reputation: 380

I've just resolved this issue on Debian.

If ORACLE_HOME has a trailing slash, this error appears. If you remove the trailing slash, connection works fine.

Upvotes: 4

Adam Musch
Adam Musch

Reputation: 13583

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

Upvotes: 15

Related Questions