Re: Why my Oracle Instance Fails..?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 Nov 2005 08:56:00 +0100
Message-ID: <godon19o3v1irqinj17ncqoo8ipba0fja2@4ax.com>

On 16 Nov 2005 22:07:03 -0800, "Sreelal" <sreelalpp_at_gmail.com> wrote:

>Hi,
>
> I have Oracle 9i installed in Windows 2000.
> When i change the system time in windows to any year greater
> than 2039, the the oracle instance fails.
>
>Why it is so?
>
>
> thank you
> Lal

This question can not be answered without - information about the *exact* version of Oracle - any specific error messages (we weren't there when the instance 'failed')

- The NLS settings of the instance
- the Windows regional settings
- the business rationale for mucking around with the system time,

because likely you won't work there any more in 2039.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Nov 17 2005 - 01:56:00 CST