11-19-2010 01:34 AM
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
Solved! Go to Solution.
11-22-2010 09:04 PM
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.
11-19-2010 02:21 AM
More inputs needed...
what is VCS version you are using ?
can you paste the oracle resource config from main.cf ?
Gaurav
11-21-2010 03:15 AM
The internals of Oracle's configuration should not concern VCS unless it relates to mounts for instance.
11-21-2010 11:07 PM
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
11-22-2010 08:13 PM
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"
)
11-22-2010 08:25 PM
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
11-22-2010 09:04 PM
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.
11-22-2010 09:26 PM
thanks marianne/gaurav!
there should be no effect for VCS on spfile parameter change.