SEO

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.

TIA

Jigga

"jiggaman" <jiggamanrocks@yahoo.com> wrote in message
news:5374d389.0312171117.146334eb@posting.google.c om...
> 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
******************************************

jiggaman wrote:

> 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.
>
> TIA
>
> Jigga

Go into the Control Panel - Services and set startup for the Oracle
Service and Listener to auto.

If that doesn't work ... go to $ORACLE_HOME\bin. Use oradim.exe to drop
and then recreate the service using the startmode auto parameter.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

On 17 Dec 2003 11:17:22 -0800, jiggamanrocks@yahoo.com (jiggaman)
wrote:

>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.
>
>TIA
>

Check out %ORACLE_HOME%\database\oradim.log for errors
and c:\oracle\admin\%ORACLE_SID%\bdump\alert_%ORACLE_S ID%.log
for errors, resolve them or post them here.
Actually this is a FAQ, and I have provided this advice many times.
You are advised to search the Google archives prior to posting.


>Jigga

--
Sybrand Bakker, Senior Oracle DBA

jiggamanrocks@yahoo.com (jiggaman) wrote in message news:<5374d389.0312171117.146334eb@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/b...nuxthreat.html