10

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

OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
Gnaniyar Zubair
  • 8,114
  • 23
  • 61
  • 72
  • What OS? What Oracle version? – DCookie Jul 21 '10 at 19:24
  • Version: Oracle-Xe - Server : Ubuntu – Gnaniyar Zubair Jul 21 '10 at 19:27
  • 1
    What are `ORACLE_HOME` and `ORACLE_SID` set to, are they exported in the shell (not just set), and does the SID exactly match the process: what does `ps -fe | grep pmon` show? – Alex Poole Jul 21 '10 at 20:27
  • ORACLE_SID = XE ORACLE_HOME = bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server ps -fe | grep pmon shows like : jubair 4564 3458 0 02:13 pts/0 00:00:00 grep --color=auto pmon – Gnaniyar Zubair Jul 21 '10 at 20:47
  • That looks like there's no ora_pmon_XE process, indicating the DB isn't running, but I'm not entirely clear from your question whether you're getting the error on startup or trying to access after start. Is the 'bash: ' in the ORACLE_HOME a transcription error? (does `ls $ORACLE_HOME` show the expected directory contents, or an error?) Is there anything in the alert log? – Alex Poole Jul 21 '10 at 21:11
  • That ORACLE_HOME value looks a bit odd to me. Should just be a path. I think @Adam is correct, instance needs to be started. – DCookie Jul 21 '10 at 21:15

2 Answers2

14

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

Adam Musch
  • 13,286
  • 2
  • 28
  • 32
3

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.

mikevdg
  • 370
  • 1
  • 7