[Comm] Oracle

Ср Май 28 11:58:14 MSD 2003

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

КакСде:
0) Параметры конфигурации менеджера памяти ОС должны быть примерно такими:

# Max. shared memory segment size that can be allocated.
# The ONLY parameter you should touch at all (and only if you have more than
# 4 GB of physical memory) is SHMMAX. It does not make any sense to change
# the others for Oracle!
# Kernel sources header file: /usr/src/linux/include/linux/shm.h
# Recommended: SHMMAX = 0.5*(physical memory). Higher # values are okay,
# since this parameter only sets the OS maximum:
# This setting does not affect how much shared memory is needed or used by
# Oracle8i or the operating system. It is used only to indicate the maximum
# allowable size. This setting also does not impact operating system
# kernel resources.
# The values for SHMSEG and SHMMIN cannot be changed via the proc-interface,
# but there is no need to change anything anyway!
# SHMSEG (default: 4096): max. number of shared segments per process
# SHMMIN (default: 1): min. size of a shared mem. segment in bytes
#
# SHMMAX max. size of a shared memory segment in bytes
#
SHMMAX=3294967296
#
# SHMMNI (default: 4096): max. number of shared segments system wide
# No change is needed for running Oracle!
#
SHMMNI=4096
#
# SHMALL (default: 8G [2097152]): max. shm system wide (pages)
# No change is needed for running Oracle!
#
SHMALL=2097152

#
# Sempahore values
# Kernel sources header file: /usr/src/linux/include/linux/sem.h
#
# SEMVMX: semaphore maximum value. Oracle recommends a value of 32767,
# which is the default in SuSE *and* the maximum value possible.
# This value cannot be changed during runtime via the /proc interface,
# but there is no need to do so anyway!
#
# SEMMSL: max. number of semaphores per id. Set to 10 plus the largest
# PROCESSES parameter of any Oracle database on the system (see init.ora).
# Max. value possible is 8000.
#
SEMMSL=1250
#
# SEMMNS: max. number of semaphores system wide. Set to the sum of the
# PROCESSES parameter for each Oracle database, adding the largest one
# twice, then add an additional 10 for each database (see init.ora).
# Max. value possible is INT_MAX (largest INTEGER value on this
# architecture, on 32-bit systems: 2147483647).
#
SEMMNS=32000
#
# SEMOPM: max. number of operations per semop call. Oracle recommends
# a value of 100. Max. value possible is 1000.
#
SEMOPM=100
#
# SEMMNI: max. number of semaphore identifiers. Oracle recommends a
# a value of (at least) 100. Max. value possible is 32768 (defined
# in include/linux/ipc.h: IPCMNI)
#
SEMMNI=256
#
# Defines the local port range that is used by TCP and UDP to
# choose the local port. The first number is the first, the
# second the last local port number. Default value depends on
# amount of memory available on the system:
# > 128Mb 32768-61000
# < 128Mb 1024-4999 or even less.
# This number defines number of active connections, which this
# system can issue simultaneously to systems not supporting
# TCP extensions (timestamps). With tcp_tw_recycle enabled
# (i.e. by default) range 1024-4999 is enough to issue up to
# 2000 connections per second to systems supporting timestamps.
#
IP_LOCAL_PORT_RANGE="1024 65000"

#
# The *_SHELL settings are for the Oracle startup script (/etc/rc.d/oracle
# and 'rcoracle') *ONLY*, it does NOT have any influence on the
# limits if you login as user 'oracle' and start Oracle from there!!!
# This sets the limits for the number of open files and processes.
# FILE_MAX_SHELL *MUST* be lower than FILE_MAX_KERNEL, obviously
#
FILE_MAX_KERNEL=131072
FILE_MAX_SHELL=65536
PROCESSES_MAX_SHELL=16384
MAX_CORE_FILE_SIZE_SHELL=unlimited
#
# By Andrea Arcangeli, SuSE:
# This decreases the swappiness of the kernel. It will tend to swap less. It
# will shrink the pagecache more, before falling back into swap. So
# increasing the mapped ratio will result in less cache and less swap.
# On a lowmemory machine reducing the cache, and the swap can decrease
# performance.
# On a database machine with plenty of ram, swapping some hundred mbyte
# instead may not be necessary, better to shrink the cache, in particular
# because having that much shm allocated tends to fool the VM. The VM
# can't know if the shm is fs cache too (the shm in Oracle is mostly cache
# for the filesystem).
# So going to 1000 is probably a good idea for high end servers with
# plenty of memory. Using "1000" make sense where you really know swapping
# is going to be not necessary during all the important workloads because
# you tune the machine in a way that it has enough ram to succeed w/o the
# need of swap. Using 1000 tells the VM to swap less.
#
VM_MAPPED_RATIO=1000

#
# Max. size of an async I/O request
#
AIO_MAX_SIZE=262144

1) Подменить в /opt/oracle JRE 1.1.8 на Java2 1.4 (с 9-го диска Мастера
- - Ok)
2) Сделать симлинк java -> jre
3) в JVM.CFG убрать мат на предмет -green, -nojit переназначить на
"безобидную" опцию.
Будет работать, но без рюсски бюкф.

Если у кого-то проблема с инсталляцией, то сию процедуру с Явой нужно
провернуть тогда, когда инсталлятор просит запустить скрипт "рутом".
- --
Rgds!
Roman Savelyev
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+1GwWu08PPWJOeNERArniAJ9jMW1HBcQU9tZCbXLmcZf6VYvF0QCeJCW4
B7un4zNfUtBWqQJLRLh9lng=
=qEof
-----END PGP SIGNATURE-----