Jack:

# After restart (Win7-64b =about 2k8R2 *rdbms alerts "Beginning
crash recovery"

.... I think it (OS) does not shutdown database, there was somewere
some bat-file when shutding down OP. Or what could fix this?

There should be a windows service installed that handles starting up
and shutting down a database. In windows probably an auto start type
of thing.

I think it is a really really bad idea to automate starting a database
on a server reboot. What if you were having some kind of storage
problem or hardware problem etc that is not yet diagnosed and/or fixed
completely.

The last thing in the world you want to happen is several restarts in
a row where Oracle may be trying to recover things and may have dicey
and/or incomplete view of the environment.

My recommendation is to disable windows services ( and unix/linux
similar things ) that start up database automatically. Take control
of those decisions!

On Nov 17, 6:39*am, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:
Check your Services applet. Start -> Run -> Services.msc

There should be a service called "OracleService<instance_name>". This
service is responsible for starting and stopping the Oracle instance.
As John Hurley suggested, I would ensure that this service is set to
"manual".

Then I would shut the database down, rename the current alert log and
reboot the server. Check your Event Log after startup for any clues,
then start the Oracle service you set to manual above then re-examine
the alert log.

HTH
-g

On Nov 16, 10:39*pm, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:
See MOS Database Does Not Shutdown Cleanly When Oracle Service Is
Restarted [ID 437876.1]

There is a long-running dispute between how MS and Oracle handle this,
I don't know the Win7+modern Oracle aspects, if any. I may be doing
such an installation at some unknowable point in the future, depending
on a vendor demo in another department, so I'd be interested in what
you find.

I have mixed feelings about auto restart, I've seen bigtime screwups
as John described, but since I'm on a system where I have complete
control, I autostart production, since the usual case is some one-time
thing once a year, while multi-restarts are either a place with bad
communications between departments with distributed control (like the
hardware maintainer comes in and pulls the plug, thinking everything
was ready), or a hardware issue so bad it means moving to another box
anyways. Standbys are a good thing, YMMV.

jg
--
@home.com is bogus.
Those darn computer glitches! http://www.signonsandiego.com/news/2...ll-city-audit/

"joel garry" <joel-garry (AT) home (DOT) com> kirjoitti
viestissä:a2db7bf2-8f52-4677-8c06-f3e14ca94dd2 (AT) w21g2000vby (DOT) googlegroups.com...
On Nov 16, 10:39 pm, "Jack" <n... (AT) INVALIDmail (DOT) com> wrote:
--
@home.com is bogus.
Those darn computer glitches!
http://www.signonsandiego.com/news/2...ll-city-audit/
--------------------------------

Note, value of 0,05?

w2k3 OK.
w2k8x64 (x86) not matured, good try but not 100% valid. Better luck next
time/next year.
Rigths to change opinion reserved
Lets see what tomorrow will show in servers/farms/clouds, hope to have good
mood (by sailing/ambiguous term Hyvällä tuulella ).

Thanks -Jack-
just one a bit "angry bird "
http://musicwn.com/browse.php?artist...C3%A4+tuulella
http://download.mtv3.fi/album/Mikko_...-DB29E075499E/