Re: ORA-27101: Shared Memory Does Not Exist

"Keith A. Jakubowski" <kjakubowsk_at_aol.com> wrote in message news:3FA929A5.2309_at_aol.com...
> Can anyone help me?
>
> I am currently working towards the 2nd certification exam and I am now
> having a problem. I have been using Oracle 8i and I just recently
> upgraded to Oracle 9i. The Oracle 9i installation was successful and my
> database converted over fine. After the installation I was able to use
> SQL*Plus and everything was fine. I was able to log in and was able to
> access all of my tables. However, I rebooted my PC today (first time
> since the installation) and I am now getting the following error when
> trying to log on to SQL*Plus:
>
> ORA-01034: Oracle not available
> ORA-27101: Shared memory does not exist

On Windows, that error message often indicates that the service required to support the instance is not running. So open the Control Panel, find the Services applet, and check whether the 'OracleServiceXXXX' ("xxxx" being the name of your database/instance) is running and start it if not. Make sure the service is set to auto-start for future reboots.

Other than that, it can mean that although the service is started, the instance isn't. In which case connecting as a privileged user and issuing ye olde startup command should do the trick.

>
> I can't log in and I can't figure out how to fix this. Does anyone have
> any suggestions?
>
> My PC specs are:
>
> Gateway Laptop
> OS: Windows XP Home

See, this is where things start to go a bit dodgy. No version of Oracle is certified for Windows XP Home. You should be running XP Professional. Or Windows 2000 Professional. But a "professional" O/S nonetheless. Given your lack of RAM (see below), I'd be ditching XP and switching to W2K.

> Processor: P4 2.00 GHz
> Memory: 256 MB RAM

That's a bit thin. 9i will work in 256MB, but its approaching 'bare minimum', and depending on how you've fine-tuned your init.ora parameters, you may well run into trouble starting instances. The Database Configuration Assistant's proposals for shared pool, large pool, java pool and buffer cache seem to think everyone has shares in a RAM foundry, for one thing. 512MB is a useful realistic minimum these days.

Regards
HJR Received on Wed Nov 05 2003 - 13:11:36 CST