Home » Server Options » RAC & Failsafe » different fixed_date in RAC DB and Instance
different fixed_date in RAC DB and Instance [message #409996] Wed, 24 June 2009 15:24 Go to next message
casttree
Messages: 83
Registered: August 2008
Member
Looks like I can set the different value for initialzation parameter FIXED_DATE in each RAC instance and DB?


Is there any relationship for the fixed_date between RAC Instance and RAC DB ? I thought the value of init paramter in RAC DB should be consistent with Rac instance.
Re: different fixed_date in RAC DB and Instance [message #409999 is a reply to message #409996] Wed, 24 June 2009 15:49 Go to previous messageGo to next message
babuknb
Messages: 1729
Registered: December 2005
Location: NJ
Senior Member

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams073.htm

As per as i know; This parameter should be null in RAC environment; You can configure same date & time from OS level.

Thanks
Re: different fixed_date in RAC DB and Instance [message #410007 is a reply to message #409999] Wed, 24 June 2009 17:02 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
I mean I am doing a test to set fixed_date for Rac DB and instance .

If I set different value for each instance,
for example
rac_inst1 fixed_date = 01/01/2009
rac_inst2 fixed_date = 01/01/2008


I am thinking if I try to get the fixed_date value for RAC DB, what I will get ? Looks like RAC DB just create a conntion to random instance, and get a value from that instance.

So looks like I will get a random value with either 01/01/2009 or 01/01/2008, is it right? Do I have other ways to control what value i can get ?
Re: different fixed_date in RAC DB and Instance [message #410008 is a reply to message #409996] Wed, 24 June 2009 17:22 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
What problem are you trying to solve?
How would an independent observer conclude the problem has been solved?
Re: different fixed_date in RAC DB and Instance [message #410010 is a reply to message #410008] Wed, 24 June 2009 17:40 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
I hope to understand how we can get the paramter value for RAC DB when different RAC instance has different values.

In my case,
rac_inst1 : fixed_date = 01/01/2001
rac_inst2 : fixed_date = 02/02/2002
rac_inst3 : fixed_date = none

in this case, what I will get when I check the fixed_date value for rac DB?
Re: different fixed_date in RAC DB and Instance [message #410013 is a reply to message #410010] Wed, 24 June 2009 18:11 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
maybe the issue is more simple.

Can we set different value for init parameter fixed_date as different value for different instance?

If it is not correct case, then I don't need to worry about it.

Thanks,
Re: different fixed_date in RAC DB and Instance [message #410043 is a reply to message #410013] Wed, 24 June 2009 23:09 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to set this parameter?

Regards
Michel
Re: different fixed_date in RAC DB and Instance [message #410079 is a reply to message #410043] Thu, 25 June 2009 02:13 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
I need it for a test case.

Now I think that fixed_date is a instance level paramter, and we should not check it from DB level .
Re: different fixed_date in RAC DB and Instance [message #410109 is a reply to message #410079] Thu, 25 June 2009 05:09 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How are you setting this parameter?

If you want to go to a particular instance you could consider setting up services with RAC and/or configuring your listener to go to one particular instance.
Re: different fixed_date in RAC DB and Instance [message #410245 is a reply to message #410109] Thu, 25 June 2009 17:34 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
I set it from oracle EM. I know it can be set in single Instance DB as below
alter system set fixed_date = '19-APR-1978';


but I don't know the normal process to set it in Rac from sqlplus? Will we access one rac instance and issue the alter command? will it affect the whole RAC DB (all instances ) or just that instance?

Thanks,

[Updated on: Thu, 25 June 2009 17:35]

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410246 is a reply to message #410245] Thu, 25 June 2009 17:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Use the following to set the parameter for one particular instance:
alter system set fixed_date = '19-APR-1978' scope=both sid='rac_inst1';
Re: different fixed_date in RAC DB and Instance [message #410247 is a reply to message #410246] Thu, 25 June 2009 17:52 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
Thanks, if I removed sid='rac_inst1' like below , will it set for all instances? Sorry I don't hvae RAC db to verify it now.

alter system set fixed_date = '19-APR-1978' scope=both;

Thanks,
Re: different fixed_date in RAC DB and Instance [message #410248 is a reply to message #410247] Thu, 25 June 2009 17:53 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes.
Previous Topic: 11g cluster and 10g database
Next Topic: ORA-12516: TNS:listener could not find available handler with matching protocol
Goto Forum:
  


Current Time: Sat Aug 30 13:35:22 CDT 2014

Total time taken to generate the page: 0.12893 seconds