How to change the value of Sysdate 2005-07-02 - By Ram K
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 (See ORA-00065.ora-code.com): 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 (See ORA-01034.ora-code.com): 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 (See ORA-01034.ora-code.com): ORACLE not available
16:38:18 SQL> startup mount;
ORA-00065 (See ORA-00065.ora-code.com): initialization of FIXED_DATE failed
16:38:44 SQL> startup;
ORA-00065 (See ORA-00065.ora-code.com): initialization of FIXED_DATE failed
---
16:41:55 SQL> startup force;
ORA-00065 (See ORA-00065.ora-code.com): 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 (See ORA-00065.ora-code.com): initialization of FIXED_DATE failed
16:42:19 SQL> startup nomount;
ORA-00065 (See ORA-00065.ora-code.com): 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
|
|
