Re: How to change the value of Sysdate

Hi all,     

   Problem: Database doesnt start.
   After playing with the fixed_date and then unsetting it with NONE option, I rebooted the machine later; tried to restart Oracle. Logged into sqlplus /nolog as sysdba then:

16:34:40 SQL> show user;
USER is "SYS"
16:35:00 SQL> startup mount;
ORA-00065: initialization of FIXED_DATE failed

16:35:43 SQL> alter system set fixed_date=NONE; alter system set fixed_date=NONE
*

ERROR at line 1:
ORA-01034: ORACLE not available

16:37:58 SQL> alter system set fixed_date='23-DEC-2004'; alter system set fixed_date='23-DEC-2004'
*

ERROR at line 1:
ORA-01034: ORACLE not available

16:38:18 SQL> startup mount;
ORA-00065: initialization of FIXED_DATE failed

16:38:44 SQL> startup;
ORA-00065: initialization of FIXED_DATE failed

   ---

16:41:55 SQL> startup force;
ORA-00065: initialization of FIXED_DATE failed 16:42:07 SQL>
16:42:07 SQL> shutdown abort;
ORACLE instance shut down.

16:42:15 SQL> startup mount;
ORA-00065: initialization of FIXED_DATE failed 16:42:19 SQL> startup nomount;
ORA-00065: initialization of FIXED_DATE failed

I rebooted the machine twice and tried, but the problem remains.  

only thing I did after playing with the fixed_date parameter was "alter system archivelog start to '/some/file'".

After rebooting the computer first time, I tried to 'alter system archivelog stop', I get 'ORACLE not available'.    

Env: Win 2000/Oracle 9.2.0.1.0. Using spfile.    

-- 
Thanks,
Ram.
--
http://www.freelists.org/webpage/oracle-l