'Re: [Veritas-ha] Any Tunnning parameters needed for VCS'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: veritas-ha
Subject: Re: [Veritas-ha] Any Tunnning parameters needed for VCS
From: "Cronin, John S" <John.Cronin () bellsouth ! com>
Date: 2007-03-07 14:10:41
Message-ID: 336764B6202EE447B3C0FB198453F3DB0B8407 () crexc52p
[Download RAW message or body]

--===============0050599584==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C760C2.63DA5F58"
Content-Transfer-Encoding: 7bit

This is a multi-part message in MIME format.

Your Oracle performance problems are not caused by VCS - VCS just starts and stops \
Oracle, and checks on it sometimes.  There is nothing you can do with VCS to improve \
database performance.

As for your kernel settings, etc, you really need to contact Oracle or find an Oracle \
specific list.  This list is for VCS discussion, and your chance of getting a quick \
and correct answer to your Oracle specific questions here is not great.  
-- 
John Cronin

________________________________

From: veritas-ha-bounces@mailman.eng.auburn.edu on behalf of Damodharan K
Sent: Tue 3/6/2007 11:09 PM
To: Veritas-ha@mailman.eng.auburn.edu; veritas-vx@mailman.eng.auburn.edu
Subject: [Veritas-ha] Any Tunnning parameters needed for VCS

We are migrating from old server to my new server . The database there was oracle 8i \
, but here new server is having 10 g, so we migrated the oracle 8i to oracle 10g. Its \
very slow when we start and use the database in a new server using veritas cluster \
4.1 .  But the  database is running on the oracle 8i on old server fine and its \
hitting oracle server multiple times. But if we migrate that database to my server \
its very slow. Please advice me is any tunning can be done in cluster or OS part for \
best performance like 

system LargeServer1 ( 
Capacity = 200 
Limits = { ShrMemSeg=??, Semaphores=??, Processors=?? } 
LoadWarningLevel = 90 
LoadTimeThreshold = 600 
) 

Attached kernel parameters and cluster configuration also. 

Please help me its very urgent 

My new server Config 

Veritas Cluster 4.1 
Model:  v 490 server 
Memory size: 32768 Megabytes 
Release : Solaris 10 3/05 s10_74L2a SPARC 
Assembled 22 January 2005 

Processor information 
 /usr/sbin/psrinfo 
0       on-line   since 10/03/2006 18:54:37 
1       on-line   since 10/03/2006 18:54:37 
2       on-line   since 10/03/2006 18:54:37 
3       on-line   since 10/03/2006 18:53:50 
16      on-line   since 10/03/2006 18:54:37 
17      on-line   since 10/03/2006 18:54:37 
18      on-line   since 10/03/2006 18:54:37 
19      on-line   since 10/03/2006 18:54:37 

My new server Cluster config 

include "types.cf" 
include "OracleTypes.cf" 

cluster vcssec01-th ( 
        UserNames = { admin = bopHojOlpKppNxpJom, root = aLMeLGlIMheMMkUMgLJ, 
                 dba = aLIeMHkGLheIGkK } 
        ClusterAddress = "10.17.32.111" 
        Administrators = { admin, root } 
        CredRenewFrequency = 0 
        UseFence = SCSI3 
        CounterInterval = 5 
        ) 

system system01-th ( 
        LoadTimeThreshold = 300 
        Limits = { Processors = 4 } 
        ) 

system system02-th ( 
        LoadTimeThreshold = 300 
        Limits = { Processors = 4 } 
        ) 

system system03-th ( 
        LoadTimeThreshold = 300 
        Limits = { Processors = 4 } 
        ) 

system system04-th ( 
        LoadTimeThreshold = 300 
        Limits = { Processors = 4 } 
        ) 

group IDA_GROUP ( 
        SystemList = { system03-th = 0, system04-th = 1 } 
        Frozen = 1 
        AutoStartList = { system03-th, system04-th } 
        FailOverPolicy = Load 
        AutoStartPolicy = Load 
        Load = 20 
        Prerequisites = { Processors = 1 } 
        ) 

Thanks
Damodharan K

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

*****

The information transmitted is intended only for the person or entity to which it is \
addressed and may contain confidential, proprietary, and/or privileged material. Any \
review, retransmission, dissemination or other use of, or taking of any action in \
reliance upon this information by persons or entities other than the intended \
recipient is prohibited. If you received this in error, please contact the sender and \
delete the material from all computers. GA624

[Attachment #3 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; \
charset=unicode"> <META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText91011 dir=ltr>
<DIV dir=ltr>Your Oracle performance 
problems are not caused by VCS - VCS just starts and stops Oracle, and checks on 
it sometimes.&nbsp; There is nothing you can do with VCS to improve database 
performance. </DIV>
<DIV dir=ltr>As for your kernel settings, etc, you 
really need to contact Oracle or find an Oracle specific list.&nbsp; This list 
is for VCS discussion, and your chance of getting a quick and correct answer to 
your Oracle specific questions here is not great.</DIV>
<DIV dir=ltr>&nbsp;</DIV>
<DIV dir=ltr>-- </DIV>
<DIV dir=ltr>John Cronin</DIV></DIV>
<DIV dir=ltr> 
<HR tabIndex=-1>
From: veritas-ha-bounces@mailman.eng.auburn.edu 
on behalf of Damodharan K Sent: Tue 3/6/2007 11:09 PM To: 
Veritas-ha@mailman.eng.auburn.edu; 
veritas-vx@mailman.eng.auburn.edu Subject: [Veritas-ha] Any Tunnning 
parameters needed for VCS </DIV>
<DIV> We are migrating from old server to my new 
server . The database there was oracle 8i , but here new server is having 10 g, 
so we migrated the oracle 8i to oracle 10g. Its very slow when we start and use 
the database in a new server using veritas cluster 4.1 . But the &nbsp;database is running on the oracle 8i on old 
server fine and its hitting oracle server multiple times. But if we migrate that 
database to my server its very slow. Please advice me is any tunning can be done 
in cluster or OS part for best performance like system LargeServer1 ( Capacity = 200 Limits = { 
ShrMemSeg=??, Semaphores=??, Processors=?? } LoadWarningLevel = 90 LoadTimeThreshold = 600 ) 
 Attached kernel parameters and cluster 
configuration also. Please help me 
its very urgent My new server 
Config Veritas Cluster 
4.1 Model: &nbsp;v 490 server 
 Memory size: 32768 
Megabytes Release : Solaris 10 
3/05 s10_74L2a SPARC Assembled 22 
January 2005 Processor 
information &nbsp;/usr/sbin/psrinfo 0 &nbsp; 
&nbsp; &nbsp; on-line &nbsp; since 10/03/2006 18:54:37 1 &nbsp; &nbsp; &nbsp; on-line &nbsp; since 10/03/2006 
18:54:37 2 &nbsp; &nbsp; &nbsp; on-line 
&nbsp; since 10/03/2006 18:54:37 3 
&nbsp; &nbsp; &nbsp; on-line &nbsp; since 10/03/2006 18:53:50 16 &nbsp; &nbsp; &nbsp;on-line &nbsp; since 10/03/2006 
18:54:37 17 &nbsp; &nbsp; &nbsp;on-line 
&nbsp; since 10/03/2006 18:54:37 18 
&nbsp; &nbsp; &nbsp;on-line &nbsp; since 10/03/2006 18:54:37 19 &nbsp; &nbsp; &nbsp;on-line &nbsp; since 10/03/2006 
18:54:37 My new server 
Cluster config include 
"types.cf" include 
"OracleTypes.cf" cluster vcssec01-th 
( &nbsp; &nbsp; &nbsp; &nbsp; UserNames 
= { admin = bopHojOlpKppNxpJom, root = aLMeLGlIMheMMkUMgLJ, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;dba = aLIeMHkGLheIGkK } &nbsp; 
&nbsp; &nbsp; &nbsp; ClusterAddress = "10.17.32.111" &nbsp; &nbsp; &nbsp; &nbsp; Administrators = { admin, 
root } &nbsp; &nbsp; &nbsp; &nbsp; 
CredRenewFrequency = 0 &nbsp; &nbsp; 
&nbsp; &nbsp; UseFence = SCSI3 &nbsp; 
&nbsp; &nbsp; &nbsp; CounterInterval = 5 &nbsp; &nbsp; &nbsp; &nbsp; ) system system01-th ( &nbsp; 
&nbsp; &nbsp; &nbsp; LoadTimeThreshold = 300 &nbsp; &nbsp; &nbsp; &nbsp; Limits = { Processors = 4 } &nbsp; &nbsp; &nbsp; &nbsp; ) system system02-th ( &nbsp; &nbsp; &nbsp; &nbsp; LoadTimeThreshold = 300 &nbsp; &nbsp; &nbsp; &nbsp; Limits = { Processors = 4 
} &nbsp; &nbsp; &nbsp; &nbsp; ) 
 system system03-th ( &nbsp; &nbsp; &nbsp; &nbsp; LoadTimeThreshold = 
300 &nbsp; &nbsp; &nbsp; &nbsp; Limits = 
{ Processors = 4 } &nbsp; &nbsp; &nbsp; 
&nbsp; ) system system04-th ( 
 &nbsp; &nbsp; &nbsp; &nbsp; LoadTimeThreshold = 
300 &nbsp; &nbsp; &nbsp; &nbsp; Limits = 
{ Processors = 4 } &nbsp; &nbsp; &nbsp; 
&nbsp; ) group IDA_GROUP 
( &nbsp; &nbsp; &nbsp; &nbsp; SystemList 
= { system03-th = 0, system04-th = 1 } &nbsp; &nbsp; &nbsp; &nbsp; Frozen = 1 &nbsp; &nbsp; &nbsp; &nbsp; AutoStartList = { system03-th, system04-th 
} &nbsp; &nbsp; &nbsp; &nbsp; 
FailOverPolicy = Load &nbsp; &nbsp; 
&nbsp; &nbsp; AutoStartPolicy = Load &nbsp; &nbsp; &nbsp; &nbsp; Load = 20 &nbsp; &nbsp; &nbsp; &nbsp; Prerequisites = { Processors = 1 } 
 &nbsp; &nbsp; &nbsp; &nbsp; ) 
 Thanks Damodharan 
K <PRE>=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

</PRE></DIV></BODY>
*****
The information transmitted is intended \
only for the person or entity to which it is addressed and may contain confidential, \
proprietary, and/or privileged material. Any review, retransmission, dissemination or \
other use of, or taking of any action in reliance upon this information by persons or \
entities other than the intended recipient is prohibited. If you received this in \
error, please contact the sender and delete the material from all computers. \
GA624</HTML>

_______________________________________________
Veritas-ha maillist  -  Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha

--===============0050599584==--

[prev in list] [next in list] [prev in thread] [next in thread] 