Installationsanleitung Linux/Oracle: Unterschied zwischen den Versionen
Aus MeinWiki
Zeile 57: | Zeile 57: | ||
# max number of open files for user | # max number of open files for user | ||
# ulimit -n ${FILE_MAX_SHELL:-65536} 2>/dev/null | # ulimit -n ${FILE_MAX_SHELL:-65536} 2>/dev/null | ||
+ | *Datei /etc/sysctl.conf anpassen | ||
+ | # Controls the maximum number of shared memory segments, in pages | ||
+ | # For 10g, uncomment 'fs.file-max = 327679', and comment 'fs.file-max = 6553600' entry and re-run sysctl -p | ||
+ | fs.file-max = 65536 | ||
+ | # fs.file-max = 327679 | ||
+ | # fs.file-max = 6815744 | ||
+ | |||
+ | # Oracle-Validated setting for kernel.msgmni is 2878 | ||
+ | kernel.msgmni = 2878 | ||
+ | # Oracle-Validated setting for kernel.msgmnb is 65536 | ||
+ | kernel.msgmnb = 65536 | ||
+ | |||
+ | # Oracle-Validated setting for kernel.sem is '250 32000 100 142' | ||
+ | kernel.sem = 250 32000 100 142 | ||
+ | |||
+ | # Oracle-Validated setting for kernel.shmmni is 4096 | ||
+ | kernel.shmmni = 4096 | ||
+ | |||
+ | # Oracle-Validated setting for kernel.shmall is 1073741824 | ||
+ | kernel.shmall = 1073741824 | ||
+ | |||
+ | # Oracle-Validated setting for kernel.shmmax is 4398046511104 on x86_64 and 4294967295 on i386 architecture. Refer Note id 567506.1 | ||
+ | kernel.shmmax = 4398046511104 | ||
+ | |||
+ | # Oracle-Validated setting for kernel.sysrq is 1 | ||
+ | kernel.sysrq = 1 | ||
+ | |||
+ | # Oracle-Validated setting for net.core.rmem_default is 262144 | ||
+ | net.core.rmem_default = 262144 | ||
+ | |||
+ | # For 11g, Oracle-Validated setting for net.core.rmem_max is 4194304 | ||
+ | # For 10g, uncomment 'net.core.rmem_max = 2097152', comment 'net.core.rmem_max = 4194304' entry and re-run sysctl -p | ||
+ | net.core.rmem_max = 2097152 | ||
+ | # net.core.rmem_max = 4194304 | ||
+ | |||
+ | # Oracle-Validated setting for net.core.wmem_default is 262144 | ||
+ | net.core.wmem_default = 262144 | ||
+ | |||
+ | # For 11g, Oracle-Validated setting for net.core.wmem_max is 1048576 | ||
+ | # For 10g, uncomment 'net.core.wmem_max = 262144', comment 'net.core.wmem_max = 1048576' entry for this parameter and re-run sysctl -p | ||
+ | net.core.wmem_max = 262144 | ||
+ | # net.core.wmem_max = 1048576 | ||
+ | |||
+ | # Oracle-Validated setting for fs.aio-max-nr is 3145728 | ||
+ | fs.aio-max-nr = 3145728 | ||
+ | |||
+ | # For 11g, Oracle-Validated setting for net.ipv4.ip_local_port_range is 9000 65500 | ||
+ | # For 10g, uncomment 'net.ipv4.ip_local_port_range = 1024 65000', comment 'net.ipv4.ip_local_port_range = 9000 65500' entry and re-run sysctl -p | ||
+ | net.ipv4.ip_local_port_range = 1024 65000 | ||
+ | # net.ipv4.ip_local_port_range = 9000 65500 | ||
+ | |||
+ | # Oracle-Validated setting for vm.min_free_kbytes is 51200 to avoid OOM killer | ||
+ | vm.min_free_kbytes = 51200 | ||
+ | ====Oraclesetup==== | ||
+ | *System neu starten | ||
+ | *Datei /etc/SuSE-release kopieren und Einträge von 11 auf 9 setzen | ||
+ | *ggf. Oracle Paket 102 (cpio –idmv < …) entpacken | ||
+ | *runInstaller ausführen und Standard Edition ohne Datenbank installieren. Gruppe dba wenn nötig auswählen, sonst sind keine Anpassung notwendig. (1 Fehler kann ignoriert werden) | ||
+ | *ggf. Oracle Paket |
Version vom 26. August 2014, 19:03 Uhr
Inhaltsverzeichnis
Linux Installation (SLES 10.2 / 11.2)
Basisinstallation
- Hardware bereitstellen (Blech ohne Multipath!) (withiscssi=1)
- Installation Physikalischen Server auswählen
- Festplatten konfigurieren
- Software auswählen (mit KDE, Entwicklungsumgebung, Oraclevorbereitung, ohne Gnom, Druckerumgebung, und Webbasierende Unternehmensanwendung)
- Netzwerk konfigurieren
- Lokale Userverwaltung verwenden
- User / user anlegen UID 1000
- ssh konfigurieren
ggf. Multipath installieren
- modprobe dm_multipath
- Definition in fstab und boot.menu überprüfen (/dev/disk/by-id/…)
- Kernelfile (qla…, dm_multipath)
- Autostart multipathd
ggf. VMwaretools installieren
Installationsverzeichnis verknüpfen
- Mountpoint erstellen
- Fstab bearbeiten (/etc/fstab)
Zusätzliche Software installieren
Remotezugriff (NX-Nomachine) installieren
Client entpacken (/usr) Node entpacken Server entpacken Setup aufrufen Konfigurationsfile kopieren nxserver –useradd nxadmin –system –administrator --uid 5002 nxserver –userenable nxadmin
Oracle Installation
Vorbereitung
- User oracle aktivieren, UserID auf 5001 setzen, Homeverzeichnis ändern, Gruppe dba auf 5000 setzen
- Festplatten hinzufügen / Berechtigungen oracle:dba setzen
- /dev/sdc1 /opt/oracle
- /dev/sde1 /backup
- Datei /etc/profile.d/oracle.sh (oracle.csh) anpassen
# Set your ORACLE environment variable here # ORACLE_HOME - Used here and in /etc/init.d/oracle(ora_environment()) # ORACLE_SID - Your Oracle System Identifier # ORACLE_BASE=/opt/oracle ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1 ORACLE_SID="SID" export ORACLE_BASE ORACLE_HOME ORACLE_SID export NLS_LANG=GERMAN_GERMANY.AL32UTF8 # For RAC # export ORA_CRS_HOME=$ORACLE_BASE/product/11gR1/crs # export ORA_ASM_HOME=$ORACLE_BASE/product/11gR1/asm # core dump file size # ulimit -c ${MAX_CORE_FILE_SIZE_SHELL:-0} 2>/dev/null # max number of processes for user # ulimit -u ${PROCESSES_MAX_SHELL:-16384} 2>/dev/null # max number of open files for user # ulimit -n ${FILE_MAX_SHELL:-65536} 2>/dev/null
- Datei /etc/sysctl.conf anpassen
# Controls the maximum number of shared memory segments, in pages # For 10g, uncomment 'fs.file-max = 327679', and comment 'fs.file-max = 6553600' entry and re-run sysctl -p fs.file-max = 65536 # fs.file-max = 327679 # fs.file-max = 6815744 # Oracle-Validated setting for kernel.msgmni is 2878 kernel.msgmni = 2878 # Oracle-Validated setting for kernel.msgmnb is 65536 kernel.msgmnb = 65536 # Oracle-Validated setting for kernel.sem is '250 32000 100 142' kernel.sem = 250 32000 100 142 # Oracle-Validated setting for kernel.shmmni is 4096 kernel.shmmni = 4096 # Oracle-Validated setting for kernel.shmall is 1073741824 kernel.shmall = 1073741824 # Oracle-Validated setting for kernel.shmmax is 4398046511104 on x86_64 and 4294967295 on i386 architecture. Refer Note id 567506.1 kernel.shmmax = 4398046511104 # Oracle-Validated setting for kernel.sysrq is 1 kernel.sysrq = 1 # Oracle-Validated setting for net.core.rmem_default is 262144 net.core.rmem_default = 262144 # For 11g, Oracle-Validated setting for net.core.rmem_max is 4194304 # For 10g, uncomment 'net.core.rmem_max = 2097152', comment 'net.core.rmem_max = 4194304' entry and re-run sysctl -p net.core.rmem_max = 2097152 # net.core.rmem_max = 4194304 # Oracle-Validated setting for net.core.wmem_default is 262144 net.core.wmem_default = 262144 # For 11g, Oracle-Validated setting for net.core.wmem_max is 1048576 # For 10g, uncomment 'net.core.wmem_max = 262144', comment 'net.core.wmem_max = 1048576' entry for this parameter and re-run sysctl -p net.core.wmem_max = 262144 # net.core.wmem_max = 1048576 # Oracle-Validated setting for fs.aio-max-nr is 3145728 fs.aio-max-nr = 3145728 # For 11g, Oracle-Validated setting for net.ipv4.ip_local_port_range is 9000 65500 # For 10g, uncomment 'net.ipv4.ip_local_port_range = 1024 65000', comment 'net.ipv4.ip_local_port_range = 9000 65500' entry and re-run sysctl -p net.ipv4.ip_local_port_range = 1024 65000 # net.ipv4.ip_local_port_range = 9000 65500 # Oracle-Validated setting for vm.min_free_kbytes is 51200 to avoid OOM killer vm.min_free_kbytes = 51200
Oraclesetup
- System neu starten
- Datei /etc/SuSE-release kopieren und Einträge von 11 auf 9 setzen
- ggf. Oracle Paket 102 (cpio –idmv < …) entpacken
- runInstaller ausführen und Standard Edition ohne Datenbank installieren. Gruppe dba wenn nötig auswählen, sonst sind keine Anpassung notwendig. (1 Fehler kann ignoriert werden)
- ggf. Oracle Paket