OraFAQ Forum: RAC & Failsafe » RAC DB instance

Home » Server Options » RAC & Failsafe » RAC DB instance (Oracle 11.2.0.3.0 , Linux)

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

RAC DB instance [message #593065]

Tue, 13 August 2013 18:38

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi ,

Would there be any issue in application and database when i down RAC database instance using below srvctl command ?

srvctl stop instance -d DB -i DB1

srvctl start instance -d DB -i DB1

Thanks

Report message to a moderator

Re: RAC DB instance [message #593206 is a reply to message #593065]

Thu, 15 August 2013 01:19

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

guys,

no answer to my question ??

Report message to a moderator

Re: RAC DB instance [message #593207 is a reply to message #593206]

Thu, 15 August 2013 01:31

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is explained in detail in the documentation maybe this is the reason you have no answer.
In short, for database, nothing; for application, they have to handle the return code saying the instance they are currently connected is no more there.

Regards
Michel

Report message to a moderator

Re: RAC DB instance [message #593221 is a reply to message #593207]

Thu, 15 August 2013 02:49

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Thank you Michel,

When we have to bounce database or instance for specific database activities like increase processes parameter
to higher value or some other DB changes which require database or instance to bounce to take effective in database ,
which one to bounce either database or instance ? which one ( database or instance ) will have more impact to users ?

Regards

Report message to a moderator

Re: RAC DB instance [message #593227 is a reply to message #593221]

Thu, 15 August 2013 03:05

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Bounce instance if it is an instance parameter, bounce database if it is a database parameter.
Of course, bounce database means you stop all instances and so all applications whereas if you stop an instance you stop or relocate (and so impact) the sessions of only the instances you bounce.

Regards
Michel

[Edit: add missing "if"]

[Updated on: Thu, 15 August 2013 05:33]

Report message to a moderator

Re: RAC DB instance [message #593244 is a reply to message #593227]

Thu, 15 August 2013 04:39

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Michel,

Well explained.Thank you for that.

Quote:

Bounce instance it is an instance parameter, bounce database if it is a database parameter.

Could you list out instance and database parameters in RAC.

Regards,

Report message to a moderator

Re: RAC DB instance [message #593252 is a reply to message #593244]

Thu, 15 August 2013 05:27

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

suhasdba wrote on Thu, 15 August 2013 10:39

Michel,

Well explained.Thank you for that.

Quote:
Bounce instance it is an instance parameter, bounce database if it is a database parameter.

Could you list out instance and database parameters in RAC.

Regards,

I think you should consider listing them yourself. Look at the ISINSTANCE_MODIFIABLE column of v$parameter.

Report message to a moderator

Re: RAC DB instance [message #593279 is a reply to message #593252]

Thu, 15 August 2013 08:47

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

John,

As per your suggestion , i queried v$parameter and found the following results .

SQL> select ISINSTANCE_MODIFIABLE from v$parameter;
SQL> /

ISINS
-----
FALSE
FALSE
FALSE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
FALSE
FALSE

ISINS
-----
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
TRUE
TRUE
TRUE

ISINS
-----
TRUE
FALSE
FALSE
FALSE

There was about 347 rows selected.

from above results could you tell me how to list out instance and database parameters in RAC?

Thanks

[Updated on: Thu, 15 August 2013 08:48]

Report message to a moderator

Re: RAC DB instance [message #593293 is a reply to message #593279]

Thu, 15 August 2013 09:35

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

desc v$parameter

Regards
Michel

Report message to a moderator

Re: RAC DB instance [message #593334 is a reply to message #593293]

Thu, 15 August 2013 12:39

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

SQL> desc v$parameter
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NUM                                                NUMBER
 NAME                                               VARCHAR2(80)
 TYPE                                               NUMBER
 VALUE                                              VARCHAR2(4000)
 DISPLAY_VALUE                                      VARCHAR2(4000)
 ISDEFAULT                                          VARCHAR2(9)
 ISSES_MODIFIABLE                                   VARCHAR2(5)
 ISSYS_MODIFIABLE                                   VARCHAR2(9)
 ISINSTANCE_MODIFIABLE                              VARCHAR2(5)
 ISMODIFIED                                         VARCHAR2(10)
 ISADJUSTED                                         VARCHAR2(5)
 ISDEPRECATED                                       VARCHAR2(5)
 ISBASIC                                            VARCHAR2(5)
 DESCRIPTION                                        VARCHAR2(255)
 UPDATE_COMMENT                                     VARCHAR2(255)
 HASH                                               NUMBER

Report message to a moderator

Re: RAC DB instance [message #593345 is a reply to message #593334]

Thu, 15 August 2013 13:08

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So to get the name of the parameter for which ISINSTANCE_MODIFIABLE is true what have you to add to your query?

Regards
Michel

Report message to a moderator

Re: RAC DB instance [message #593367 is a reply to message #593345]

Thu, 15 August 2013 23:10

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Michel,

I dont get your point.Could you rephrase it.

I want list of instance and database parameters in RAC.

Regards
Suhasdba

Report message to a moderator

Re: RAC DB instance [message #593368 is a reply to message #593367]

Thu, 15 August 2013 23:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SELECT * FROM V$PARAMETER;

Report message to a moderator

Re: RAC DB instance [message #593375 is a reply to message #593368]

Thu, 15 August 2013 23:58

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Swan,

For Processes parameter, the value of ISINSTANCE_MODIFIABLE column is false.Does it mean that we cannot bounce
at instance level to change processes parameter ?

I dont get your point.Its really confusing me.

Regards
Suhas

Report message to a moderator

Re: RAC DB instance [message #593376 is a reply to message #593375]

Fri, 16 August 2013 00:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I dont get your point.Its really confusing me.

I don't get why you require others to clear your confusion.
You can simply test yourself on your own test DB what works & what does not work until you are no longer confused.
We have no direct impact on Oracle or your confusion!
So stop blaming us for your own reality!

Report message to a moderator

Re: RAC DB instance [message #593394 is a reply to message #593376]

Fri, 16 August 2013 05:36

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Swan,

I am not blaming you.I am asking you to make things clear what you are explaining me.

Report message to a moderator

Re: RAC DB instance [message #593395 is a reply to message #593394]

Fri, 16 August 2013 06:04

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Suhas, I think the BS is a few time zones West of us. So I'll try again.

When you first replied to my suggestion that looking at v$parameter.isinstance_modifiable might help you to determine whether a parameter has an instance scope or a database scope, I was astounded that you replied with query that projected just that one column. I ignored it, because I assumed that you were just trying to make people angry by being deliberately obtuse.
But since then, it does appear that you really did not understand. There are two issues: whether a parameter can be changed without restarting anything (issys_modifiable), and whether a parameter can have different values in different instances (isinstance_modifiable).
So start looking up a few parameters in the docs, and you'll be able to work out what is going on.

Report message to a moderator