oracle

linux.x64_11gR2_database_1of2.zip

linux.x64_11gR2_database_2of2.zip


free -h | grep G

Mem:? ? ? ? ? ?6.8G? ?


groupadd oinstall && groupadd dba

useradd -g oinstall -g dba -m oracle

echo oracle | passwd --stdin oracle

mkdir -pv /data/{oracle,oraInventory,database}

mkdir -pv /data/oracle/product/11.2.0/db_1


cp -pv /etc/redhat-release /etc/redhat-release.bak

echo redhat-7 > /etc/redhat-release &&? cat /etc/redhat-release

redhat-7


yum install -y binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* pdksh*


cp -pv /etc/sysctl.conf /etc/sysctl.conf.bak

cat /etc/sysctl.conf

net.ipv4.icmp_echo_ignore_broadcasts = 1

net.ipv4.conf.all.rp_filter = 1

fs.file-max = 6815744?

fs.aio-max-nr = 1048576

kernel.shmall = 2097152?

kernel.shmmax = 2147483648?

kernel.shmmni = 4096?

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500?

net.core.rmem_default = 262144

net.core.rmem_max= 4194304

net.core.wmem_default= 262144

net.core.wmem_max= 1048576

net.ipv4.tcp_fin_timeout=2

net.ipv4.tcp_tw_reuse=1

net.ipv4.tcp_tw_recycle=1

sysctl -p


cp -pv /etc/security/limits.conf /etc/security/limits.conf.bak

tail -n4 /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536


cp -pv? /home/oracle/.bash_profile /home/oracle/.bash_profile.bak

tail -n7 /home/oracle/.bash_profile

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1?

export ORACLE_SID=orcl?

export ORACLE_TERM=xterm?

export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib?

export?

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

source /home/oracle/.bash_profile


unzip linux.x64_11gR2_database_1of2.zip -d /data/database/??

unzip linux.x64_11gR2_database_2of2.zip -d /data/database/??

chown -R oracle:oinstall /data/database/database/

chown -R oracle:oinstall oraInventory

chown -R oracle:oinstall oracle/


export DISPLAY=localhost:2

xhost +

access control disabled, clients can connect from any host


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle


oracle

oracle

上一篇:关于mysql大小写敏感问题


下一篇:SQL中的分组之后TOPN问题