Home » Server Options » RAC & Failsafe » RAC DB instance (Oracle 11.2.0.3.0 , Linux)
RAC DB instance [message #593065] Tue, 13 August 2013 18:38 Go to next message
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
Re: RAC DB instance [message #593206 is a reply to message #593065] Thu, 15 August 2013 01:19 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
guys,

no answer to my question ??
Re: RAC DB instance [message #593207 is a reply to message #593206] Thu, 15 August 2013 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RAC DB instance [message #593221 is a reply to message #593207] Thu, 15 August 2013 02:49 Go to previous messageGo to next message
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
Re: RAC DB instance [message #593227 is a reply to message #593221] Thu, 15 August 2013 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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,
Re: RAC DB instance [message #593252 is a reply to message #593244] Thu, 15 August 2013 05:27 Go to previous messageGo to next message
John Watson
Messages: 4870
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.
Re: RAC DB instance [message #593279 is a reply to message #593252] Thu, 15 August 2013 08:47 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
desc v$parameter

Regards
Michel
Re: RAC DB instance [message #593334 is a reply to message #593293] Thu, 15 August 2013 12:39 Go to previous messageGo to next message
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

Re: RAC DB instance [message #593345 is a reply to message #593334] Thu, 15 August 2013 13:08 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RAC DB instance [message #593367 is a reply to message #593345] Thu, 15 August 2013 23:10 Go to previous messageGo to next message
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
Re: RAC DB instance [message #593368 is a reply to message #593367] Thu, 15 August 2013 23:13 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
Senior Member
SELECT * FROM V$PARAMETER;
Re: RAC DB instance [message #593375 is a reply to message #593368] Thu, 15 August 2013 23:58 Go to previous messageGo to next message
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
Re: RAC DB instance [message #593376 is a reply to message #593375] Fri, 16 August 2013 00:08 Go to previous messageGo to next message
BlackSwan
Messages: 23189
Registered: January 2009
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!
Re: RAC DB instance [message #593394 is a reply to message #593376] Fri, 16 August 2013 05:36 Go to previous messageGo to next message
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.
Re: RAC DB instance [message #593395 is a reply to message #593394] Fri, 16 August 2013 06:04 Go to previous messageGo to next message
John Watson
Messages: 4870
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.
Re: RAC DB instance [message #593422 is a reply to message #593395] Fri, 16 August 2013 09:56 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the book is: Database Reference

Regards
Michel
Re: RAC DB instance [message #593547 is a reply to message #593395] Sun, 18 August 2013 08:53 Go to previous message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Thanks Michel and John

[Updated on: Sun, 18 August 2013 08:55]

Report message to a moderator

Previous Topic: RAC Issue on Solaries (merged)
Next Topic: Listener went offline during network issue
Goto Forum:
  


Current Time: Sun Dec 28 02:09:20 CST 2014

Total time taken to generate the page: 0.05500 seconds