Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- computer:linux:oracle_database_11g_auf_centos [2011/03/17 13:35] – christian
+++ computer:linux:oracle_database_11g_auf_centos [2011/03/18 13:50] (aktuell) – christian
@@ Zeile 1: / Zeile 1: @@
 Abhängigkeiten:
 <code>
-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
+# 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
 </code>
 Gruppen und Benutzeraccount:
 <code>
-#groupadd oinstall
+# groupadd oinstall
-#groupadd dba
+# groupadd dba
-#groupadd oper
+# groupadd oper
-#groupadd asmadmin
+# groupadd asmadmin
-#useradd -g oinstall -G dba,oper,asmadmin oracle
+# useradd -g oinstall -G dba,oper,asmadmin oracle
-#passwd oracle
+# passwd oracle
 </code>
@@ Zeile 34: / Zeile 34: @@
 PAM:
 <code>
-echo "session    required     pam_limits.so" >> /etc/pam.d/login
+# echo "session    required     pam_limits.so" >> /etc/pam.d/login
 </code>
@@ Zeile 66: / Zeile 66: @@
 ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
 ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
-ORACLE_SID=DB11G; export ORACLE_SID
+ORACLE_SID=orcl; export ORACLE_SID
 ORACLE_TERM=xterm; export ORACLE_TERM
 PATH=/usr/sbin:$PATH; export PATH
@@ Zeile 86: / Zeile 86: @@
 <code>
-C:\Programme\Xming>xming -ac -multiwindow -clipboard
+C:\Programme\Xming> xming -ac -multiwindow -clipboard
 </code>
@@ Zeile 143: / Zeile 143: @@
 ...
 </code>
+Initskript:
+<code>
+# 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
+</code>

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Unterschiede

Seiten-Werkzeuge