From: Roman Savelyev <savelyev@interlot.ru> To: community@altlinux.ru Subject: Re: [Comm] Oracle Date: Wed, 28 May 2003 11:58:14 +0400 Message-ID: <3ED46C16.9090504@interlot.ru> (raw) In-Reply-To: <Pine.LNX.4.55L.0305262141400.11862@gw.lincomp.ru> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dmitriy Gnidchenko пишет: | | Доброе время суток!!! | | Подскажите, такая вещь как | Oracle Enterprise Manager Console | под линухом работает или инет ? http://www.rromas.newmail.ru/shot3.png КакСде: 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-----
next prev parent reply other threads:[~2003-05-28 7:58 UTC|newest] Thread overview: 12+ messages / expand[flat|nested] mbox.gz Atom feed top 2003-05-26 17:53 Dmitriy Gnidchenko 2003-05-26 19:43 ` Alexey V. Arnautov 2003-05-27 8:07 ` Dmitriy Gnidchenko 2003-05-27 20:11 ` Re[2]: " Alexey V. Arnautov 2003-05-28 10:32 ` Dmitriy Gnidchenko 2003-05-27 10:20 ` Dmitriy Gnidchenko 2003-05-28 7:58 ` Roman Savelyev [this message] 2003-05-30 12:00 ` Dmitriy Gnidchenko 2003-05-30 12:32 ` Roman Savelyev 2003-05-30 14:56 ` Dmitriy Gnidchenko 2003-05-31 5:44 ` Roman S 2003-05-31 9:43 ` Dmitriy Gnidchenko
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=3ED46C16.9090504@interlot.ru \ --to=savelyev@interlot.ru \ --cc=community@altlinux.ru \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Community general discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 community community/ http://lore.altlinux.org/community \ mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com public-inbox-index community Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.community AGPL code for this site: git clone https://public-inbox.org/public-inbox.git