OraFAQ Forum: RAC & Failsafe » different fixed

Home » Server Options » RAC & Failsafe » different fixed_date in RAC DB and Instance

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

different fixed_date in RAC DB and Instance [message #409996]

Wed, 24 June 2009 15:24

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.

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #409999 is a reply to message #409996]

Wed, 24 June 2009 15:49

babuknb
Messages: 1734
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

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410007 is a reply to message #409999]

Wed, 24 June 2009 17:02

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 ?

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410008 is a reply to message #409996]

Wed, 24 June 2009 17:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What problem are you trying to solve?
How would an independent observer conclude the problem has been solved?

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410010 is a reply to message #410008]

Wed, 24 June 2009 17:40

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?

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410013 is a reply to message #410010]

Wed, 24 June 2009 18:11

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,

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410043 is a reply to message #410013]

Wed, 24 June 2009 23:09

Michel Cadot
Messages: 68264
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why do you want to set this parameter?

Regards
Michel

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410079 is a reply to message #410043]

Thu, 25 June 2009 02:13

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 .

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410109 is a reply to message #410079]

Thu, 25 June 2009 05:09

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.

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410245 is a reply to message #410109]

Thu, 25 June 2009 17:34

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

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';

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410247 is a reply to message #410246]

Thu, 25 June 2009 17:52

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,

Report message to a moderator

Re: different fixed_date in RAC DB and Instance [message #410248 is a reply to message #410247]

Thu, 25 June 2009 17:53

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Yes.

Report message to a moderator

Previous Topic:	11g cluster and 10g database
Next Topic:	ORA-12516: TNS:listener could not find available handler with matching protocol

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 18 08:42:02 CDT 2022