Re: Oracle Startup Problem -- Shared memory realm does not exist.

jiggamanrocks_at_yahoo.com (jiggaman) wrote in message news:<5374d389.0312171117.146334eb_at_posting.google.com>...
> hi
>
> Just installed oracle8i EE on Windows 2000 server. all installation
> was fine. Created the database ..everything went on sucessfully. When
> i restarted my machine oracle did not start automatically. when i try
> to login using system/manager it gives me the err saying Oracle not
> available and that the shared memory realm does not exist. Upon
> examing my process in the task manager i found that there was a
> oracle.exe process running utilizing around 8 Megs of memory. so i
> went into svrmgrl and connected using internal and gave the startup
> command and the database was mounted sucessfully. After that i have
> my database up and running fine and i can use it as i want.
>
> The Problem is everytime i restart my machine i have to go thru this
> process of manually going into svrmgrl and then starting it. I know
> previuosly we had a dba and at that time when the machine was
> restarted, oracle was start automatically. How can this be achieved on
> my current database. are they some extra parameters that need to be
> set somewhere ??
>
> any and all help in this matter will be hight appreciated.

There should be some system service that starts with Ora and has the system identifier in it. That could be set to automatically start.

However, there are potential problems with this (particularly with possible database or registry corruption on automatic shutdown or in backups) so some people purposefully make it a manual operation, and others use startup scripts with the plugin group resources stuff. It depends on what the machine is doing. Look for startup scripts (or maybe your DBA left some manual procedures) with ORADIM. Type in ORADIM in a dos box (pathed to your oracle home bin) for syntax.

If you are not already subscribed to metalink.oracle.com, get on there, there are many FAQ's about running on Windows. That is the preferred support method, too.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/business/20031209-1330-linuxthreat.html