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

"jiggaman" <jiggamanrocks_at_yahoo.com> 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 ??

most likely all you need to issue at a command prompt is

oradim -edit -sid <yoursid> -startmode a

You might also want to take a look at oradim.log before you do this and after a restart and see what is recorded there.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************