Install Oracle 11g on linux and Autostart after reboo. (Oracle 11g)

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • 1). Add ip and domain /etc/hosts/
    2). Add /etc/sysctl.conf
    fs.file-max = 6815744
    kernel.sem = 250 32000 100 128
    kernel.shmmni = 4096
    kernel.shmall = 1073741824
    kernel.shmmax = 4398046511104
    net.core.rmem_default = 262144
    net.core.rmem_max = 4194304
    net.core.wmem_default = 262144
    net.core.wmem_max = 1048576
    fs.aio-max-nr = 1048576
    net.ipv4.ip_local_port_range = 9000 65500
    sysctl -p - apply changes
    3). Add /etc/security/limits.conf
    oracle soft nofile 1024
    oracle hard nofile 65536
    oracle soft nproc 2047
    oracle hard nproc 16384
    oracle soft stack 10240
    oracle hard stack 32768
    4). Install Packages
    yum install binutils -y
    yum install compat-libcap1 -y
    yum install compat-libstdc++-33 -y
    yum install compat-libstdc++-33.i686 -y
    yum install gcc -y
    yum install gcc-c++ -y
    yum install glibc -y
    yum install glibc.i686 -y
    yum install glibc-devel -y
    yum install glibc-devel.i686 -y
    yum install ksh -y
    yum install libgcc -y
    yum install libgcc.i686 -y
    yum install libstdc++ -y
    yum install libstdc++.i686 -y
    yum install libstdc++-devel -y
    yum install libstdc++-devel.i686 -y
    yum install libaio -y
    yum install libaio.i686 -y
    yum install libaio-devel -y
    yum install libaio-devel.i686 -y
    yum install libXext -y
    yum install libXext.i686 -y
    yum install libXtst -y
    yum install libXtst.i686 -y
    yum install libX11 -y
    yum install libX11.i686 -y
    yum install libXau -y
    yum install libXau.i686 -y
    yum install libxcb -y
    yum install libxcb.i686 -y
    yum install libXi -y
    yum install libXi.i686 -y
    yum install make -y
    yum install sysstat -y
    yum install unixODBC -y
    yum install unixODBC-devel -y
    5). Add dba group
    groupadd -g 54321 oinstall
    groupadd -g 54322 dba
    groupadd -g 54323 oper
    useradd -u 54321 -g oinstall -G dba,oper oracle
    passwd oracle
    6). Add Oracle folders
    mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
    mkdir -p /u01/setup
    chown -R oracle:oinstall /u01
    chmod -R 775 /u01
    7). Install Oracle
    8). Add .bash_profile
    vi .bash_profile
    . ./.bash_profile
    export TMP=/tmp
    export TMPDIR=$TMP
    export ORACLE_HOSTNAME=localhost.localdomain
    export ORACLE_UNQNAME=orcl
    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
    export ORACLE_SID=orcl
    export PATH=/usr/sbin:$PATH
    export PATH=$ORACLE_HOME/bin:$PATH
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
    export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
    9). Autostart oracle
    vi /etc/oratab
    chown oracle:oinstall /etc/oratab
    chmod 777 /etc/oratab
    Add
    orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y
    ---
    vi /etc/init.d/dbora
    Add
    #!/bin/bash
    chkconfig: 35 99 10
    description: Starts and stops Oracle processes
    ORA_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
    ORA_OWNER=oracle
    case "$1" in
    'start')
    su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
    su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
    ;;
    'stop')
    su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
    su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
    ;;
    esac
    End of script dbora
    chgrp dba /etc/init.d/dbora
    chmod 750 /etc/init.d/dbora
    chkconfig --add dbora
    chkconfig --list | grep dbora
    /etc/init.d/dbora stop
    /etc/init.d/dbora start

Комментарии • 1