Machine time change and login/startup problem

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Jun 2004 12:10:48 -0400

Hi, 

We are using 10g on windows and whenever I changes system clock to past,
oracle doesn't startup. And I get errors: 

SQL> connect sys/[Email address protected] as sysdba 
ERROR: 
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor 


SQL> connect / as sysdba 
ERROR: 
ORA-01041: internal error. hostdef extension doesn't exist 

More error like this when try to connect to already running oracle after
time changes: 

R:\>sqlplus hs/hs 

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Feb 18 16:06:39 2004 

Copyright (c) 1982, 2004, Oracle. All rights reserved. 

ERROR: 
ORA-28547: connection to server failed, probable Net8 admin error 

But if I change clock back to current time it start working again. 

What is the workaround to be able to change date to the past date and
still use oracle. 

Thanks 
--Harvinder 



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: