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: [EMAIL PROTECTED] 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
_______________________________________________
Veritas-ha maillist - Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha
