Forum Discussion

pjeia's avatar
pjeia
Level 3
14 years ago

parameter change in spfile, is there impact on VCS?

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

 

business continuity
Cluster Server
  • Marianne's avatar
    Marianne
    14 years ago

    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.

  • Gaurav_S's avatar
    Gaurav_S
    Moderator
    14 years ago

    More inputs needed...

    what is VCS version you are using ?

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

     

    Gaurav

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    14 years ago

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

  • Gaurav_S's avatar
    Gaurav_S
    Moderator
    14 years ago

    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's avatar
    pjeia
    Level 3
    14 years ago

    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's avatar
    Gaurav_S
    Moderator
    14 years ago

    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's avatar
    Marianne
    Level 6
    14 years ago

    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's avatar
    pjeia
    Level 3
    14 years ago

    thanks marianne/gaurav!

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