We are running Oracle 10.2.0.2.0 on a windows 2003 server. We have a script that shuts the database down every night, makes a cold backup and then restarts it. About once a month we get the error ORA-01034: ORACLE not available and ORA-27101: shared memory realm does not exist
If I connect via sqlplus I am unable to start the database but rebooting the server cures it.
Most of the most of what I can find online points to this problem happening all of the time not occasionally. I have tried adding physical RAM and changing memory parameters.