Re: Problem when WIndows 2000 Server is rebooted

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 12 Aug 2006 01:06:32 +0200
Message-ID: <g63qd2d3polqssrf5uasdp6mchceijjpnr@4ax.com>

On 11 Aug 2006 15:49:59 -0700, dbaplusplus_at_hotmail.com wrote:

>I am running Oracle 10.1.0.3 on Windows 2000 server. I have a few
>database instances. I have noticed that when Windows server is
>rebooted, once in a while (every 3 month or so). a database instance
>will not start properly. There are no error messages in alert.log file,
>however when one connects to database instance, it gives some error
>message.
>
>As I stated problem happens only once in a while and it is also not
>tied to a specific database instance (I have 3 instances). Has anyone
>seen similar problem and knows how to fix it in Windows 2000
>environment (I cannot move to UNIX, LINUX ...).
>
>Thanks.

I don't know whether I once in a while have a 'similar' problem is, because my crystall ball is broken, and is unable to determine what 'some error' constitutes.

On Windows Oracle first start the service OracleService<sid> and after that the instance.
So the troubleshooting steps are evident. One would expect a 'dbaplusplus' would know those.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 11 2006 - 18:06:32 CDT