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
more /etc/system
*ident "@(#)system 1.18 97/06/27 SMI" /* SVR4 1.5 */
*
* SYSTEM SPECIFICATION FILE
*
* moddir:
*
* Set the search path for modules. This has a format similar to the
* csh path variable. If the module isn't found in the first directory
* it tries the second and so on. The default is /kernel /usr/kernel
*
* Example:
* moddir: /kernel /usr/kernel /other/modules
* root device and root filesystem configuration:
*
* The following may be used to override the defaults provided by
* the boot program:
*
* rootfs: Set the filesystem type of the root.
--More--(14%)
rootfs: Set the filesystem type of the root.
*
* rootdev: Set the root device. This should be a fully
* expanded physical pathname. The default is the
* physical pathname of the device where the boot
* program resides. The physical pathname is
* highly platform and configuration dependent.
*
* Example:
* rootfs:ufs
* rootdev:/[EMAIL PROTECTED],f8000000/[EMAIL
PROTECTED],800000/[EMAIL PROTECTED],0:a
*
* (Swap device configuration should be specified in /etc/vfstab.)
* exclude:
*
* Modules appearing in the moddir path which are NOT to be loaded,
* even if referenced. Note that `exclude' accepts either a module name,
* or a filename which includes the directory.
*
* Examples:
* exclude: win
* exclude: sys/shmsys
* forceload:
*
* Cause these modules to be loaded at boot time, (just before mounting
* the root filesystem) rather than at first reference. Note that
* forceload expects a filename which includes the directory. Also
* note that loading a module does not necessarily imply that it will
* be installed.
*
* Example:
* forceload: drv/foo
* set:
*
* Set an integer variable in the kernel or a module to a new value.
* This facility should be used with caution. See system(4).
*
* Examples:
*
--More--(44%)
* Cause these modules to be loaded at boot time, (just before mounting
* the root filesystem) rather than at first reference. Note that
* forceload expects a filename which includes the directory. Also
* note that loading a module does not necessarily imply that it will
* be installed.
*
* Example:
* forceload: drv/foo
* set:
*
* Set an integer variable in the kernel or a module to a new value.
* This facility should be used with caution. See system(4).
*
* Examples:
*
* To set variables in 'unix':
*
* set nautopush=32
* set maxusers=40
*
* To set a variable named 'debug' in the module named 'test_module'
*
* set test_module:debug = 0x13
* vxvm_START (do not remove)
forceload: drv/vxdmp
forceload: drv/vxio
forceload: drv/vxspec
* vxvm_END (do not remove)
* vxfs_START -- do not remove the following lines:
* VxFS requires a stack size greater than the default 8K.
* The following value allows the kernel stack size to be
* increased to 24K.
set lwp_default_stksize=0x6000
* vxfs_END
* vxfs_START -- do not remove the following lines:
* VxFS requires a stack size greater than the default 8K.
* The following value allows the kernel stack size to be
* increased to 24K.
set rpcmod:svc_default_stksize=0x6000
* vxfs_END
* The forceload of drv/clone is required for successful
* IP operation of Emulex fibre channel drivers lpfc / lpfs
* and for the diagnostics (dfc) interface.
forceload: drv/clone
--More--(69%)
vxfs_START -- do not remove the following lines:
* VxFS requires a stack size greater than the default 8K.
* The following value allows the kernel stack size to be
* increased to 24K.
set lwp_default_stksize=0x6000
* vxfs_END
* vxfs_START -- do not remove the following lines:
* VxFS requires a stack size greater than the default 8K.
* The following value allows the kernel stack size to be
* increased to 24K.
set rpcmod:svc_default_stksize=0x6000
* vxfs_END
* The forceload of drv/clone is required for successful
* IP operation of Emulex fibre channel drivers lpfc / lpfs
* and for the diagnostics (dfc) interface.
forceload: drv/clone
* Begin MDD root info (do not edit)
rootdev:/pseudo/[EMAIL PROTECTED]:0,10,blk
* End MDD root info (do not edit)
*
********************************************
* Start of JETsysfile, base_config update(s)
set semsys:seminfo_semmni=1000
set semsys:seminfo_semmap=256
set semsys:seminfo_semmns=4000
set semsys:seminfo_semmnu=800
set semsys:seminfo_semmsl=1000
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=300
* End of JETsysfile, base_config update(s)
********************************************
*
********************************************
* Start of JETsysfile, emulex update(s)
set sd:sd_max_throttle=20
set scsi_options=0x7F8
set sd:sd_io_time=0x3C
* End of JETsysfile, emulex update(s)
********************************************
*
********************************************
* Start of JETsysfile, sds update(s)
set md:mirrored_root_flag=1
* End of JETsysfile, sds update(s)
********************************************
set c2audit:audit_load = 1
set noexec_user_stack=1
set noexec_user_stack_log=1
set sys:coredumpsize=0
include "types.cf"
include "OracleTypes.cf"
cluster vcssec01-th (
UserNames = { admin = bopHojOlpKppNxpJom, root = aLMeLGlIMhMMkUMgLJ,
dba = aLIeMHkGLhIGkK }
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 }
)
Application IDA_agent (
Critical = 0
User = oracle
StartProgram =
"/dboracle/orabase/product/agent_ida-mgmt/bin/emctl start agent"
StopProgram =
"/dboracle/orabase/product/agent_ida-mgmt/bin/emctl stop agent"
MonitorProcesses = {
"/dboracle/orabase/product/agent_ida-mgmt/bin/emagent"
}
)
DiskGroup IDA_DG (
DiskGroup = ida-dg
StartVolumes = 0
StopVolumes = 0
)
IP IDA_IP_Bak_Net (
Device = ce2
Address = "10.17.32.113"
NetMask = "255.255.255.192"
)
IP IDA_IP_Mgmt_Net (
Device = ce8
Address = "10.17.32.192"
NetMask = "255.255.255.192"
)
IPMultiNICB IDA_App_IPMultiNICB (
BaseResName = App_Net_MultiNICB
Address = "10.17.32.77"
NetMask = "255.255.255.192"
)
IPMultiNICB IDA_Rep_IPMultiNICB (
BaseResName = Rep_Net_MultiNICB
Address = "10.17.32.13"
NetMask = "255.255.255.192"
)
Mount IDA_Mount_admin (
MountPoint = "/dborafiles/CISP/IDA/admin"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_admin"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_agent_mgmt (
MountPoint = "/dboracle/orabase/product/agent_ida-mgmt"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_agent-mgmt"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_arch (
MountPoint = "/dborafiles/CISP/IDA/oraarch01"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oraarch"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_data01 (
MountPoint = "/dborafiles/CISP/IDA/oradata01"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oradata01"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_data02 (
MountPoint = "/dborafiles/CISP/IDA/oradata02"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oradata02"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_data03 (
MountPoint = "/dborafiles/CISP/IDA/oradata03"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oradata03"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_data04 (
MountPoint = "/dborafiles/CISP/IDA/oradata04"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oradata04"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_flash (
MountPoint = "/dborafiles/CISP/IDA/oraflash"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oraflash"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_redo01 (
MountPoint = "/dborafiles/CISP/IDA/oraredo01"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oraredo01"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_redo02 (
MountPoint = "/dborafiles/CISP/IDA/oraredo02"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_oraredo02"
FSType = vxfs
FsckOpt = "-n"
)
Mount IDA_Mount_splex (
MountPoint = "/dborafiles/CISP/IDA/splex"
BlockDevice = "/dev/vx/dsk/ida-dg/ida_splex"
FSType = vxfs
FsckOpt = "-n"
)
Netlsnr IDA_lsnr (
Owner = oracle
Home = "/dboracle/orabase/product/10.1.0.4"
TnsAdmin = "/dboracle/orabase/product/10.1.0.4/network/admin"
Listener = LISTENER_IDA
MonScript = "./bin/Netlsnr/LsnrTest.pl"
)
Oracle IDA_ORA (
Sid = IDA
Owner = oracle
Home = "/dboracle/orabase/product/10.1.0.4"
Pfile = "/dborafiles/CISP/IDA/admin/pfile/initIDA.ora"
StartUpOpt = CUSTOM
MonScript = "./bin/Oracle/SqlTest.pl"
)
Process IDA_logmon (
Critical = 0
PathName = "/usr/etc/logmon"
Arguments = "-d -L /usr/etc/IDA/logmon"
)
Process IDA_procmon (
Critical = 0
PathName = "/usr/etc/procmon"
Arguments = "-p -d -L /usr/etc/IDA/procmon"
)
Proxy IDA_Proxy_App_Net (
TargetResName = App_Net_MultiNICB
)
Proxy IDA_Proxy_Bak_Net (
TargetResName = csgnic1
)
Proxy IDA_Proxy_Mgmt_Net (
TargetResName = csgnic
)
Proxy IDA_Proxy_Rep_Net (
TargetResName = Rep_Net_MultiNICB
)
Volume IDA_Vol_admin (
Volume = ida_admin
DiskGroup = ida-dg
)
Volume IDA_Vol_agent_mgmt (
Volume = ida_agent-mgmt
DiskGroup = ida-dg
)
Volume IDA_Vol_arch (
Volume = ida_oraarch
DiskGroup = ida-dg
)
Volume IDA_Vol_data01 (
Volume = ida_oradata01
DiskGroup = ida-dg
)
Volume IDA_Vol_data02 (
Volume = ida_oradata02
DiskGroup = ida-dg
)
Volume IDA_Vol_data03 (
Volume = ida_oradata03
DiskGroup = ida-dg
)
Volume IDA_Vol_data04 (
Volume = ida_oradata04
DiskGroup = ida-dg
)
Volume IDA_Vol_flash (
Volume = ida_oraflash
DiskGroup = ida-dg
)
Volume IDA_Vol_redo01 (
Volume = ida_oraredo01
DiskGroup = ida-dg
)
Volume IDA_Vol_redo02 (
Volume = ida_oraredo02
DiskGroup = ida-dg
)
Volume IDA_Vol_splex (
Volume = ida_splex
DiskGroup = ida-dg
)
_______________________________________________
Veritas-ha maillist - Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha
