Oracle11g single-instance installation + redhat6.3 plan

Oracle11g single-instance installation + redhat6.3 Planning 1. view the environment [root @ JSCS78DB dev] # cat/etc/redhat-release Red Hat Enterprise Linux Server release 6.3 (Santiago) [root @ JSCS78DB dev] # uname-aLinux JSCS78DB 2.6.39-prop _ 64 #1 SMP Sat Jun 23 02:39:07 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux [root @ JSCS78DB dev] # cat/ etc/passwdroot: x: 0: 0: root:/bin/bashbin: x: 1: 1: bin:/sbin/nologindaemon: x: 2: daemon: /sbin:/s Bin/nologinadm: x: 3: 4: adm:/var/adm:/sbin/nologinlp: x: 4: 7: lp:/var/spool/lpd: /sbin/nologinsync: x: 5: 0: sync:/sbin:/bin/syncshutdown: x: 6: 0: shutdown:/sbin/shutdownhalt: x: 7: 0: halt:/sbin/haltmail: x: 8: 12: mail:/var/spool/mail:/sbin/nologinuucp: x: 10: 14: uucp:/var/spool/uucp:/sbin/nologinoperator: x: 11: 0: operator:/root:/sbin/nologingames: x: 12: 100: games: /usr/games:/sbin/nologingopher: x: 13: 30: gopher:/v Ar/gopher:/sbin/nologinftp: x: 14: 50: FTP User:/var/ftp:/sbin/nologinnobody: x: 99: 99: Nobody :/: /sbin/nologinlogs: x: 81: 81: System message bus: // sbin/nologinusbmuxd: x: 113: 113: usbmuxd user: // sbin/nologinavahi-autoipd: x: 170: 170: Avahi IPv4LL Stack:/var/lib/avahi-autoipd:/sbin/nologinvcsa: x: 69: 69: virtual console memory owner:/dev: /sbin/nologinrpc: x: 32: 32: Rpcbind Daemon:/var/cache/rpcbind:/sbin/nologinrtkit: X: 499: 497: RealtimeKit:/proc:/sbin/nologinntp: x: 38: 38:/etc/ntp:/sbin/nologinapache: x: 48: 48: apache:/var/www:/sbin/nologinsaslauth: x: 498: 76: "Saslauthd user":/var/empty/saslauth:/sbin/nologinpostfix: x: 89: 89:/var/spool/postfix:/sbin/nologinavahi: x: 70: 70: Avahi mDNS/DNS-SD Stack:/var/run/avahi-daemon: /sbin/nologinrpcuser: x: 29: 29: RPC Service User:/var/lib/nfs:/sbin/nologinnfsnobody: x: 65534: 65534: Anonymo Us NFS User:/var/lib/nfs:/sbin/nologinabrt: x: 173: 173:/etc/abrt:/sbin/nologinhaldaemon: x: 68: 68: HAL daemon: // sbin/nologinpulse: x: 497: 496: PulseAudio System Daemon:/var/run/pulse:/sbin/nologingdm: x: 42: 42 :: /var/lib/TPD:/sbin/nologinsshd: x: 74: 74: Privilege-separated SSH:/var/empty/sshd:/sbin/nologintcpdump: x: 72: 72: // sbin/nologinweblogic: x: 500: 500: weblogic:/home/weblogic:/bin/bash 2. disable firewall checkconfig- -List [root @ JSCS78DB home] # export LANG = C [root @ JSCS78DB home] # chkconfig -- list | grep iptablesiptables 0: off 1: off 2: on 3: on 4: on 5: on 6: off [root @ JSCS78DB home] # [root @ JSCS78DB home] # service iptables status table: filterChain INPUT (policy ACCEPT) num target prot opt source destination 1 ACCEPT all -- 0.0.0.0/0 0.0.0.0/0 state RELATED, ESTABLISHED2 ACCEPT icmp -- 0.0.0.0/0 0.0.0.0/0 3 ACCEPT all -- 0.0. 0.0/0 0.0.0.0/0 4 ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt: 225 REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibitedChain FORWARD (policy ACCEPT) num target prot opt source destination 1 REJECT all -- 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibitedChain OUTPUT (policy ACCEPT) num target prot opt source destination [root @ JSCS78DB home] # chkconfig iptables off [root @ JSCS78D B home] # chkconfig -- list | grep iptablesiptables 0: off 1: off 2: off 3: off 4: off 5: off 6: off [root @ JSCS78DB home] # vi/etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX = can take one of these three values: # enforcing-SELinux security policy is enforced. # permissive-SELinux prints warnings instead of enforcing. # disabled-No SELinux policy is loaded. SELINUX = en Forcing # SELINUXTYPE = can take one of these two values: # targeted-Targeted processes are protected, # mls-Multi Level Security protection. SELINUXTYPE = targeted ~ III. create an oracle user group groupadd-g 501 oinstallgroupadd-g 502 dbagroupadd-g 503 operuseradd-u 501-g oinstall-G dba, export oraclepasswd oraclemkdir-p/home/oracle/ora11g/db_basemkdir-p/home/oracle/ora11g/db_base/product/11.2.0/db_1chown-R oracle: oinstall/home/oraclechmod-R 775/home/oraclechmod-R 775/oracle/app/oracle/chmod-R 775/oracle/app/oracle/product/11.2.0/db_1/chmod -R 775/oracle/app/ora Inventory 4. edit the configuration file vi. bash_profileexport PS1 = "$ LOGNAME @ 'hostname': \ $ PWD>" ORACLE_SID = xyy; export ORACLE_SID # ORACLE_BASEORACLE_BASE =/home/oracle/ora11g/db_base; export ORACLE_BASE # ORACLE_HOMEORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME # JAVA_HOME = $ ORACLE_HOME/jdk; export JAVA_HOME # ORACLE_PATHORACLE_PATH =/home/oracle/ora11g/common/oracle/SQL; export ORACLE_PATH # ORAC LE_TERMORACLE_TERM = xterm; export ORACLE_TERM # condition = "DD-MON-YYYY HH24: MI: SS"; export NLS_DATE_FORMAT # NLS_LANGNLS_LANG = condition; export NLS_LANG # TNS_ADMINTNS_ADMIN = $ ORACLE_HOME/network/admin; export TNS_ADMIN # ORA_NLS11ORA_NLS11 = $ ORACLE_HOME/nls/data; export ORA_NLS11 # PATHPATH =. :$ {JAVA_HOME}/bin :$ {PATH }:$ HOME/bin: $ ORACLE_HOME/bin:/goldengatePATH =$ {PATH}:/u Sr/bin:/usr/bin/X11:/usr/local/binPATH =$ {PATH }: /oracle/ora11g/common/oracle/binexport PATH # kernel = $ ORACLE_HOME/lib:/kernel =$ {LD_LIBRARY_PATH}: $ ORACLE_HOME/kernel M/libLD_LIBRARY_PATH =$ {LD_LIBRARY_PATH }: /lib:/usr/local/libexport LD_LIBRARY_PATH # paths = $ ORACLE_HOME/JRECLASSPATH =$ {CLASSPATH}: $ ORACLE_HOME/jlibCLASSPATH =$ {CLASSPATH}: $ O RACLE_HOME/rdbms/jlibCLASSPATH =$ {CLASSPATH}: $ ORACLE_HOME/network/jlibexport CLASSPATH # THREADS_FLAGTHREADS_FLAG = native; export THREADS_FLAG # TEMP, TMP, and TMPDIRexport TEMP =/tmpexport TMPDIR =/tmp # UMASKumask 022 vi/etc/hosts [root @ JSCS78DB oracle] # vi/etc/hosts127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4: 1 localhost. localdomain localhost6 localhost6.loc Aldomain6192.168.1.10 JSCS78DB vi/etc/sysctl. conffs. aio-max-nr = 1048576fs. file-max = 6815744 # kernel. shmall = 2097152 # kernel. shmmax = 4294967295kernel. shmmni = 4096kernel. sem = 250 32000 100. net. ipv4.ip _ local_port_range = 9000 65500net. core. rmem_default = 262144net. core. rmem_max = 4192134net. core. wmem_default = 262144net. core. wmem_max = 1048576vi/etc/security/limits. conforacle soft nproc 2047 Oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 [root @ JSCS78DB ~] # Rpm-q binutils compat-libstdc ++-33 elfutils-libelf-devel gcc-c ++ glibc-common glibc-develbinutils-2.20.51.0.2-5.34.el6.x86_64compat-libstdc ++-kernel ++-4.4.4.6- 4. el6.x86 _ release 86_64 [root @ JSCS78DB ~] # Rpm-q glibc-headers ksh libaio-devel libgcc libstdc ++-devel make numactl-devel sysstatglibc-headers-2.12-1.80.el6.x86_64ksh-20100621-16.el6.x86_64libaio-0.3.107-10.el6.x86_64libaio-devel-0.3.107-10.el6.x86_64libgcc-4.4.6-4.el6.x86_64libstdc ++-4.4.4.6-4. el6.x86 _ 64 libstdc ++-devel-4.4.6-4.el6.x86_64make-3.81-20.el6.x86_64numactl-devel-2.0.7-3.el6.x86_64sysstat-9.0.4-20.el6.x86_64 5. security Install the unzip installation package [root @ JSCS78DB database] # chown-R oracle: oinstall/xyy/database/[root @ JSCS78DB database] # lldrwxr-xr-x 12 oracle oinstall 4096 8 ?. 17 2009 docdrwxr-xr-x 4 oracle oinstall 4096 8 ?. 14 2009 installdrwxrwxr-x 2 oracle oinstall 4096 8 ?. 14 2009 responsedrwxr-xr-x 2 oracle oinstall 4096 8 ?. 14 2009 rpm-rwxr-xr-x 1 oracle oinstall 4352 8 ?. 14 2009 runInstallerdrwxrwxr-x 2 oracle oinstall 4096 8 ?. 14 2009 sshsetupdrwxr-xr-x 14 oracle oinstall 4096 8 ?. 14 2009 stage-rw-r -- 1 oracle oinstall 5400 8 ?. 18 2009 welcome.html [root @ JSCS78DB database] # su-oracleoracle @ JSCS78DB:/home/oracle> export LANG = C. /runInstaller note: the installation interface will pop up, which can be installed step by step (too many images, not easy to upload)