parameter change in spfile, is there impact on VCS?

[pjeia]

Hi guys,

Id like to ask if there are impact in VCS should the following line is to be changed.

our dba will be performing the chenge in spfile:

alter system set CURSOR_SHARING='EXACT' scope=spfile

from:

alter system set CURSOR_SHARING='SIMILAR' scope=spfile

I just want to be sure that there will be no impact on vcs for this change.. any inputs and ideas are much appreciated. Thanks in advance

[Gaurav_S]

More inputs needed...

what is VCS version you are using ?

can you paste the oracle resource config from main.cf ?

Gaurav

[RiaanBadenhorst]

The  internals of Oracle's configuration should not concern VCS unless it relates to mounts for instance.

[Gaurav_S]

I remember there use to be a spfile attribute with oracle resource.... just wanted to make sure that its used or not here & if that may have some effect on changing above..

Gaurav

[pjeia]

Thanks Gaurav and Riaan

Oracle resource shows no spfile. Any other things to consider? Thanks!

VCS version;5.0 MP1

************

Oracle VENUS_ora (

                                Sid = VENUS

                                Owner = oracle

                                Home = "/oracle/app/product/10.2.0"

                                StartUpOpt = STARTUP

                                )

                Oracle XMWA_ora (

                                Sid = XMWA

                                Owner = oracle

                                Home = "/oracle/app/product/10.2.0"

                                StartUpOpt = STARTUP

                                )

                Oracle NCGS_ora (

                                Sid = NCGS

                                Owner = oracle

                                Home = "/oracle/app/product/10.2.0"

                                StartUpOpt = STARTUP

                                )

                Oracle Prod_ora (

                                Sid = Prod

                                Owner = oracle

                                Home = "/oracle/app/product/10.2.0"

                                StartUpOpt = STARTUP

                                )

              Oracle SDMSQ_ora (

                                Sid = SDMSQ

                                Owner = oracle

                                Home = "/oracle/app/product/10.2.0"

                                )

[Gaurav_S]

cool, well in that case you are good to go..... don't think you need to consider anything else from VCS point..

VCS shouldn't bother about this internal Oracle change untill your change is not causing any impact to running Oracle instance...

Gaurav

[Marianne · Accepted solution]

The Oracle agent has an optional attribute called Pfile.

The manual says the following :

When using the Veritas High Availability Agent for Oracle, you can start a database instance by specifying a PFILE. If you do not specify the PFILE, the database instance starts up using the default SPFILE.

The agent attribute Pfile must specify the location of the PFILE. If your configuration uses the SPFILE, the contents of the PFILE must specify the location of the SPFILE, which must be created from the PFILE.

So, even if you had this attribute configured, VCS only needs to know where the location of the Spfile is.

Hope we all managed to put your mind at ease.

[pjeia]

thanks marianne/gaurav!

there should be no effect for VCS on spfile parameter change.