OraFAQ Forum: Server Administration » Oracle & Unix System Date

Home » RDBMS Server » Server Administration » Oracle & Unix System Date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle & Unix System Date [message #179695]

Wed, 28 June 2006 08:06

ziggy25
Messages: 206
Registered: July 2005

Senior Member

I have an application that requires a change to the UNIX system date in order for me to run some regression tests.
I get the following error when i change the system date.

ORA-00600: internal error code, arguments: [2252], [2116], [2164575524], [], [], [], [], []

All databases running on the same system are also not accessible.

Anyone knows what the error means and whats causing it?

This happens on an Oracle 9.2.0.7.0 and the other databases are different versions some are 10G

Thanks

[Updated on: Wed, 28 June 2006 08:10]

Report message to a moderator

Re: Oracle & Unix System Date [message #179700 is a reply to message #179695]

Wed, 28 June 2006 08:16

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Was this database restored recently?
did you set the system time too much away from the time recorded in control file and did a restart of the database?
Please post the contents of alert log .

Report message to a moderator

Re: Oracle & Unix System Date [message #179714 is a reply to message #179700]

Wed, 28 June 2006 08:39

ziggy25
Messages: 206
Registered: July 2005

Senior Member

Mahesh Rajendran wrote on Wed, 28 June 2006 08:16

Was this database restored recently?
did you set the system time too much away from the time recorded in control file and did a restart of the database?
Please post the contents of alert log .

The database was originally version 9.2.0.1 this was upgraded last week.
Before the upgrade, we used to get teh same problems but only if we change the system date and then restart the database. (This happened even we changed just the Oracle date and not the unix date)

Since the upgrade the error is showing up without having to restart the database.

The database was recently upgraded(last week) but not restored..

Report message to a moderator

Re: Oracle & Unix System Date [message #179715 is a reply to message #179700]

Wed, 28 June 2006 08:40

ziggy25
Messages: 206
Registered: July 2005

Senior Member

Mahesh Rajendran wrote on Wed, 28 June 2006 08:16

Was this database restored recently?
did you set the system time too much away from the time recorded in control file and did a restart of the database?
Please post the contents of alert log .

The system time was set to two years before today.
Which control file are u refering to?

Report message to a moderator

Re: Oracle & Unix System Date [message #179717 is a reply to message #179715]

Wed, 28 June 2006 08:50

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Open a TAR with Oracle support.
There are several known bugs in this case.

Report message to a moderator

Re: Oracle & Unix System Date [message #179748 is a reply to message #179717]

Wed, 28 June 2006 09:58

ziggy25
Messages: 206
Registered: July 2005

Senior Member

Can u point me to one.. ?

Thanks

Report message to a moderator

Re: Oracle & Unix System Date [message #179753 is a reply to message #179748]

Wed, 28 June 2006 10:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

https://metalink.oracle.com/metalink/plsql/f?p=130:10:8629079741096143439::::alltext,knowledge,numHits:ora-0600%20%202252,TRUE,100
Note:253977.1 seems to be your case.

Edit:
Hope you got the message.
Contents are removed. Proprietory to Oracle support.

[Updated on: Wed, 28 June 2006 10:11]

Report message to a moderator

Previous Topic:	Clone Oracle Codetree
Next Topic:	question about /var/lock/subsys/dbora

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:46:12 CDT 2024