Click to See Complete Forum and Search --> : Oracle shared memory realm does not exist


cpb123
May 28th, 2004, 06:37 AM
Hi,

I have Oracle 9i installed on my laptop running windows xp pro with 3Gig P4, 1GB memory, 60Gb hard disk.

It was all running great until i was running SQL++ and Oracle Forms and SQL++ hung. I managed to kill the process and I restarted my computer. I then ran SQL++ and Oracle forms but when I try to enter my username, password and host String but it couldnt connect as the following error occured:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I managed to fix the problem by removing all the oracle services from startup, rebooting, re-adding the services, rebooting and then running the database configuration program within oracle. The only problem is, that whenever I turn off my computer and restart it, the same error keeps on appearing and I have to repeat the process above to fix it.

Can anybody tell me how to fix this cos going through the process of rebooting my computer twice is rather annoying.

Thank you for your time

kimmckenzie
May 28th, 2004, 09:54 AM
Your database services aren't restarting on boot as they should. First make sure that in services that they are set to start automatically. Some versions of Oracle have a bug in them so that even though set to start automatically they don't. In that case you can write a batch file to start them for you and run on startup.