|
[oracle-l]
||
[Date Prev]
[07-2005 Date Index]
[Date Next]
||
[Thread Prev]
[07-2005 Thread Index]
[Thread Next]
Re: How to change the value of Sysdate
- From: Ram K <lambu999@xxxxxxxxx>
- To: David Sharples <davidsharples@xxxxxxxxx>
- Date: Sat, 2 Jul 2005 15:20:05 -0700
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
|
|
