- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle SYSDATE show old date
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2006 08:09 PM
01-29-2006 08:09 PM
Re: Oracle SYSDATE show old date
You really need to set a timezone since it is not set in your system.
First check /usr/lib/tztab and find your timezone for your geagraphic area. If you can't find a timezone for you, you can use GMT. Then, execute:
#/sbin/set_parms
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2006 05:29 AM
01-30-2006 05:29 AM
Re: Oracle SYSDATE show old date
I will read up on the Metallink report on this bug 3368245 -- to see if it applys
thank you
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2006 05:30 AM
01-30-2006 05:30 AM
Re: Oracle SYSDATE show old date
I did fail to state this is a LINUX machine
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 04:19 AM
02-06-2006 04:19 AM
Re: Oracle SYSDATE show old date
SQL> startup
ORA-00065: initialization of FIXED_DATE failed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 04:21 AM
02-06-2006 04:21 AM
Re: Oracle SYSDATE show old date
We rebooted the machine and thios morning I noticed that it did not start so I tryied to start it up and got that error message. to be more clear.
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 04:31 AM
02-06-2006 04:31 AM
Re: Oracle SYSDATE show old date
First you must know what init.ora file you are using. By default, you are using the init
Anyway, do:
vi $ORACLE_HOME/dbs/init
make sure there is no FIXED_DATE parameter in it and:
SQL> startup pfile=$ORACLE_HOME/dbs/init
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 04:36 AM
02-06-2006 04:36 AM
Re: Oracle SYSDATE show old date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 05:03 AM
02-06-2006 05:03 AM
Re: Oracle SYSDATE show old date
You have the FIXED_DATE parameter set in the database and are using a SPFILE instead of a pfile. You unset the parameter using:
alter system set FIXED_DATE=NONE
Available workarounds are:
1)Recreate spfile
2)Use scope=memory while unsetting the parameter:
ALTER SYSTEM SET FIXED_DATE=NONE SCOPE=MEMORY;
3)Use PFILE
Oracle uses OS date & time so check this with the sysdate funtion :
select to_char(sysdate, 'DD-MM-RRRR HH24:MI') from dual
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 05:19 AM
02-06-2006 05:19 AM
Re: Oracle SYSDATE show old date
SQL> startup pfile=$ORACLE_HOME/dbs/initPRX.ora
ORACLE instance started.
Total System Global Area 42742804 bytes
Fixed Size 451604 bytes
Variable Size 41943040 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 05:53 AM
02-06-2006 05:53 AM
Re: Oracle SYSDATE show old date
Are All Control Files Missing?
Please see attached.
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 06:38 AM
02-06-2006 06:38 AM
Re: Oracle SYSDATE show old date
control_files = (/pcsi/app/oracle/oradata/prx/control01.ctl, /pcsi/app/oracle/oradata/prx/control02.ctl, /pcsi/app/oracle/oradata/prx/control03.ctl)
----------------
startup pfile=$ORACLE_HOME/dbs/initPRX.ora
ORACLE instance started.
Total System Global Area 42742804 bytes
Fixed Size 451604 bytes
Variable Size 41943040 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
ORA-00209: control file blocksize mismatch, check alert log for more info
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 07:26 AM
02-06-2006 07:26 AM
Re: Oracle SYSDATE show old date
Action: Restore a good copy of the control file. If the control file is known to be clean set the DB_BLOCK_SIZE to match control file headers block size value.
if it is how do I find the value?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 08:10 AM
02-06-2006 08:10 AM
Re: Oracle SYSDATE show old date
My control file did not apear missing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 03:27 PM
02-06-2006 03:27 PM
Re: Oracle SYSDATE show old date
can you please check if all the 3 control files are of same size?
also, can you try to execute:
alter database backup controlfile to trace;
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 03:41 PM
02-06-2006 03:41 PM
Re: Oracle SYSDATE show old date
I must disagree with ""Yogeeraj"". In Oracle, all controlfiles are the same size since they are all identical copies of each other. I don't think they can be different from each other in term of size. But with redo logfiles you can different sizes for logfile belonging to different groups. For instance size of logfiles of group 1 can be different from the sizes of logfiles of group 2. But this is not recommended by oracle.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 03:53 PM
02-06-2006 03:53 PM
Re: Oracle SYSDATE show old date
Whoah... calm down now. You guys are late to the party.
Steve has no real problem with with the
control files, or redologs. Not really.
His DB was coming up fine, except with undesirable sysdate settings. As he is trying to fix that, he is experimenting with other, explicit, p-files pointing to mismatching control files. Once he figures out how to deal with the spfile and/or lines up a proper initXXX.ora file pointing to his real control files all will be well again.
No need to restore anything. Doing so (without backups) would create bigger problems. These are basic Oracle DBA questions/skill and he'll figure it out just fine I'm sure.
fwiw,
Hein
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 08:07 PM
02-06-2006 08:07 PM
Re: Oracle SYSDATE show old date
Hein is right: you were using another parameter file maybe in another location than $ORACLE_HOME/dbs or with spfile.
Try a find:
$find $ORACLE_BASE -name init*.ora
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2006 11:53 PM
02-06-2006 11:53 PM
Re: Oracle SYSDATE show old date
$find $ORACLE_BASE -name init*.ora -exec grep -l -e 'fixed_date' -e 'FIXED_DATE' {} \;|more
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2006 03:46 AM
02-07-2006 03:46 AM
Re: Oracle SYSDATE show old date
[root@prolinux prx]# find $ORACLE_BASE -name init*.ora -exec grep -l -e 'fixed_date' -e 'FIXED_DATE' {} \;|more
[root@prolinux prx]#
this found none
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2006 08:07 PM
02-07-2006 08:07 PM
Re: Oracle SYSDATE show old date
Try the following:
SQL>shutdown immediate;
SQL>alter system set fixed_date=none scope=both;
SQL>startup;
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2006 08:20 PM
02-07-2006 08:20 PM
Re: Oracle SYSDATE show old date
SQL>SELECT name,value FROM v$parameter WHERE name = 'spfile';
SQL>create pfile='$ORACLE_HOME/dbs/init_from_spfile.ora' from spfile='
SQL>exit;
$vi $ORACLE_HOME/dbs/init_from_spfile.ora
...
delete the fixed_date line
...
save the file
$sqlplus '/ as sysdba'
SQL>CREATE SPFILE FROM PFILE='$ORACLE_HOME/dbs/init_from_spfile.ora';
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2006 08:21 PM
02-07-2006 08:21 PM
Re: Oracle SYSDATE show old date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2006 09:37 AM
02-08-2006 09:37 AM
Re: Oracle SYSDATE show old date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2006 09:42 AM
02-08-2006 09:42 AM
Re: Oracle SYSDATE show old date
Thank you
- « Previous
-
- 1
- 2
- Next »