Oracle 9iAS configuration

[Leif Halvarsson_2]

Hi,

Need some advice for a entry-level Oracle 9iAS installation on HP-UX. For ex:

- rp- or rx- series (PA-RISC or Itanium) ?
- Required memory ?
- One or two server installation ?

[Steven E. Protter · Accepted solution]

From experience.

rp or rx series will work fine. Oracle's 9ias product line is certified on Itanium 11.22 and 11.23 and 11i v1. I am not sure if they've completed certification on 11i v2 PA-RISC. It shouldn't matter due to the Itanium Certification, but don't count on it.

Minimum memory 2 GB. Want to do it right, go for 4 GB. I just had a conference call with Oracle about our migration to the 10g as product and the typical installation thats running smoothly is 4GB.

Oracle recommends that 9ias be on its own server seperate from the database. We run the database server and the application server on the same hardware and have had no real issues other than increased memory use.

It makes kernel tuning a little harder becasue you want to be above mimimun on shared memory and such.

Here is kmtune output from a typical PA-RISC server running 11i. The 4.5 GB of shared memory is experimental. We run production at 1.5 GB shmmax.

Parameter Current Dyn Planned Module Version
===============================================================================
NSTRBLKSCHED - - 2
NSTREVENT 50 - 50
NSTRPUSH 16 - 16
NSTRSCHED 0 - 0
STRCTLSZ 1024 - 1024
STRMSGSZ 65535 - 65535
acctresume 4 - 4
acctsuspend 2 - 2
aio_listio_max 256 - 256
aio_max_ops 2048 - 2048
aio_physmem_pct 10 - 10
aio_prio_delta_max 20 - 20
allocate_fs_swapmap 0 - 0
alwaysdump 1 - 1
bcvmap_size_factor 2 - 2
bootspinlocks - - 256
bufcache_hash_locks 128 - 128
bufpages 0 - (NBUF*2)
chanq_hash_locks 256 - 256
clicreservedmem 0 - 0
core_addshmem_read 0 Y 0
core_addshmem_write 0 Y 0
create_fastlinks 0 - 0
dbc_max_pct 6 - 6
dbc_min_pct 2 - 2
default_disk_ir 0 - 0
desfree - - 0
disksort_seconds 0 - 0
dmp_rootdev_is_vol 0 - 0
dmp_swapdev_is_vol 0 - 0
dnlc_hash_locks 512 - 512
dontdump 0 - 0
dskless_node - - 0
dst 1 - 1
effective_maxpid - - ((NPROC<=30000)?30000:(NPROC*5/4))
eisa_io_estimate - - 0x300
enable_idds 1 - 1
eqmemsize 15 - 15
executable_stack 0 - 0
fcp_large_config 0 - 0
file_pad - - 10
fr_limitmax - - 10000 ipf -
fr_statemax - - 200000 ipf -
fr_tcpidletimeout - - 86400 ipf -
fs_async 0 - 0
ftable_hash_locks 64 - 64
hdlpreg_hash_locks 128 - 128
hfs_max_ra_blocks 8 - 8
hfs_max_revra_blocks 8 - 8
hfs_ra_per_disk 64 - 64
hfs_revra_per_disk 64 - 64
hp_hfs_mtra_enabled 1 - 1
hpux_aes_override - - 0
initmodmax 50 - 50
io_ports_hash_locks 64 - 64
iomemsize - - 40000
ipf_debug - - 0 ipf -
ksi_alloc_max 64000 - (NPROC*8)
ksi_send_max 32 - 32
lotsfree - - 0
max_async_ports 50 - 50
max_fcp_reqs 512 - 512
max_mem_window 0 - 0
max_thread_proc 9000 - 9000
maxdsiz 4063835136 - 4063835136
maxdsiz_64bit 2147483648 - 2147483648
maxfiles 8192 - 8192maxfiles_lim 1024 Y 1024
maxqueuetime - - 0
maxssiz 634219728 - 634219728
maxssiz_64bit 1073741824 - 1073741824
maxswapchunks 16384 - 16384
maxtsiz 0x4000000 Y 0X4000000
maxtsiz_64bit 0x40000000 Y 0X40000000
maxuprc 200 Y 200
maxusers 4096 - 4096
maxvgs 10 - 10
mesg 1 - 1
minfree - - 0
modstrmax 500 - 500
msgmap 8002 - (2+MSGTQL)
msgmax 8192 Y 8192
msgmnb 16384 Y 16384
msgmni 8000 - (NPROC)
msgseg 31999 - ((NPROC*4)-1)
msgssz 8 - 8
msgtql 8000 - (NPROC)
nbuf 0 - 0
ncallout 9000 - 9000
ncdnode 150 - 150
nclist 65636 - (100+16*MAXUSERS)
ncsize 36000 - 36000
ndilbuffers 30 - 30
netisr_priority - - -1
netmemmax - - 0
nfile 34048 - (4*NPROC+2048)
nflocks 5000 - 5000
nhtbl_scale 0 - 0
ninode 40000 - 40000
nkthread 9000 - 9000
nni - - 2
no_lvm_disks 0 - 0
nproc 8000 - 8000
npty 200 - 200
nstrpty 200 - 200
nstrtel 200 - 200
nswapdev 10 - 10
nswapfs 10 - 10
nsysmap 16000 - ((NPROC)>800?2*(NPROC):800)
nsysmap64 16000 - ((NPROC)>800?2*(NPROC):800)
o_sync_is_o_dsync 0 - 0
page_text_to_local - - 0
pfdat_hash_locks 128 - 128
pfildebug - - 0 pfil -
public_shlibs 1 - 1
qif_verbose - - 0 pfil -
region_hash_locks 128 - 128
remote_nfs_swap 0 - 0
rng_bitvals - - 654 rng -
rng_log_deskew - - 0 rng -
rng_log_raw - - 0 rng -
rng_sleeptime - - 2 rng -
rtsched_numpri 32 - 32
scroll_lines 100 - 100
scs_table_max_size - - 500
scs_table_size - - 10
scsi_max_qdepth 8 Y 8
scsi_maxphys 1048576 - 1048576
sema 1 - 1
semaem 16384 - 16384
semmap 16002 - (SEMMNI+2)
semmni 16000 - ((NPROC*2))
semmns 31998 - (((NPROC*2)*2)-2)
semmnu 7996 - (NPROC-4)
semmsl 2048 Y 2048
semume 200 - 200
semvmx 32767 - 32767
sendfile_max 0 - 0
shmem 1 - 1
shmmax 4500000000 Y 4500000000
shmmni 4000 - 4000
shmseg 240 Y 240
st_ats_enabled 0 - 0
st_fail_overruns 0 - 0
st_large_recs 0 - 0
st_san_safe 0 - 0
streampipes 0 - 0
swapmem_on 1 - 1
swchunk 2048 - 2048
sysv_hash_locks 128 - 128
tcphashsz 0 - 0
timeslice 10 - (100/10)
timezone 420 - 420
unlockable_mem 0 - 0
vas_hash_locks 128 - 128
vnode_cd_hash_locks 128 - 128
vnode_hash_locks 128 - 128
vol_checkpt_default 10240 - 10240
vol_default_iodelay 50 - 50
vol_fmr_logsz 4 - 4
vol_max_bchain 32 - 32
vol_max_nconfigs 20 - 20
vol_max_nlogs 20 - 20
vol_max_nmpool_sz 4194304 - (4*1024*1024)
vol_max_prm_dgs 1024 - 1024
vol_max_rdback_sz 4194304 - (4*1024*1024)
vol_max_vol 8388608 - (8*1024*1024)
vol_maxio 256 - 256
vol_maxioctl 32768 - 32768
vol_maxkiocount 2048 - 2048
vol_maxparallelio 256 - 256
vol_maxspecialio 256 - 256
vol_maxstablebufsize 256 - 256
vol_min_lowmem_sz 524288 - (512*1024)
vol_mvr_maxround 256 - 256
vol_rootdev_is_vol 0 - 0
vol_subdisk_num 4096 - 4096
vol_swapdev_is_vol 0 - 0
vol_vvr_transport 1 - (1)
volcvm_cluster_size 16 - 16
volcvm_smartsync 1 - 1
voldrl_max_drtregs 2048 - 2048
vol_vvr_transport 1 - (1)
volcvm_cluster_size 16 - 16
volcvm_smartsync 1 - 1
voldrl_max_drtregs 2048 - 2048
voldrl_min_regionsz 512 - 512
voliomem_chunk_size 65536 - (64*1024)
voliomem_maxpool_sz 4194304 - (4*1024*1024)
voliot_errbuf_dflt 16384 - 16384
voliot_iobuf_default 8192 - 8192
voliot_iobuf_limit 131072 - 131072
voliot_iobuf_max 65536 - 65536
voliot_max_open 32 - 32
volraid_rsrtransmax 1 - 1
vps_ceiling 256 - 256
vps_chatr_ceiling 1048576 - 1048576
vps_pagesize 4 - 4
vx_fancyra_enable 0 - 0
vx_maxlink 32767 - 32767
vx_ncsize 1024 - 1024
vx_ninode 4000 - 4000
vxfs_max_ra_kbytes 1024 - 1024
vxfs_ra_per_disk 1024 - 1024
vxtask_max_monitors 32 - 32

I'm not sure our patch list is relavent, but ask and you shall receive. Do the most current on everything Oracle recommends. They also tend to make requirements that offend the performance minded kernel tuner. Its possible to ignore certain items without oracle ias failing to function.

We currently run 9ias release 1 1.0.2.2 PL 12 and are migrating to 10g as 9.0.4.1

SEP