Abhängigkeiten: # yum install binutils elfutils-libelf-0.* glibc-2.* glibc-common-2.* libgcc-4.* libstdc++* make* elfutils-libelf-devel-0.* glibc-devel-2.* gcc-4.* gcc-c++-4.* unixODBC-2.* libaio libaio-devel unixODBC-devel sysstat compat-libstdc++* pdksh Gruppen und Benutzeraccount: # groupadd oinstall # groupadd dba # groupadd oper # groupadd asmadmin # useradd -g oinstall -G dba,oper,asmadmin oracle # passwd oracle Xhost-Tool: # yum install xorg-x11*utils Kernel-Parameter: # nano /etc/sysctl.conf ... kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 32768 61000 net.core.rmem_default=4194304 net.core.rmem_max=4194304 net.core.wmem_default=262144 ... # sysctl -p PAM: # echo "session required pam_limits.so" >> /etc/pam.d/login SELinux muss zwingend deaktiviert sein, um 11g zu verwenden. Entpacken: # unzip linux_11gR2_database_1of2.zip ... # unzip linux_11gR2_database_2of2.zip ... # chmod 775 database # chmod 775 database/* -Rf # chmod 775 database/.* -Rf # cd database/ Dateien und Profil: # mkdir -p /u01/app/oracle/product/11.2.0/db_1 # chown -R oracle:oinstall /u01 # chmod -R 775 /u01 # su oracle $ nano ~/.bash_profile ... # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=.; export ORACLE_HOSTNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi ... C:\Programme\Xming> xming -ac -multiwindow -clipboard # export DISPLAY=IP:0.0 ./runInstaller Oracle Universal Installer wird gestartet... Temporärer Speicherplatz wird geprüft: muss größer sein als 80 MB. Tatsächlich 4089 MB Erfolgreich Swap-Speicher wird geprüft: muss größer sein als 150 MB. Tatsächlich 3967 MB Erfolgreich Monitor wird geprüft: muss so konfiguriert sein, dass mindestens 256 Farben angezeigt werden. Tatsächlich 16777216 Erfolgreich Vorbereitung für das Starten von Oracle Universal Installer aus /tmp/OraInstall2011-03-14_03-10-40PM. Bitte haben Sie einen Moment Geduld... # Installation (Screenshots) # /u01/app/oraInventory/orainstRoot.sh Berechtigungen ändern von/u01/app/oraInventory. Lese- und Schreibberechtigungen für Gruppe werden hinzugefügt. Lese-, Schreib- und Ausführungsberechtigungen für World werden entfernt. Ändern des Gruppennamen von /u01/app/oraInventory zu oinstall. Die Ausführung des Skripts ist abgeschlossen. # /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Running Oracle 11g root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Finished product-specific root actions. Oratab: $ exit # nano /etc/oratab ... orcl:/u01/app/oracle/product/11.2.0/db_1:Y ... Initskript: # nano /etc/init.d/dbora ... #!/bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. # # Set ORA_HOME to be equivalent to the $ORACLE_HOME # from which you wish to execute dbstart and dbshut; # # Set ORA_OWNER to the user id of the owner of the # Oracle database in ORA_HOME. ORA_HOME=/u01/app/oracle/product/11.2.0 ORA_OWNER=oracle if [ ! -f $ORA_HOME/db_1/bin/dbstart ] then echo "Oracle startup: cannot start" exit fi case "$1" in 'start') # Start the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su - $ORA_OWNER -c "$ORA_HOME/db_1/bin/lsnrctl start" su - $ORA_OWNER -c "$ORA_HOME/db_1/bin/dbstart" su - $ORA_OWNER -c "$ORA_HOME/db_1/bin/emctl start dbconsole" touch /var/lock/subsys/dbora ;; 'stop') # Stop the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su - $ORA_OWNER -c "$ORA_HOME/db_1/bin/emctl stop dbconsole" su - $ORA_OWNER -c "$ORA_HOME/db_1/bin/dbshut" su - $ORA_OWNER -c "$ORA_HOME/db_1/bin/lsnrctl stop" rm -f /var/lock/subsys/dbora ;; esac ... # chmod 750 /etc/init.d/dbora # chkconfig --add dbora # chkconfig --list dbora dbora 0:off 1:off 2:off 3:on 4:on 5:on 6:off