ORA-27101: shared memory realm does not exist.
We have been seeing the same error on a daily basis. We are running Resin application server with a database connection to Oracle on the same machine. This is a common configuration that all of us use on our development boxes. We have a training server for outside access to groups around the country to use to learn our applications. Nearly every morning we come in to find this error has occurred. If we check the Windows services, Oracle is running. If we stop and restart the service, everything picks up fine. This is happens on this box, and yes the service is set to start automatically -- although this is not relevant as the error is occurring when we have a connection open. Do you have any idea what is wrong?
connect / as sysdba
The instance will be down, but if you look at the services, the service will still be running. Give the "startup" command to start the instance.
So the trick is to find out why your instance is not running. Look in the directory denoted by your BACKGROUND_DUMP_DEST parameter. Your Alert log is in this directory. The Alert Log should contain a clue as to why the instance was terminated. There might also be some trace files in that directory which can give clues. You'll have to look at the Alert log to narrow down the cause of your problem.
Dig Deeper on Oracle database design and architecture
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.